API tools faq
paste
csaw19

db stat

csaw19
Nov 18th, 2019
533
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.48 KB | None | 0 0
raw download clone embed print report
  1. | InnoDB | |
  2. =====================================
  3. 2019-11-18 13:12:17 0x7ff35e2d2700 INNODB MONITOR OUTPUT
  4. =====================================
  5. Per second averages calculated from the last 44 seconds
  6. -----------------
  7. BACKGROUND THREAD
  8. -----------------
  9. srv_master_thread loops: 89911 srv_active, 0 srv_shutdown, 6 srv_idle
  10. srv_master_thread log flush and writes: 89917
  11. ----------
  12. SEMAPHORES
  13. ----------
  14. OS WAIT ARRAY INFO: reservation count 730885
  15. --Thread 140672751101696 has waited at buf0lru.cc line 1320 for 0 seconds the semaphore:
  16. Mutex at 0x2ebf5d8, Mutex BUF_POOL created buf0buf.cc:1731, lock var 1
  17.  
  18. --Thread 140672997861120 has waited at buf0lru.cc line 1139 for 0 seconds the semaphore:
  19. Mutex at 0x2ebf5d8, Mutex BUF_POOL created buf0buf.cc:1731, lock var 1
  20.  
  21. OS WAIT ARRAY INFO: signal count 734931
  22. RW-shared spins 0, rounds 211512, OS waits 22290
  23. RW-excl spins 0, rounds 5677361, OS waits 184861
  24. RW-sx spins 96846, rounds 2517511, OS waits 80352
  25. Spin rounds per wait: 211512.00 RW-shared, 5677361.00 RW-excl, 25.99 RW-sx
  26. ------------
  27. TRANSACTIONS
  28. ------------
  29. Trx id counter 28185433
  30. Purge done for trx's n:o < 28185244 undo n:o < 0 state: running but idle
  31. History list length 14
  32. LIST OF TRANSACTIONS FOR EACH SESSION:
  33. ---TRANSACTION 422159311548048, not started
  34. 0 lock struct(s), heap size 1136, 0 row lock(s)
  35. ---TRANSACTION 28185432, ACTIVE 1 sec inserting
  36. mysql tables in use 1, locked 1
  37. 6 lock struct(s), heap size 1136, 31 row lock(s), undo log entries 22
  38. MySQL thread id 121, OS thread handle 140672997861120, query id 8318443 localhost trader update
  39. insert ignore into `zerodha_dataLoad`.`FUTSTK_DATA` (`myToken`,`strike_price`,`request_time`,`timestamp_int`,`data_timestamp`,`instrument_token`,`ltp`,`ltpQty`,`ltpDtTm`,`avgPrc`,`volume`,`tot_buy_quantity`,`tot_sell_quantity`,`open`,`high`,`low`,`prevDayClose`,`net_change`,`oi`,`oi_day_high`,`oi_day_low`,`temp`) values ('118348','0.00','2019-11-18 13:12:13','1574062929','2019-11-18 13:12:09','12524034','1502.95','400','2019-11-18 13:02:10','1505.01','21200','19600','20400','1497.55','1520.05','1497.5','1495.1','0','34000','34000','28800','0'),('118034','0.00','2019-11-18 13:12:13','1574062929
  40. ---TRANSACTION 28097028, ACTIVE 101428 sec recovered trx
  41. ROLLING BACK 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 234862269
  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: complete io for buf page (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: 1
  58. 4662760 OS file reads, 6665521 OS file writes, 2055577 OS fsyncs
  59. 22.00 reads/s, 16384 avg bytes/read, 174.25 writes/s, 17.68 fsyncs/s
  60. -------------------------------------
  61. INSERT BUFFER AND ADAPTIVE HASH INDEX
  62. -------------------------------------
  63. Ibuf: size 1, free list len 33765, seg size 33767, 1519 merges
  64. merged operations:
  65. insert 16628, delete mark 7730, delete 0
  66. discarded operations:
  67. insert 0, delete mark 0, delete 0
  68. Hash table size 2656163, node heap has 57 buffer(s)
  69. Hash table size 2656163, node heap has 17 buffer(s)
  70. Hash table size 2656163, node heap has 288 buffer(s)
  71. Hash table size 2656163, node heap has 663 buffer(s)
  72. Hash table size 2656163, node heap has 166 buffer(s)
  73. Hash table size 2656163, node heap has 16 buffer(s)
  74. Hash table size 2656163, node heap has 120 buffer(s)
  75. Hash table size 2656163, node heap has 55 buffer(s)
  76. 4697.26 hash searches/s, 13630.39 non-hash searches/s
  77. ---
  78. LOG
  79. ---
  80. Log sequence number 4841629874309
  81. Log flushed up to 4841629772525
  82. Pages flushed up to 4841600210546
  83. Last checkpoint at 4841598366089
  84. 0 pending log flushes, 0 pending chkp writes
  85. 336128 log i/o's done, 4.02 log i/o's/second
  86. ----------------------
  87. BUFFER POOL AND MEMORY
  88. ----------------------
  89. Total large memory allocated 8795455488
  90. Dictionary memory allocated 441284
  91. Buffer pool size 524256
  92. Free buffers 733
  93. Database pages 522141
  94. Old database pages 192624
  95. Modified db pages 5667
  96. Pending reads 0
  97. Pending writes: LRU 0, flush list 8, single page 0
  98. Pages made young 246417, not young 3962642865
  99. 0.00 youngs/s, 0.00 non-youngs/s
  100. Pages read 4662151, created 93393, written 5546626
  101. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  102. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 268 / 1000
  103. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  104. LRU len: 522141, unzip_LRU len: 0
  105. I/O sum[65664]:cur[762], unzip sum[0]:cur[0]
  106. ----------------------
  107. INDIVIDUAL BUFFER POOL INFO
  108. ----------------------
  109. ---BUFFER POOL 0
  110. Buffer pool size 65536
  111. Free buffers 98
  112. Database pages 65264
  113. Old database pages 24073
  114. Modified db pages 677
  115. Pending reads 0
  116. Pending writes: LRU 0, flush list 0, single page 0
  117. Pages made young 30767, not young 496008683
  118. 0.00 youngs/s, 0.00 non-youngs/s
  119. Pages read 577744, created 14768, written 715492
  120. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  121. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 229 / 1000
  122. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  123. LRU len: 65264, unzip_LRU len: 0
  124. I/O sum[8208]:cur[94], unzip sum[0]:cur[0]
  125. ---BUFFER POOL 1
  126. Buffer pool size 65528
  127. Free buffers 102
  128. Database pages 65257
  129. Old database pages 24069
  130. Modified db pages 697
  131. Pending reads 0
  132. Pending writes: LRU 0, flush list 0, single page 0
  133. Pages made young 29857, not young 494703210
  134. 0.00 youngs/s, 0.00 non-youngs/s
  135. Pages read 582137, created 11337, written 691873
  136. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  137. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 313 / 1000
  138. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  139. LRU len: 65257, unzip_LRU len: 0
  140. I/O sum[8208]:cur[94], unzip sum[0]:cur[0]
  141. ---BUFFER POOL 2
  142. Buffer pool size 65536
  143. Free buffers 36
  144. Database pages 65308
  145. Old database pages 24127
  146. Modified db pages 843
  147. Pending reads 0
  148. Pending writes: LRU 0, flush list 0, single page 0
  149. Pages made young 30913, not young 498299714
  150. 0.00 youngs/s, 0.00 non-youngs/s
  151. Pages read 585876, created 11211, written 669526
  152. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  153. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 305 / 1000
  154. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  155. LRU len: 65308, unzip_LRU len: 0
  156. I/O sum[8208]:cur[94], unzip sum[0]:cur[0]
  157. ---BUFFER POOL 3
  158. Buffer pool size 65528
  159. Free buffers 100
  160. Database pages 65262
  161. Old database pages 24070
  162. Modified db pages 963
  163. Pending reads 0
  164. Pending writes: LRU 0, flush list 4, single page 0
  165. Pages made young 31542, not young 497540049
  166. 0.00 youngs/s, 0.00 non-youngs/s
  167. Pages read 587048, created 11287, written 696937
  168. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  169. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 318 / 1000
  170. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  171. LRU len: 65262, unzip_LRU len: 0
  172. I/O sum[8208]:cur[96], unzip sum[0]:cur[0]
  173. ---BUFFER POOL 4
  174. Buffer pool size 65536
  175. Free buffers 99
  176. Database pages 65259
  177. Old database pages 24070
  178. Modified db pages 334
  179. Pending reads 0
  180. Pending writes: LRU 0, flush list 2, single page 0
  181. Pages made young 30976, not young 483638515
  182. 0.00 youngs/s, 0.00 non-youngs/s
  183. Pages read 577575, created 11370, written 782770
  184. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  185. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 83 / 1000
  186. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  187. LRU len: 65259, unzip_LRU len: 0
  188. I/O sum[8208]:cur[96], unzip sum[0]:cur[0]
  189. ---BUFFER POOL 5
  190. Buffer pool size 65528
  191. Free buffers 101
  192. Database pages 65244
  193. Old database pages 24064
  194. Modified db pages 635
  195. Pending reads 0
  196. Pending writes: LRU 0, flush list 2, single page 0
  197. Pages made young 31344, not young 498275545
  198. 0.00 youngs/s, 0.00 non-youngs/s
  199. Pages read 583525, created 11237, written 658467
  200. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  201. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 211 / 1000
  202. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  203. LRU len: 65244, unzip_LRU len: 0
  204. I/O sum[8208]:cur[96], unzip sum[0]:cur[0]
  205. ---BUFFER POOL 6
  206. Buffer pool size 65536
  207. Free buffers 98
  208. Database pages 65271
  209. Old database pages 24075
  210. Modified db pages 956
  211. Pending reads 0
  212. Pending writes: LRU 0, flush list 0, single page 0
  213. Pages made young 31608, not young 497318603
  214. 0.00 youngs/s, 0.00 non-youngs/s
  215. Pages read 585715, created 11297, written 672942
  216. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  217. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 387 / 1000
  218. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  219. LRU len: 65271, unzip_LRU len: 0
  220. I/O sum[8208]:cur[96], unzip sum[0]:cur[0]
  221. ---BUFFER POOL 7
  222. Buffer pool size 65528
  223. Free buffers 99
  224. Database pages 65276
  225. Old database pages 24076
  226. Modified db pages 562
  227. Pending reads 0
  228. Pending writes: LRU 0, flush list 0, single page 0
  229. Pages made young 29410, not young 496858546
  230. 0.00 youngs/s, 0.00 non-youngs/s
  231. Pages read 582531, created 10886, written 658619
  232. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  233. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 379 / 1000
  234. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  235. LRU len: 65276, unzip_LRU len: 0
  236. I/O sum[8208]:cur[96], unzip sum[0]:cur[0]
  237. --------------
  238. ROW OPERATIONS
  239. --------------
  240. 0 queries inside InnoDB, 0 queries in queue
  241. 0 read views open inside InnoDB
  242. Process ID=1133, Main thread ID=140673089074944, state: sleeping
  243. Number of rows inserted 15307742, updated 225618, deleted 21764, read 105532818
  244. 1081.13 inserts/s, 0.00 updates/s, 0.00 deletes/s, 2791.05 reads/s
  245. ----------------------------
  246. END OF INNODB MONITOR OUTPUT
  247. ============================
Add Comment
Please, Sign In to add comment
Public Pastes
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!