flush tables

  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 executed at least once. Provides

I. Principles of Replication MySQL replication tracks all database changes (updates, deletions, and so on) in binary logs based on the master server ). Each slave server receives updates recorded by the master server to the storage of its binary

INSERT statement speed The time required to insert a record is composed of the following factors, and the number indicates the approximate proportion: Connection: (3) Send query to server: (2) Analysis query: (2) Insert record: (1x record

If you run the table check/repair program at the same time, you may not want the MySQL server and utility to access a table at the same time. If both programs write data to the table, it will obviously cause a lot of trouble and even cause

Case study of failure to log on to the server using the specified MySQL clientI am used to installing MySQL in binary mode. Today I am eager to install MySQL with an RPM package. I did not expect that I have encountered some problems. I will share

MySQL improves Insert performance and mysqlinsert Performance The time required to insert a record is composed of the following factors, and the number indicates the approximate proportion: Connection: (3) Send query to server: (2) Analysis

Summary of solutions for Tableisreadonly in mysql bitsCN.com if it is a database in use, some class problems suddenly occur. Run the following command in Linux. of course, you need to find your mysql directory. Linux

MySQL replication (1) --- what is binary log 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.

Introduction: Nagios interface. See Monitoring MySQL service errors, as below:Warning:NRPE:Unable to read output1, with the Nagios monitor server on the check1.1. Run the Check_nrpe command for remote callsRun Check_nrpe on the monitor side

1. Why back up the database? Backup is the most important and easy to ignore for databases. Unexpected events may cause serious losses. The more important the data is, the more frequently the data changes, and the more frequently backup is

Nagios monitors MySQL and reports the following error: NRPE: Unable to read output. On the nagios page, the following error message is displayed: Warning: NRPE: Unable to read output     1. Go to the nagios monitoring server and check 1.1. Execute

MySQL Tutorial database tutorial full backup and incremental backup strategy for backup recovery Backup strategy One: Copy database files directly (not recommended)Backup strategy Two: Use Mysqlhotcopy backup Database (full backup, suitable for

1. Enter the Mysqladmin processlist into the Mysql/bin catalogue; 2. Start MySQL, enter show Processlist; If you have SUPER permissions, you can see all of the threads, otherwise you can only see the thread that you originated (this is the current

　　The speed of the insert query: The time to insert a record consists of the following: Connection: (3) Send query to server: (2) Analysis of the query: (2) Insert Record: (1 x record size) Insert Index: (1 x index) Off: (1) The numbers here

First, the principle of reproduction MySQL replication tracks all changes to the database (update, delete, and so on) based on the primary server in the binary log. Each receive from the server from the primary server has been logged to the saved

mysql| Data | Database Ideally, MySQL has been running smoothly since the first installation. Sometimes, however, problems can occur for a variety of reasons, ranging from power outages to hardware failures to abnormally shutting down MySQL servers (

MySQL Performance tuning: The speed of the insert query: The time to insert a record consists of the following: Connection: (3) Send query to server: (2) Analysis of the query: (2) Insert Record: (1 x record size) Insert Index: (1 x index)

Preparatory work:To deactivate the database service:Systemctl Stop Mariadb.serviceCopy the database file from the main library as the From library data:Cp-a-r/data/mysql_data/mysql/*/data/mysql_data/mysql2/Finish copying the boot:Systemctl Start

1. If you insert many rows from the same client at the same time, insert a few rows using the INSERT statement with multiple value. This is faster than using a single-line INSERT statement (in some cases several times faster). If you are adding data

Make a note for the convenience of inspection.View the status of the MySQL process through show processlist, which has the following status on the State column:AnalyzingThe thread makes an analysis of the statistics of the MyISAM table (for example,