flush tables

For some large data systems, the problem is that the query efficiency is low, and there is a very important problem is that the insertion time is long. We have a business system that requires 4-5 clocks per day for data import. This time-consuming

I've got about 200,000 data inserts in my job, after the completion of the program to find the running timeout, modify PHP maximum execution time to 600, or timeout, check out before the number of data inserted before the calculation, probably to

INSERT the speed of the statementThe time required to insert a record is made up of the following factors, where the number represents the approximate scale: Connection: (3) Send query to server: (2) Analysis query: (2) Insert record: (1x record

The backup of the database is an extremely important thing. If you do not have a backup, you will be crazy if you encounter the following conditions:UPDATE or DELETE whitout where ...Table was DROPPed accidentally ...INNODB was corrupt ...Entire

Mydumper principle and mydumper PrincipleInstallation of mydumper: http://www.cnblogs.com/lizhi221/p/7010174.htmlMydumper Introduction MySQL's mysqldump tool supports single-threaded operations. Multiple tables are exported one by one without a

MySQLFlush operation ---------------------------------------------------------------- If you want to clear some internal caches used by MySQL, you should use the FLUSH statement. To perform FLUSH, you must have the RELOAD permission.

Three methods for mysql backup: bitsCN.com I. purpose of backup Disaster Recovery: recover and restore damaged dataDemand Change: data needs to be restored to a time before the change due to demand changesTest: test whether the new function is

Improve the table_cache of MySQL. There is a table_cache parameter in mysql. When the value is too large, the efficiency will decrease significantly. This is because open_cache hash is scanned. Improve the table_cache of MySQL. There is a

MYSQL usage experience (8)-configuration and recovery of online master-slave replication cluster and online execution of master-slave configuration FLUSHTABLESWITHREADLOCK; UNLOCKTABLES; there is a master.info file under the slave database data

I. Purpose of backup Disaster recovery: recover and restore damaged dataDemand change: data needs to be restored to a time before the change due to demand changesTest: test whether the new function is available Ii. Backup considerations How long

Mysql tutorial database tutorial backup and mysql Restoration 1. mysqldump1.1 backupMysqldump adopts an SQL-level backup mechanism. It imports data tables into SQL script files and is suitable for upgrading between different MySQL versions. This is

Mysql metadata lock (3), mysqlmetadatalock Preface The MDL lock is mainly used to protect the metadata of Mysql internal objects. The MDL mechanism ensures the concurrency of DDL, DML, and SELECT query operations. MySQL Meta Lock (1) and MySQL Meta

When a mysql-related fault occurs in the development or test environment, most of my friends may post on the Forum and discuss the problem with the QQ group. This method is one of the effective ways to get help. However, in a production environment

Introduction: MySQL databaseOne server acts as the master server while one or more other servers act as the slave server. The master server writes updates to the binary log file and maintains an index of the log file to track log loops. When an

MySQL performance tuning and Architecture Design-Chapter 1 Performance Design-MySQL Replication and replication Optimization Chapter 1 scalability design-MySQL Replication Preface: MySQL Replication is a unique feature of MySQL. It can completely

When a mysql-related fault occurs in the development or test environment, most of my friends may post on the forum and discuss the problem with the QQ group. This method is one of the effective ways to get help. However, in a production environment

Mysql quick backup bitsCN.com 1.1 Backup Mysqldump adopts an SQL-level backup mechanism. it imports data tables into SQL script files and is suitable for upgrading between different MySQL versions. this is also the most common backup method. Here

MySQL replication (1) bitsCN.com Compared with small sites, database administrators of large sites must do the following in advance: Provides a recovery plan for core business data in the event of a disaster. Theoretically, this process must be

MySQL database data backup and recovery details bitsCN.com This article discusses the backup and recovery mechanisms of MySQL and how to maintain data tables, including the two most important types of tables: MyISAM and Innodb. the MySQL version

MySql configuration master-slave replication read/write splitting bitsCN.com Configure master-slave replication read/write splitting for MySql In the my. ini configuration file Master-slave replication must be performed through binary log files.