NAV: SLTechnology News&Howtos > Database >

• 

  Mysqladmin extended-status summary

  1. Aborted_clients the number of connections that have been abandoned because the customer did not close the connection correctly. (monitoring) indicates that the client did not close the connection correctly, and the number of connections terminated caused by 1. 5%. The client program is not adjusted before exiting.

  2022-06-01 18:52:37 Views: 241
• 

  The method of realizing timing Task by mysql

  Since MySQL5.1.6, a very unique function-event Scheduler (Event Scheduler) has been added, which can be used to perform certain tasks on a regular basis (such as deleting records, summarizing data, backing up data, etc.), instead of being operated only by the operating system.

  2022-06-01 18:52:20 Views: 281
• 

  How to realize time carry in mysql?

  After mysql was updated to 5.6.4, a new feature called factional seconds was added to record the millisecond value of time. But the current database does not record millisecond values, so it will generate a Millise of time in java

  2022-06-01 18:52:20 Views: 248
• 

  How does redis judge the existence of key?

  The basic syntax of the redis EXISTS command is as follows: redis 127.0.0.1 EXISTS KEY_NAME 6379 > available version of EXISTS KEY_NAME > = 1.0.0 return value 1 if key exists, otherwise return 0. Instance re

  2022-06-01 18:52:19 Views: 277
• 

  Elasticsearch inserts data in bulk

  Elasticsearch bulk insert data use bulk batch operation database 1. Create batch operation file format: {"index": {"_ index": "home", "_ type": "home", "_ id": "2"}} {

  2022-06-01 18:52:18 Views: 284
• 

  Talk about B + Tree

  First look at the characteristics of the B + Tree data structure (From Wikipedia). 1. The primary value of a B + tree is in storing data for efficient

  2022-06-01 18:52:06 Views: 230
• 

  Build cacti under centos7

  Cacti what is Cacti?Cacti means cactus in English. Cacti is a set of graphical analysis tools for network traffic monitoring based on PHP,MySQL,SNMP and RRDTool. It uses snmpget to get the data, so that

  2022-06-01 18:51:48 Views: 226
• 

  11G flashback database

  The first scenario library is used to train or test the environment, and restore the original SYS@ odb > archive log list;Databaselog mode No Archive ModeAutomaticar after testing.

  2022-06-01 18:51:48 Views: 247
• 

  The powerful function and usage of RAID,LVM

  1. Advanced file system management 1) set file system quotas 2) set and manage soft RAID devices 3) configure logical volumes 4) set LVM snapshots 5) btrfs file system 2. Demonstration steps for configuring disk quotas are as follows: 1. Partition mount all texts in / home directory

  2022-06-01 18:51:47 Views: 233
• 

  MySQL modifies the table structure pt-osc online

  MySQL modify the table structure online pt-osc it is well known that the DDL operation of MySQL is relatively expensive. Because MySQL blocks any read and write operations during table modification. Basically, business is paralyzed. If the amount of data is large, it may take several hours to complete, none

  2022-06-01 18:51:45 Views: 263
• 

  The maven+mybatis+spring xml file is not compiled to the output path

  Maven+mybatis+spring encountered the following error during development: org.springframework.beans.factory.UnsatisfiedDependencyException:

  2022-06-01 18:51:45 Views: 299
• 

  Installation and self-startup method under Mongodb Ubuntu

  Today, I took some time to install the Mongodb database under Ubuntu13.10, now write down the installation operation method and the method of automatic startup: 1. Apt-get update update software library 2. Apt-get install mo

  2022-06-01 18:51:44 Views: 257
• 

  ORA-09925: Unable to create au

  Sqlplus / as sysdba brought by ORA-09925: Unable to create audit trail file cannot connect to ERROR:ORA-09925: Unable to cre

  2022-06-01 18:51:44 Views: 250
• 

  OGG synchronous testing in LINUX environment

  Because I just changed my job, I was a little busy at first. As soon as I was free, I retested the previous case and shared it with you. This article mainly records the test process command, although the result is not screenshot, but the result is ok and has been tested many times. If there are any questions in this article, you are welcome to leave a message and point out the source of the environment description.

  2022-06-01 18:51:32 Views: 295
• 

  Oracle data update explanation

  (1) update one column: update T_Person set Age=30 (2) update multiple columns: update T_Person set Age=30,Name='Tom' (3) update part of the data: updat

  2022-06-01 18:51:32 Views: 227
• 

  Mysql+ssl master-slave replication

  The principle of master-slave replication, as the master server Master, will record every change in the binary log Binarylog. (from the server Imax O thread is responsible for reading the master binary log and then writing to itself

  2022-06-01 18:51:02 Views: 298
• 

  Do you understand the business in MySQL?

  This article mainly introduces the affairs in MySQL, the contents of the articles are carefully selected and edited by the author, with a certain pertinence, the reference significance for everyone is still relatively great, the following with the author to understand the affairs in MySQL. An example: a bank reference is a classic example of a transaction

  2022-06-01 18:51:01 Views: 223
• 

  Teach you how to change the root password in MySQL in one step

  This article mainly gives you a brief introduction to the method of changing the root password in MySQL. You can look up the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here. Let's go straight to the topic. I hope the method of changing the root password in MySQL can bring you some.

  2022-06-01 18:50:58 Views: 274
• 

  How to set up mysql8 to have its own full-text index

  The following is about the full-text index that comes with mysql8. The secret of the text is that it is close to the topic. So, no gossip, let's go straight to the following, I believe you will benefit from reading this article with mysql8's own full-text index. Modify the configuration file: vim / etc/my.

  2022-06-01 18:50:58 Views: 247
• 

  On the limitations in GTID- GTID-based replication

  In the same transaction (statement), the changes of transaction and non-transaction data tables cannot be involved at the same time, which will result in a transaction corresponding to multiple GTID, violating the one-to-one correspondence principle between transaction and GTID. [root@mysql.sock] [db1] > show creat

  2022-06-01 18:50:35 Views: 244