258 system user NULL Connect 7928474 Waiting for master to send event NULL 259 system user NULL Connect 0 Slave has read all relay log; waiting for the slave I/O thread to update it NULL 3476 replicant 192.168.10.43:57253 NULL Binlog Dump 7922546 Master has sent all binlog to slave; waiting for binlog to be updated NULL 9905559 myds 10.112.0.203:41591 merchant_portal Sleep 0 NULL 9905563 myds 10.112.0.203:41594 merchant_portal Query 0 Sending data SELECT field_data_field_account_id0.entity_type AS entity_type, field_data_field_account_id0.entity_ 9905576 myds 10.112.0.203:41601 merchant_portal Sleep 0 NULL 9905581 myds 10.112.0.202:46815 merchant_portal Query 0 Sending data SELECT field_data_field_account_id0.entity_type AS entity_type, field_data_field_account_id0.entity_ 9905583 myds 10.112.0.202:46816 merchant_portal Query 0 init SELECT t__0.* FROM file_display t__0 WHERE (name IN ('image__teaser__file_field_file_audio', 'ima 9905584 myds 10.112.0.202:46819 merchant_portal Query 0 Creating sort index SELECT email_log.account_id AS email_log_account_id, email_log.origin AS email_log_origin, email_log 9905585 myds 10.112.0.201:58998 merchant_portal Query 0 init SELECT t__0.* FROM file_display t__0 WHERE (name IN ('image__default__file_field_file_audio', 'im 9905588 myds 10.112.0.201:59007 merchant_portal Query 1 Sending data SELECT field_data_field_account_id0.entity_type AS entity_type, field_data_field_account_id0.entity_ 9905590 myds 10.112.0.201:59013 merchant_portal Query 1 Sending data SELECT field_data_field_account_id0.entity_type AS entity_type, field_data_field_account_id0.entity_ 9905597 myds 10.112.0.201:59023 merchant_portal Query 0 Sending data SELECT field_data_field_account_id0.entity_type AS entity_type, field_data_field_account_id0.entity_ 9905598 myds 10.112.0.202:46829 merchant_portal Sleep 3 NULL 9905603 myds 10.112.0.202:46834 merchant_portal Query 0 statistics SELECT * FROM panels_pane WHERE did IN ('70') ORDER BY did, panel, position 9905605 myds 10.112.0.201:59029 merchant_portal Sleep 0 NULL 9905607 myds 10.112.0.201:59031 merchant_portal Query 0 Sending data SELECT field_data_field_account_id0.entity_type AS entity_type, field_data_field_account_id0.entity_ 9905608 myds 10.112.0.203:41615 merchant_portal Sleep 0 NULL 9905609 myds 10.112.0.202:46839 merchant_portal Sleep 0 NULL 9905610 drupal 10.113.0.205:55778 NULL Query 0 init SHOW PROCESSLIST InnoDB ===================================== 2014-04-09 15:22:17 7f68aad35700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 52 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 7460381 srv_active, 0 srv_shutdown, 303673 srv_idle srv_master_thread log flush and writes: 7764054 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 15007579 --Thread 140087670327040 has waited at row0purge.cc line 772 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x1331aa0 created in file dict0dict.cc line 892 a writer (thread id 140087638857472) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0purge.cc line 772 Last time write locked in file /pb2/build/sb_0-8179570-1358873986.58/rpm/BUILD/mysql-5.6.10/mysql-5.6.10/storage/innobase/dict/dict0stats.cc line 2259 OS WAIT ARRAY INFO: signal count 13847349 Mutex spin waits 938114515, rounds 612036837, OS waits 10269882 RW-shared spins 4192153, rounds 120428824, OS waits 3493672 RW-excl spins 1073310, rounds 45957305, OS waits 1164820 Spin rounds per wait: 0.65 mutex, 28.73 RW-shared, 42.82 RW-excl ------------------------ LATEST DETECTED DEADLOCK ------------------------ 2014-04-09 15:22:01 7f68a9390700 *** (1) TRANSACTION: TRANSACTION 10095917168, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 LOCK WAIT 3 lock struct(s), heap size 376, 2 row lock(s) MySQL thread id 9905558, OS thread handle 0x7f6d142bd700, query id 2141131249 10.112.0.201 myds update INSERT INTO cache_field (cid, serialized, created, expire, data) VALUES ('field_info:field_map', '1', '1397082118', '0', 'a:148:{s:4:\"body\";a:2:{s:7:\"bundles\";a:1:{s:4:\"node\";a:5:{i:0;s:7:\"webform\";i:1;s:4:\"page\";i:2;s:3:\"faq\";i:3;s:9:\"marketing\";i:4;s:12:\"testimonials\";}}s:4:\"type\";s:17:\"text_with_summary\";}s:16:\"field_video_file\";a:2:{s:7:\"bundles\";a:1:{s:4:\"node\";a:1:{i:0;s:5:\"video\";}}s:4:\"type\";s:5:\"media\";}s:21:\"field_coupon_headline\";a:2:{s:7:\"bundles\";a:1:{s:4:\"node\";a:1:{i:0;s:6:\"coupon\";}}s:4:\"type\";s:4:\"text\";}s:25:\"field_coupon_miniheadline\";a:2:{s:7:\"bundles\";a:1:{s:4:\"node\";a:1:{i:0;s:6:\"coupon\";}}s:4:\"type\";s:4:\"text\";}s:24:\"field_coupon_description\";a:2:{s:7:\"bundles\";a:1:{s:4:\"node\";a:1:{i:0;s:6:\"coupon\";}}s:4:\"type\";s:9:\"text_long\";}s:18:\"field_coupon_legal\";a:2:{s:7:\"bundles\";a:1:{s:4:\"node\";a:1:{i:0;s:6:\"coupon\"; *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 1518791 page no 30 n bits 80 index "PRIMARY" of table "merchant_portal"."cache_field" trx id 10095917168 lock_mode X locks rec but not gap waiting Record lock, heap no 5 PHYSICAL RECORD: n_fields 7; compact format; info bits 32 0: len 20; hex 6669656c645f696e666f3a6669656c645f6d6170; asc field_info:field_map;; 1: len 6; hex 000259c377cd; asc Y w ;; 2: len 7; hex 5e000001ef2d5f; asc ^ -_;; 3: len 30; hex 613a3134383a7b733a343a22626f6479223b613a323a7b733a373a226275; asc a:148:{s:4:"body";a:2:{s:7:"bu; (total 788 bytes); 4: len 4; hex 80000000; asc ;; 5: len 4; hex d345c806; asc E ;; 6: len 2; hex 8001; asc ;; *** (2) TRANSACTION: TRANSACTION 10095917169, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 3 lock struct(s), heap size 376, 2 row lock(s) MySQL thread id 9905575, OS thread handle 0x7f68a9390700, query id 2141131251 10.112.0.202 myds update INSERT INTO cache_field (cid, serialized, created, expire, data) VALUES ('field_info:field_map', '1', '1397082120', '0', 'a:148:{s:4:\"body\";a:2:{s:7:\"bundles\";a:1:{s:4:\"node\";a:5:{i:0;s:7:\"webform\";i:1;s:4:\"page\";i:2;s:3:\"faq\";i:3;s:9:\"marketing\";i:4;s:12:\"testimonials\";}}s:4:\"type\";s:17:\"text_with_summary\";}s:16:\"field_video_file\";a:2:{s:7:\"bundles\";a:1:{s:4:\"node\";a:1:{i:0;s:5:\"video\";}}s:4:\"type\";s:5:\"media\";}s:21:\"field_coupon_headline\";a:2:{s:7:\"bundles\";a:1:{s:4:\"node\";a:1:{i:0;s:6:\"coupon\";}}s:4:\"type\";s:4:\"text\";}s:25:\"field_coupon_miniheadline\";a:2:{s:7:\"bundles\";a:1:{s:4:\"node\";a:1:{i:0;s:6:\"coupon\";}}s:4:\"type\";s:4:\"text\";}s:24:\"field_coupon_description\";a:2:{s:7:\"bundles\";a:1:{s:4:\"node\";a:1:{i:0;s:6:\"coupon\";}}s:4:\"type\";s:9:\"text_long\";}s:18:\"field_coupon_legal\";a:2:{s:7:\"bundles\";a:1:{s:4:\"node\";a:1:{i:0;s:6:\"coupon\"; *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 1518791 page no 30 n bits 80 index "PRIMARY" of table "merchant_portal"."cache_field" trx id 10095917169 lock mode S locks rec but not gap Record lock, heap no 5 PHYSICAL RECORD: n_fields 7; compact format; info bits 32 0: len 20; hex 6669656c645f696e666f3a6669656c645f6d6170; asc field_info:field_map;; 1: len 6; hex 000259c377cd; asc Y w ;; 2: len 7; hex 5e000001ef2d5f; asc ^ -_;; 3: len 30; hex 613a3134383a7b733a343a22626f6479223b613a323a7b733a373a226275; asc a:148:{s:4:"body";a:2:{s:7:"bu; (total 788 bytes); 4: len 4; hex 80000000; asc ;; 5: len 4; hex d345c806; asc E ;; 6: len 2; hex 8001; asc ;; *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 1518791 page no 30 n bits 80 index "PRIMARY" of table "merchant_portal"."cache_field" trx id 10095917169 lock_mode X locks rec but not gap waiting Record lock, heap no 5 PHYSICAL RECORD: n_fields 7; compact format; info bits 32 0: len 20; hex 6669656c645f696e666f3a6669656c645f6d6170; asc field_info:field_map;; 1: len 6; hex 000259c377cd; asc Y w ;; 2: len 7; hex 5e000001ef2d5f; asc ^ -_;; 3: len 30; hex 613a3134383a7b733a343a22626f6479223b613a323a7b733a373a226275; asc a:148:{s:4:"body";a:2:{s:7:"bu; (total 788 bytes); 4: len 4; hex 80000000; asc ;; 5: len 4; hex d345c806; asc E ;; 6: len 2; hex 8001; asc ;; *** WE ROLL BACK TRANSACTION (2) ------------ TRANSACTIONS ------------ Trx id counter 10095954213 Purge done for trx's n:o < 10095951946 undo n:o < 0 state: running History list length 797 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started MySQL thread id 9905610, OS thread handle 0x7f68aad35700, query id 2141163193 10.113.0.205 drupal init SHOW ENGINE INNODB STATUS ---TRANSACTION 10095954216, not started MySQL thread id 9905608, OS thread handle 0x7f68aa24a700, query id 2141163251 10.112.0.203 myds cleaning up ---TRANSACTION 10095954218, not started MySQL thread id 9905605, OS thread handle 0x7f68a8aee700, query id 2141163255 10.112.0.201 myds cleaning up ---TRANSACTION 10095954214, not started MySQL thread id 9905603, OS thread handle 0x7f68a8599700, query id 2141163248 10.112.0.202 myds cleaning up ---TRANSACTION 10095937279, not started MySQL thread id 9905598, OS thread handle 0x7f68a2cea700, query id 2141149151 10.112.0.202 myds cleaning up ---TRANSACTION 10095954099, not started mysql tables in use 1, locked 0 MySQL thread id 9905585, OS thread handle 0x7f68a7086700, query id 2141163148 10.112.0.201 myds statistics SELECT t__0.* FROM file_display t__0 WHERE (name IN ('image__default__file_field_file_audio', 'image__default__file_field_direct_download', 'image__default__file_field_direct_download_accessible', 'image__default__file_field_direct_download_accessible_icon', 'image__default__file_field_direct_download_icon', 'image__default__file_field_file_download_link', 'image__default__file_field_editable', 'image__default__file_field_file_default', 'image__default__file_field_image', 'image__default__file_image', 'image__default__file_field_media_large_icon', 'image__default__lightbox2_iframe', 'image_ ---TRANSACTION 10095954132, not started mysql tables in use 1, locked 0 MySQL thread id 9905583, OS thread handle 0x7f68a7b71700, query id 2141163188 10.112.0.202 myds statistics SELECT t__0.* FROM file_display t__0 WHERE (name IN ('image__teaser__file_field_file_audio', 'image__teaser__file_field_direct_download', 'image__teaser__file_field_direct_download_accessible', 'image__teaser__file_field_direct_download_accessible_icon', 'image__teaser__file_field_direct_download_icon', 'image__teaser__file_field_file_download_link', 'image__teaser__file_field_editable', 'image__teaser__file_field_file_default', 'image__teaser__file_field_image', 'image__teaser__file_image', 'image__teaser__file_field_media_large_icon', 'image__teaser__lightbox2_iframe', 'image__teaser__lig ---TRANSACTION 10095954215, not started MySQL thread id 9905576, OS thread handle 0x7f68aba69700, query id 2141163249 10.112.0.203 myds cleaning up ---TRANSACTION 10095954205, not started MySQL thread id 9905559, OS thread handle 0x7f68a2a60700, query id 2141163256 10.112.0.203 myds Opening tables SELECT node.nid AS nid, file_managed0.fid AS field_video_raw_file_fid, file_managed0.uid AS field_video_raw_file_uid, file_managed0.filename AS field_video_raw_file_filename, file_managed0.uri AS field_video_raw_file_uri, file_managed0.filemime AS field_video_raw_file_filemime, file_managed0.filesize AS field_video_raw_file_filesize, file_managed0.status AS field_video_raw_file_status, file_managed0.timestamp AS field_video_raw_file_timestamp, file_managed0.type AS field_video_raw_file_type, taxonomy_term_data1.tid AS field_video_voice_talent_tid, taxonomy_term_data1.vid AS field_video_voice_t ---TRANSACTION 10095953881, not started MySQL thread id 259, OS thread handle 0x7f6d14916700, query id 2141162920 Slave has read all relay log; waiting for the slave I/O thread to update it ---TRANSACTION 10095953625, ACTIVE 0 sec fetching rows mysql tables in use 1, locked 0 MySQL thread id 9905584, OS thread handle 0x7f68aa6dc700, query id 2141162673 10.112.0.202 myds Creating sort index SELECT email_log.account_id AS email_log_account_id, email_log.origin AS email_log_origin, email_log.sender_uid AS email_log_sender_uid, email_log.recipient_uid AS email_log_recipient_uid, email_log.recipient_email AS email_log_recipient_email, email_log.created AS email_log_created, email_log.subject AS email_log_subject, 'outbound_script_data:block' AS view_name FROM email_log email_log WHERE (( (email_log.account_id = '12584007' ) )AND(( (email_log.origin LIKE 'koi_choose_talent_form_submit' ESCAPE '\\') ))) ORDER BY email_log_created DESC LIMIT 1 OFFSET 0 Trx read view will not see trx with id >= 10095953626, sees < 10095951324 ---TRANSACTION 10095951324, ACTIVE 1 sec starting index read mysql tables in use 4, locked 0 19 lock struct(s), heap size 3112, 1 row lock(s), undo log entries 17 MySQL thread id 9905563, OS thread handle 0x7f6d14894700, query id 2141162993 10.112.0.203 myds Sending data SELECT field_data_field_account_id0.entity_type AS entity_type, field_data_field_account_id0.entity_id AS entity_id, field_data_field_account_id0.revision_id AS revision_id, field_data_field_account_id0.bundle AS bundle, field_data_field_account_source101.field_account_source_value AS field_account_source_value, role_roles.name AS role_names, role_roles.rid AS role_rids FROM field_data_field_account_id field_data_field_account_id0 LEFT JOIN field_data_field_account_source field_data_field_account_source101 ON field_data_field_account_source101.entity_type = field_data_field_account_id0.entity Trx read view will not see trx with id >= 10095953958, sees < 10095953625 -------- 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) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (read thread) I/O thread 7 state: waiting for completed aio requests (read thread) I/O thread 8 state: waiting for completed aio requests (read thread) I/O thread 9 state: waiting for completed aio requests (read thread) I/O thread 10 state: waiting for completed aio requests (read thread) I/O thread 11 state: waiting for completed aio requests (read thread) I/O thread 12 state: waiting for completed aio requests (read thread) I/O thread 13 state: waiting for completed aio requests (read thread) I/O thread 14 state: waiting for completed aio requests (read thread) I/O thread 15 state: waiting for completed aio requests (read thread) I/O thread 16 state: waiting for completed aio requests (read thread) I/O thread 17 state: waiting for completed aio requests (read thread) I/O thread 18 state: waiting for completed aio requests (write thread) I/O thread 19 state: waiting for completed aio requests (write thread) I/O thread 20 state: waiting for completed aio requests (write thread) I/O thread 21 state: waiting for completed aio requests (write thread) I/O thread 22 state: waiting for completed aio requests (write thread) I/O thread 23 state: waiting for completed aio requests (write thread) I/O thread 24 state: waiting for completed aio requests (write thread) I/O thread 25 state: waiting for completed aio requests (write thread) I/O thread 26 state: waiting for completed aio requests (write thread) I/O thread 27 state: waiting for completed aio requests (write thread) I/O thread 28 state: waiting for completed aio requests (write thread) I/O thread 29 state: waiting for completed aio requests (write thread) I/O thread 30 state: waiting for completed aio requests (write thread) I/O thread 31 state: waiting for completed aio requests (write thread) I/O thread 32 state: waiting for completed aio requests (write thread) I/O thread 33 state: waiting for completed aio requests (write thread) Pending normal aio reads: 0 [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 1; buffer pool: 0 671148 OS file reads, 361177336 OS file writes, 223322891 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 96.19 writes/s, 72.77 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 56189, seg size 56191, 228479 merges merged operations: insert 221499, delete mark 9936967, delete 142341 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 31874593, node heap has 0 buffer(s) 0.00 hash searches/s, 139262.74 non-hash searches/s --- LOG --- Log sequence number 1237563842463 Log flushed up to 1237563840815 Pages flushed up to 1237177814686 Last checkpoint at 1237162500150 1 pending log writes, 0 pending chkp writes 28990164 log i/o's done, 22.27 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 16483614720; in additional pool allocated 0 Dictionary memory allocated 16186634 Buffer pool size 983035 Free buffers 47955 Database pages 935080 Old database pages 345121 Modified db pages 4182 Pending reads 0 Pending writes: LRU 0, flush list 0 single page 0 Pages made young 24826967, not young 21104124 0.02 youngs/s, 0.00 non-youngs/s Pages read 661860, created 7470459, written 274562135 0.00 reads/s, 127.04 creates/s, 41.04 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 935080, unzip_LRU len: 0 I/O sum[25008]:cur[144], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 81920 Free buffers 4130 Database pages 77790 Old database pages 28731 Modified db pages 312 Pending reads 0 Pending writes: LRU 0, flush list 0 single page 0 Pages made young 2065701, not young 1755553 0.00 youngs/s, 0.00 non-youngs/s Pages read 55005, created 625453, written 26165347 0.00 reads/s, 9.77 creates/s, 4.25 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 77790, unzip_LRU len: 0 I/O sum[2084]:cur[12], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 81920 Free buffers 4139 Database pages 77781 Old database pages 28730 Modified db pages 174 Pending reads 0 Pending writes: LRU 0, flush list 0 single page 0 Pages made young 1902074, not young 1907370 0.00 youngs/s, 0.00 non-youngs/s Pages read 53141, created 621683, written 18937121 0.00 reads/s, 8.19 creates/s, 3.88 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 77781, unzip_LRU len: 0 I/O sum[2084]:cur[12], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 81919 Free buffers 4129 Database pages 77790 Old database pages 28716 Modified db pages 369 Pending reads 0 Pending writes: LRU 0, flush list 0 single page 0 Pages made young 2137702, not young 1453874 0.00 youngs/s, 0.00 non-youngs/s Pages read 56808, created 621806, written 21397220 0.00 reads/s, 10.23 creates/s, 3.69 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 77790, unzip_LRU len: 0 I/O sum[2084]:cur[12], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 81920 Free buffers 4054 Database pages 77866 Old database pages 28736 Modified db pages 341 Pending reads 0 Pending writes: LRU 0, flush list 0 single page 0 Pages made young 2105802, not young 1898896 0.02 youngs/s, 0.00 non-youngs/s Pages read 57141, created 627141, written 31662730 0.00 reads/s, 13.54 creates/s, 3.17 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 77866, unzip_LRU len: 0 I/O sum[2084]:cur[12], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 81919 Free buffers 3944 Database pages 77975 Old database pages 28766 Modified db pages 473 Pending reads 0 Pending writes: LRU 0, flush list 0 single page 0 Pages made young 2254546, not young 1576181 0.00 youngs/s, 0.00 non-youngs/s Pages read 57124, created 626275, written 31964308 0.00 reads/s, 13.29 creates/s, 4.06 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 77975, unzip_LRU len: 0 I/O sum[2084]:cur[12], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 81920 Free buffers 3844 Database pages 78076 Old database pages 28808 Modified db pages 280 Pending reads 0 Pending writes: LRU 0, flush list 0 single page 0 Pages made young 2009427, not young 2183367 0.00 youngs/s, 0.00 non-youngs/s Pages read 57277, created 623004, written 21353254 0.00 reads/s, 11.50 creates/s, 2.63 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 78076, unzip_LRU len: 0 I/O sum[2084]:cur[12], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 81919 Free buffers 3782 Database pages 78137 Old database pages 28825 Modified db pages 330 Pending reads 0 Pending writes: LRU 0, flush list 0 single page 0 Pages made young 2003537, not young 1786733 0.00 youngs/s, 0.00 non-youngs/s Pages read 55260, created 623952, written 18802256 0.00 reads/s, 12.35 creates/s, 2.37 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 78137, unzip_LRU len: 0 I/O sum[2084]:cur[12], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 81920 Free buffers 3752 Database pages 78168 Old database pages 28834 Modified db pages 450 Pending reads 0 Pending writes: LRU 0, flush list 0 single page 0 Pages made young 2036936, not young 1834276 0.00 youngs/s, 0.00 non-youngs/s Pages read 50764, created 617696, written 22322730 0.00 reads/s, 13.25 creates/s, 2.92 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 78168, unzip_LRU len: 0 I/O sum[2084]:cur[12], unzip sum[0]:cur[0] ---BUFFER POOL 8 Buffer pool size 81919 Free buffers 3854 Database pages 78065 Old database pages 28796 Modified db pages 504 Pending reads 0 Pending writes: LRU 0, flush list 0 single page 0 Pages made young 2135689, not young 1769336 0.00 youngs/s, 0.00 non-youngs/s Pages read 57040, created 624326, written 23726875 0.00 reads/s, 11.79 creates/s, 4.10 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 78065, unzip_LRU len: 0 I/O sum[2084]:cur[12], unzip sum[0]:cur[0] ---BUFFER POOL 9 Buffer pool size 81920 Free buffers 3911 Database pages 78009 Old database pages 28776 Modified db pages 421 Pending reads 0 Pending writes: LRU 0, flush list 0 single page 0 Pages made young 2165027, not young 1600375 0.00 youngs/s, 0.00 non-youngs/s Pages read 52669, created 620424, written 19186696 0.00 reads/s, 8.73 creates/s, 3.87 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 78009, unzip_LRU len: 0 I/O sum[2084]:cur[12], unzip sum[0]:cur[0] ---BUFFER POOL 10 Buffer pool size 81919 Free buffers 4111 Database pages 77808 Old database pages 28733 Modified db pages 243 Pending reads 0 Pending writes: LRU 0, flush list 0 single page 0 Pages made young 1938504, not young 1514274 0.00 youngs/s, 0.00 non-youngs/s Pages read 53848, created 617987, written 16920730 0.00 reads/s, 5.35 creates/s, 2.54 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 77808, unzip_LRU len: 0 I/O sum[2084]:cur[12], unzip sum[0]:cur[0] ---BUFFER POOL 11 Buffer pool size 81920 Free buffers 4305 Database pages 77615 Old database pages 28670 Modified db pages 285 Pending reads 0 Pending writes: LRU 0, flush list 0 single page 0 Pages made young 2072022, not young 1823889 0.00 youngs/s, 0.00 non-youngs/s Pages read 55783, created 620712, written 22122868 0.00 reads/s, 9.06 creates/s, 3.56 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 77615, unzip_LRU len: 0 I/O sum[2084]:cur[12], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 9 read views open inside InnoDB Main thread process no. 23535, id 140087712286464, state: sleeping Number of rows inserted 137850986, updated 42978587, deleted 73263776, read 3333979222826 120.27 inserts/s, 154.40 updates/s, 4.25 deletes/s, 480332.49 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================