Advertisement
Guest User

Untitled

a guest
Oct 23rd, 2014
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.18 KB | None | 0 0
  1. mysql> show processlist ;
  2. +----+-------------+-----------+------+---------+-------+----------------------------------+------------------+
  3. | Id | User | Host | db | Command | Time | State | Info |
  4. +----+-------------+-----------+------+---------+-------+----------------------------------+------------------+
  5. | 10 | system user | | NULL | Connect | 1803 | Waiting for master to send event | NULL |
  6. | 11 | system user | | NULL | Connect | 51074 | Reading event from the relay log | NULL |
  7. | 13 | root | localhost | NULL | Query | 0 | init | show processlist |
  8. +----+-------------+-----------+------+---------+-------+----------------------------------+------------------+
  9. 3 rows in set (0.00 sec)
  10.  
  11. SQL_Remaining_Delay: NULL
  12. Slave_SQL_Running_State: System lock
  13.  
  14. # at 157339529
  15. #141023 3:31:44 server id 110 end_log_pos 157339430 CRC32 0xd98f9571 Query thread_id=528336 exec_time=0 error_code=0
  16. SET TIMESTAMP=1414035104/*!*/;
  17.  
  18. # at 181969091
  19. #141023 4:29:01 server id 110 end_log_pos 181968992 CRC32 0xb6072e6b Query thread_id=530335 exec_time=0 error_code=0
  20. SET TIMESTAMP=1414038541/*!*/;
  21.  
  22. ----------------------
  23. INDIVIDUAL BUFFER POOL INFO
  24. ----------------------
  25. ---BUFFER POOL 0
  26. Buffer pool size 163839
  27. Free buffers 140920
  28. Database pages 22619
  29. Old database pages 8369
  30. Modified db pages 131
  31. Pending reads 0
  32.  
  33. LIST OF TRANSACTIONS FOR EACH SESSION:
  34. ---TRANSACTION 0, not started
  35. MySQL thread id 14, OS thread handle 0x7f7824698700, query id 216193 localhost root init
  36. show engine innodb status
  37. ---TRANSACTION 230426904, not started
  38. mysql tables in use 1638, locked 1638
  39. MySQL thread id 11, OS thread handle 0x7f7824920700, query id 216192 System lock
  40. --------
  41. FILE I/O
  42. --------
  43. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  44. I/O thread 1 state: waiting for completed aio requests (log thread)
  45. I/O thread 2 state: waiting for completed aio requests (read thread)
  46. I/O thread 3 state: waiting for completed aio requests (read thread)
  47. I/O thread 4 state: waiting for completed aio requests (read thread)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement