mysql> show slave status \G ^Z [1]+ Stopped mysql DB-SLAVE-BKP:[root@p-spuoljc06db03v ~]# bg [1]+ mysql & DB-SLAVE-BKP:[root@p-spuoljc06db03v ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 Server version: 5.6.30-76.3-log Percona Server (GPL), Release 76.3, Revision 3850db5 Copyright (c) 2009-2016 Percona LLC and/or its affiliates Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show processlist; +----+-------------+-----------+------+---------+--------+----------------------------------------+-------------------+-----------+---------------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined | +----+-------------+-----------+------+---------+--------+----------------------------------------+-------------------+-----------+---------------+ | 1 | system user | | NULL | Connect | 2539 | Queueing master event to the relay log | NULL | 0 | 0 | | 2 | system user | | NULL | Connect | 106804 | Reading event from the relay log | NULL | 0 | 0 | | 5 | root | localhost | NULL | Query | 455 | init | show slave status | 0 | 0 | | 6 | root | localhost | NULL | Query | 0 | init | show processlist | 0 | 0 | +----+-------------+-----------+------+---------+--------+----------------------------------------+-------------------+-----------+---------------+ 4 rows in set (0.00 sec) mysql> show engine innodb status \G *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2016-10-11 21:42:43 7fd44018f700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 47 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 550 srv_active, 0 srv_shutdown, 1984 srv_idle srv_master_thread log flush and writes: 2534 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 4951 OS WAIT ARRAY INFO: signal count 4954 Mutex spin waits 6001, rounds 110853, OS waits 3588 RW-shared spins 2087, rounds 39581, OS waits 733 RW-excl spins 896, rounds 23566, OS waits 603 Spin rounds per wait: 18.47 mutex, 18.97 RW-shared, 26.30 RW-excl ------------ TRANSACTIONS ------------ Trx id counter 1261005628 Purge done for trx's n:o < 1261005628 undo n:o < 0 state: running but idle History list length 903 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started MySQL thread id 6, OS thread handle 0x7fd44018f700, query id 162830 localhost root init show engine innodb status ---TRANSACTION 1261005614, not started MySQL thread id 2, OS thread handle 0x7fd74405a700, query id 162825 Reading event from the relay log -------- FILE I/O -------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread) I/O thread 1 state: waiting for completed aio requests (log thread) I/O thread 2 state: waiting for completed aio requests (read thread) I/O thread 3 state: waiting for completed aio requests (read thread) I/O thread 4 state: waiting for completed aio requests (read thread) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (read thread) I/O thread 7 state: waiting for completed aio requests (read thread) I/O thread 8 state: waiting for completed aio requests (write thread) I/O thread 9 state: waiting for completed aio requests (write thread) I/O thread 10 state: waiting for completed aio requests (write thread) I/O thread 11 state: waiting for completed aio requests (write thread) I/O thread 12 state: waiting for completed aio requests (write thread) I/O thread 13 state: waiting for completed aio requests (write thread) Pending normal aio reads: 0 [0, 0, 0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 83516 OS file reads, 109523 OS file writes, 5054 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 35111, seg size 35113, 14351 merges merged operations: insert 3501, delete mark 10962, delete 38 discarded operations: insert 0, delete mark 0, delete 0 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 1987121911473 Log flushed up to 1987121911473 Pages flushed up to 1987121911473 Last checkpoint at 1987121911473 Max checkpoint age 216721613 Checkpoint age target 209949063 Modified age 0 Checkpoint age 0 0 pending log writes, 0 pending chkp writes 34908 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 12295602176; in additional pool allocated 0 Total memory allocated by read views 192 Internal hash tables (constant factor + variable factor) Adaptive hash index 197062224 (186998248 + 10063976) Page hash 5844472 (buffer pool 0 only) Dictionary cache 48131288 (46751216 + 1380072) File system 1398592 (812272 + 586320) Lock system 29220088 (29219368 + 720) Recovery system 0 (0 + 0) Dictionary memory allocated 1380072 Buffer pool size 720894 Buffer pool size, bytes 11811127296 Free buffers 634047 Database pages 86233 Old database pages 31871 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 218, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 83468, created 2765, written 73057 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 86233, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 360447 Buffer pool size, bytes 5905563648 Free buffers 317409 Database pages 42733 Old database pages 15794 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 98, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 41395, created 1338, written 36455 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 42733, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 360447 Buffer pool size, bytes 5905563648 Free buffers 316638 Database pages 43500 Old database pages 16077 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 120, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 42073, created 1427, written 36602 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 43500, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB 0 RW transactions active inside InnoDB 0 RO transactions active inside InnoDB 0 out of 1000 descriptors used Main thread process no. 14047, id 140549610616576, state: sleeping Number of rows inserted 26653, updated 45932, deleted 30152, read 116498 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 1 row in set (0.01 sec) mysql> show engine innodb mutex; +--------+------------------------------+---------------+ | Type | Name | Status | +--------+------------------------------+---------------+ | InnoDB | &rseg->mutex | os_waits=1 | | InnoDB | &rseg->mutex | os_waits=1 | | InnoDB | &rseg->mutex | os_waits=1 | | InnoDB | &dict_sys->mutex | os_waits=4 | | InnoDB | &trx_sys->mutex | os_waits=4 | | InnoDB | &lock_sys->mutex | os_waits=2 | | InnoDB | &log_sys->mutex | os_waits=3525 | | InnoDB | &buf_pool->flush_state_mutex | os_waits=36 | | InnoDB | &buf_pool->flush_state_mutex | os_waits=14 | | InnoDB | &new_index->lock | os_waits=22 | | InnoDB | &new_index->lock | os_waits=11 | | InnoDB | &new_index->lock | os_waits=2 | | InnoDB | &new_index->lock | os_waits=53 | | InnoDB | &new_index->lock | os_waits=1 | | InnoDB | &new_index->lock | os_waits=1 | | InnoDB | &dict_operation_lock | os_waits=180 | | InnoDB | &space->latch | os_waits=2 | | InnoDB | &log_sys->checkpoint_lock | os_waits=6 | | InnoDB | &btr_search_latch_arr[i] | os_waits=3 | | InnoDB | combined &block->lock | os_waits=1055 | +--------+------------------------------+---------------+ 20 rows in set (0.18 sec) mysql> show engine innodb mutex; +--------+------------------------------+---------------+ | Type | Name | Status | +--------+------------------------------+---------------+ | InnoDB | &rseg->mutex | os_waits=1 | | InnoDB | &rseg->mutex | os_waits=1 | | InnoDB | &rseg->mutex | os_waits=1 | | InnoDB | &dict_sys->mutex | os_waits=4 | | InnoDB | &trx_sys->mutex | os_waits=4 | | InnoDB | &lock_sys->mutex | os_waits=2 | | InnoDB | &log_sys->mutex | os_waits=3525 | | InnoDB | &buf_pool->flush_state_mutex | os_waits=36 | | InnoDB | &buf_pool->flush_state_mutex | os_waits=14 | | InnoDB | &new_index->lock | os_waits=22 | | InnoDB | &new_index->lock | os_waits=11 | | InnoDB | &new_index->lock | os_waits=2 | | InnoDB | &new_index->lock | os_waits=53 | | InnoDB | &new_index->lock | os_waits=1 | | InnoDB | &new_index->lock | os_waits=1 | | InnoDB | &dict_operation_lock | os_waits=180 | | InnoDB | &space->latch | os_waits=2 | | InnoDB | &log_sys->checkpoint_lock | os_waits=6 | | InnoDB | &btr_search_latch_arr[i] | os_waits=3 | | InnoDB | combined &block->lock | os_waits=1055 | +--------+------------------------------+---------------+ 20 rows in set (0.09 sec) mysql> show engine innodb mutex; +--------+------------------------------+---------------+ | Type | Name | Status | +--------+------------------------------+---------------+ | InnoDB | &rseg->mutex | os_waits=1 | | InnoDB | &rseg->mutex | os_waits=1 | | InnoDB | &rseg->mutex | os_waits=1 | | InnoDB | &dict_sys->mutex | os_waits=4 | | InnoDB | &trx_sys->mutex | os_waits=4 | | InnoDB | &lock_sys->mutex | os_waits=2 | | InnoDB | &log_sys->mutex | os_waits=3525 | | InnoDB | &buf_pool->flush_state_mutex | os_waits=36 | | InnoDB | &buf_pool->flush_state_mutex | os_waits=14 | | InnoDB | &new_index->lock | os_waits=22 | | InnoDB | &new_index->lock | os_waits=11 | | InnoDB | &new_index->lock | os_waits=2 | | InnoDB | &new_index->lock | os_waits=53 | | InnoDB | &new_index->lock | os_waits=1 | | InnoDB | &new_index->lock | os_waits=1 | | InnoDB | &dict_operation_lock | os_waits=180 | | InnoDB | &space->latch | os_waits=2 | | InnoDB | &log_sys->checkpoint_lock | os_waits=6 | | InnoDB | &btr_search_latch_arr[i] | os_waits=3 | | InnoDB | combined &block->lock | os_waits=1055 | +--------+------------------------------+---------------+ 20 rows in set (0.15 sec) mysql> \! free -m total used free shared buff/cache available Mem: 15887 2729 169 152 12988 12730 Swap: 2047 0 2047 mysql> \! cat /etc/issue \S Kernel \r on an \m mysql> \! cat /etc/centos-release CentOS Linux release 7.2.1511 (Core) mysql> status -------------- mysql Ver 14.14 Distrib 5.6.30-76.3, for Linux (x86_64) using 6.2 Connection id: 6 Current database: Current user: root@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server version: 5.6.30-76.3-log Percona Server (GPL), Release 76.3, Revision 3850db5 Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client characterset: utf8 Conn. characterset: utf8 UNIX socket: /var/lib/mysql/mysql.sock Uptime: 43 min 39 sec Threads: 4 Questions: 162839 Slow queries: 0 Opens: 96 Flush tables: 1 Open tables: 89 Queries per second avg: 62.176 -------------- top - 21:44:45 up 83 days, 2:52, 1 user, load average: 0.00, 0.01, 0.13 Tasks: 142 total, 2 running, 140 sleeping, 0 stopped, 0 zombie %Cpu(s): 0.0 us, 0.1 sy, 0.0 ni, 99.9 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st KiB Mem : 16268380 total, 170532 free, 2794680 used, 13303168 buff/cache KiB Swap: 2097148 total, 2097148 free, 0 used. 13036472 avail Mem PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 14047 mysql 20 0 13.591g 2.483g 8396 S 0.3 16.0 3:55.12 /usr/sbin/mysqld --basedir=/usr --datadir=/mysql/data --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/mys+ 443 root 20 0 131340 71116 66652 S 0.0 0.4 0:44.38 /usr/lib/systemd/systemd-journald 653 root 20 0 456328 50144 45156 S 0.0 0.3 0:14.92 /usr/sbin/rsyslogd -n 917 root 20 0 553160 13208 488 S 0.0 0.1 9:35.19 /usr/bin/python -Es /usr/sbin/tuned -l -P 20016 root 20 0 110528 13084 624 S 0.0 0.1 0:00.32 /sbin/dhclient -H p-spuoljc06db03v -q -lf /var/lib/dhclient/dhclient--eth0.lease -pf /var/run/dhclient-eth0.pid eth0 19685 polkitd 20 0 527576 8636 936 S 0.0 0.1 0:13.62 /usr/lib/polkit-1/polkitd --no-debug 1 root 20 0 45972 7428 1328 S 0.0 0.0 3:02.27 /usr/lib/systemd/systemd --system --deserialize 16 Packages: Percona-Server-client-56-5.6.30-rel76.3.el7.x86_64 Percona-Server-shared-56-5.6.30-rel76.3.el7.x86_64 Percona-Server-server-56-5.6.30-rel76.3.el7.x86_64