Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> show processlist ;
- +----+-------------+-----------+------+---------+-------+----------------------------------+------------------+
- | Id | User | Host | db | Command | Time | State | Info |
- +----+-------------+-----------+------+---------+-------+----------------------------------+------------------+
- | 10 | system user | | NULL | Connect | 1803 | Waiting for master to send event | NULL |
- | 11 | system user | | NULL | Connect | 51074 | Reading event from the relay log | NULL |
- | 13 | root | localhost | NULL | Query | 0 | init | show processlist |
- +----+-------------+-----------+------+---------+-------+----------------------------------+------------------+
- 3 rows in set (0.00 sec)
- SQL_Remaining_Delay: NULL
- Slave_SQL_Running_State: System lock
- # at 157339529
- #141023 3:31:44 server id 110 end_log_pos 157339430 CRC32 0xd98f9571 Query thread_id=528336 exec_time=0 error_code=0
- SET TIMESTAMP=1414035104/*!*/;
- # at 181969091
- #141023 4:29:01 server id 110 end_log_pos 181968992 CRC32 0xb6072e6b Query thread_id=530335 exec_time=0 error_code=0
- SET TIMESTAMP=1414038541/*!*/;
- ----------------------
- INDIVIDUAL BUFFER POOL INFO
- ----------------------
- ---BUFFER POOL 0
- Buffer pool size 163839
- Free buffers 140920
- Database pages 22619
- Old database pages 8369
- Modified db pages 131
- Pending reads 0
- LIST OF TRANSACTIONS FOR EACH SESSION:
- ---TRANSACTION 0, not started
- MySQL thread id 14, OS thread handle 0x7f7824698700, query id 216193 localhost root init
- show engine innodb status
- ---TRANSACTION 230426904, not started
- mysql tables in use 1638, locked 1638
- MySQL thread id 11, OS thread handle 0x7f7824920700, query id 216192 System lock
- --------
- 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)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement