Skip to content

Instantly share code, notes, and snippets.

@cdimartino

cdimartino/gist:2347a408097bf1ff70fe04bf0420baf3

Created May 28, 2020 20:36
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 cdimartino/2347a408097bf1ff70fe04bf0420baf3 to your computer and use it in GitHub Desktop.
Save cdimartino/2347a408097bf1ff70fe04bf0420baf3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
mysql> show slave status \G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 172.18.0.119
Master_User: rdsrepladmin
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin-changelog.182568
Read_Master_Log_Pos: 42797165
Relay_Log_File: relaylog.003824
Relay_Log_Pos: 6192083
Relay_Master_Log_File: mysql-bin-changelog.182104
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table: mysql.plugin,mysql.rds_monitor,mysql.rds_sysinfo,innodb_memcache.cache_policies,mysql.rds_history,innodb_memcache.config_options,mysql.rds_configuration,mysql.rds_replication_status
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 6191850
Relay_Log_Space: 10497755866
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 138420
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 1851581175
Master_UUID: b79272b8-b6cf-11e8-b347-02f36a1af49e
Master_Info_File: mysql.slave_master_info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: starting
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp:
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set:
Auto_Position: 0
Replicate_Rewrite_DB:
Channel_Name:
Master_TLS_Version:
1 row in set (0.12 sec)
mysql> show processlist;
+-------+-------------+--------------------+-------------------------------+---------+--------+----------------------------------+----------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+-------------+--------------------+-------------------------------+---------+--------+----------------------------------+----------------------------------------------------------------------------------------------------+
| 19655 | rdsadmin | localhost:44098 | NULL | Sleep | 6 | | NULL |
| 20716 | ut_orders | 10.33.101.80:56454 | usertesting_orders_production | Sleep | 17 | | NULL |
| 20717 | ut_orders | 10.33.101.80:56456 | NULL | Sleep | 17 | | NULL |
| 21070 | ut_orders | 10.33.101.80:52062 | usertesting_orders_production | Query | 666146 | Sending data | SELECT COUNT(*) FROM `test_templates` WHERE (id NOT IN (SELECT DISTINCT(whodunnit) FROM versions)) |
| 21739 | system user | | NULL | Connect | 470309 | Waiting for master to send event | NULL |
| 21740 | system user | | NULL | Connect | 138421 | System lock | NULL |
| 23027 | ut_orders | 10.33.101.80:54316 | usertesting_orders_production | Sleep | 46 | | NULL |
| 23028 | ut_orders | 10.33.101.80:54318 | NULL | Sleep | 56 | | NULL |
| 23054 | ut_orders | 10.33.101.80:58660 | usertesting_orders_production | Sleep | 61 | | NULL |
| 23055 | ut_orders | 10.33.101.80:58662 | NULL | Sleep | 37 | | NULL |
| 23226 | ut_orders | 10.33.101.80:42324 | usertesting_orders_production | Sleep | 7188 | | NULL |
| 23227 | ut_orders | 10.33.101.80:42326 | usertesting_orders_production | Sleep | 7188 | | NULL |
| 23277 | ut_orders | 10.33.101.80:55214 | usertesting_orders_production | Sleep | 218 | | NULL |
| 23278 | ut_orders | 10.33.101.80:55216 | usertesting_orders_production | Sleep | 218 | | NULL |
| 23312 | ut_orders | 10.33.101.80:34198 | usertesting_orders_production | Sleep | 29 | | NULL |
| 23335 | ut_orders | 10.33.101.80:38504 | usertesting_orders_production | Sleep | 9117 | | NULL |
| 23352 | ut_orders | 10.33.101.80:42506 | usertesting_orders_production | Sleep | 4662 | | NULL |
| 23360 | ut_orders | 10.33.101.80:43100 | usertesting_orders_production | Sleep | 3766 | | NULL |
| 23363 | ut_orders | 10.33.101.80:44254 | usertesting_orders_production | Sleep | 2934 | | NULL |
| 23366 | ut_orders | 10.33.101.80:44256 | usertesting_orders_production | Sleep | 1706 | | NULL |
| 23371 | ut_orders | 10.33.101.80:45688 | usertesting_orders_production | Sleep | 1420 | | NULL |
| 23374 | ut_orders | 10.33.101.80:45690 | usertesting_orders_production | Sleep | 911 | | NULL |
| 23378 | ut_orders | 10.33.101.80:47116 | usertesting_orders_production | Query | 0 | starting | show processlist |
+-------+-------------+--------------------+-------------------------------+---------+--------+----------------------------------+----------------------------------------------------------------------------------------------------+
23 rows in set (0.12 sec)
mysql> kill 21070;
Query OK, 0 rows affected (0.16 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment