=====================================
2017-08-10 03:15:01 0x7f41d00f1700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 9 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 5650 srv_active, 0 srv_shutdown, 23892 srv_idle
srv_master_thread log flush and writes: 29540
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 11183
OS WAIT ARRAY INFO: signal count 21372
RW-shared spins 0, rounds 18535, OS waits 6885
RW-excl spins 0, rounds 143803, OS waits 1673
RW-sx spins 2557, rounds 57162, OS waits 945
Spin rounds per wait: 18535.00 RW-shared, 143803.00 RW-excl, 22.36 RW-sx
------------------------
LATEST DETECTED DEADLOCK
------------------------
2017-08-10 02:45:08 0x7f39701ce700
*** (1) TRANSACTION:
TRANSACTION 2207654, ACTIVE 55 sec starting index read
mysql tables in use 17, locked 17
LOCK WAIT 24 lock struct(s), heap size 3520, 54 row lock(s)
MySQL thread id 89679, OS thread handle 0x7f41e006d700, query id 2110135 localhost site1 updating
update `users` set `duplicate_browser_id` = 13, `updated_at` = '2017-08-10 06:44:14' where `id` in (31, 52, 63, 64, 94, 113, 115, 116, 174, 180, 213, 219, 260, 262, 275, 294, 300, 327, 328, 353, 381, 393, 395, 464, 470, 474, 513, 514, 549, 584, 587, 594, 614, 617, 639, 658, 667, 709, 712, 739, 748, 750, 760, 766, 797, 873, 889, 898, 912, 927, 954, 998, 1021, 1038, 1043, 1060, 1067, 1096, 1108, 1109, 1131, 1135, 1150, 1164, 1172, 1181, 1207, 1213, 1254, 1287, 1320, 1326, 1343, 1351, 1378, 1391, 1394, 1446, 1483, 1494, 1519, 1544, 1551, 1553, 1554, 1578, 1594, 1609, 1624, 1647, 1653, 1656, 1700, 1708, 1739, 1779, 1786, 1833, 1856, 1873, 1895, 1910, 1915, 1945, 1962, 1967, 1995, 1996, 2039, 2050, 2081, 2097, 2105, 2125, 2131, 2133, 2137, 2159, 2169, 2172, 2173, 2177, 2187, 2194, 2198, 2199, 2203, 2204, 2205, 2218, 2225, 2226, 2228, 2232, 2234, 2235, 2254, 2257, 2262, 2263, 2268, 2284, 2285, 2305, 2352, 2368, 2374,
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 393 page no 61 n bits 112 index PRIMARY of table `site1`.`users` trx id 2207654 lock_mode X locks rec but not gap waiting
Record lock, heap no 15 PHYSICAL RECORD: n_fields 36; compact format; info bits 0
0: len 4; hex 0000040e; asc     ;;
1: len 6; hex 000000210f2a; asc    ! *;;
2: len 7; hex 74000003861450; asc t     P;;
3: len 6; hex 7869616f7975; asc xiaoyu;;
4: len 20; hex 6138363731623431333340676d61696c2e636f6d; asc a8671b4133@gmail.com;;
5: len 30; hex 2432792431302434663666566c686657654e536268395236492e36564f33; asc $2y$10$4f6fVlhfWeNSbh9R6I.6VO3; (total 60 bytes);
6: len 30; hex 373538383331396637386563363665633465646466623762333833373738; asc 7588319f78ec66ec4eddfb7b383778; (total 64 bytes);
7: len 2; hex 656e; asc en;;
8: len 14; hex 416d65726963616e2053616d6f61; asc American Samoa;;
9: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc                              ;;
10: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc                              ;;
11: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc                              ;;
12: len 4; hex 00000001; asc     ;;
13: len 4; hex 34323330; asc 4230;;
14: len 4; hex 626c7565; asc blue;;
15: SQL NULL;
16: SQL NULL;
17: len 4; hex 80001c1e; asc     ;;
18: len 1; hex 80; asc  ;;
19: len 1; hex 80; asc  ;;
20: SQL NULL;
21: len 1; hex 80; asc  ;;
22: SQL NULL;
23: len 30; hex 7b2230223a2231343430222c22313535223a2232313630222c2231353539; asc {"0":"1440","155":"2160","1559; (total 39 bytes);
24: len 1; hex 80; asc  ;;
25: SQL NULL;
26: SQL NULL;
27: len 1; hex 81; asc  ;;
28: len 1; hex 80; asc  ;;
29: len 1; hex 80; asc  ;;
30: len 4; hex 75736572; asc user;;
31: SQL NULL;
32: SQL NULL;
33: len 4; hex 00000001; asc     ;;
34: len 4; hex 596113a5; asc Ya  ;;
35: len 4; hex 598b318f; asc Y 1 ;;

*** (2) TRANSACTION:
TRANSACTION 2207608, ACTIVE 127 sec inserting, thread declared inside InnoDB 5000
mysql tables in use 1, locked 1
51 lock struct(s), heap size 8400, 59 row lock(s), undo log entries 58
MySQL thread id 88497, OS thread handle 0x7f39701ce700, query id 2120078 localhost site1 update
insert into `investment_earnings` (`investment_id`, `user_id`, `payment_id`, `amount`, `investment_plan_id`, `type`, `withdraw_num`, `last_earning_at`, `updated_at`, `created_at`) values (6302, 748, 28472, '0.60000000', 5, 'reinvest', 4, '2017-08-10 06:41:01', '2017-08-10 06:45:08', '2017-08-10 06:45:08')
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 393 page no 61 n bits 112 index PRIMARY of table `site1`.`users` trx id 2207608 lock mode S locks rec but not gap
Record lock, heap no 15 PHYSICAL RECORD: n_fields 36; compact format; info bits 0
0: len 4; hex 0000040e; asc     ;;
1: len 6; hex 000000210f2a; asc    ! *;;
2: len 7; hex 74000003861450; asc t     P;;
3: len 6; hex 7869616f7975; asc xiaoyu;;
4: len 20; hex 6138363731623431333340676d61696c2e636f6d; asc a8671b4133@gmail.com;;
5: len 30; hex 2432792431302434663666566c686657654e536268395236492e36564f33; asc $2y$10$4f6fVlhfWeNSbh9R6I.6VO3; (total 60 bytes);
6: len 30; hex 373538383331396637386563363665633465646466623762333833373738; asc 7588319f78ec66ec4eddfb7b383778; (total 64 bytes);
7: len 2; hex 656e; asc en;;
8: len 14; hex 416d65726963616e2053616d6f61; asc American Samoa;;
9: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc                              ;;
10: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc                              ;;
11: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc                              ;;
12: len 4; hex 00000001; asc     ;;
13: len 4; hex 34323330; asc 4230;;
14: len 4; hex 626c7565; asc blue;;
15: SQL NULL;
16: SQL NULL;
17: len 4; hex 80001c1e; asc     ;;
18: len 1; hex 80; asc  ;;
19: len 1; hex 80; asc  ;;
20: SQL NULL;
21: len 1; hex 80; asc  ;;
22: SQL NULL;
23: len 30; hex 7b2230223a2231343430222c22313535223a2232313630222c2231353539; asc {"0":"1440","155":"2160","1559; (total 39 bytes);
24: len 1; hex 80; asc  ;;
25: SQL NULL;
26: SQL NULL;
27: len 1; hex 81; asc  ;;
28: len 1; hex 80; asc  ;;
29: len 1; hex 80; asc  ;;
30: len 4; hex 75736572; asc user;;
31: SQL NULL;
32: SQL NULL;
33: len 4; hex 00000001; asc     ;;
34: len 4; hex 596113a5; asc Ya  ;;
35: len 4; hex 598b318f; asc Y 1 ;;

*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 393 page no 45 n bits 112 index PRIMARY of table `site1`.`users` trx id 2207608 lock mode S locks rec but not gap waiting
Record lock, heap no 13 PHYSICAL RECORD: n_fields 36; compact format; info bits 0
0: len 4; hex 000002ec; asc     ;;
1: len 6; hex 000000210f2a; asc    ! *;;
2: len 7; hex 740000039d1388; asc t      ;;
3: len 7; hex 616e6e6131356d; asc anna15m;;
4: len 21; hex 636f727669642e616e6e6140676d61696c2e636f6d; asc corvid.anna@gmail.com;;
5: len 30; hex 24327924313024314475354f4447446f395a4c652e2f65534a4f36364f57; asc $2y$10$1Du5ODGDo9ZLe./eSJO66OW; (total 60 bytes);
6: len 30; hex 343032333635633934376331376231316232316437396566623930653333; asc 402365c947c17b11b21d79efb90e33; (total 64 bytes);
7: len 2; hex 656e; asc en;;
8: len 9; hex 4175737472616c6961; asc Australia;;
9: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc                              ;;
10: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc                              ;;
11: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc                              ;;
12: len 4; hex 00000001; asc     ;;
13: len 4; hex 31333133; asc 1313;;
14: len 4; hex 626c7565; asc blue;;
15: SQL NULL;
16: SQL NULL;
17: len 4; hex 8000531e; asc   S ;;
18: len 1; hex 80; asc  ;;
19: len 1; hex 81; asc  ;;
20: len 5; hex 999d549810; asc   T  ;;
21: len 1; hex 80; asc  ;;
22: SQL NULL;
23: len 30; hex 7b2230223a2231343430222c22313535223a2232313630222c2231353539; asc {"0":"1440","155":"2160","1559; (total 39 bytes);
24: len 1; hex 80; asc  ;;
25: SQL NULL;
26: SQL NULL;
27: len 1; hex 81; asc  ;;
28: len 1; hex 80; asc  ;;
29: len 1; hex 80; asc  ;;
30: len 4; hex 75736572; asc user;;
31: len 4; hex 00000005; asc     ;;
32: SQL NULL;
33: len 4; hex 00000001; asc     ;;
34: len 4; hex 595def1b; asc Y]  ;;
35: len 4; hex 598b3190; asc Y 1 ;;

*** WE ROLL BACK TRANSACTION (1)
------------
TRANSACTIONS
------------
Trx id counter 2208848
Purge done for trx's n:o < 2208734 undo n:o < 0 state: running but idle
History list length 16
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421395664371096, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421395664367512, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421395664370200, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421395664363032, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421395664362136, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421395664365720, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421395664361240, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 2208795, ACTIVE 74 sec inserting
mysql tables in use 3, locked 3
LOCK WAIT 10 lock struct(s), heap size 1136, 5 row lock(s), undo log entries 2
MySQL thread id 115012, OS thread handle 0x7f397020b700, query id 2483861 localhost site1 update
insert into `payments` (`is_fake`, `status`, `type`, `amount`, `bitcoin_amount`, `order_id`, `payment_system`, `withdraw_account`, `investment_plan_id`, `user_id`, `updated_at`, `created_at`) values (0, 'pending', 'withdraw', '3', 0.0008927, 'ORDER_hpVLgSIxVt0M', 'payeer', 'P32598163', '5', 1273, '2017-08-10 07:13:47', '2017-08-10 07:13:47')
Trx read view will not see trx with id >= 2208795, sees < 2208723
------- TRX HAS BEEN WAITING 74 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 383 page no 979 n bits 104 index payments_payment_system_foreign of table `site1`.`payments` trx id 2208795 lock_mode X locks gap before rec insert intention waiting
Record lock, heap no 2 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 5; hex 7061797a61; asc payza;;
1: len 4; hex 00000708; asc     ;;

------------------
---TRANSACTION 2208779, ACTIVE 113 sec
5 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 3
MySQL thread id 114637, OS thread handle 0x7f3969e8d700, query id 2480941 localhost site1 cleaning up
Trx read view will not see trx with id >= 2208779, sees < 2208723
---TRANSACTION 2208777, ACTIVE 113 sec
5 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 3
MySQL thread id 113821, OS thread handle 0x7f41d00b4700, query id 2481050 localhost site1 cleaning up
Trx read view will not see trx with id >= 2208777, sees < 2208702
---TRANSACTION 2208766, ACTIVE 119 sec fetching rows
mysql tables in use 4, locked 4
LOCK WAIT 669 lock struct(s), heap size 90320, 38748 row lock(s)
MySQL thread id 114891, OS thread handle 0x7f3970117700, query id 2480262 localhost site1 Sending data
select * from `payments` where `type` = 'withdraw' and `payment_system` = 'payza' and `status` = 'pending' and `batch_num` is null and `paid_at` <= '2017-08-10 07:13:02' and `payments`.`deleted_at` is null for update
------- TRX HAS BEEN WAITING 113 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 383 page no 1263 n bits 160 index PRIMARY of table `site1`.`payments` trx id 2208766 lock_mode X locks rec but not gap waiting
Record lock, heap no 91 PHYSICAL RECORD: n_fields 22; compact format; info bits 0
0: len 4; hex 00008198; asc     ;;
1: len 6; hex 00000021b40b; asc    !  ;;
2: len 7; hex 4e000002ea1169; asc N     i;;
3: len 4; hex 000004f1; asc     ;;
4: len 18; hex 4f524445525f5674346d7056753066746b68; asc ORDER_Vt4mpVu0ftkh;;
5: len 4; hex 00000005; asc     ;;
6: len 30; hex 37643662626232632d303830342d343037662d386466612d343939353336; asc 7d6bbb2c-0804-407f-8dfa-499536; (total 36 bytes);
7: len 13; hex 616476616e6365645f63617368; asc advanced_cash;;
8: len 29; hex 8000000000000000000000000000000000000000000000000f00989680; asc                              ;;
9: len 29; hex 800000000000000000000000000000000000000000000000000006d45a; asc                             Z;;
10: SQL NULL;
11: len 13; hex 55373737303534353933313137; asc U777054593117;;
12: SQL NULL;
13: len 1; hex 02; asc  ;;
14: SQL NULL;
15: len 6; hex 616374697665; asc active;;
16: len 1; hex 80; asc  ;;
17: SQL NULL;
18: len 5; hex 999d52e1d4; asc   R  ;;
19: len 4; hex 5989fdd8; asc Y   ;;
20: len 4; hex 598c3fc6; asc Y ? ;;
21: SQL NULL;

------------------
---TRANSACTION 2208765, ACTIVE 121 sec
5 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 3
MySQL thread id 98888, OS thread handle 0x7f3970524700, query id 2481031 localhost site1 cleaning up
Trx read view will not see trx with id >= 2208765, sees < 2208694
---TRANSACTION 2208723, ACTIVE 179 sec inserting
mysql tables in use 1, locked 1
LOCK WAIT 13 lock struct(s), heap size 1136, 6 row lock(s), undo log entries 3
MySQL thread id 114768, OS thread handle 0x7f397033c700, query id 2485923 localhost site1 update
insert into `investment_earnings` (`investment_id`, `user_id`, `payment_id`, `amount`, `investment_plan_id`, `type`, `withdraw_num`, `last_earning_at`, `updated_at`, `created_at`) values (3149, 1302, 16916, '6.00000000', 5, 'reinvest', 12, '2017-08-10 07:11:55', '2017-08-10 07:14:09', '2017-08-10 07:14:09')
Trx read view will not see trx with id >= 2208724, sees < 2208641
------- TRX HAS BEEN WAITING 52 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 383 page no 483 n bits 136 index PRIMARY of table `site1`.`payments` trx id 2208723 lock mode S locks rec but not gap waiting
Record lock, heap no 13 PHYSICAL RECORD: n_fields 22; compact format; info bits 0
0: len 4; hex 00004214; asc   B ;;
1: len 6; hex 00000012bf87; asc       ;;
2: len 7; hex 9e000001a50110; asc        ;;
3: len 4; hex 00000516; asc     ;;
4: len 19; hex 5245494e564553545f416c445233567055716a; asc REINVEST_AlDR3VpUqj;;
5: len 4; hex 00000005; asc     ;;
6: SQL NULL;
7: len 5; hex 7061797a61; asc payza;;
8: len 29; hex 8000000000000000000000000000000000000000000000003200000000; asc                         2    ;;
9: len 29; hex 80000000000000000000000000000000000000000000000000001d3993; asc                            9 ;;
10: SQL NULL;
11: SQL NULL;
12: SQL NULL;
13: len 1; hex 01; asc  ;;
14: SQL NULL;
15: len 6; hex 616374697665; asc active;;
16: len 1; hex 80; asc  ;;
17: SQL NULL;
18: SQL NULL;
19: len 4; hex 5977277b; asc Yw'{;;
20: len 4; hex 5977277b; asc Yw'{;;
21: SQL NULL;

------------------
--------
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 (write thread)
I/O thread 11 state: waiting for completed aio requests (write thread)
I/O thread 12 state: waiting for completed aio requests (write thread)
I/O thread 13 state: waiting for completed aio requests (write thread)
I/O thread 14 state: waiting for completed aio requests (write thread)
I/O thread 15 state: waiting for completed aio requests (write thread)
I/O thread 16 state: waiting for completed aio requests (write thread)
I/O thread 17 state: waiting for completed aio requests (write thread)
Pending normal aio reads: [0, 0, 0, 0, 0, 0, 0, 0] , aio writes: [0, 0, 0, 0, 0, 0, 0, 0] ,
ibuf aio reads:, log i/o's:, sync i/o's:
Pending flushes (fsync) log: 0; buffer pool: 0
12554 OS file reads, 121354 OS file writes, 89902 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.22 writes/s, 0.22 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2, 0 merges
merged operations:
insert 0, delete mark 0, delete 0
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 9461581, node heap has 1 buffer(s)
Hash table size 9461581, node heap has 8 buffer(s)
Hash table size 9461581, node heap has 109 buffer(s)
Hash table size 9461581, node heap has 105 buffer(s)
Hash table size 9461581, node heap has 49 buffer(s)
Hash table size 9461581, node heap has 9 buffer(s)
Hash table size 9461581, node heap has 18 buffer(s)
Hash table size 9461581, node heap has 23 buffer(s)
188.98 hash searches/s, 34.89 non-hash searches/s
---
LOG
---
Log sequence number 889304775
Log flushed up to   889304775
Pages flushed up to 889303701
Last checkpoint at  889303692
0 pending log flushes, 0 pending chkp writes
27023 log i/o's done, 0.22 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 35215376384
Dictionary memory allocated 368530
Buffer pool size   2097120
Free buffers       2084022
Database pages     12771
Old database pages 4784
Modified db pages  8
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 90.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 32, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 12489, created 282, written 67752
0.00 reads/s, 0.00 creates/s, 0.00 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: 12771, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   262144
Free buffers       260439
Database pages     1658
Old database pages 600
Modified db pages  2
Percent of dirty pages(LRU & free pages): 0.001
Max dirty pages percent: 90.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 12, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1601, created 57, written 11301
0.00 reads/s, 0.00 creates/s, 0.00 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: 1658, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   262144
Free buffers       260520
Database pages     1580
Old database pages 594
Modified db pages  0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 90.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 4, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1567, created 13, written 7197
0.00 reads/s, 0.00 creates/s, 0.00 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: 1580, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   262144
Free buffers       260555
Database pages     1546
Old database pages 570
Modified db pages  1
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 90.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 3, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1500, created 46, written 8878
0.00 reads/s, 0.00 creates/s, 0.00 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: 1546, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   262144
Free buffers       260576
Database pages     1525
Old database pages 569
Modified db pages  1
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 90.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 5, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1501, created 24, written 12388
0.00 reads/s, 0.00 creates/s, 0.00 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: 1525, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   262144
Free buffers       260597
Database pages     1507
Old database pages 572
Modified db pages  1
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 90.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 2, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1503, created 4, written 5700
0.00 reads/s, 0.00 creates/s, 0.00 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: 1507, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   262144
Free buffers       260694
Database pages     1412
Old database pages 536
Modified db pages  0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 90.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 3, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1407, created 5, written 6979
0.00 reads/s, 0.00 creates/s, 0.00 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: 1412, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   262112
Free buffers       260360
Database pages     1717
Old database pages 649
Modified db pages  1
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 90.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 3, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1650, created 67, written 7989
0.00 reads/s, 0.00 creates/s, 0.00 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: 1717, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   262144
Free buffers       260281
Database pages     1826
Old database pages 694
Modified db pages  2
Percent of dirty pages(LRU & free pages): 0.001
Max dirty pages percent: 90.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1760, created 66, written 7320
0.00 reads/s, 0.00 creates/s, 0.00 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: 1826, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
5 read views open inside InnoDB
Process ID=23168, Main thread ID=139884707874560, state: sleeping
Number of rows inserted 9090, updated 13612, deleted 1, read 308564467
0.11 inserts/s, 0.11 updates/s, 0.00 deletes/s, 3334.85 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 0
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================