API tools faq
paste
Advertisement
Guest User

show_engine_innodb_status

a guest
Feb 21st, 2018
249
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.84 KB | None | 0 0
raw download clone embed print report
  1. =====================================
  2. 2018-02-22 00:42:59 0x7f8be40f1700 INNODB MONITOR OUTPUT
  3. =====================================
  4. Per second averages calculated from the last 58 seconds
  5. -----------------
  6. BACKGROUND THREAD
  7. -----------------
  8. srv_master_thread loops: 116041 srv_active, 0 srv_shutdown, 56170 srv_idle
  9. srv_master_thread log flush and writes: 172168
  10. ----------
  11. SEMAPHORES
  12. ----------
  13. OS WAIT ARRAY INFO: reservation count 426442
  14. OS WAIT ARRAY INFO: signal count 332276
  15. RW-shared spins 0, rounds 205751, OS waits 91004
  16. RW-excl spins 0, rounds 4363399, OS waits 181448
  17. RW-sx spins 8855, rounds 265597, OS waits 7873
  18. Spin rounds per wait: 205751.00 RW-shared, 4363399.00 RW-excl, 29.99 RW-sx
  19. ------------------------
  20. LATEST DETECTED DEADLOCK
  21. ------------------------
  22. 2018-02-22 00:40:13 0x7f8be406f700
  23. *** (1) TRANSACTION:
  24. TRANSACTION 264888, ACTIVE 1 sec fetching rows
  25. mysql tables in use 1, locked 1
  26. LOCK WAIT 5 lock struct(s), heap size 1136, 8 row lock(s)
  27. MySQL thread id 437190, OS thread handle 140238803642112, query id 5628526 ********.*********.com ***.***.***.*** ********* Searching rows for update
  28. UPDATE items SET ***** ... [text removed]
  29. *** (1) WAITING FOR THIS LOCK TO BE GRANTED:
  30. RECORD LOCKS space id 215 page no 48941 n bits 80 index PRIMARY of table `********`.`items` trx id 264888 lock_mode X locks rec but not gap waiting
  31. Record lock, heap no 6 PHYSICAL RECORD: n_fields 65; compact format; info bits 0
  32. [text removed]
  33. ------------
  34. TRANSACTIONS
  35. ------------
  36. Trx id counter 265012
  37. Purge done for trx's n:o < 265011 undo n:o < 0 state: running but idle
  38. History list length 7
  39. LIST OF TRANSACTIONS FOR EACH SESSION:
  40. ---TRANSACTION 421714360837984, not started
  41. 0 lock struct(s), heap size 1136, 0 row lock(s)
  42. --------
  43. FILE I/O
  44. --------
  45. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  46. I/O thread 1 state: waiting for completed aio requests (log thread)
  47. I/O thread 2 state: waiting for completed aio requests (read thread)
  48. I/O thread 3 state: waiting for completed aio requests (read thread)
  49. I/O thread 4 state: waiting for completed aio requests (read thread)
  50. I/O thread 5 state: waiting for completed aio requests (read thread)
  51. I/O thread 6 state: waiting for completed aio requests (write thread)
  52. I/O thread 7 state: waiting for completed aio requests (write thread)
  53. I/O thread 8 state: waiting for completed aio requests (write thread)
  54. I/O thread 9 state: waiting for completed aio requests (write thread)
  55. Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
  56. ibuf aio reads:, log i/o's:, sync i/o's:
  57. Pending flushes (fsync) log: 0; buffer pool: 0
  58. 71221169 OS file reads, 7079360 OS file writes, 177510 OS fsyncs
  59. 8.60 reads/s, 16384 avg bytes/read, 5.86 writes/s, 1.12 fsyncs/s
  60. -------------------------------------
  61. INSERT BUFFER AND ADAPTIVE HASH INDEX
  62. -------------------------------------
  63. Ibuf: size 1, free list len 209, seg size 211, 14918 merges
  64. merged operations:
  65. insert 20788, delete mark 95377, delete 1870
  66. discarded operations:
  67. insert 0, delete mark 0, delete 0
  68. Hash table size 99707, node heap has 1 buffer(s)
  69. Hash table size 99707, node heap has 262 buffer(s)
  70. Hash table size 99707, node heap has 5 buffer(s)
  71. Hash table size 99707, node heap has 1 buffer(s)
  72. Hash table size 99707, node heap has 0 buffer(s)
  73. Hash table size 99707, node heap has 8 buffer(s)
  74. Hash table size 99707, node heap has 2 buffer(s)
  75. Hash table size 99707, node heap has 1 buffer(s)
  76. 32.71 hash searches/s, 18.67 non-hash searches/s
  77. ---
  78. LOG
  79. ---
  80. Log sequence number 6076204411
  81. Log flushed up to 6076204411
  82. Pages flushed up to 6076204411
  83. Last checkpoint at 6076204047
  84. 0 pending log flushes, 0 pending chkp writes
  85. 85338 log i/o's done, 0.62 log i/o's/second
  86. ----------------------
  87. BUFFER POOL AND MEMORY
  88. ----------------------
  89. Total large memory allocated 412286976
  90. Dictionary memory allocated 942534
  91. Buffer pool size 24573
  92. Free buffers 1024
  93. Database pages 23269
  94. Old database pages 8569
  95. Modified db pages 4
  96. Pending reads 0
  97. Pending writes: LRU 0, flush list 0, single page 0
  98. Pages made young 9830386, not young 825737868
  99. 1.53 youngs/s, 24.48 non-youngs/s
  100. Pages read 71221038, created 6255225, written 6955827
  101. 8.60 reads/s, 0.00 creates/s, 5.05 writes/s
  102. Buffer pool hit rate 981 / 1000, young-making rate 3 / 1000 not 55 / 1000
  103. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  104. LRU len: 23269, unzip_LRU len: 0
  105. I/O sum[739]:cur[4], unzip sum[0]:cur[0]
  106. --------------
  107. ROW OPERATIONS
  108. --------------
  109. 0 queries inside InnoDB, 0 queries in queue
  110. 0 read views open inside InnoDB
  111. Process ID=15990, Main thread ID=140238837745408, state: sleeping
  112. Number of rows inserted 43869441, updated 3065654, deleted 1045, read 6051037025
  113. 8.62 inserts/s, 0.16 updates/s, 0.00 deletes/s, 1650.11 reads/s
  114. ----------------------------
  115. END OF INNODB MONITOR OUTPUT
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!