3.show full processlist mysql> show full processlist ; +-----+-----------------+-----------------+--------+---------+------+------------------------+----------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +-----+-----------------+-----------------+--------+---------+------+------------------------+----------------------------------------+ | 4 | event_scheduler | localhost | NULL | Daemon | 1455 | Waiting on empty queue | NULL | | 446 | mysql | localhost | NULL | Query | 0 | starting | show full processlist | | 575 | mysql | localhost:51189 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest1 WHERE id=5016389 | | 576 | mysql | localhost:51191 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest4 WHERE id=4980855 | | 577 | mysql | localhost:51190 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest3 WHERE id=5027265 | | 578 | mysql | localhost:51192 | dbtest | Execute | 0 | System lock | SELECT c FROM sbtest7 WHERE id=5044417 | | 579 | mysql | localhost:51194 | dbtest | Sleep | 0 | NULL | NULL | | 580 | mysql | localhost:51195 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest5 WHERE id=5024721 | | 581 | mysql | localhost:51196 | dbtest | Execute | 0 | checking permissions | SELECT c FROM sbtest5 WHERE id=4996662 | | 582 | mysql | localhost:51197 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest3 WHERE id=5964377 | | 583 | mysql | localhost:51198 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest7 WHERE id=4995425 | | 584 | mysql | localhost:51200 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest2 WHERE id=6110711 | | 585 | mysql | localhost:51199 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest1 WHERE id=5040007 | | 586 | mysql | localhost:51201 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest2 WHERE id=5035717 | | 587 | mysql | localhost:51202 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest5 WHERE id=4977286 | | 588 | mysql | localhost:51204 | dbtest | Sleep | 0 | | NULL | | 589 | mysql | localhost:51203 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest8 WHERE id=4997319 | | 590 | mysql | localhost:51205 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest6 WHERE id=4993679 | | 591 | mysql | localhost:51206 | dbtest | Execute | 0 | statistics | SELECT c FROM sbtest4 WHERE id=2547416 | | 592 | mysql | localhost:51207 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest8 WHERE id=5619934 | | 593 | mysql | localhost:51208 | dbtest | Execute | 0 | statistics | SELECT c FROM sbtest4 WHERE id=2811314 | | 594 | mysql | localhost:51209 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest5 WHERE id=5014970 | | 595 | mysql | localhost:51210 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest4 WHERE id=4986305 | | 596 | mysql | localhost:51211 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest6 WHERE id=5029764 | | 597 | mysql | localhost:51212 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest3 WHERE id=5035651 | | 598 | mysql | localhost:51213 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest6 WHERE id=5004433 | | 599 | mysql | localhost:51214 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest3 WHERE id=4960533 | | 600 | mysql | localhost:51215 | dbtest | Execute | 0 | statistics | SELECT c FROM sbtest5 WHERE id=3538408 | | 601 | mysql | localhost:51217 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest4 WHERE id=4977576 | | 602 | mysql | localhost:51218 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest8 WHERE id=4174817 | | 603 | mysql | localhost:51219 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest2 WHERE id=4978137 | | 604 | mysql | localhost:51220 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest6 WHERE id=5016835 | | 605 | mysql | localhost:51221 | dbtest | Execute | 0 | closing tables | SELECT c FROM sbtest3 WHERE id=4980083 | | 606 | mysql | localhost:51222 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest7 WHERE id=5036341 | | 607 | mysql | localhost:51223 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest8 WHERE id=4888537 | | 608 | mysql | localhost:51225 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest3 WHERE id=5021148 | | 609 | mysql | localhost:51224 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest4 WHERE id=4987455 | | 610 | mysql | localhost:51226 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest1 WHERE id=5026649 | | 611 | mysql | localhost:51228 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest5 WHERE id=5009671 | | 612 | mysql | localhost:51227 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest4 WHERE id=4982430 | | 613 | mysql | localhost:51230 | dbtest | Execute | 0 | Sending data | SELECT c FROM sbtest5 WHERE id=4995420 | | 614 | mysql | localhost:51229 | dbtest | Execute | 0 | Opening tables | SELECT c FROM sbtest7 WHERE id=5010175 | | 615 | mysql | localhost:51231 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest5 WHERE id=3987436 | | 616 | mysql | localhost:51232 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest5 WHERE id=5016329 | | 617 | mysql | localhost:51234 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest5 WHERE id=4993748 | | 618 | mysql | localhost:51233 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest2 WHERE id=5042614 | | 619 | mysql | localhost:51235 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest5 WHERE id=4640405 | | 620 | mysql | localhost:51236 | dbtest | Execute | 0 | statistics | SELECT c FROM sbtest6 WHERE id=5004710 | | 621 | mysql | localhost:51237 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest7 WHERE id=5000395 | | 622 | mysql | localhost:51238 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest6 WHERE id=4605534 | | 623 | mysql | localhost:51240 | dbtest | Execute | 0 | statistics | SELECT c FROM sbtest1 WHERE id=5030737 | | 624 | mysql | localhost:51239 | dbtest | Execute | 0 | statistics | SELECT c FROM sbtest6 WHERE id=4520140 | | 625 | mysql | localhost:51241 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest8 WHERE id=4982432 | | 626 | mysql | localhost:51242 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest4 WHERE id=4984478 | | 627 | mysql | localhost:51243 | dbtest | Execute | 0 | statistics | SELECT c FROM sbtest7 WHERE id=5979089 | | 628 | mysql | localhost:51244 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest7 WHERE id=5023400 | | 629 | mysql | localhost:51245 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest3 WHERE id=5036417 | | 630 | mysql | localhost:51246 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest3 WHERE id=4986010 | | 631 | mysql | localhost:51247 | dbtest | Sleep | 0 | | NULL | | 632 | mysql | localhost:51249 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest2 WHERE id=4988452 | | 633 | mysql | localhost:51248 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest8 WHERE id=4323427 | | 634 | mysql | localhost:51250 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest3 WHERE id=5009014 | | 635 | mysql | localhost:51251 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest7 WHERE id=5031584 | | 636 | mysql | localhost:51252 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest4 WHERE id=5022086 | | 637 | mysql | localhost:51253 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest1 WHERE id=5040131 | | 638 | mysql | localhost:51254 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest4 WHERE id=5045309 | | 639 | mysql | localhost:51255 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest7 WHERE id=7209240 | | 640 | mysql | localhost:51256 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest8 WHERE id=5040256 | | 641 | mysql | localhost:51257 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest8 WHERE id=5042869 | | 642 | mysql | localhost:51258 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest7 WHERE id=5008966 | | 643 | mysql | localhost:51259 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest7 WHERE id=5049671 | | 644 | mysql | localhost:51260 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest4 WHERE id=5030887 | | 645 | mysql | localhost:51261 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest5 WHERE id=5028632 | | 646 | mysql | localhost:51262 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest2 WHERE id=5713470 | | 647 | mysql | localhost:51265 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest2 WHERE id=5040197 | | 648 | mysql | localhost:51263 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest4 WHERE id=5026576 | | 649 | mysql | localhost:51266 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest8 WHERE id=5040804 | | 650 | mysql | localhost:51267 | dbtest | Execute | 0 | starting | SELECT c FROM sbtest1 WHERE id=5031467 | | 651 | mysql | localhost:51269 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest2 WHERE id=5049086 | | 652 | mysql | localhost:51271 | dbtest | Execute | 0 | statistics | SELECT c FROM sbtest3 WHERE id=5028018 | | 653 | mysql | localhost:51268 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest2 WHERE id=4913822 | | 654 | mysql | localhost:51270 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest4 WHERE id=5033776 | | 655 | mysql | localhost:51273 | dbtest | Execute | 0 | preparing | SELECT c FROM sbtest4 WHERE id=4980892 | | 656 | mysql | localhost:51274 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest3 WHERE id=5041382 | | 657 | mysql | localhost:51272 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest8 WHERE id=5033345 | | 658 | mysql | localhost:51275 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest5 WHERE id=5046990 | | 659 | mysql | localhost:51276 | dbtest | Execute | 0 | statistics | SELECT c FROM sbtest4 WHERE id=5293837 | | 660 | mysql | localhost:51278 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest2 WHERE id=4992040 | | 661 | mysql | localhost:51279 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest1 WHERE id=4789923 | | 662 | mysql | localhost:51277 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest4 WHERE id=5044831 | | 663 | mysql | localhost:51280 | dbtest | Execute | 0 | statistics | SELECT c FROM sbtest1 WHERE id=2957052 | | 664 | mysql | localhost:51282 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest2 WHERE id=4987798 | | 665 | mysql | localhost:51284 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest2 WHERE id=5033514 | | 666 | mysql | localhost:51281 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest8 WHERE id=5012720 | | 667 | mysql | localhost:51286 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest1 WHERE id=2976215 | | 668 | mysql | localhost:51285 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest5 WHERE id=5007506 | | 669 | mysql | localhost:51287 | dbtest | Execute | 0 | statistics | SELECT c FROM sbtest7 WHERE id=3354900 | | 670 | mysql | localhost:51283 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest2 WHERE id=5202751 | | 671 | mysql | localhost:51290 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest7 WHERE id=5180961 | | 672 | mysql | localhost:51291 | dbtest | Execute | 0 | statistics | SELECT c FROM sbtest8 WHERE id=5003144 | | 673 | mysql | localhost:51294 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest7 WHERE id=4975654 | | 674 | mysql | localhost:51293 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest2 WHERE id=4997268 | | 675 | mysql | localhost:51292 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest4 WHERE id=4999523 | | 676 | mysql | localhost:51295 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest5 WHERE id=4975461 | | 677 | mysql | localhost:51296 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest4 WHERE id=4853382 | | 678 | mysql | localhost:51298 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest6 WHERE id=5037363 | | 679 | mysql | localhost:51297 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest4 WHERE id=5149171 | | 680 | mysql | localhost:51299 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest1 WHERE id=5034984 | | 681 | mysql | localhost:51300 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest4 WHERE id=5941868 | | 682 | mysql | localhost:51301 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest7 WHERE id=5006503 | | 683 | mysql | localhost:51302 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest1 WHERE id=4989778 | | 684 | mysql | localhost:51303 | dbtest | Execute | 0 | statistics | SELECT c FROM sbtest7 WHERE id=2816497 | | 685 | mysql | localhost:51305 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest5 WHERE id=5002038 | | 686 | mysql | localhost:51306 | dbtest | Sleep | 0 | | NULL | | 687 | mysql | localhost:51307 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest7 WHERE id=5022369 | | 688 | mysql | localhost:51308 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest6 WHERE id=5045934 | | 689 | mysql | localhost:51309 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest5 WHERE id=5008280 | | 690 | mysql | localhost:51310 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest6 WHERE id=4981350 | | 691 | mysql | localhost:51311 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest7 WHERE id=5040844 | | 692 | mysql | localhost:51312 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest4 WHERE id=5002927 | | 693 | mysql | localhost:51314 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest4 WHERE id=5313842 | | 694 | mysql | localhost:51313 | dbtest | Execute | 0 | Opening tables | SELECT c FROM sbtest7 WHERE id=5001115 | | 695 | mysql | localhost:51317 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest1 WHERE id=5036554 | | 696 | mysql | localhost:51316 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest6 WHERE id=5366778 | | 697 | mysql | localhost:51318 | dbtest | Execute | 0 | System lock | SELECT c FROM sbtest2 WHERE id=4984293 | | 698 | mysql | localhost:51315 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest1 WHERE id=4975804 | | 699 | mysql | localhost:51319 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest2 WHERE id=4781170 | | 700 | mysql | localhost:51320 | dbtest | Execute | 0 | statistics | SELECT c FROM sbtest7 WHERE id=5030337 | | 701 | mysql | localhost:51321 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest1 WHERE id=5386475 | | 702 | mysql | localhost:51322 | dbtest | Execute | 0 | Sending to client | SELECT c FROM sbtest4 WHERE id=4997156 | +-----+-----------------+-----------------+--------+---------+------+------------------------+----------------------------------------+ -------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 4. observing innodb status mysql> show engine innodb status \G *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2018-09-25 19:56:26 0x7fe55369b700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 1 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 1445 srv_idle srv_master_thread log flush and writes: 0 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 13155 OS WAIT ARRAY INFO: signal count 63187 RW-shared spins 14581, rounds 17479, OS waits 2879 RW-excl spins 10143, rounds 131436, OS waits 2303 RW-sx spins 0, rounds 0, OS waits 0 Spin rounds per wait: 1.20 RW-shared, 12.96 RW-excl, 0.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 33533 Purge done for trx's n:o < 33286 undo n:o < 0 state: running but idle History list length 5 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 422099341324232, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422099341323312, not started ... 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422099341325152, not started 0 lock struct(s), heap size 1136, 0 row lock(s) -------- 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 21 state: waiting for completed aio requests (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0, 0, 0, 0, 0, 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 829089 OS file reads, 312 OS file writes, 31 OS fsyncs 3 pending preads, 0 pending pwrites 555.44 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 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 12750011, node heap has 10906 buffer(s) Hash table size 12750011, node heap has 5453 buffer(s) Hash table size 12750011, node heap has 3 buffer(s) Hash table size 12750011, node heap has 10904 buffer(s) Hash table size 12750011, node heap has 0 buffer(s) Hash table size 12750011, node heap has 5451 buffer(s) Hash table size 12750011, node heap has 10904 buffer(s) Hash table size 12750011, node heap has 0 buffer(s) 428249.75 hash searches/s, 11863.14 non-hash searches/s --- LOG --- Log sequence number 21083961238 Log buffer assigned up to 21083961238 Log buffer completed up to 21083961238 Log written up to 21083961238 Log flushed up to 21083961238 Added dirty pages up to 21083961238 Pages flushed up to 21083961238 Last checkpoint at 21083961238 115 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 52772732928 Dictionary memory allocated 445227 Buffer pool size 3145728 Free buffers 2272654 Database pages 829453 Old database pages 306341 Modified db pages 0 Pending reads 3 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 829318, created 132, written 176 556.44 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: 829453, unzip_LRU len: 0 I/O sum[0]:cur[160], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 393216 Free buffers 283994 Database pages 103775 Old database pages 38327 Modified db pages 0 Pending reads 2 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 103773, created 0, written 2 59.94 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: 103775, unzip_LRU len: 0 I/O sum[0]:cur[20], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 393216 Free buffers 284094 Database pages 103663 Old database pages 38286 Modified db pages 0 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 103663, created 0, written 0 63.94 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: 103663, unzip_LRU len: 0 I/O sum[0]:cur[20], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 393216 Free buffers 284228 Database pages 103535 Old database pages 38238 Modified db pages 0 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 103535, created 0, written 1 64.94 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: 103535, unzip_LRU len: 0 I/O sum[0]:cur[20], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 393216 Free buffers 284015 Database pages 103744 Old database pages 38316 Modified db pages 0 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 103743, created 1, written 12 87.91 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: 103744, unzip_LRU len: 0 I/O sum[0]:cur[20], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 393216 Free buffers 284237 Database pages 103528 Old database pages 38236 Modified db pages 0 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 103528, created 0, written 1 69.93 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: 103528, unzip_LRU len: 0 I/O sum[0]:cur[20], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 393216 Free buffers 284214 Database pages 103547 Old database pages 38243 Modified db pages 0 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 103484, created 63, written 66 66.93 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: 103547, unzip_LRU len: 0 I/O sum[0]:cur[20], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 393216 Free buffers 283948 Database pages 103820 Old database pages 38344 Modified db pages 0 Pending reads 1 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 103755, created 64, written 76 80.92 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: 103820, unzip_LRU len: 0 I/O sum[0]:cur[20], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 393216 Free buffers 283924 Database pages 103841 Old database pages 38351 Modified db pages 0 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 103837, created 4, written 18 61.94 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: 103841, unzip_LRU len: 0 I/O sum[0]:cur[20], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 8 read views open inside InnoDB Process ID=4808, Main thread ID=140601427085056 , state=sleeping Number of rows inserted 0, updated 313, deleted 0, read 49506785 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 528066.93 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================