NAV: SLTechnology News&Howtos > Database >

• 

  Explain Analyze in MySQL version 8.0.18

  In previous versions, we used the explain command to see the specific execution plan of SQL. Explain extension has been added in MySQL version 8.0.18, one is explain format=tree, the other is based on explain

  2022-06-01 22:17:39 Views: 255
• 

  MongoDB grammar practice

  # basic query for simple operation: construct query data: db.test.insert ({name: "stephen", age:35,genda: "male", email: "stephen@hotmail.com"

  2022-06-01 22:17:39 Views: 244
• 

  Mongodb English Handbook

  Https://docs.mongodb.com/manual/

  2022-06-01 22:17:39 Views: 286
• 

  Basic operation of MySQL-- database

  Basic operation command 1. View database list information show databases;mysql > show databases;+-+ | Database | +-

  2022-06-01 22:17:38 Views: 264
• 

  Configure mongodb service under win7

  Create the file mg.conf under the same level directory in the bin directory and write as follows: dbpath=D:\ Program Files\ MongoDB\ Server\ 3.2\ data # database path logpath=D:\ Progr

  2022-06-01 22:17:37 Views: 222
• 

  Redis-string type

  1 px set key value ex seconds / px millisecond nx/xx127.0.0.1:6379 > set name Z2 px 1000OK127.0.0.1:6379 > ttl name (intege

  2022-06-01 22:17:37 Views: 293
• 

  ORA-00379: no free buffers ava

  When doing an off-machine migration to recover the database, the following error is reported. PSDRPC returns significant error 1013.PSDRPC returns significant error 1013.PSDRP

  2022-06-01 22:16:37 Views: 221
• 

  Learning records of highly available mongodb clusters (1 installation and configuration of MongoDB

  Installation and configuration of MongoDB 1, overview of NoSQL, refers to non-relational databases. NoSQL, sometimes referred to as the abbreviation of Not Only SQL, is a general term for database management systems that are different from traditional relational databases. NoSQL is used for very large data

  2022-06-01 22:16:37 Views: 274
• 

  Redis project (2): exploring the underlying layer of Redis data structure

  Introduction to the previous article Redis chat (1): the construction of knowledge graph introduces the basic concepts, advantages and disadvantages of redis and its memory elimination mechanism. I believe we have a preliminary understanding of redis. Many application scenarios of the Internet have the shadow of Redis, what it can do is far away.

  2022-06-01 22:16:37 Views: 220
• 

  MySQL-5.6.36 compilation and installation tutorial, a novice must see!

  First of all, MySQL is a relational database, what is a relational relational database, we also talked about the advantages and disadvantages, in the last blog: https://blog.51cto.com/14573101/2447264, now let's talk about the installation of MySQL.

  2022-06-01 22:16:37 Views: 223
• 

  Installation and use of Kettle data Migration

  Premise 1, install JDK java environment 1. Kettle is an open source ETL tool written by pure Java. At present, both Kettle7 and Kettle8 need Java8 or above to run normally. So before running Kettle, check whether the Java environment is

  2022-06-01 22:16:25 Views: 230
• 

  Exchange2016 deployment and configuration (7)-DAG configuration

  1. Preparation work 1.1, noun explanation witness: the function of witness is to coordinate the failure between nodes, that is, when a node fails, it is up to the witness to decide who will continue to take over the service. Witness server only if there is an even number of DAG member servers and arbitration is required

  2022-06-01 22:15:55 Views: 256
• 

  Redis message queuing

  Redis 127.0.0.1 redis 6379 > LPUSH the_list'{"name": "zhangsan", "age": 18}'(integer) 1redis 127.0.0.1 zhangsan 6379 >

  2022-06-01 22:15:54 Views: 248
• 

  Learning log-hbase learning (maximum version query)

  In HBase, there is only one row for the same column corresponding to a row. Use scan or get to get the most up-to-date data. If we change the column corresponding to this row, we will not generate one more piece of data, unlike RDBMS when insert.

  2022-06-01 22:15:48 Views: 206
• 

  Mysql MASTER_POS_WAIT function

  Syntax select master_pos_wait (file, pos [, timeout]). File and pos are the values of the corresponding main library, which can be obtained through show master status. Timeout

  2022-06-01 22:15:48 Views: 295
• 

  MySQL 8.0.18 Optimizer adds AntiJoin Anti-connection Optimization

  In MySQL 8.0.18, the optimization of NOT IN/ exists subquery statements is supported, and the query is automatically rewritten into AntiJoin disjoin query SQL statements within the optimizer. Usually, we want to complete the query results in the inner table first from the inside to the outside.

  2022-06-01 22:15:48 Views: 248
• 

  Yang Zhenkun, founder of database OceanBase: how many TPC-C are there in customs clearance?

  Since Ant Financial Services Group's self-research database OceanBase won the first place in TPC-C test, it has attracted a lot of attention inside and outside the industry. we sincerely thank you for your support and love for OceanBase, and humbly listen to the opinions and suggestions of the outside world. In order to let everyone better understand the skills of testing.

  2022-06-01 22:15:45 Views: 279
• 

  Data default directory

  Source code installation version / usr/local/mysql/varapt binary discovery version / usr/local/mysql/dataRPM installation version / var/lib/mysql! [] (https://cache.yi

  2022-06-01 22:15:44 Views: 220
• 

  Realize the ranking function.

  The ranking function is realized by using the ordered collection of MongoDB and Redis respectively. Compared with the sorting function of the traditional database, look for the advantages of the ordered set to realize the sorting function. Specific to a practical example, such as the ranking version of a live broadcast website where viewers send gifts to the anchor, if it is directly in the database

  2022-06-01 22:15:24 Views: 253
• 

  Construction of mongodb and creation of user authentication

  Today, the company needs to deploy the mongodb environment to migrate the server, and then Baidu has a lot of blogs and documents online. Finally, the construction is completed, and the specific construction process is shared with you. I hope it will be helpful to you. Step 1 of MongoDB installation: create

  2022-06-01 22:15:24 Views: 264