Slave_sql_running_state parameters in MySQL main library copy

To view a command:

Show Slave Status\g

Other related parameters:

seconds_behind_master:1287

Slave_sql_running_state Common status values:

Slave_sql_running_state:slave have read all relay log; Waiting for the slave I/O thread to update it

The synchronization log is also fully executed, the most common state.

Slave_sql_running_state:updating

The synchronization log is being used for the update.

Slave_sql_running_state:waiting for table level lock

Waiting for a table lock to be paused from the library copy operation is generally due to the fact that the table is a MyISAM storage engine, which is caused by a large number of update operations.

Slave_sql_running_state:waiting for Table metadata Lock

Waiting to get a metadata lock, the copy operation from the library is paused, typically because the table is modifying the table structure.

This article is from the "twists and turns ◇2015" blog, please be sure to keep this source http://huangfuff.blog.51cto.com/2632203/1604073

Slave_sql_running_state parameters in MySQL main library copy