Advertisement
Guest User

Untitled

a guest
Jul 18th, 2018
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 58.52 KB | None | 0 0
  1.  
  2. =====================================
  3. 2018-07-18 09:01:08 2b89ce282700 INNODB MONITOR OUTPUT
  4. =====================================
  5. Per second averages calculated from the last 24 seconds
  6. -----------------
  7. BACKGROUND THREAD
  8. -----------------
  9. srv_master_thread loops: 4107 srv_active, 0 srv_shutdown, 0 srv_idle
  10. srv_master_thread log flush and writes: 0
  11. ----------
  12. SEMAPHORES
  13. ----------
  14. OS WAIT ARRAY INFO: reservation count 5422387
  15. OS WAIT ARRAY INFO: signal count 11890279
  16. Mutex spin waits 232823611, rounds 204533612, OS waits 7939
  17. RW-shared spins 21550305, rounds 329423580, OS waits 3100291
  18. RW-excl spins 12203365, rounds 193808225, OS waits 1928037
  19. Spin rounds per wait: 0.88 mutex, 15.29 RW-shared, 15.88 RW-excl
  20. ------------------------
  21. LATEST DETECTED DEADLOCK
  22. ------------------------
  23. 2018-07-18 08:59:24 2bd55547d700
  24. *** (1) TRANSACTION:
  25. TRANSACTION 19369888770, ACTIVE 1 sec starting index read
  26. mysql tables in use 6, locked 6
  27. LOCK WAIT 89 lock struct(s), heap size 376, 354 row lock(s)
  28. MySQL thread id 24077, OS thread handle 0x2b8ca9ac3700, query id 14488433 172.31.41.249 gresvig Sending data
  29. INSERT INTO `search_tmp_5b4f016c42d834_17017270` SELECT `main_select`.`entity_id`, SUM(score) AS `relevance` FROM (SELECT DISTINCT `search_index`.`entity_id`, (((0) + (0) + (0)) * 1) AS `score` FROM `catalog_product_index_eav` AS `search_index`
  30. INNER JOIN `catalog_product_index_eav` AS `brand_filter` ON `search_index`.`entity_id` = `brand_filter`.`entity_id` AND `search_index`.`source_id` = `brand_filter`.`source_id` AND `brand_filter`.`attribute_id` = 286 AND `brand_filter`.`store_id` = 2
  31. INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON stock_index.product_id = search_index.entity_id AND `stock_index`.`website_id` = 0 AND `stock_index`.`stock_id` = 1
  32. INNER JOIN `cataloginventory_stock_status` AS `sub_products_stock_index` ON sub_products_stock_index.product_id = search_index.source_id AND `sub_products_stock_index`.`website_id` = 0 AND `sub_products_stock_index`.`stock_id` = 1
  33. INNE
  34. *** (1) WAITING FOR THIS LOCK TO BE GRANTED:
  35. RECORD LOCKS space id 2115094 page no 1338 n bits 50 index `PRIMARY` of table `m2prod`.`catalog_product_index_eav` trx id 19369888770 lock mode S waiting
  36. Record lock, heap no 50 PHYSICAL RECORD: n_fields 7; compact format; info bits 0
  37. 0: len=4; bufptr=0x2bb1d79306dd; hex= 00011330; asc 0;;
  38. 1: len=2; bufptr=0x2bb1d79306e1; hex= 0063; asc c;;
  39. 2: len=2; bufptr=0x2bb1d79306e3; hex= 0002; asc ;;
  40. 3: len=4; bufptr=0x2bb1d79306e5; hex= 00000001; asc ;;
  41. 4: len=4; bufptr=0x2bb1d79306e9; hex= 00011332; asc 2;;
  42. 5: len=6; bufptr=0x2bb1d79306ed; hex= 000481795a1d; asc yZ ;;
  43. 6: len=7; bufptr=0x2bb1d79306f3; hex= a4000758660d0d; asc Xf ;;
  44.  
  45. *** (2) TRANSACTION:
  46. TRANSACTION 19369888723, ACTIVE 2 sec fetching rows
  47. mysql tables in use 1, locked 1
  48. LOCK WAIT 50 lock struct(s), heap size 376, 11204 row lock(s), undo log entries 117
  49. MySQL thread id 24006, OS thread handle 0x2b7738385700, query id 14483530 172.31.40.10 gresvig updating
  50. DELETE FROM `catalog_product_index_eav` WHERE (entity_id IN('456186', '281261', '599056', '471443', '274145', '307603', '320329', '599058', '294511', '315717', '599059', '324868', '315705', '335987', '465356', '461211', '53332', '53573', '505658', '53574', '53575', '464698', '53578', '54161', '54314', '456124', '97774', '314216', '416838', '100200', '100199', '417379', '510607', '100198', '507133', '418084', '100202', '492714', '507188', '53811', '418090', '494963', '419282', '507267', '494962', '419291', '419657', '507500', '419727', '420609', '507545', '310109', '420616', '465359', '421932', '507604', '465433', '429922', '310054', '430154', '507671', '194450', '430296', '319936', '430361', '314863', '507733', '191518', '430441', '303702', '430679', '299907', '431490', '262923', '431511', '451766', '173487', '435474', '421105', '435478', '295815', '435501', '435646', '602891', '295794', '436477', '420104'
  51. *** (2) HOLDS THE LOCK(S):
  52. RECORD LOCKS space id 2115094 page no 1338 n bits 2 index `PRIMARY` of table `m2prod`.`catalog_product_index_eav` trx id 19369888723 lock_mode X
  53. Record lock, heap no 2 PHYSICAL RECORD: n_fields 7; compact format; info bits 0
  54. 0: len=4; bufptr=0x2bb1d793007d; hex= 000112ff; asc ;;
  55. 1: len=2; bufptr=0x2bb1d7930081; hex= 011e; asc ;;
  56. 2: len=2; bufptr=0x2bb1d7930083; hex= 0002; asc ;;
  57. 3: len=4; bufptr=0x2bb1d7930085; hex= 00007a62; asc zb;;
  58. 4: len=4; bufptr=0x2bb1d7930089; hex= 000112ff; asc ;;
  59. 5: len=6; bufptr=0x2bb1d793008d; hex= 000481795a1d; asc yZ ;;
  60. 6: len=7; bufptr=0x2bb1d7930093; hex= a4000758680258; asc Xh X;;
  61.  
  62. [bitmap0 of 38 bytes in hex: fc ff ff ff ff ff 3f 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ]
  63. *** (2) WAITING FOR THIS LOCK TO BE GRANTED:
  64. RECORD LOCKS space id 2115094 page no 1338 n bits 54 index `PRIMARY` of table `m2prod`.`catalog_product_index_eav` trx id 19369888723 lock_mode X waiting
  65. Record lock, heap no 54 PHYSICAL RECORD: n_fields 7; compact format; info bits 0
  66. 0: len=4; bufptr=0x2bb1d7930765; hex= 00011330; asc 0;;
  67. 1: len=2; bufptr=0x2bb1d7930769; hex= 011e; asc ;;
  68. 2: len=2; bufptr=0x2bb1d793076b; hex= 0002; asc ;;
  69. 3: len=4; bufptr=0x2bb1d793076d; hex= 000081d7; asc ;;
  70. 4: len=4; bufptr=0x2bb1d7930771; hex= 00011330; asc 0;;
  71. 5: len=6; bufptr=0x2bb1d7930775; hex= 000481795a1d; asc yZ ;;
  72. 6: len=7; bufptr=0x2bb1d793077b; hex= a40007586802d8; asc Xh ;;
  73.  
  74. ------------
  75. TRANSACTIONS
  76. ------------
  77. Trx id counter 19369904841
  78. Purge done for trx's n:o < 19369093595 undo n:o < 0 state: running but idle
  79. History list length 88028
  80. LIST OF TRANSACTIONS FOR EACH SESSION:
  81. ---TRANSACTION 19369896199, not started
  82. MySQL thread id 24265, OS thread handle 0x2b7a14840700, query id 15194641 172.31.40.10 gresvig cleaned up
  83. COMMIT
  84. ---TRANSACTION 19369904699, not started
  85. MySQL thread id 23665, OS thread handle 0x2b86f25c8700, query id 15185114 172.31.40.10 gresvig delayed send ok done
  86. ---TRANSACTION 19369897796, not started
  87. MySQL thread id 3026, OS thread handle 0x2b70d33cb700, query id 14775402 localhost rdsadmin delayed send ok done
  88. ---TRANSACTION 19369897653, not started
  89. MySQL thread id 6, OS thread handle 0x2b75cac40700, query id 15190324 localhost rdsadmin delayed send ok done
  90. ---TRANSACTION 19369902623, not started
  91. MySQL thread id 11, OS thread handle 0x2b70d33cb700, query id 15115900 localhost rdsadmin cleaned up
  92. ---TRANSACTION 19369904519, not started
  93. MySQL thread id 7, OS thread handle 0x2b75cac40700, query id 15174660 localhost rdsadmin delayed send ok done
  94. ---TRANSACTION 19369904840, ACTIVE 0 sec starting index read
  95. mysql tables in use 2, locked 0
  96. MySQL thread id 7195, OS thread handle 0x2b885fa40700, query id 15190973 172.31.40.10 gresvig Sending data
  97. SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e`
  98. INNER JOIN `catalog_product_entity_varchar` AS `at_ean` ON (`at_ean`.`row_id` = `e`.`row_id`) AND (`at_ean`.`attribute_id` = '246') AND (`at_ean`.`store_id` = 0) WHERE ((at_ean.value = '7323342394839') AND (`e`.`type_id` IN('simple', 'bundle'))) AND (e.created_in <= '1531558020') AND (e.updated_in > '1531558020')
  99. Trx read view will not see trx with id >= 19369904841, sees < 19369194982
  100. ---TRANSACTION 19369904755, ACTIVE 1 sec
  101. 162 lock struct(s), heap size 376, 2372 row lock(s)
  102. MySQL thread id 24628, OS thread handle 0x2b9260f04700, query id 15194640 172.31.37.72 gresvig cleaned up
  103. Trx read view will not see trx with id >= 19369904756, sees < 19369194982
  104. ---TRANSACTION 19369904750, ACTIVE 1 sec
  105. 10 lock struct(s), heap size 376, 10 row lock(s)
  106. MySQL thread id 24627, OS thread handle 0x2b9260f04700, query id 15194642 172.31.38.113 gresvig init
  107. SELECT `catalog_category_entity`.* FROM `catalog_category_entity` WHERE ((entity_id =971)) AND (catalog_category_entity.created_in <= '1531558020') AND (catalog_category_entity.updated_in > '1531558020')
  108. Trx read view will not see trx with id >= 19369904751, sees < 19369194982
  109. ---TRANSACTION 19369904742, ACTIVE 1 sec
  110. MySQL thread id 24621, OS thread handle 0x2b7739985700, query id 15194634 172.31.7.140 gresvig cleaned up
  111. Trx read view will not see trx with id >= 19369904743, sees < 19369194982
  112. ---TRANSACTION 19369904741, ACTIVE 1 sec starting index read
  113. mysql tables in use 2, locked 0
  114. MySQL thread id 23346, OS thread handle 0x2b8f85386700, query id 15186194 172.31.40.10 gresvig Sending data
  115. SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e`
  116. INNER JOIN `catalog_product_entity_varchar` AS `at_ean` ON (`at_ean`.`row_id` = `e`.`row_id`) AND (`at_ean`.`attribute_id` = '246') AND (`at_ean`.`store_id` = 0) WHERE ((at_ean.value = '7611313596130') AND (`e`.`type_id` = 'simple')) AND (e.created_in <= '1531558020') AND (e.updated_in > '1531558020')
  117. Trx read view will not see trx with id >= 19369904742, sees < 19369194982
  118. ---TRANSACTION 19369904717, ACTIVE 1 sec
  119. MySQL thread id 24626, OS thread handle 0x2b8b3be82700, query id 15185848 172.31.40.10 gresvig cleaned up
  120. Trx read view will not see trx with id >= 19369904718, sees < 19369194982
  121. ---TRANSACTION 19369904712, ACTIVE 1 sec
  122. MySQL thread id 24625, OS thread handle 0x2b75cad85700, query id 15185720 172.31.40.10 gresvig cleaned up
  123. Trx read view will not see trx with id >= 19369904713, sees < 19369194982
  124. ---TRANSACTION 19369904661, ACTIVE 1 sec starting index read
  125. mysql tables in use 2, locked 0
  126. MySQL thread id 23052, OS thread handle 0x2b7738281700, query id 15184033 172.31.40.10 gresvig Sending data
  127. SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e`
  128. INNER JOIN `catalog_product_entity_varchar` AS `at_ean` ON (`at_ean`.`row_id` = `e`.`row_id`) AND (`at_ean`.`attribute_id` = '246') AND (`at_ean`.`store_id` = 0) WHERE ((at_ean.value = '675911392263') AND (`e`.`type_id` = 'simple')) AND (e.created_in <= '1531558020') AND (e.updated_in > '1531558020')
  129. Trx read view will not see trx with id >= 19369904662, sees < 19369194982
  130. ---TRANSACTION 19369904644, ACTIVE 1 sec
  131. MySQL thread id 24623, OS thread handle 0x2b85833c8700, query id 15194558 172.31.41.249 gresvig cleaned up
  132. Trx read view will not see trx with id >= 19369904645, sees < 19369194982
  133. ---TRANSACTION 19369904425, ACTIVE 3 sec
  134. 1973 lock struct(s), heap size 376, 23180 row lock(s)
  135. MySQL thread id 24609, OS thread handle 0x2b92606c2700, query id 15194467 172.31.41.249 gresvig cleaned up
  136. Trx read view will not see trx with id >= 19369904426, sees < 19369194982
  137. ---TRANSACTION 19369904041, ACTIVE 5 sec
  138. MySQL thread id 24582, OS thread handle 0x2b7739944700, query id 15148098 172.31.40.10 gresvig cleaned up
  139. Trx read view will not see trx with id >= 19369904042, sees < 19369194982
  140. ---TRANSACTION 19369902895, ACTIVE 7 sec
  141. MySQL thread id 24580, OS thread handle 0x2b8ca9a41700, query id 15134992 172.31.40.10 gresvig cleaned up
  142. Trx read view will not see trx with id >= 19369902896, sees < 19369194982
  143. ---TRANSACTION 19369894086, ACTIVE 66 sec
  144. MySQL thread id 24261, OS thread handle 0x2b86f2483700, query id 14612633 172.31.40.10 gresvig cleaned up
  145. Trx read view will not see trx with id >= 19369894087, sees < 19369194982
  146. ---TRANSACTION 19369884560, ACTIVE 124 sec
  147. MySQL thread id 23637, OS thread handle 0x2b86f1bc7700, query id 14739988 81.166.54.180 gresvig cleaned up
  148. Trx read view will not see trx with id >= 19369884561, sees < 19369194982
  149. ---TRANSACTION 19369868067, ACTIVE 175 sec
  150. MySQL thread id 23647, OS thread handle 0x2b7a14385700, query id 14265093 172.31.40.10 gresvig cleaned up
  151. Trx read view will not see trx with id >= 19369868068, sees < 19369194982
  152. ---TRANSACTION 19369867653, ACTIVE 177 sec
  153. MySQL thread id 23629, OS thread handle 0x2b89ce282700, query id 15194638 81.166.54.180 gresvig init
  154. show engine innodb status
  155. Trx read view will not see trx with id >= 19369867654, sees < 19369194982
  156. ---TRANSACTION 19369856224, ACTIVE 235 sec
  157. MySQL thread id 23330, OS thread handle 0x2b86f1a82700, query id 14139781 172.31.40.10 gresvig cleaned up
  158. Trx read view will not see trx with id >= 19369856225, sees < 19369194982
  159. ---TRANSACTION 19369848147, ACTIVE 295 sec
  160. MySQL thread id 23039, OS thread handle 0x2b77399c6700, query id 13979511 172.31.40.10 gresvig cleaned up
  161. Trx read view will not see trx with id >= 19369848148, sees < 19369194982
  162. ---TRANSACTION 19369194982, ACTIVE 3115 sec
  163. MySQL thread id 7182, OS thread handle 0x2b89ce3c7700, query id 3221083 172.31.40.10 gresvig cleaned up
  164. Trx read view will not see trx with id >= 19369194983, sees < 19369093575
  165. --------
  166. FILE I/O
  167. --------
  168. I/O thread 0 state: waiting for i/o request (insert buffer thread)
  169. I/O thread 1 state: waiting for i/o request (log thread)
  170. I/O thread 2 state: waiting for i/o request (read thread)
  171. I/O thread 3 state: waiting for i/o request (read thread)
  172. I/O thread 4 state: waiting for i/o request (read thread)
  173. I/O thread 5 state: waiting for i/o request (read thread)
  174. I/O thread 6 state: waiting for i/o request (read thread)
  175. I/O thread 7 state: waiting for i/o request (read thread)
  176. I/O thread 8 state: waiting for i/o request (read thread)
  177. I/O thread 9 state: waiting for i/o request (read thread)
  178. I/O thread 10 state: waiting for i/o request (read thread)
  179. I/O thread 11 state: waiting for i/o request (read thread)
  180. I/O thread 12 state: waiting for i/o request (read thread)
  181. I/O thread 13 state: waiting for i/o request (read thread)
  182. I/O thread 14 state: waiting for i/o request (read thread)
  183. I/O thread 15 state: waiting for i/o request (read thread)
  184. I/O thread 16 state: waiting for i/o request (read thread)
  185. I/O thread 17 state: waiting for i/o request (read thread)
  186. I/O thread 18 state: waiting for i/o request (read thread)
  187. I/O thread 19 state: waiting for i/o request (read thread)
  188. I/O thread 20 state: waiting for i/o request (read thread)
  189. I/O thread 21 state: waiting for i/o request (read thread)
  190. I/O thread 22 state: waiting for i/o request (read thread)
  191. I/O thread 23 state: waiting for i/o request (read thread)
  192. I/O thread 24 state: waiting for i/o request (read thread)
  193. I/O thread 25 state: waiting for i/o request (read thread)
  194. I/O thread 26 state: waiting for i/o request (read thread)
  195. I/O thread 27 state: waiting for i/o request (read thread)
  196. I/O thread 28 state: waiting for i/o request (read thread)
  197. I/O thread 29 state: waiting for i/o request (read thread)
  198. I/O thread 30 state: waiting for i/o request (read thread)
  199. I/O thread 31 state: waiting for i/o request (read thread)
  200. I/O thread 32 state: waiting for i/o request (read thread)
  201. I/O thread 33 state: waiting for i/o request (read thread)
  202. I/O thread 34 state: waiting for i/o request (read thread)
  203. I/O thread 35 state: waiting for i/o request (read thread)
  204. I/O thread 36 state: waiting for i/o request (read thread)
  205. I/O thread 37 state: waiting for i/o request (read thread)
  206. I/O thread 38 state: waiting for i/o request (read thread)
  207. I/O thread 39 state: waiting for i/o request (read thread)
  208. I/O thread 40 state: waiting for i/o request (read thread)
  209. I/O thread 41 state: waiting for i/o request (read thread)
  210. I/O thread 42 state: waiting for i/o request (read thread)
  211. I/O thread 43 state: waiting for i/o request (read thread)
  212. I/O thread 44 state: waiting for i/o request (read thread)
  213. I/O thread 45 state: waiting for i/o request (read thread)
  214. I/O thread 46 state: waiting for i/o request (read thread)
  215. I/O thread 47 state: waiting for i/o request (read thread)
  216. I/O thread 48 state: waiting for i/o request (read thread)
  217. I/O thread 49 state: waiting for i/o request (read thread)
  218. I/O thread 50 state: waiting for i/o request (read thread)
  219. I/O thread 51 state: waiting for i/o request (read thread)
  220. I/O thread 52 state: waiting for i/o request (read thread)
  221. I/O thread 53 state: waiting for i/o request (read thread)
  222. I/O thread 54 state: waiting for i/o request (read thread)
  223. I/O thread 55 state: waiting for i/o request (read thread)
  224. I/O thread 56 state: waiting for i/o request (read thread)
  225. I/O thread 57 state: waiting for i/o request (read thread)
  226. I/O thread 58 state: waiting for i/o request (read thread)
  227. I/O thread 59 state: waiting for i/o request (read thread)
  228. I/O thread 60 state: waiting for i/o request (read thread)
  229. I/O thread 61 state: waiting for i/o request (read thread)
  230. I/O thread 62 state: waiting for i/o request (read thread)
  231. I/O thread 63 state: waiting for i/o request (read thread)
  232. I/O thread 64 state: waiting for i/o request (read thread)
  233. I/O thread 65 state: waiting for i/o request (read thread)
  234. I/O thread 66 state: waiting for i/o request (write thread)
  235. I/O thread 67 state: waiting for i/o request (write thread)
  236. I/O thread 68 state: waiting for i/o request (write thread)
  237. I/O thread 69 state: waiting for i/o request (write thread)
  238. Pending normal aio reads: 0 [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
  239. ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
  240. Pending flushes (fsync) log: 0; buffer pool: 0
  241. 0 OS file reads, 0 OS file writes, 0 OS fsyncs
  242. 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
  243. -------------------------------------
  244. INSERT BUFFER AND ADAPTIVE HASH INDEX
  245. -------------------------------------
  246. Ibuf: size 1, free list len 0, seg size 2, 0 merges
  247. merged operations:
  248. insert 0, delete mark 0, delete 0
  249. discarded operations:
  250. insert 0, delete mark 0, delete 0
  251. Adaptive hash table 0: Hash table size 23671211, node heap has 0 buffer(s)
  252. Adaptive hash table 1: Hash table size 23671211, node heap has 0 buffer(s)
  253. Adaptive hash table 2: Hash table size 23671211, node heap has 0 buffer(s)
  254. Adaptive hash table 3: Hash table size 23671211, node heap has 0 buffer(s)
  255. Adaptive hash table 4: Hash table size 23671211, node heap has 0 buffer(s)
  256. Adaptive hash table 5: Hash table size 23671211, node heap has 0 buffer(s)
  257. Adaptive hash table 6: Hash table size 23671211, node heap has 0 buffer(s)
  258. Adaptive hash table 7: Hash table size 23671211, node heap has 0 buffer(s)
  259. Adaptive hash table 8: Hash table size 23671211, node heap has 0 buffer(s)
  260. Adaptive hash table 9: Hash table size 23671211, node heap has 0 buffer(s)
  261. Adaptive hash table 10: Hash table size 23671211, node heap has 0 buffer(s)
  262. Adaptive hash table 11: Hash table size 23671211, node heap has 0 buffer(s)
  263. Adaptive hash table 12: Hash table size 23671211, node heap has 0 buffer(s)
  264. Adaptive hash table 13: Hash table size 23671211, node heap has 0 buffer(s)
  265. Adaptive hash table 14: Hash table size 23671211, node heap has 0 buffer(s)
  266. Adaptive hash table 15: Hash table size 23671211, node heap has 0 buffer(s)
  267. Adaptive hash table 16: Hash table size 23671211, node heap has 0 buffer(s)
  268. Adaptive hash table 17: Hash table size 23671211, node heap has 0 buffer(s)
  269. Adaptive hash table 18: Hash table size 23671211, node heap has 0 buffer(s)
  270. Adaptive hash table 19: Hash table size 23671211, node heap has 0 buffer(s)
  271. Adaptive hash table 20: Hash table size 23671211, node heap has 0 buffer(s)
  272. Adaptive hash table 21: Hash table size 23671211, node heap has 0 buffer(s)
  273. Adaptive hash table 22: Hash table size 23671211, node heap has 0 buffer(s)
  274. Adaptive hash table 23: Hash table size 23671211, node heap has 0 buffer(s)
  275. Adaptive hash table 24: Hash table size 23671211, node heap has 0 buffer(s)
  276. Adaptive hash table 25: Hash table size 23671211, node heap has 0 buffer(s)
  277. Adaptive hash table 26: Hash table size 23671211, node heap has 0 buffer(s)
  278. Adaptive hash table 27: Hash table size 23671211, node heap has 0 buffer(s)
  279. Adaptive hash table 28: Hash table size 23671211, node heap has 0 buffer(s)
  280. Adaptive hash table 29: Hash table size 23671211, node heap has 0 buffer(s)
  281. Adaptive hash table 30: Hash table size 23671211, node heap has 0 buffer(s)
  282. Adaptive hash table 31: Hash table size 23671211, node heap has 0 buffer(s)
  283. 0.00 hash searches/s, 1004926.71 non-hash searches/s
  284. ---
  285. LOG
  286. ---
  287. Log sequence number 8204
  288. Log flushed up to 8204
  289. Pages flushed up to 8204
  290. Last checkpoint at 8192
  291. 0 pending log writes, 0 pending chkp writes
  292. 0 log i/o's done, 0.00 log i/o's/second
  293. ----------------------
  294. BUFFER POOL AND MEMORY
  295. ----------------------
  296. Total memory allocated 0; in additional pool allocated 0
  297. Dictionary memory allocated 5733597
  298. Buffer pool size 23355392
  299. Free buffers 22096250
  300. Database pages 1259142
  301. Old database pages 463492
  302. Modified db pages 0
  303. Pending reads 0
  304. Pending writes: LRU 0, flush list 0 single page 0
  305. Pages made young 237923, not young 5114
  306. 0.71 youngs/s, 0.00 non-youngs/s
  307. Pages read 584, created 34539, written 0
  308. 0.00 reads/s, 0.21 creates/s, 0.00 writes/s
  309. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  310. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  311. LRU len: 1259142, unzip_LRU len: 0
  312. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  313. ----------------------
  314. INDIVIDUAL BUFFER POOL INFO
  315. ----------------------
  316. ---BUFFER POOL 0
  317. Buffer pool size 364928
  318. Free buffers 345211
  319. Database pages 19717
  320. Old database pages 7258
  321. Modified db pages 0
  322. Pending reads 0
  323. Pending writes: LRU 0, flush list 0 single page 0
  324. Pages made young 3742, not young 8
  325. 0.00 youngs/s, 0.00 non-youngs/s
  326. Pages read 19, created 560, written 0
  327. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  328. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  329. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  330. LRU len: 19717, unzip_LRU len: 0
  331. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  332. ---BUFFER POOL 1
  333. Buffer pool size 364928
  334. Free buffers 344924
  335. Database pages 20004
  336. Old database pages 7364
  337. Modified db pages 0
  338. Pending reads 0
  339. Pending writes: LRU 0, flush list 0 single page 0
  340. Pages made young 3175, not young 31
  341. 0.00 youngs/s, 0.00 non-youngs/s
  342. Pages read 8, created 647, written 0
  343. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  344. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  345. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  346. LRU len: 20004, unzip_LRU len: 0
  347. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  348. ---BUFFER POOL 2
  349. Buffer pool size 364928
  350. Free buffers 345176
  351. Database pages 19752
  352. Old database pages 7271
  353. Modified db pages 0
  354. Pending reads 0
  355. Pending writes: LRU 0, flush list 0 single page 0
  356. Pages made young 3652, not young 1976
  357. 0.04 youngs/s, 0.00 non-youngs/s
  358. Pages read 51, created 518, written 0
  359. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  360. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  361. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  362. LRU len: 19752, unzip_LRU len: 0
  363. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  364. ---BUFFER POOL 3
  365. Buffer pool size 364928
  366. Free buffers 345293
  367. Database pages 19635
  368. Old database pages 7228
  369. Modified db pages 0
  370. Pending reads 0
  371. Pending writes: LRU 0, flush list 0 single page 0
  372. Pages made young 3910, not young 6
  373. 0.00 youngs/s, 0.00 non-youngs/s
  374. Pages read 21, created 385, written 0
  375. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  376. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  377. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  378. LRU len: 19635, unzip_LRU len: 0
  379. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  380. ---BUFFER POOL 4
  381. Buffer pool size 364928
  382. Free buffers 345591
  383. Database pages 19337
  384. Old database pages 7118
  385. Modified db pages 0
  386. Pending reads 0
  387. Pending writes: LRU 0, flush list 0 single page 0
  388. Pages made young 2960, not young 0
  389. 0.00 youngs/s, 0.00 non-youngs/s
  390. Pages read 31, created 333, written 0
  391. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  392. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  393. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  394. LRU len: 19337, unzip_LRU len: 0
  395. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  396. ---BUFFER POOL 5
  397. Buffer pool size 364928
  398. Free buffers 344980
  399. Database pages 19948
  400. Old database pages 7343
  401. Modified db pages 0
  402. Pending reads 0
  403. Pending writes: LRU 0, flush list 0 single page 0
  404. Pages made young 3272, not young 0
  405. 0.00 youngs/s, 0.00 non-youngs/s
  406. Pages read 6, created 424, written 0
  407. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  408. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  409. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  410. LRU len: 19948, unzip_LRU len: 0
  411. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  412. ---BUFFER POOL 6
  413. Buffer pool size 364928
  414. Free buffers 344900
  415. Database pages 20028
  416. Old database pages 7373
  417. Modified db pages 0
  418. Pending reads 0
  419. Pending writes: LRU 0, flush list 0 single page 0
  420. Pages made young 3162, not young 54
  421. 0.00 youngs/s, 0.00 non-youngs/s
  422. Pages read 8, created 527, written 0
  423. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  424. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  425. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  426. LRU len: 20028, unzip_LRU len: 0
  427. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  428. ---BUFFER POOL 7
  429. Buffer pool size 364928
  430. Free buffers 345205
  431. Database pages 19723
  432. Old database pages 7260
  433. Modified db pages 0
  434. Pending reads 0
  435. Pending writes: LRU 0, flush list 0 single page 0
  436. Pages made young 3369, not young 15
  437. 0.00 youngs/s, 0.00 non-youngs/s
  438. Pages read 10, created 407, written 0
  439. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  440. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  441. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  442. LRU len: 19723, unzip_LRU len: 0
  443. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  444. ---BUFFER POOL 8
  445. Buffer pool size 364928
  446. Free buffers 345496
  447. Database pages 19432
  448. Old database pages 7153
  449. Modified db pages 0
  450. Pending reads 0
  451. Pending writes: LRU 0, flush list 0 single page 0
  452. Pages made young 3100, not young 1
  453. 0.04 youngs/s, 0.00 non-youngs/s
  454. Pages read 4, created 442, written 0
  455. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  456. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  457. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  458. LRU len: 19432, unzip_LRU len: 0
  459. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  460. ---BUFFER POOL 9
  461. Buffer pool size 364928
  462. Free buffers 346049
  463. Database pages 18879
  464. Old database pages 6949
  465. Modified db pages 0
  466. Pending reads 0
  467. Pending writes: LRU 0, flush list 0 single page 0
  468. Pages made young 2972, not young 10
  469. 0.00 youngs/s, 0.00 non-youngs/s
  470. Pages read 4, created 412, written 0
  471. 0.00 reads/s, 0.04 creates/s, 0.00 writes/s
  472. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  473. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  474. LRU len: 18879, unzip_LRU len: 0
  475. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  476. ---BUFFER POOL 10
  477. Buffer pool size 364928
  478. Free buffers 345737
  479. Database pages 19191
  480. Old database pages 7064
  481. Modified db pages 0
  482. Pending reads 0
  483. Pending writes: LRU 0, flush list 0 single page 0
  484. Pages made young 3148, not young 104
  485. 0.00 youngs/s, 0.00 non-youngs/s
  486. Pages read 11, created 457, written 0
  487. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  488. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  489. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  490. LRU len: 19191, unzip_LRU len: 0
  491. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  492. ---BUFFER POOL 11
  493. Buffer pool size 364928
  494. Free buffers 345844
  495. Database pages 19084
  496. Old database pages 7024
  497. Modified db pages 0
  498. Pending reads 0
  499. Pending writes: LRU 0, flush list 0 single page 0
  500. Pages made young 2559, not young 0
  501. 0.00 youngs/s, 0.00 non-youngs/s
  502. Pages read 4, created 413, written 0
  503. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  504. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  505. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  506. LRU len: 19084, unzip_LRU len: 0
  507. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  508. ---BUFFER POOL 12
  509. Buffer pool size 364928
  510. Free buffers 345853
  511. Database pages 19075
  512. Old database pages 7021
  513. Modified db pages 0
  514. Pending reads 0
  515. Pending writes: LRU 0, flush list 0 single page 0
  516. Pages made young 4181, not young 24
  517. 0.00 youngs/s, 0.00 non-youngs/s
  518. Pages read 7, created 416, written 0
  519. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  520. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  521. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  522. LRU len: 19075, unzip_LRU len: 0
  523. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  524. ---BUFFER POOL 13
  525. Buffer pool size 364928
  526. Free buffers 345880
  527. Database pages 19048
  528. Old database pages 7011
  529. Modified db pages 0
  530. Pending reads 0
  531. Pending writes: LRU 0, flush list 0 single page 0
  532. Pages made young 3226, not young 0
  533. 0.04 youngs/s, 0.00 non-youngs/s
  534. Pages read 2, created 316, written 0
  535. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  536. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  537. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  538. LRU len: 19048, unzip_LRU len: 0
  539. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  540. ---BUFFER POOL 14
  541. Buffer pool size 364928
  542. Free buffers 345608
  543. Database pages 19320
  544. Old database pages 7111
  545. Modified db pages 0
  546. Pending reads 0
  547. Pending writes: LRU 0, flush list 0 single page 0
  548. Pages made young 3316, not young 226
  549. 0.00 youngs/s, 0.00 non-youngs/s
  550. Pages read 4, created 399, written 0
  551. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  552. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  553. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  554. LRU len: 19320, unzip_LRU len: 0
  555. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  556. ---BUFFER POOL 15
  557. Buffer pool size 364928
  558. Free buffers 346190
  559. Database pages 18738
  560. Old database pages 6896
  561. Modified db pages 0
  562. Pending reads 0
  563. Pending writes: LRU 0, flush list 0 single page 0
  564. Pages made young 3156, not young 4
  565. 0.00 youngs/s, 0.00 non-youngs/s
  566. Pages read 9, created 338, written 0
  567. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  568. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  569. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  570. LRU len: 18738, unzip_LRU len: 0
  571. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  572. ---BUFFER POOL 16
  573. Buffer pool size 364928
  574. Free buffers 345985
  575. Database pages 18943
  576. Old database pages 6972
  577. Modified db pages 0
  578. Pending reads 0
  579. Pending writes: LRU 0, flush list 0 single page 0
  580. Pages made young 2851, not young 6
  581. 0.00 youngs/s, 0.00 non-youngs/s
  582. Pages read 16, created 519, written 0
  583. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  584. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  585. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  586. LRU len: 18943, unzip_LRU len: 0
  587. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  588. ---BUFFER POOL 17
  589. Buffer pool size 364928
  590. Free buffers 345693
  591. Database pages 19235
  592. Old database pages 7080
  593. Modified db pages 0
  594. Pending reads 0
  595. Pending writes: LRU 0, flush list 0 single page 0
  596. Pages made young 3188, not young 0
  597. 0.00 youngs/s, 0.00 non-youngs/s
  598. Pages read 1, created 567, written 0
  599. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  600. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  601. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  602. LRU len: 19235, unzip_LRU len: 0
  603. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  604. ---BUFFER POOL 18
  605. Buffer pool size 364928
  606. Free buffers 345837
  607. Database pages 19091
  608. Old database pages 7027
  609. Modified db pages 0
  610. Pending reads 0
  611. Pending writes: LRU 0, flush list 0 single page 0
  612. Pages made young 2804, not young 21
  613. 0.00 youngs/s, 0.00 non-youngs/s
  614. Pages read 9, created 519, written 0
  615. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  616. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  617. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  618. LRU len: 19091, unzip_LRU len: 0
  619. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  620. ---BUFFER POOL 19
  621. Buffer pool size 364928
  622. Free buffers 345460
  623. Database pages 19468
  624. Old database pages 7166
  625. Modified db pages 0
  626. Pending reads 0
  627. Pending writes: LRU 0, flush list 0 single page 0
  628. Pages made young 2922, not young 5
  629. 0.00 youngs/s, 0.00 non-youngs/s
  630. Pages read 3, created 650, written 0
  631. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  632. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  633. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  634. LRU len: 19468, unzip_LRU len: 0
  635. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  636. ---BUFFER POOL 20
  637. Buffer pool size 364928
  638. Free buffers 345875
  639. Database pages 19053
  640. Old database pages 7013
  641. Modified db pages 0
  642. Pending reads 0
  643. Pending writes: LRU 0, flush list 0 single page 0
  644. Pages made young 4654, not young 108
  645. 0.04 youngs/s, 0.00 non-youngs/s
  646. Pages read 15, created 410, written 0
  647. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  648. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  649. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  650. LRU len: 19053, unzip_LRU len: 0
  651. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  652. ---BUFFER POOL 21
  653. Buffer pool size 364928
  654. Free buffers 345779
  655. Database pages 19149
  656. Old database pages 7048
  657. Modified db pages 0
  658. Pending reads 0
  659. Pending writes: LRU 0, flush list 0 single page 0
  660. Pages made young 2760, not young 0
  661. 0.00 youngs/s, 0.00 non-youngs/s
  662. Pages read 1, created 457, written 0
  663. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  664. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  665. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  666. LRU len: 19149, unzip_LRU len: 0
  667. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  668. ---BUFFER POOL 22
  669. Buffer pool size 364928
  670. Free buffers 345617
  671. Database pages 19311
  672. Old database pages 7108
  673. Modified db pages 0
  674. Pending reads 0
  675. Pending writes: LRU 0, flush list 0 single page 0
  676. Pages made young 3080, not young 1
  677. 0.00 youngs/s, 0.00 non-youngs/s
  678. Pages read 8, created 602, written 0
  679. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  680. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  681. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  682. LRU len: 19311, unzip_LRU len: 0
  683. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  684. ---BUFFER POOL 23
  685. Buffer pool size 364928
  686. Free buffers 344984
  687. Database pages 19944
  688. Old database pages 7342
  689. Modified db pages 0
  690. Pending reads 0
  691. Pending writes: LRU 0, flush list 0 single page 0
  692. Pages made young 4367, not young 38
  693. 0.00 youngs/s, 0.00 non-youngs/s
  694. Pages read 16, created 661, written 0
  695. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  696. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  697. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  698. LRU len: 19944, unzip_LRU len: 0
  699. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  700. ---BUFFER POOL 24
  701. Buffer pool size 364928
  702. Free buffers 345749
  703. Database pages 19179
  704. Old database pages 7059
  705. Modified db pages 0
  706. Pending reads 0
  707. Pending writes: LRU 0, flush list 0 single page 0
  708. Pages made young 4237, not young 0
  709. 0.00 youngs/s, 0.00 non-youngs/s
  710. Pages read 4, created 386, written 0
  711. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  712. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  713. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  714. LRU len: 19179, unzip_LRU len: 0
  715. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  716. ---BUFFER POOL 25
  717. Buffer pool size 364928
  718. Free buffers 345661
  719. Database pages 19267
  720. Old database pages 7092
  721. Modified db pages 0
  722. Pending reads 0
  723. Pending writes: LRU 0, flush list 0 single page 0
  724. Pages made young 4459, not young 14
  725. 0.00 youngs/s, 0.00 non-youngs/s
  726. Pages read 7, created 463, written 0
  727. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  728. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  729. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  730. LRU len: 19267, unzip_LRU len: 0
  731. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  732. ---BUFFER POOL 26
  733. Buffer pool size 364928
  734. Free buffers 345468
  735. Database pages 19460
  736. Old database pages 7163
  737. Modified db pages 0
  738. Pending reads 0
  739. Pending writes: LRU 0, flush list 0 single page 0
  740. Pages made young 4528, not young 220
  741. 0.00 youngs/s, 0.00 non-youngs/s
  742. Pages read 21, created 585, written 0
  743. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  744. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  745. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  746. LRU len: 19460, unzip_LRU len: 0
  747. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  748. ---BUFFER POOL 27
  749. Buffer pool size 364928
  750. Free buffers 345578
  751. Database pages 19350
  752. Old database pages 7122
  753. Modified db pages 0
  754. Pending reads 0
  755. Pending writes: LRU 0, flush list 0 single page 0
  756. Pages made young 2698, not young 65
  757. 0.00 youngs/s, 0.00 non-youngs/s
  758. Pages read 2, created 743, written 0
  759. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  760. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  761. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  762. LRU len: 19350, unzip_LRU len: 0
  763. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  764. ---BUFFER POOL 28
  765. Buffer pool size 364928
  766. Free buffers 345862
  767. Database pages 19066
  768. Old database pages 7018
  769. Modified db pages 0
  770. Pending reads 0
  771. Pending writes: LRU 0, flush list 0 single page 0
  772. Pages made young 3777, not young 0
  773. 0.00 youngs/s, 0.00 non-youngs/s
  774. Pages read 0, created 465, written 0
  775. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  776. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  777. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  778. LRU len: 19066, unzip_LRU len: 0
  779. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  780. ---BUFFER POOL 29
  781. Buffer pool size 364928
  782. Free buffers 345176
  783. Database pages 19752
  784. Old database pages 7271
  785. Modified db pages 0
  786. Pending reads 0
  787. Pending writes: LRU 0, flush list 0 single page 0
  788. Pages made young 4281, not young 2
  789. 0.04 youngs/s, 0.00 non-youngs/s
  790. Pages read 5, created 522, written 0
  791. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  792. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  793. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  794. LRU len: 19752, unzip_LRU len: 0
  795. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  796. ---BUFFER POOL 30
  797. Buffer pool size 364928
  798. Free buffers 345569
  799. Database pages 19359
  800. Old database pages 7126
  801. Modified db pages 0
  802. Pending reads 0
  803. Pending writes: LRU 0, flush list 0 single page 0
  804. Pages made young 4083, not young 0
  805. 0.00 youngs/s, 0.00 non-youngs/s
  806. Pages read 11, created 606, written 0
  807. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  808. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  809. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  810. LRU len: 19359, unzip_LRU len: 0
  811. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  812. ---BUFFER POOL 31
  813. Buffer pool size 364928
  814. Free buffers 345088
  815. Database pages 19840
  816. Old database pages 7303
  817. Modified db pages 0
  818. Pending reads 0
  819. Pending writes: LRU 0, flush list 0 single page 0
  820. Pages made young 4214, not young 665
  821. 0.00 youngs/s, 0.00 non-youngs/s
  822. Pages read 10, created 623, written 0
  823. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  824. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  825. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  826. LRU len: 19840, unzip_LRU len: 0
  827. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  828. ---BUFFER POOL 32
  829. Buffer pool size 364928
  830. Free buffers 345580
  831. Database pages 19348
  832. Old database pages 7122
  833. Modified db pages 0
  834. Pending reads 0
  835. Pending writes: LRU 0, flush list 0 single page 0
  836. Pages made young 4299, not young 0
  837. 0.00 youngs/s, 0.00 non-youngs/s
  838. Pages read 1, created 578, written 0
  839. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  840. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  841. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  842. LRU len: 19348, unzip_LRU len: 0
  843. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  844. ---BUFFER POOL 33
  845. Buffer pool size 364928
  846. Free buffers 345275
  847. Database pages 19653
  848. Old database pages 7234
  849. Modified db pages 0
  850. Pending reads 0
  851. Pending writes: LRU 0, flush list 0 single page 0
  852. Pages made young 4270, not young 1
  853. 0.04 youngs/s, 0.00 non-youngs/s
  854. Pages read 3, created 448, written 0
  855. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  856. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  857. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  858. LRU len: 19653, unzip_LRU len: 0
  859. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  860. ---BUFFER POOL 34
  861. Buffer pool size 364928
  862. Free buffers 345202
  863. Database pages 19726
  864. Old database pages 7261
  865. Modified db pages 0
  866. Pending reads 0
  867. Pending writes: LRU 0, flush list 0 single page 0
  868. Pages made young 4030, not young 0
  869. 0.00 youngs/s, 0.00 non-youngs/s
  870. Pages read 0, created 506, written 0
  871. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  872. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  873. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  874. LRU len: 19726, unzip_LRU len: 0
  875. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  876. ---BUFFER POOL 35
  877. Buffer pool size 364928
  878. Free buffers 344716
  879. Database pages 20212
  880. Old database pages 7441
  881. Modified db pages 0
  882. Pending reads 0
  883. Pending writes: LRU 0, flush list 0 single page 0
  884. Pages made young 4372, not young 106
  885. 0.00 youngs/s, 0.00 non-youngs/s
  886. Pages read 6, created 657, written 0
  887. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  888. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  889. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  890. LRU len: 20212, unzip_LRU len: 0
  891. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  892. ---BUFFER POOL 36
  893. Buffer pool size 364928
  894. Free buffers 345578
  895. Database pages 19350
  896. Old database pages 7122
  897. Modified db pages 0
  898. Pending reads 0
  899. Pending writes: LRU 0, flush list 0 single page 0
  900. Pages made young 3178, not young 0
  901. 0.00 youngs/s, 0.00 non-youngs/s
  902. Pages read 25, created 382, written 0
  903. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  904. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  905. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  906. LRU len: 19350, unzip_LRU len: 0
  907. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  908. ---BUFFER POOL 37
  909. Buffer pool size 364928
  910. Free buffers 345466
  911. Database pages 19462
  912. Old database pages 7164
  913. Modified db pages 0
  914. Pending reads 0
  915. Pending writes: LRU 0, flush list 0 single page 0
  916. Pages made young 3033, not young 108
  917. 0.00 youngs/s, 0.00 non-youngs/s
  918. Pages read 12, created 389, written 0
  919. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  920. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  921. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  922. LRU len: 19462, unzip_LRU len: 0
  923. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  924. ---BUFFER POOL 38
  925. Buffer pool size 364928
  926. Free buffers 345454
  927. Database pages 19474
  928. Old database pages 7168
  929. Modified db pages 0
  930. Pending reads 0
  931. Pending writes: LRU 0, flush list 0 single page 0
  932. Pages made young 4214, not young 0
  933. 0.00 youngs/s, 0.00 non-youngs/s
  934. Pages read 1, created 538, written 0
  935. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  936. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  937. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  938. LRU len: 19474, unzip_LRU len: 0
  939. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  940. ---BUFFER POOL 39
  941. Buffer pool size 364928
  942. Free buffers 344706
  943. Database pages 20222
  944. Old database pages 7444
  945. Modified db pages 0
  946. Pending reads 0
  947. Pending writes: LRU 0, flush list 0 single page 0
  948. Pages made young 4620, not young 32
  949. 0.29 youngs/s, 0.00 non-youngs/s
  950. Pages read 6, created 697, written 0
  951. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  952. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  953. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  954. LRU len: 20222, unzip_LRU len: 0
  955. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  956. ---BUFFER POOL 40
  957. Buffer pool size 364928
  958. Free buffers 345047
  959. Database pages 19881
  960. Old database pages 7318
  961. Modified db pages 0
  962. Pending reads 0
  963. Pending writes: LRU 0, flush list 0 single page 0
  964. Pages made young 4110, not young 0
  965. 0.00 youngs/s, 0.00 non-youngs/s
  966. Pages read 0, created 765, written 0
  967. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  968. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  969. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  970. LRU len: 19881, unzip_LRU len: 0
  971. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  972. ---BUFFER POOL 41
  973. Buffer pool size 364928
  974. Free buffers 345005
  975. Database pages 19923
  976. Old database pages 7334
  977. Modified db pages 0
  978. Pending reads 0
  979. Pending writes: LRU 0, flush list 0 single page 0
  980. Pages made young 4279, not young 4
  981. 0.00 youngs/s, 0.00 non-youngs/s
  982. Pages read 6, created 561, written 0
  983. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  984. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  985. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  986. LRU len: 19923, unzip_LRU len: 0
  987. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  988. ---BUFFER POOL 42
  989. Buffer pool size 364928
  990. Free buffers 345041
  991. Database pages 19887
  992. Old database pages 7321
  993. Modified db pages 0
  994. Pending reads 0
  995. Pending writes: LRU 0, flush list 0 single page 0
  996. Pages made young 4131, not young 0
  997. 0.00 youngs/s, 0.00 non-youngs/s
  998. Pages read 5, created 553, written 0
  999. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1000. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1001. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1002. LRU len: 19887, unzip_LRU len: 0
  1003. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1004. ---BUFFER POOL 43
  1005. Buffer pool size 364928
  1006. Free buffers 344700
  1007. Database pages 20228
  1008. Old database pages 7446
  1009. Modified db pages 0
  1010. Pending reads 0
  1011. Pending writes: LRU 0, flush list 0 single page 0
  1012. Pages made young 4381, not young 12
  1013. 0.00 youngs/s, 0.00 non-youngs/s
  1014. Pages read 3, created 732, written 0
  1015. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1016. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1017. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1018. LRU len: 20228, unzip_LRU len: 0
  1019. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1020. ---BUFFER POOL 44
  1021. Buffer pool size 364928
  1022. Free buffers 344662
  1023. Database pages 20266
  1024. Old database pages 7461
  1025. Modified db pages 0
  1026. Pending reads 0
  1027. Pending writes: LRU 0, flush list 0 single page 0
  1028. Pages made young 3915, not young 0
  1029. 0.00 youngs/s, 0.00 non-youngs/s
  1030. Pages read 4, created 652, written 0
  1031. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1032. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1033. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1034. LRU len: 20266, unzip_LRU len: 0
  1035. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1036. ---BUFFER POOL 45
  1037. Buffer pool size 364928
  1038. Free buffers 344881
  1039. Database pages 20047
  1040. Old database pages 7380
  1041. Modified db pages 0
  1042. Pending reads 0
  1043. Pending writes: LRU 0, flush list 0 single page 0
  1044. Pages made young 5269, not young 0
  1045. 0.00 youngs/s, 0.00 non-youngs/s
  1046. Pages read 7, created 567, written 0
  1047. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1048. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1049. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1050. LRU len: 20047, unzip_LRU len: 0
  1051. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1052. ---BUFFER POOL 46
  1053. Buffer pool size 364928
  1054. Free buffers 344659
  1055. Database pages 20269
  1056. Old database pages 7462
  1057. Modified db pages 0
  1058. Pending reads 0
  1059. Pending writes: LRU 0, flush list 0 single page 0
  1060. Pages made young 3569, not young 132
  1061. 0.00 youngs/s, 0.00 non-youngs/s
  1062. Pages read 4, created 582, written 0
  1063. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1064. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1065. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1066. LRU len: 20269, unzip_LRU len: 0
  1067. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1068. ---BUFFER POOL 47
  1069. Buffer pool size 364928
  1070. Free buffers 344655
  1071. Database pages 20273
  1072. Old database pages 7463
  1073. Modified db pages 0
  1074. Pending reads 0
  1075. Pending writes: LRU 0, flush list 0 single page 0
  1076. Pages made young 4140, not young 7
  1077. 0.00 youngs/s, 0.00 non-youngs/s
  1078. Pages read 6, created 807, written 0
  1079. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1080. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1081. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1082. LRU len: 20273, unzip_LRU len: 0
  1083. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1084. ---BUFFER POOL 48
  1085. Buffer pool size 364928
  1086. Free buffers 344736
  1087. Database pages 20192
  1088. Old database pages 7433
  1089. Modified db pages 0
  1090. Pending reads 0
  1091. Pending writes: LRU 0, flush list 0 single page 0
  1092. Pages made young 4158, not young 0
  1093. 0.00 youngs/s, 0.00 non-youngs/s
  1094. Pages read 5, created 709, written 0
  1095. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1096. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1097. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1098. LRU len: 20192, unzip_LRU len: 0
  1099. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1100. ---BUFFER POOL 49
  1101. Buffer pool size 364928
  1102. Free buffers 344425
  1103. Database pages 20503
  1104. Old database pages 7548
  1105. Modified db pages 0
  1106. Pending reads 0
  1107. Pending writes: LRU 0, flush list 0 single page 0
  1108. Pages made young 4204, not young 0
  1109. 0.00 youngs/s, 0.00 non-youngs/s
  1110. Pages read 1, created 670, written 0
  1111. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1112. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1113. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1114. LRU len: 20503, unzip_LRU len: 0
  1115. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1116. ---BUFFER POOL 50
  1117. Buffer pool size 364928
  1118. Free buffers 344959
  1119. Database pages 19969
  1120. Old database pages 7351
  1121. Modified db pages 0
  1122. Pending reads 0
  1123. Pending writes: LRU 0, flush list 0 single page 0
  1124. Pages made young 3790, not young 0
  1125. 0.00 youngs/s, 0.00 non-youngs/s
  1126. Pages read 13, created 605, written 0
  1127. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1128. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1129. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1130. LRU len: 19969, unzip_LRU len: 0
  1131. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1132. ---BUFFER POOL 51
  1133. Buffer pool size 364928
  1134. Free buffers 344807
  1135. Database pages 20121
  1136. Old database pages 7407
  1137. Modified db pages 0
  1138. Pending reads 0
  1139. Pending writes: LRU 0, flush list 0 single page 0
  1140. Pages made young 3967, not young 23
  1141. 0.00 youngs/s, 0.00 non-youngs/s
  1142. Pages read 5, created 494, written 0
  1143. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1144. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1145. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1146. LRU len: 20121, unzip_LRU len: 0
  1147. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1148. ---BUFFER POOL 52
  1149. Buffer pool size 364928
  1150. Free buffers 344651
  1151. Database pages 20277
  1152. Old database pages 7465
  1153. Modified db pages 0
  1154. Pending reads 0
  1155. Pending writes: LRU 0, flush list 0 single page 0
  1156. Pages made young 3856, not young 12
  1157. 0.00 youngs/s, 0.00 non-youngs/s
  1158. Pages read 6, created 573, written 0
  1159. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1160. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1161. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1162. LRU len: 20277, unzip_LRU len: 0
  1163. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1164. ---BUFFER POOL 53
  1165. Buffer pool size 364928
  1166. Free buffers 344658
  1167. Database pages 20270
  1168. Old database pages 7462
  1169. Modified db pages 0
  1170. Pending reads 0
  1171. Pending writes: LRU 0, flush list 0 single page 0
  1172. Pages made young 4234, not young 0
  1173. 0.00 youngs/s, 0.00 non-youngs/s
  1174. Pages read 1, created 573, written 0
  1175. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1176. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1177. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1178. LRU len: 20270, unzip_LRU len: 0
  1179. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1180. ---BUFFER POOL 54
  1181. Buffer pool size 364928
  1182. Free buffers 344563
  1183. Database pages 20365
  1184. Old database pages 7497
  1185. Modified db pages 0
  1186. Pending reads 0
  1187. Pending writes: LRU 0, flush list 0 single page 0
  1188. Pages made young 3982, not young 0
  1189. 0.00 youngs/s, 0.00 non-youngs/s
  1190. Pages read 15, created 556, written 0
  1191. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1192. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1193. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1194. LRU len: 20365, unzip_LRU len: 0
  1195. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1196. ---BUFFER POOL 55
  1197. Buffer pool size 364928
  1198. Free buffers 344416
  1199. Database pages 20512
  1200. Old database pages 7551
  1201. Modified db pages 0
  1202. Pending reads 0
  1203. Pending writes: LRU 0, flush list 0 single page 0
  1204. Pages made young 4086, not young 159
  1205. 0.00 youngs/s, 0.00 non-youngs/s
  1206. Pages read 6, created 537, written 0
  1207. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1208. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1209. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1210. LRU len: 20512, unzip_LRU len: 0
  1211. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1212. ---BUFFER POOL 56
  1213. Buffer pool size 364928
  1214. Free buffers 344790
  1215. Database pages 20138
  1216. Old database pages 7413
  1217. Modified db pages 0
  1218. Pending reads 0
  1219. Pending writes: LRU 0, flush list 0 single page 0
  1220. Pages made young 3643, not young 10
  1221. 0.00 youngs/s, 0.00 non-youngs/s
  1222. Pages read 12, created 466, written 0
  1223. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1224. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1225. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1226. LRU len: 20138, unzip_LRU len: 0
  1227. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1228. ---BUFFER POOL 57
  1229. Buffer pool size 364928
  1230. Free buffers 344760
  1231. Database pages 20168
  1232. Old database pages 7424
  1233. Modified db pages 0
  1234. Pending reads 0
  1235. Pending writes: LRU 0, flush list 0 single page 0
  1236. Pages made young 3833, not young 0
  1237. 0.00 youngs/s, 0.00 non-youngs/s
  1238. Pages read 8, created 617, written 0
  1239. 0.00 reads/s, 0.04 creates/s, 0.00 writes/s
  1240. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1241. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1242. LRU len: 20168, unzip_LRU len: 0
  1243. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1244. ---BUFFER POOL 58
  1245. Buffer pool size 364928
  1246. Free buffers 345217
  1247. Database pages 19711
  1248. Old database pages 7256
  1249. Modified db pages 0
  1250. Pending reads 0
  1251. Pending writes: LRU 0, flush list 0 single page 0
  1252. Pages made young 3257, not young 187
  1253. 0.00 youngs/s, 0.00 non-youngs/s
  1254. Pages read 6, created 697, written 0
  1255. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1256. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1257. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1258. LRU len: 19711, unzip_LRU len: 0
  1259. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1260. ---BUFFER POOL 59
  1261. Buffer pool size 364928
  1262. Free buffers 345027
  1263. Database pages 19901
  1264. Old database pages 7326
  1265. Modified db pages 0
  1266. Pending reads 0
  1267. Pending writes: LRU 0, flush list 0 single page 0
  1268. Pages made young 4294, not young 222
  1269. 0.04 youngs/s, 0.00 non-youngs/s
  1270. Pages read 28, created 624, written 0
  1271. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1272. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1273. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1274. LRU len: 19901, unzip_LRU len: 0
  1275. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1276. ---BUFFER POOL 60
  1277. Buffer pool size 364928
  1278. Free buffers 345500
  1279. Database pages 19428
  1280. Old database pages 7151
  1281. Modified db pages 0
  1282. Pending reads 0
  1283. Pending writes: LRU 0, flush list 0 single page 0
  1284. Pages made young 3309, not young 52
  1285. 0.04 youngs/s, 0.00 non-youngs/s
  1286. Pages read 15, created 573, written 0
  1287. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1288. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1289. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1290. LRU len: 19428, unzip_LRU len: 0
  1291. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1292. ---BUFFER POOL 61
  1293. Buffer pool size 364928
  1294. Free buffers 345541
  1295. Database pages 19387
  1296. Old database pages 7136
  1297. Modified db pages 0
  1298. Pending reads 0
  1299. Pending writes: LRU 0, flush list 0 single page 0
  1300. Pages made young 2922, not young 0
  1301. 0.00 youngs/s, 0.00 non-youngs/s
  1302. Pages read 7, created 641, written 0
  1303. 0.00 reads/s, 0.08 creates/s, 0.00 writes/s
  1304. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1305. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1306. LRU len: 19387, unzip_LRU len: 0
  1307. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1308. ---BUFFER POOL 62
  1309. Buffer pool size 364928
  1310. Free buffers 345123
  1311. Database pages 19805
  1312. Old database pages 7290
  1313. Modified db pages 0
  1314. Pending reads 0
  1315. Pending writes: LRU 0, flush list 0 single page 0
  1316. Pages made young 3540, not young 192
  1317. 0.00 youngs/s, 0.00 non-youngs/s
  1318. Pages read 12, created 521, written 0
  1319. 0.00 reads/s, 0.04 creates/s, 0.00 writes/s
  1320. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1321. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1322. LRU len: 19805, unzip_LRU len: 0
  1323. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1324. ---BUFFER POOL 63
  1325. Buffer pool size 364928
  1326. Free buffers 345132
  1327. Database pages 19796
  1328. Old database pages 7287
  1329. Modified db pages 0
  1330. Pending reads 0
  1331. Pending writes: LRU 0, flush list 0 single page 0
  1332. Pages made young 3235, not young 251
  1333. 0.08 youngs/s, 0.00 non-youngs/s
  1334. Pages read 27, created 497, written 0
  1335. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1336. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1337. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1338. LRU len: 19796, unzip_LRU len: 0
  1339. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1340. --------------
  1341. ROW OPERATIONS
  1342. --------------
  1343. 0 queries inside InnoDB, 0 queries in queue
  1344. 0 read views open inside InnoDB
  1345. Main thread process no. 62143, id 48195252496128, state: sleeping
  1346. Number of rows inserted 3883930, updated 147214, deleted 1202801, read 4203061617
  1347. 21.37 inserts/s, 9.79 updates/s, 0.00 deletes/s, 1188763.34 reads/s
  1348. ----------------------------
  1349. END OF INNODB MONITOR OUTPUT
  1350. ============================
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement