Skip to content

Instantly share code, notes, and snippets.

@josephglanville

josephglanville/master_status

Created July 29, 2016 05:50
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save josephglanville/7b96c34bb6e79ace33e56627672b98a5 to your computer and use it in GitHub Desktop.
Save josephglanville/7b96c34bb6e79ace33e56627672b98a5 to your computer and use it in GitHub Desktop.
Download ZIP
MariaDB semi-sync hang
Raw
master_status
+--------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+--------------------+----------+--------------+------------------+
| mariadb-bin.000005 | 329 | | |
+--------------------+----------+--------------+------------------+
Raw
processlist master
+-----+----------------------------------+--------------------+----------------------------------+-------------+------+-----------------------------------------------------------------------+------------------------------------------------------------------------------------------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+-----+----------------------------------+--------------------+----------------------------------+-------------+------+-----------------------------------------------------------------------+------------------------------------------------------------------------------------------------------+----------+
| 269 | flynn | 100.100.22.1:54510 | NULL | Binlog Dump | 418 | Master has sent all binlog to slave; waiting for binlog to be updated | NULL | 0.000 |
| 292 | 2a2619764b5ec9c1882a416dbb1deaf2 | 100.100.22.1:58948 | 605792d8c81552a70778a214bd8ffce1 | Query | 245 | Waiting for semi-sync ACK from slave | INSERT INTO `category` VALUES (226789296,'Films_shot_in_Suriname',0,0,0),(226789904,'British_railway | 0.000 |
| 293 | flynn | 100.100.22.1:38760 | mysql | Query | 0 | init | SHOW PROCESSLIST | 0.000 |
+-----+----------------------------------+--------------------+----------------------------------+-------------+------+-----------------------------------------------------------------------+------------------------------------------------------------------------------------------------------+----------+
Raw
processlist slave
+----+-------------+--------------------+------+-------------+------+-----------------------------------------------------------------------------+------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+----+-------------+--------------------+------+-------------+------+-----------------------------------------------------------------------------+------------------+----------+
| 9 | system user | | NULL | Connect | 448 | Waiting for master to send event | NULL | 0.000 |
| 10 | system user | | NULL | Connect | 271 | Slave has read all relay log; waiting for the slave I/O thread to update it | NULL | 0.000 |
| 25 | flynn | 100.100.44.1:33490 | NULL | Binlog Dump | 440 | Master has sent all binlog to slave; waiting for binlog to be updated | NULL | 0.000 |
| 34 | flynn | 100.100.44.1:33544 | NULL | Query | 0 | init | SHOW PROCESSLIST | 0.000 |
+----+-------------+--------------------+------+-------------+------+-----------------------------------------------------------------------------+------------------+----------+
Raw
slave_status
+----------------------------------+--------------+-------------+-------------+---------------+--------------------+---------------------+------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+--------------------+------------------------+-------------------------+-----------------------------+------------+------------+--------------+---------------------+-----------------+-----------------+----------------+---------------+--------------------+--------------------+--------------------+-----------------+-------------------+----------------+-----------------------+-------------------------------+---------------+---------------+----------------+----------------+-----------------------------+------------------+----------------+--------------------+-------------+------------------+-------------------------+-----------------------------+---------------+
| Slave_IO_State | Master_Host | Master_User | Master_Port | Connect_Retry | Master_Log_File | Read_Master_Log_Pos | Relay_Log_File | Relay_Log_Pos | Relay_Master_Log_File | Slave_IO_Running | Slave_SQL_Running | Replicate_Do_DB | Replicate_Ignore_DB | Replicate_Do_Table | Replicate_Ignore_Table | Replicate_Wild_Do_Table | Replicate_Wild_Ignore_Table | Last_Errno | Last_Error | Skip_Counter | Exec_Master_Log_Pos | Relay_Log_Space | Until_Condition | Until_Log_File | Until_Log_Pos | Master_SSL_Allowed | Master_SSL_CA_File | Master_SSL_CA_Path | Master_SSL_Cert | Master_SSL_Cipher | Master_SSL_Key | Seconds_Behind_Master | Master_SSL_Verify_Server_Cert | Last_IO_Errno | Last_IO_Error | Last_SQL_Errno | Last_SQL_Error | Replicate_Ignore_Server_Ids | Master_Server_Id | Master_SSL_Crl | Master_SSL_Crlpath | Using_Gtid | Gtid_IO_Pos | Replicate_Do_Domain_Ids | Replicate_Ignore_Domain_Ids | Parallel_Mode |
+----------------------------------+--------------+-------------+-------------+---------------+--------------------+---------------------+------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+--------------------+------------------------+-------------------------+-----------------------------+------------+------------+--------------+---------------------+-----------------+-----------------+----------------+---------------+--------------------+--------------------+--------------------+-----------------+-------------------+----------------+-----------------------+-------------------------------+---------------+---------------+----------------+----------------+-----------------------------+------------------+----------------+--------------------+-------------+------------------+-------------------------+-----------------------------+---------------+
| Waiting for master to send event | 100.100.22.7 | flynn | 3306 | 10 | mariadb-bin.000005 | 329 | relay-bin.000005 | 619 | mariadb-bin.000005 | Yes | Yes | | | | | | | 0 | | 0 | 329 | 956 | None | | 0 | No | | | | | | 0 | No | 0 | | 0 | | | 1684280839 | | | Current_Pos | 0-1684280839-156 | | | conservative |
+----------------------------------+--------------+-------------+-------------+---------------+--------------------+---------------------+------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+--------------------+------------------------+-------------------------+-----------------------------+------------+------------+--------------+---------------------+-----------------+-----------------+----------------+---------------+--------------------+--------------------+--------------------+-----------------+-------------------+----------------+-----------------------+-------------------------------+---------------+---------------+----------------+----------------+-----------------------------+------------------+----------------+--------------------+-------------+------------------+-------------------------+-----------------------------+---------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment