flush tables

1.show Full ProcesslistDisplays all of the MySQL processes that are executing to view the current MySQL operation, avoiding deadlocks and other anomalies.The main columns: ID: Process ID User: Login Account Host: Logon User IP port DB:

First, data backup　　1. Backup with mysqldump commandThe mysqldump command backs up the data in the database into a text file. The structure of the table and the data in the table are stored in the generated text file.The mysqldump command works very

Overview In general, once the database structure has been designed, it cannot be easily changed because changes DDL (Data Definition Language) are expensive to operate, so you need to be cautious about database structure design. However, business

A variety of MySQL administration Tools <>mysql provides command-line tools mysql_install_db : MySQL Build library tool, in the source installation MySQL link we used. Mysql_safe : MySQL boot tool mysqld : MySQL master process,

Both logical and physical backups are strongly dependent on FTWRL (Flush Table with Read Lock) in order to obtain consistency sites. This lock is very lethal, because the whole database is essentially unable to provide write service to the time the

Phenomenon :1, from the mysqlbackup of the log to see that it has been in state:waiting for locks;2, from the MySQL level show processlist to see it in waiting for GLOABL read lockshow Processlist;+-----+-------------+---------------------+------+---

MySQL Data backup and restore MySQL Data backup and restore Data backup Mysqldump Backup Copy this database directory directly Mysqlhotcopy Tool

MySQL Primary master replicationI. Description of the EnvironmentServer A 192.168.1.108Server B 192.168.1.110MySQL version: 5.1.26System Os:centos Release 5.4Second, the main master configuration process1. Create a sync User:Server A:Grant

First, data backup　　1. Backup with mysqldump commandThe mysqldump command backs up the data in the database into a text file. The structure of the table and the data in the table are stored in the generated text file.The mysqldump command works very

In the development or testing environment when encountering MySQL-related failures, most friends may be posted through the Forum, QQ group discussion method to get help. This approach is one of the effective ways to get help. However, in the

Mysqldump Backup principleThe basic process for backup is as follows:1. Call FTWRL (flush tables with read lock), global prohibit read/write2. Turn on snapshot read to get a snapshot at this time (only works on InnoDB table)3. Backing up non-InnoDB

In the original LNMP environment[Email protected] ~]# vim/etc/init.d/mysqld #查找数据库的安装路径[Email protected] ~]# cd/data/mysql/[[email protected] mysql]# ls[Email protected] mysql]# tar czvf discuz.tar/data/mysql/discuz/#备份之前的discuz Forum database table.

First, Introduction1, Xtrabackup have so several files InnobackupexInnobackupex is a symbolic link to xtrabackup. Innobackupex still supports all features and syntax as 2.2 version do, but are now deprecated and would be removed in next Major

MySQL Data backup and restore original sticker: http://www.cnblogs.com/kissdodog/p/4174421.html. Data backup　　1. Backup with mysqldump commandThe mysqldump command backs up the data in the database into a text file. The structure of the table and

The first step is to prepare the work: to avoid inconsistencies in data, updates to data in the database are not allowed during backup of the database file. The simplest way to achieve this is to stop the MySQL service. Then, copy the backup files

Under Windows configuration, the following will be configured under Linux to test, you need to configure the MySQL database synchronization of Friends can refer to.1. On the primary database server, add a user with permission to access the main

When you take over a MySQL database management, you first need to look at the version of the MySQL database that you maintain, and when the developer asks you about the MySQL database version, and you forget it, you also need to look at the MySQL

Environment:Master ip:192.168.10.10Salve ip:192.168.10.201) Install MySQL on both machines.2) Modify Master my.cnf to add the following linesServer-id = 1Log-bin =/opt/mysql/log/mysql-bin.logDataDir =/opt/mysql/dataInnodb_flush_log_at_trx_commit =

Read Catalogue Environment Introduction Configuration of the primary server Configuration from the server Windows Scheduled Backup Database script As I have said in other essays, the company database chooses the

1. The MySQL database does not have a mechanism for incremental backups, which is a big problem when the amount of data is too large. Fortunately, MySQL database provides a mechanism of master-slave backup, in fact, all the data of the primary