Times when connection timeout was detected: 2024-01-06 01:52:13 2024-01-06 03:51:05 2024-01-06 05:21:39 2024-01-06 05:27:19 2024-01-06 05:49:01 2024-01-06 09:49:10 2024-01-06 09:49:16 2024-01-06 11:59:43 2024-01-06 12:00:03 2024-01-06 12:07:34 2024-01-06 13:06:04 2024-01-06 13:21:39 2024-01-06 13:27:25 2024-01-06 13:49:13 2024-01-06 15:46:03 2024-01-06 17:09:03 2024-01-06 17:26:49 2024-01-06 17:48:26 2024-01-06 19:54:26 Output of the log queries 4 seconds before the timeout reported: Timestamp: 2024-01-06 01:52:09 Query 1 Output: EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT wait/synch/mutex/sql/THD::LOCK_thd_data 20894157 903195425912 10028 43164 454468960 wait/synch/mutex/sql/THD::LOCK_thd_kill 3779402 302919135324 10028 79788 59977468 wait/synch/mutex/sql/LOCK_table_cache 347734 51290131376 10028 147368 45246336 wait/synch/rwlock/sql/MDL_lock::rwlock 345302 50042156804 10028 144752 24388096 wait/synch/rwlock/innodb/log_latch 493468 31874369036 10028 64528 17157908 wait/synch/rwlock/innodb/lock_latch 597894 27394690960 10028 45780 99237088 wait/synch/mutex/aria/SHARE::bitmap::bitmap_lock 482003 17350004368 10028 35752 52496580 wait/synch/mutex/threadpool/group_mutex 506134 16624628988 10028 32700 26965292 wait/synch/rwlock/innodb/fil_space_latch 201479 10473152948 10028 51884 89550040 wait/synch/rwlock/innodb/trx_purge_latch 183968 3153224376 10028 17004 8142736 wait/synch/mutex/aria/SHARE::intern_lock 24229 1938673128 10028 79788 1955460 wait/synch/rwlock/innodb/trx_rseg_latch 57639 1771887432 10028 30520 17709448 wait/synch/mutex/sql/LOG::LOCK_log 213 1512102064 10028 7098952 873960256 wait/synch/mutex/innodb/buf_pool_mutex 11301 497499108 10028 43600 8112652 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_binlog_end_pos 1066 299466164 10028 280784 23495604 wait/synch/mutex/aria/PAGECACHE::cache_lock 6248 268429504 10028 42728 9546656 wait/synch/rwlock/innodb/dict_operation_lock 6063 243259224 10028 40112 9887608 wait/synch/rwlock/sql/LOCK_system_variables_hash 2453 228086860 10028 92868 882464 wait/synch/mutex/innodb/trx_sys_mutex 1498 211961836 10028 141264 37013348 wait/synch/mutex/mysys/THR_LOCK_threads 747 197641852 30084 264216 1383864 Query 2 Output: *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2024-01-06 01:52:09 0x7f2d916ac640 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 5 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 0 srv_active, 1789 srv_idle srv_master_thread log flush and writes: 1789 ---------- SEMAPHORES ---------- ------------ TRANSACTIONS ------------ Trx id counter 11323634944 Purge done for trx's n:o < 11323634876 undo n:o < 0 state: running History list length 28 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION (0x7f2d92c1c280), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c62f80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c4cf80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c22580), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c4c480), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c29380), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c60e80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c5f880), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c5ed80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c5e280), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c5c180), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c5b680), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c39b80), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c4f080), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c55380), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c61980), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c5a080), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c58a80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c33880), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c4fb80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c57f80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c55e80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c57480), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c4e580), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c29e80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c52780), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c51c80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c53d80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c53280), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c54880), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c50680), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c51180), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c46180), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c44080), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c43580), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c42a80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c2bf80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c3d280), not started ---TRANSACTION (0x7f2d92c50680), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c51180), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c46180), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c44080), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c43580), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c42a80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c2bf80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c3d280), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c2f680), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c41f80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c35980), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c2d580), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c2ca80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c26780), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c34e80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c41480), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c40980), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c3fe80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c34380), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c3bc80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c39080), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c38580), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c36480), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c2a980), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c30c80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c32280), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c27d80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c25c80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c1f980), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c21a80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c2b480), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c25180), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c1cd80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c1e380), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c1a180), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c28880), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c37a80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c1ee80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c23080), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c20480), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c19680), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c1b780), not started ---TRANSACTION (0x7f2d92c1a180), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c28880), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c37a80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c1ee80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c23080), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c20480), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c19680), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c1b780), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c4da80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c4a380), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c3a680), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c27280), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c4b980), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c4ae80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c49880), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c31780), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c48d80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c48280), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c46c80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c2eb80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c1d880), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c3dd80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c3f380), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c32d80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c36f80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c2e080), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c20f80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c1ac80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c3e880), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c3b180), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c3c780), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c5cc80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c59580), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c99480), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c47780), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c5ab80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c24680), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c45680), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c66680), not started ---TRANSACTION (0x7f2d92c30180), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92cb1580), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c56980), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f2d92c18b80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- Pending flushes (fsync): 0 3720843 OS file reads, 846043 OS file writes, 845970 OS fsyncs 58.39 reads/s, 13578 avg bytes/read, 876.82 writes/s, 876.82 fsyncs/s --- LOG --- Log sequence number 14528801076591 Log flushed up to 14528801076591 Pages flushed up to 14523616981843 Last checkpoint at 14523616981843 ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 77846282240 Dictionary memory allocated 459511432 Buffer pool size 4672944 Free buffers 832410 Database pages 3840534 Old database pages 1417677 Modified db pages 747437 Percent of dirty pages(LRU & free pages): 15.995 Max dirty pages percent: 85.000 Pending reads 0 Pending writes: LRU 0, flush list 0 Pages made young 1987591, not young 27297937 1063.59 youngs/s, 29841.23 non-youngs/s Pages read 3720538, created 122734, written 0 58.39 reads/s, 187.36 creates/s, 0.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 1 / 1000 not 39 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 3840534, unzip_LRU len: 0 I/O sum[3213]:cur[122], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 read views open inside InnoDB state: sleeping ---------------------------- END OF INNODB MONITOR OUTPUT ============================ Query 3 Output: VARIABLE_NAME VARIABLE_VALUE ABORTED_CLIENTS 160 ABORTED_CONNECTS 0 ABORTED_CONNECTS_PREAUTH 0 ACCESS_DENIED_ERRORS 0 ACL_COLUMN_GRANTS 0 ACL_DATABASE_GRANTS 50 ACL_FUNCTION_GRANTS 0 ACL_PROCEDURE_GRANTS 0 ACL_PACKAGE_SPEC_GRANTS 0 ACL_PACKAGE_BODY_GRANTS 0 ACL_PROXY_USERS 1 ACL_ROLE_GRANTS 0 ACL_ROLES 0 ACL_TABLE_GRANTS 1 ACL_USERS 40 ARIA_PAGECACHE_BLOCKS_NOT_FLUSHED 0 ARIA_PAGECACHE_BLOCKS_UNUSED 15629 ARIA_PAGECACHE_BLOCKS_USED 745 ARIA_PAGECACHE_READ_REQUESTS 502709 ARIA_PAGECACHE_READS 4865 ARIA_PAGECACHE_WRITE_REQUESTS 198927 ARIA_PAGECACHE_WRITES 198927 ARIA_TRANSACTION_LOG_SYNCS 43 BINLOG_COMMITS 143698 BINLOG_GROUP_COMMITS 142895 BINLOG_GROUP_COMMIT_TRIGGER_COUNT 0 BINLOG_GROUP_COMMIT_TRIGGER_LOCK_WAIT 0 BINLOG_GROUP_COMMIT_TRIGGER_TIMEOUT 0 BINLOG_SNAPSHOT_FILE master22-bin.012526 BINLOG_SNAPSHOT_POSITION 871502194 BINLOG_BYTES_WRITTEN 3019919332 BINLOG_CACHE_DISK_USE 6116 BINLOG_CACHE_USE 143698 BINLOG_STMT_CACHE_DISK_USE 0 BINLOG_STMT_CACHE_USE 0 BUSY_TIME 0.000000 BYTES_RECEIVED 4839588148 BYTES_SENT 21046981981 COLUMN_COMPRESSIONS 0 COLUMN_DECOMPRESSIONS 0 COM_ADMIN_COMMANDS 2 COM_ALTER_DB 0 COM_ALTER_DB_UPGRADE 0 COM_ALTER_EVENT 0 COM_ALTER_FUNCTION 0 COM_ALTER_PROCEDURE 0 COM_ALTER_SERVER 0 COM_ALTER_SEQUENCE 0 COM_ALTER_TABLE 0 COM_ALTER_USER 0 COM_ANALYZE 0 COM_ASSIGN_TO_KEYCACHE 0 COM_BACKUP 0 COM_BACKUP_LOCK 0 COM_BEGIN 4744 COM_BINLOG 0 COM_CALL_PROCEDURE 4744 COM_CHANGE_DB 6876 COM_CHANGE_MASTER 0 COM_CHECK 0 COM_CHECKSUM 0 COM_COMMIT 4744 COM_COMPOUND_SQL 0 COM_CREATE_DB 0 COM_CREATE_EVENT 0 COM_CREATE_FUNCTION 0 COM_CREATE_INDEX 0 COM_CREATE_PACKAGE 0 COM_CREATE_PACKAGE_BODY 0 COM_CREATE_PROCEDURE 0 COM_CREATE_ROLE 0 COM_CREATE_SEQUENCE 0 COM_CREATE_SERVER 0 COM_CREATE_TABLE 0 COM_CREATE_TEMPORARY_TABLE 0 COM_CREATE_TRIGGER 0 COM_CREATE_UDF 0 COM_CREATE_USER 0 COM_CREATE_VIEW 0 COM_DEALLOC_SQL 0 COM_DELETE 8956 COM_DELETE_MULTI 154 COM_DO 0 COM_DROP_DB 0 COM_DROP_EVENT 0 COM_DROP_FUNCTION 0 COM_DROP_INDEX 0 COM_DROP_PROCEDURE 0 COM_DROP_PACKAGE 0 COM_DROP_PACKAGE_BODY 0 COM_DROP_ROLE 0 COM_DROP_SERVER 0 COM_DROP_SEQUENCE 0 COM_DROP_TABLE 0 COM_DROP_TEMPORARY_TABLE 0 COM_DROP_TRIGGER 0 COM_DROP_USER 0 COM_DROP_VIEW 0 COM_EMPTY_QUERY 0 COM_EXECUTE_IMMEDIATE 0 COM_EXECUTE_SQL 0 COM_FLUSH 0 COM_GET_DIAGNOSTICS 0 COM_GRANT 0 COM_GRANT_ROLE 0 COM_HA_CLOSE 0 COM_HA_OPEN 0 COM_HA_READ 0 COM_HELP 0 COM_INSERT 325761 COM_INSERT_SELECT 713380 COM_INSTALL_PLUGIN 0 COM_KILL 0 COM_LOAD 0 COM_LOCK_TABLES 0 COM_OPTIMIZE 0 COM_PRELOAD_KEYS 0 COM_PREPARE_SQL 0 COM_PURGE 0 COM_PURGE_BEFORE_DATE 0 COM_RELEASE_SAVEPOINT 0 COM_RENAME_TABLE 0 COM_RENAME_USER 0 COM_REPAIR 0 COM_REPLACE 0 COM_REPLACE_SELECT 0 COM_RESET 0 COM_RESIGNAL 0 COM_REVOKE 0 COM_REVOKE_ALL 0 COM_REVOKE_ROLE 0 COM_ROLLBACK 0 COM_ROLLBACK_TO_SAVEPOINT 0 COM_SAVEPOINT 0 COM_SELECT 29661267 COM_SET_OPTION 258170 COM_SHOW_AUTHORS 0 COM_SHOW_BINLOG_EVENTS 0 COM_SHOW_BINLOGS 0 COM_SHOW_CHARSETS 0 COM_SHOW_COLLATIONS 0 COM_SHOW_CONTRIBUTORS 0 COM_SHOW_CREATE_DB 0 COM_SHOW_CREATE_EVENT 0 COM_SHOW_CREATE_FUNC 0 COM_SHOW_CREATE_PACKAGE 0 COM_SHOW_CREATE_PACKAGE_BODY 0 COM_SHOW_CREATE_PROC 0 COM_SHOW_CREATE_TABLE 0 COM_SHOW_CREATE_TRIGGER 0 COM_SHOW_CREATE_USER 0 COM_SHOW_DATABASES 0 COM_SHOW_ENGINE_LOGS 0 COM_SHOW_ENGINE_MUTEX 0 COM_SHOW_ENGINE_STATUS 299 COM_SHOW_ERRORS 0 COM_SHOW_EVENTS 0 COM_SHOW_EXPLAIN 0 COM_SHOW_ANALYZE 0 COM_SHOW_FIELDS 0 COM_SHOW_FUNCTION_STATUS 0 COM_SHOW_GENERIC 0 COM_SHOW_GRANTS 0 COM_SHOW_KEYS 0 COM_SHOW_BINLOG_STATUS 0 COM_SHOW_OPEN_TABLES 0 COM_SHOW_PACKAGE_STATUS 0 COM_SHOW_PACKAGE_BODY_STATUS 0 COM_SHOW_PLUGINS 0 COM_SHOW_PRIVILEGES 0 COM_SHOW_PROCEDURE_STATUS 0 COM_SHOW_PROCESSLIST 2 COM_SHOW_PROFILE 0 COM_SHOW_PROFILES 0 COM_SHOW_RELAYLOG_EVENTS 0 COM_SHOW_SLAVE_HOSTS 0 COM_SHOW_SLAVE_STATUS 0 COM_SHOW_STATUS 6886 COM_SHOW_STORAGE_ENGINES 0 COM_SHOW_TABLE_STATUS 0 COM_SHOW_TABLES 0 COM_SHOW_TRIGGERS 0 COM_SHOW_VARIABLES 14 COM_SHOW_WARNINGS 0 COM_SHUTDOWN 0 COM_SIGNAL 0 COM_START_ALL_SLAVES 0 COM_START_SLAVE 0 COM_STMT_CLOSE 0 COM_STMT_EXECUTE 0 COM_STMT_FETCH 0 COM_STMT_PREPARE 0 COM_STMT_REPREPARE 0 COM_STMT_RESET 0 COM_STMT_SEND_LONG_DATA 0 COM_STOP_ALL_SLAVES 0 COM_STOP_SLAVE 0 COM_TRUNCATE 302 COM_UNINSTALL_PLUGIN 0 COM_UNLOCK_TABLES 0 COM_UPDATE 53859 COM_UPDATE_MULTI 0 COM_XA_COMMIT 0 COM_XA_END 0 COM_XA_PREPARE 0 COM_XA_RECOVER 0 COM_XA_ROLLBACK 0 COM_XA_START 0 COMPRESSION OFF CONNECTION_ERRORS_ACCEPT 0 CONNECTION_ERRORS_INTERNAL 0 CONNECTION_ERRORS_MAX_CONNECTIONS 0 CONNECTION_ERRORS_PEER_ADDRESS 0 CONNECTION_ERRORS_SELECT 0 CONNECTION_ERRORS_TCPWRAP 0 CONNECTIONS 298564 CPU_TIME 0.000000 CREATED_TMP_DISK_TABLES 4845 CREATED_TMP_FILES 656 CREATED_TMP_TABLES 33860 DELAYED_ERRORS 0 DELAYED_INSERT_THREADS 0 DELAYED_WRITES 0 DELETE_SCAN 1151 EMPTY_QUERIES 4416700 EXECUTED_EVENTS 0 EXECUTED_TRIGGERS 0 FEATURE_APPLICATION_TIME_PERIODS 0 FEATURE_CHECK_CONSTRAINT 3 FEATURE_CUSTOM_AGGREGATE_FUNCTIONS 0 FEATURE_DELAY_KEY_WRITE 0 FEATURE_DYNAMIC_COLUMNS 0 FEATURE_FULLTEXT 0 FEATURE_GIS 0 FEATURE_INSERT_RETURNING 0 FEATURE_INTO_OUTFILE 0 FEATURE_INTO_VARIABLE 25 FEATURE_INVISIBLE_COLUMNS 0 FEATURE_JSON 312 FEATURE_LOCALE 0 FEATURE_SUBQUERY 2611 FEATURE_SYSTEM_VERSIONING 0 FEATURE_TIMEZONE 0 FEATURE_TRIGGER 0 FEATURE_WINDOW_FUNCTIONS 0 FEATURE_XML 0 HANDLER_COMMIT 31826270 HANDLER_DELETE 7156317 HANDLER_DISCOVER 300 HANDLER_EXTERNAL_LOCK 0 HANDLER_ICP_ATTEMPTS 19269664 HANDLER_ICP_MATCH 19253363 HANDLER_MRR_INIT 0 HANDLER_MRR_KEY_REFILLS 0 HANDLER_MRR_ROWID_REFILLS 0 HANDLER_PREPARE 2137838 HANDLER_READ_FIRST 4874 HANDLER_READ_KEY 65486481 HANDLER_READ_LAST 136 HANDLER_READ_NEXT 129838595 HANDLER_READ_PREV 826280 HANDLER_READ_RETRY 0 HANDLER_READ_RND 956207 HANDLER_READ_RND_DELETED 114 HANDLER_READ_RND_NEXT 46390208 HANDLER_ROLLBACK 0 HANDLER_SAVEPOINT 0 HANDLER_SAVEPOINT_ROLLBACK 0 HANDLER_TMP_DELETE 0 HANDLER_TMP_UPDATE 184789 HANDLER_TMP_WRITE 7593570 HANDLER_UPDATE 460617 HANDLER_WRITE 6465553 INNODB_ADAPTIVE_HASH_HASH_SEARCHES 0 INNODB_ADAPTIVE_HASH_NON_HASH_SEARCHES 0 INNODB_BACKGROUND_LOG_SYNC 1789 INNODB_BUFFER_POOL_DUMP_STATUS INNODB_BUFFER_POOL_LOAD_STATUS Buffer pool(s) load completed at 240106 1:22:46 INNODB_BUFFER_POOL_RESIZE_STATUS INNODB_BUFFER_POOL_LOAD_INCOMPLETE OFF INNODB_BUFFER_POOL_PAGES_DATA 3840534 INNODB_BUFFER_POOL_BYTES_DATA 62923309056 INNODB_BUFFER_POOL_PAGES_DIRTY 747437 INNODB_BUFFER_POOL_BYTES_DIRTY 12246007808 INNODB_BUFFER_POOL_PAGES_FLUSHED 0 INNODB_BUFFER_POOL_PAGES_FREE 832410 INNODB_BUFFER_POOL_PAGES_MADE_NOT_YOUNG 27297937 INNODB_BUFFER_POOL_PAGES_MADE_YOUNG 1987591 INNODB_BUFFER_POOL_PAGES_MISC 0 INNODB_BUFFER_POOL_PAGES_OLD 1417677 INNODB_BUFFER_POOL_PAGES_TOTAL 4672944 INNODB_BUFFER_POOL_PAGES_LRU_FLUSHED 0 INNODB_BUFFER_POOL_PAGES_LRU_FREED 0 INNODB_BUFFER_POOL_PAGES_SPLIT 118270 INNODB_BUFFER_POOL_READ_AHEAD_RND 0 INNODB_BUFFER_POOL_READ_AHEAD 11981 INNODB_BUFFER_POOL_READ_AHEAD_EVICTED 0 INNODB_BUFFER_POOL_READ_REQUESTS 0 INNODB_BUFFER_POOL_READS 3720538 INNODB_BUFFER_POOL_WAIT_FREE 0 INNODB_BUFFER_POOL_WRITE_REQUESTS 88310302 INNODB_CHECKPOINT_AGE 5184094748 INNODB_CHECKPOINT_MAX_AGE 13914976298 INNODB_DATA_FSYNCS 845970 INNODB_DATA_PENDING_FSYNCS 0 INNODB_DATA_PENDING_READS 0 INNODB_DATA_PENDING_WRITES 0 INNODB_DATA_READ 60957229056 INNODB_DATA_READS 3720843 INNODB_DATA_WRITES 846043 INNODB_DATA_WRITTEN 0 INNODB_DBLWR_PAGES_WRITTEN 0 INNODB_DBLWR_WRITES 0 INNODB_DEADLOCKS 0 INNODB_HISTORY_LIST_LENGTH 28 INNODB_LOG_WAITS 0 INNODB_LOG_WRITE_REQUESTS 85073128 INNODB_LOG_WRITES 845914 INNODB_LSN_CURRENT 14528801076591 INNODB_LSN_FLUSHED 14528801076591 INNODB_LSN_LAST_CHECKPOINT 14523616981843 INNODB_MASTER_THREAD_ACTIVE_LOOPS 0 INNODB_MASTER_THREAD_IDLE_LOOPS 1789 INNODB_MAX_TRX_ID 11323634944 INNODB_MEM_ADAPTIVE_HASH 0 INNODB_MEM_DICTIONARY 459511432 INNODB_OS_LOG_WRITTEN 5184094795 INNODB_PAGE_SIZE 16384 INNODB_PAGES_CREATED 122734 INNODB_PAGES_READ 3720538 INNODB_PAGES_WRITTEN 0 INNODB_ROW_LOCK_CURRENT_WAITS 0 INNODB_ROW_LOCK_TIME 4085 INNODB_ROW_LOCK_TIME_AVG 3 INNODB_ROW_LOCK_TIME_MAX 42 INNODB_ROW_LOCK_WAITS 1104 INNODB_NUM_OPEN_FILES 294 INNODB_TRUNCATED_STATUS_WRITES 0 INNODB_AVAILABLE_UNDO_LOGS 128 INNODB_UNDO_TRUNCATIONS 0 INNODB_PAGE_COMPRESSION_SAVED 0 INNODB_NUM_PAGES_PAGE_COMPRESSED 0 INNODB_NUM_PAGE_COMPRESSED_TRIM_OP 0 INNODB_NUM_PAGES_PAGE_DECOMPRESSED 0 INNODB_NUM_PAGES_PAGE_COMPRESSION_ERROR 0 INNODB_NUM_PAGES_ENCRYPTED 0 INNODB_NUM_PAGES_DECRYPTED 0 INNODB_HAVE_LZ4 OFF INNODB_HAVE_LZO OFF INNODB_HAVE_LZMA OFF INNODB_HAVE_BZIP2 OFF INNODB_HAVE_SNAPPY OFF INNODB_HAVE_PUNCH_HOLE ON INNODB_INSTANT_ALTER_COLUMN 0 INNODB_ONLINEDDL_ROWLOG_ROWS 0 INNODB_ONLINEDDL_ROWLOG_PCT_USED 0 INNODB_ONLINEDDL_PCT_PROGRESS 0 INNODB_ENCRYPTION_ROTATION_PAGES_READ_FROM_CACHE 0 INNODB_ENCRYPTION_ROTATION_PAGES_READ_FROM_DISK 0 INNODB_ENCRYPTION_ROTATION_PAGES_MODIFIED 0 INNODB_ENCRYPTION_ROTATION_PAGES_FLUSHED 0 INNODB_ENCRYPTION_ROTATION_ESTIMATED_IOPS 0 INNODB_ENCRYPTION_N_MERGE_BLOCKS_ENCRYPTED 0 INNODB_ENCRYPTION_N_MERGE_BLOCKS_DECRYPTED 0 INNODB_ENCRYPTION_N_ROWLOG_BLOCKS_ENCRYPTED 0 INNODB_ENCRYPTION_N_ROWLOG_BLOCKS_DECRYPTED 0 INNODB_ENCRYPTION_N_TEMP_BLOCKS_ENCRYPTED 0 INNODB_ENCRYPTION_N_TEMP_BLOCKS_DECRYPTED 0 INNODB_ENCRYPTION_NUM_KEY_REQUESTS 0 KEY_BLOCKS_NOT_FLUSHED 0 KEY_BLOCKS_UNUSED 8279 KEY_BLOCKS_USED 0 KEY_BLOCKS_WARM 0 KEY_READ_REQUESTS 0 KEY_READS 0 KEY_WRITE_REQUESTS 0 KEY_WRITES 0 LAST_QUERY_COST 0.000000 MASTER_GTID_WAIT_COUNT 0 MASTER_GTID_WAIT_TIME 0 MASTER_GTID_WAIT_TIMEOUTS 0 MAX_STATEMENT_TIME_EXCEEDED 0 MAX_USED_CONNECTIONS 537 MAX_USED_CONNECTIONS_TIME 2024-01-06 01:30:50 MEMORY_USED 78058278112 MEMORY_USED_INITIAL 78005352352 NOT_FLUSHED_DELAYED_ROWS 0 OPEN_FILES 67 OPEN_STREAMS 4 OPEN_TABLE_DEFINITIONS 501 OPEN_TABLES 503 OPENED_FILES 20762 OPENED_PLUGIN_LIBRARIES 0 OPENED_TABLE_DEFINITIONS 704 OPENED_TABLES 816 OPENED_VIEWS 1 OPTIMIZER_JOIN_PREFIXES_CHECK_CALLS 25955172 PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0 PERFORMANCE_SCHEMA_COND_CLASSES_LOST 0 PERFORMANCE_SCHEMA_COND_INSTANCES_LOST 0 PERFORMANCE_SCHEMA_DIGEST_LOST 0 PERFORMANCE_SCHEMA_FILE_CLASSES_LOST 0 PERFORMANCE_SCHEMA_FILE_HANDLES_LOST 0 PERFORMANCE_SCHEMA_FILE_INSTANCES_LOST 0 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_INDEX_STAT_LOST 0 PERFORMANCE_SCHEMA_LOCKER_LOST 0 PERFORMANCE_SCHEMA_MEMORY_CLASSES_LOST 0 PERFORMANCE_SCHEMA_METADATA_LOCK_LOST 0 PERFORMANCE_SCHEMA_MUTEX_CLASSES_LOST 0 PERFORMANCE_SCHEMA_MUTEX_INSTANCES_LOST 0 PERFORMANCE_SCHEMA_NESTED_STATEMENT_LOST 0 PERFORMANCE_SCHEMA_PREPARED_STATEMENTS_LOST 0 PERFORMANCE_SCHEMA_PROGRAM_LOST 0 PERFORMANCE_SCHEMA_RWLOCK_CLASSES_LOST 0 PERFORMANCE_SCHEMA_RWLOCK_INSTANCES_LOST 0 PERFORMANCE_SCHEMA_SESSION_CONNECT_ATTRS_LOST 0 PERFORMANCE_SCHEMA_SOCKET_CLASSES_LOST 0 PERFORMANCE_SCHEMA_SOCKET_INSTANCES_LOST 0 PERFORMANCE_SCHEMA_STAGE_CLASSES_LOST 0 PERFORMANCE_SCHEMA_STATEMENT_CLASSES_LOST 0 PERFORMANCE_SCHEMA_TABLE_HANDLES_LOST 0 PERFORMANCE_SCHEMA_TABLE_INSTANCES_LOST 0 PERFORMANCE_SCHEMA_TABLE_LOCK_STAT_LOST 0 PERFORMANCE_SCHEMA_THREAD_CLASSES_LOST 0 PERFORMANCE_SCHEMA_THREAD_INSTANCES_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 PREPARED_STMT_COUNT 0 QCACHE_FREE_BLOCKS 0 QCACHE_FREE_MEMORY 0 QCACHE_HITS 0 QCACHE_INSERTS 0 QCACHE_LOWMEM_PRUNES 0 QCACHE_NOT_CACHED 0 QCACHE_QUERIES_IN_CACHE 0 QCACHE_TOTAL_BLOCKS 0 QUERIES 36588761 QUESTIONS 30148405 RESULTSET_METADATA_SKIPPED 0 ROWS_READ 174738879 ROWS_SENT 74062715 ROWS_TMP_READ 8019223 RPL_SEMI_SYNC_MASTER_CLIENTS 0 RPL_SEMI_SYNC_MASTER_GET_ACK 0 RPL_SEMI_SYNC_MASTER_NET_AVG_WAIT_TIME 0 RPL_SEMI_SYNC_MASTER_NET_WAIT_TIME 0 RPL_SEMI_SYNC_MASTER_NET_WAITS 0 RPL_SEMI_SYNC_MASTER_NO_TIMES 0 RPL_SEMI_SYNC_MASTER_NO_TX 0 RPL_SEMI_SYNC_MASTER_REQUEST_ACK 0 RPL_SEMI_SYNC_MASTER_STATUS OFF RPL_SEMI_SYNC_MASTER_TIMEFUNC_FAILURES 0 RPL_SEMI_SYNC_MASTER_TX_AVG_WAIT_TIME 0 RPL_SEMI_SYNC_MASTER_TX_WAIT_TIME 0 RPL_SEMI_SYNC_MASTER_TX_WAITS 0 RPL_SEMI_SYNC_MASTER_WAIT_POS_BACKTRAVERSE 0 RPL_SEMI_SYNC_MASTER_WAIT_SESSIONS 0 RPL_SEMI_SYNC_MASTER_YES_TX 0 RPL_SEMI_SYNC_SLAVE_SEND_ACK 0 RPL_SEMI_SYNC_SLAVE_STATUS OFF RPL_STATUS AUTH_MASTER RPL_TRANSACTIONS_MULTI_ENGINE 0 SELECT_FULL_JOIN 2 SELECT_FULL_RANGE_JOIN 0 SELECT_RANGE 33868 SELECT_RANGE_CHECK 0 SELECT_SCAN 1032906 SLAVE_CONNECTIONS 2 SLAVE_HEARTBEAT_PERIOD 0.000 SLAVE_OPEN_TEMP_TABLES 0 SLAVE_RECEIVED_HEARTBEATS 0 SLAVE_RETRIED_TRANSACTIONS 0 SLAVE_RUNNING OFF SLAVE_SKIPPED_ERRORS 0 SLAVES_CONNECTED 2 SLAVES_RUNNING 0 SLOW_LAUNCH_THREADS 0 SLOW_QUERIES 1 SORT_MERGE_PASSES 305 SORT_PRIORITY_QUEUE_SORTS 16888 SORT_RANGE 4255988 SORT_ROWS 10399697 SORT_SCAN 31047 SSL_ACCEPT_RENEGOTIATES 0 SSL_ACCEPTS 0 SSL_CALLBACK_CACHE_HITS 0 SSL_CIPHER SSL_CIPHER_LIST SSL_CLIENT_CONNECTS 0 SSL_CONNECT_RENEGOTIATES 0 SSL_CTX_VERIFY_DEPTH 0 SSL_CTX_VERIFY_MODE 0 SSL_DEFAULT_TIMEOUT 0 SSL_FINISHED_ACCEPTS 0 SSL_FINISHED_CONNECTS 0 SSL_SERVER_NOT_AFTER SSL_SERVER_NOT_BEFORE SSL_SESSION_CACHE_HITS 0 SSL_SESSION_CACHE_MISSES 0 SSL_SESSION_CACHE_MODE NONE SSL_SESSION_CACHE_OVERFLOWS 0 SSL_SESSION_CACHE_SIZE 0 SSL_SESSION_CACHE_TIMEOUTS 0 SSL_SESSIONS_REUSED 0 SSL_USED_SESSION_CACHE_ENTRIES 0 SSL_VERIFY_DEPTH 0 SSL_VERIFY_MODE 0 SSL_VERSION SUBQUERY_CACHE_HIT 0 SUBQUERY_CACHE_MISS 1064 SYNCS 143021 TABLE_LOCKS_IMMEDIATE 1322 TABLE_LOCKS_WAITED 0 TABLE_OPEN_CACHE_ACTIVE_INSTANCES 1 TABLE_OPEN_CACHE_HITS 31070488 TABLE_OPEN_CACHE_MISSES 817 TABLE_OPEN_CACHE_OVERFLOWS 0 TC_LOG_MAX_PAGES_USED 0 TC_LOG_PAGE_SIZE 0 TC_LOG_PAGE_WAITS 0 THREADPOOL_IDLE_THREADS 208 THREADPOOL_THREADS 212 THREADS_CACHED 0 THREADS_CONNECTED 129 THREADS_CREATED 872 THREADS_RUNNING 5 TRANSACTIONS_GTID_FOREIGN_ENGINE 0 TRANSACTIONS_MULTI_ENGINE 0 UPDATE_SCAN 17490 UPTIME 1790 UPTIME_SINCE_FLUSH_STATUS 1790 WSREP 0 WSREP_APPLIER_THREAD_COUNT 0 WSREP_CLUSTER_CAPABILITIES WSREP_CLUSTER_CONF_ID 18446744073709551615 WSREP_CLUSTER_SIZE 0 WSREP_CLUSTER_STATE_UUID WSREP_CLUSTER_STATUS Disconnected WSREP_CONNECTED OFF WSREP_LOCAL_BF_ABORTS 0 WSREP_LOCAL_INDEX 18446744073709551615 WSREP_PROVIDER_CAPABILITIES WSREP_PROVIDER_NAME WSREP_PROVIDER_VENDOR WSREP_PROVIDER_VERSION WSREP_READY OFF WSREP_ROLLBACKER_THREAD_COUNT 0 WSREP_THREAD_COUNT 0