=====================================
2014-03-21 05:16:10 7f7b3c53e700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 26 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 1078942 srv_active, 0 srv_shutdown, 156604 srv_idle
srv_master_thread log flush and writes: 1235546
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 927606
OS WAIT ARRAY INFO: signal count 3651330
Mutex spin waits 10781275, rounds 11622780, OS waits 176878
RW-shared spins 1514976, rounds 21834527, OS waits 579515
RW-excl spins 163065, rounds 10526942, OS waits 155564
Spin rounds per wait: 1.08 mutex, 14.41 RW-shared, 64.56 RW-excl
------------
TRANSACTIONS
------------
Trx id counter 119086609
Purge done for trx's n:o < 119086584 undo n:o < 0 state: running but idle
History list length 1215
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started
MySQL thread id 23798, OS thread handle 0x7f7b3c53e700, query id 690212130 localhost ::1 pd-readonly init
show ENGINE innodb status
---TRANSACTION 118461873, not started
MySQL thread id 281, OS thread handle 0x7f7b3c6c4700, query id 690154958 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461875, not started
MySQL thread id 280, OS thread handle 0x7f7b3c705700, query id 690154956 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118711907, not started
MySQL thread id 279, OS thread handle 0x7f7b3c746700, query id 690154685 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118462119, not started
MySQL thread id 278, OS thread handle 0x7f7b3c787700, query id 690154832 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119019149, not started
MySQL thread id 277, OS thread handle 0x7f7b3c7c8700, query id 690154667 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710572, not started
MySQL thread id 276, OS thread handle 0x7f7b3c809700, query id 690154796 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461903, not started
MySQL thread id 272, OS thread handle 0x7f7b3c90d700, query id 690154906 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710527, not started
MySQL thread id 274, OS thread handle 0x7f7b3c88b700, query id 690154788 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461874, not started
MySQL thread id 275, OS thread handle 0x7f7b3c84a700, query id 690154943 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118462065, not started
MySQL thread id 271, OS thread handle 0x7f7b3c94e700, query id 690154845 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119019153, not started
MySQL thread id 273, OS thread handle 0x7f7b3c8cc700, query id 690154663 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461916, not started
MySQL thread id 269, OS thread handle 0x7f7b3c9d0700, query id 690154864 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710555, not started
MySQL thread id 270, OS thread handle 0x7f7b3c98f700, query id 690154749 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118452433, not started
MySQL thread id 267, OS thread handle 0x7f7b3ca52700, query id 690154986 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710650, not started
MySQL thread id 266, OS thread handle 0x7f7b3ca93700, query id 690154727 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710683, not started
MySQL thread id 268, OS thread handle 0x7f7b3ca11700, query id 690154721 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461847, not started
MySQL thread id 264, OS thread handle 0x7f7b3cb15700, query id 690154953 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710363, not started
MySQL thread id 265, OS thread handle 0x7f7b3cad4700, query id 690154771 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119086599, not started
MySQL thread id 263, OS thread handle 0x7f7b3cb56700, query id 690212088 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461870, not started
MySQL thread id 261, OS thread handle 0x7f7b3cbd8700, query id 690154898 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461762, not started
MySQL thread id 262, OS thread handle 0x7f7b3cb97700, query id 690154972 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710586, not started
MySQL thread id 260, OS thread handle 0x7f7b3cc19700, query id 690154757 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118711827, not started
MySQL thread id 257, OS thread handle 0x7f7b3ccdc700, query id 690154699 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710560, not started
MySQL thread id 259, OS thread handle 0x7f7b3cc5a700, query id 690154818 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710585, not started
MySQL thread id 256, OS thread handle 0x7f7b3cd1d700, query id 690154766 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461888, not started
MySQL thread id 258, OS thread handle 0x7f7b3cc9b700, query id 690154911 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119019143, not started
MySQL thread id 252, OS thread handle 0x7f7b3ce21700, query id 690154677 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710686, not started
MySQL thread id 255, OS thread handle 0x7f7b3cd5e700, query id 690154717 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119079982, not started
MySQL thread id 254, OS thread handle 0x7f7b3cd9f700, query id 690154674 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118452439, not started
MySQL thread id 253, OS thread handle 0x7f7b3cde0700, query id 690154985 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118711822, not started
MySQL thread id 250, OS thread handle 0x7f7b3cea3700, query id 690154703 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461837, not started
MySQL thread id 251, OS thread handle 0x7f7b3ce62700, query id 690154969 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710542, not started
MySQL thread id 248, OS thread handle 0x7f7b3cf25700, query id 690154803 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119079988, not started
MySQL thread id 217, OS thread handle 0x7f7b3d704700, query id 690154777 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461878, not started
MySQL thread id 247, OS thread handle 0x7f7b3cf66700, query id 690154944 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118711918, not started
MySQL thread id 249, OS thread handle 0x7f7b3cee4700, query id 690154683 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118711811, not started
MySQL thread id 244, OS thread handle 0x7f7b3d029700, query id 690154698 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119019151, not started
MySQL thread id 245, OS thread handle 0x7f7b3cfe8700, query id 690154665 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118463807, not started
MySQL thread id 246, OS thread handle 0x7f7b3cfa7700, query id 690154821 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461900, not started
MySQL thread id 243, OS thread handle 0x7f7b3d06a700, query id 690154881 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119079986, not started
MySQL thread id 242, OS thread handle 0x7f7b3d0ab700, query id 690154740 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710594, not started
MySQL thread id 239, OS thread handle 0x7f7b3d16e700, query id 690154736 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118462121, not started
MySQL thread id 241, OS thread handle 0x7f7b3d0ec700, query id 690154833 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710518, not started
MySQL thread id 240, OS thread handle 0x7f7b3d12d700, query id 690154802 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118709225, not started
MySQL thread id 238, OS thread handle 0x7f7b3d1af700, query id 690154820 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119079984, not started
MySQL thread id 237, OS thread handle 0x7f7b3d1f0700, query id 690154706 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710857, not started
MySQL thread id 235, OS thread handle 0x7f7b3d272700, query id 690154711 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118462113, not started
MySQL thread id 236, OS thread handle 0x7f7b3d231700, query id 690154849 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461920, not started
MySQL thread id 233, OS thread handle 0x7f7b3d2f4700, query id 690154873 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461889, not started
MySQL thread id 234, OS thread handle 0x7f7b3d2b3700, query id 690154926 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710573, not started
MySQL thread id 232, OS thread handle 0x7f7b3d335700, query id 690154789 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710502, not started
MySQL thread id 231, OS thread handle 0x7f7b3d376700, query id 690154813 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461899, not started
MySQL thread id 228, OS thread handle 0x7f7b3d439700, query id 690154908 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461864, not started
MySQL thread id 230, OS thread handle 0x7f7b3d3b7700, query id 690154875 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118462118, not started
MySQL thread id 229, OS thread handle 0x7f7b3d3f8700, query id 690154846 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710882, not started
MySQL thread id 226, OS thread handle 0x7f7b3d4bb700, query id 690154714 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118462110, not started
MySQL thread id 227, OS thread handle 0x7f7b3d47a700, query id 690154861 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461877, not started
MySQL thread id 225, OS thread handle 0x7f7b3d4fc700, query id 690154952 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461887, not started
MySQL thread id 223, OS thread handle 0x7f7b3d57e700, query id 690154927 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710571, not started
MySQL thread id 224, OS thread handle 0x7f7b3d53d700, query id 690154797 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119085894, not started
MySQL thread id 221, OS thread handle 0x7f7b3d600700, query id 690205755 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118711925, not started
MySQL thread id 222, OS thread handle 0x7f7b3d5bf700, query id 690154682 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461902, not started
MySQL thread id 220, OS thread handle 0x7f7b3d641700, query id 690154901 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710589, not started
MySQL thread id 219, OS thread handle 0x7f7b3d682700, query id 690154745 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710503, not started
MySQL thread id 216, OS thread handle 0x7f7b3d745700, query id 690154817 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461893, not started
MySQL thread id 218, OS thread handle 0x7f7b3d6c3700, query id 690154922 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119085916, not started
MySQL thread id 214, OS thread handle 0x7f7b3d7c7700, query id 690205971 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118711896, not started
MySQL thread id 215, OS thread handle 0x7f7b3d786700, query id 690154695 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461791, not started
MySQL thread id 207, OS thread handle 0x7f7b3d98e700, query id 690154970 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461912, not started
MySQL thread id 212, OS thread handle 0x7f7b3d849700, query id 690154880 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710590, not started
MySQL thread id 213, OS thread handle 0x7f7b3d808700, query id 690154746 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461879, not started
MySQL thread id 210, OS thread handle 0x7f7b3d8cb700, query id 690154950 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461846, not started
MySQL thread id 211, OS thread handle 0x7f7b3d88a700, query id 690154978 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461871, not started
MySQL thread id 208, OS thread handle 0x7f7b3d94d700, query id 690154954 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710688, not started
MySQL thread id 209, OS thread handle 0x7f7b3d90c700, query id 690154716 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710565, not started
MySQL thread id 206, OS thread handle 0x7f7b3d9cf700, query id 690154806 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710566, not started
MySQL thread id 205, OS thread handle 0x7f7b3da10700, query id 690154804 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119019150, not started
MySQL thread id 204, OS thread handle 0x7f7b3da51700, query id 690154666 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710578, not started
MySQL thread id 203, OS thread handle 0x7f7b3da92700, query id 690154782 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119019147, not started
MySQL thread id 201, OS thread handle 0x7f7b3db14700, query id 690154671 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461907, not started
MySQL thread id 202, OS thread handle 0x7f7b3dad3700, query id 690154894 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118462721, not started
MySQL thread id 200, OS thread handle 0x7f7b3db55700, query id 690154828 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461915, not started
MySQL thread id 192, OS thread handle 0x7f7b3dd5d700, query id 690154874 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710592, not started
MySQL thread id 198, OS thread handle 0x7f7b3dbd7700, query id 690154738 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710584, not started
MySQL thread id 199, OS thread handle 0x7f7b3db96700, query id 690154719 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119080984, not started
MySQL thread id 197, OS thread handle 0x7f7b3dc18700, query id 690163709 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461865, not started
MySQL thread id 195, OS thread handle 0x7f7b3dc9a700, query id 690154973 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119083445, not started
MySQL thread id 196, OS thread handle 0x7f7b3dc59700, query id 690184000 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710562, not started
MySQL thread id 194, OS thread handle 0x7f7b3dcdb700, query id 690154816 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118711915, not started
MySQL thread id 189, OS thread handle 0x7f7b3de20700, query id 690154693 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118711913, not started
MySQL thread id 193, OS thread handle 0x7f7b3dd1c700, query id 690154697 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119086603, not started
MySQL thread id 190, OS thread handle 0x7f7b3dddf700, query id 690212042 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118711824, not started
MySQL thread id 191, OS thread handle 0x7f7b3dd9e700, query id 690154702 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118462103, not started
MySQL thread id 187, OS thread handle 0x7f7b3dea2700, query id 690154850 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461838, not started
MySQL thread id 186, OS thread handle 0x7f7b3dee3700, query id 690154936 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461898, not started
MySQL thread id 188, OS thread handle 0x7f7b3de61700, query id 690154910 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710564, not started
MySQL thread id 183, OS thread handle 0x7f7b3dfa6700, query id 690154812 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118452438, not started
MySQL thread id 185, OS thread handle 0x7f7b3df24700, query id 690154987 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710581, not started
MySQL thread id 184, OS thread handle 0x7f7b3df65700, query id 690154781 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461908, not started
MySQL thread id 181, OS thread handle 0x7f7b3e028700, query id 690154879 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461885, not started
MySQL thread id 182, OS thread handle 0x7f7b3dfe7700, query id 690154902 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461905, not started
MySQL thread id 178, OS thread handle 0x7f7b3e0eb700, query id 690154892 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461892, not started
MySQL thread id 180, OS thread handle 0x7f7b3e069700, query id 690154924 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118711919, not started
MySQL thread id 179, OS thread handle 0x7f7b3e0aa700, query id 690154694 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710582, not started
MySQL thread id 176, OS thread handle 0x7f7b3e16d700, query id 690154778 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119019146, not started
MySQL thread id 177, OS thread handle 0x7f7b3e12c700, query id 690154668 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710557, not started
MySQL thread id 175, OS thread handle 0x7f7b3e1ae700, query id 690154750 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118711921, not started
MySQL thread id 174, OS thread handle 0x7f7b3e1ef700, query id 690154681 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119019145, not started
MySQL thread id 172, OS thread handle 0x7f7b3e271700, query id 690154678 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119079981, not started
MySQL thread id 173, OS thread handle 0x7f7b3e230700, query id 690154658 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461914, not started
MySQL thread id 170, OS thread handle 0x7f7b3e2f3700, query id 690154877 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119079985, not started
MySQL thread id 168, OS thread handle 0x7f7b3e375700, query id 690154723 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119085250, not started
MySQL thread id 171, OS thread handle 0x7f7b3e2b2700, query id 690200248 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461884, not started
MySQL thread id 165, OS thread handle 0x7f7b3e438700, query id 690154935 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461809, not started
MySQL thread id 169, OS thread handle 0x7f7b3e334700, query id 690154934 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710568, not started
MySQL thread id 167, OS thread handle 0x7f7b3e3b6700, query id 690154801 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710574, not started
MySQL thread id 166, OS thread handle 0x7f7b3e3f7700, query id 690154787 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461906, not started
MySQL thread id 162, OS thread handle 0x7f7b3e4fb700, query id 690154878 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118462109, not started
MySQL thread id 164, OS thread handle 0x7f7b3e479700, query id 690154855 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710888, not started
MySQL thread id 161, OS thread handle 0x7f7b3e53c700, query id 690154708 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461923, not started
MySQL thread id 163, OS thread handle 0x7f7b3e4ba700, query id 690154865 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118462115, not started
MySQL thread id 160, OS thread handle 0x7f7b3e57d700, query id 690154847 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461880, not started
MySQL thread id 95, OS thread handle 0x7f7b3e681700, query id 690154918 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710550, not started
MySQL thread id 93, OS thread handle 0x7f7b3e703700, query id 690154770 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710532, not started
MySQL thread id 98, OS thread handle 0x7f7b3e5be700, query id 690154756 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118462120, not started
MySQL thread id 97, OS thread handle 0x7f7b3e5ff700, query id 690154834 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710567, not started
MySQL thread id 96, OS thread handle 0x7f7b3e640700, query id 690154765 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461890, not started
MySQL thread id 94, OS thread handle 0x7f7b3e6c2700, query id 690154923 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119086067, not started
MySQL thread id 91, OS thread handle 0x7f7b3e785700, query id 690207408 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118462116, not started
MySQL thread id 92, OS thread handle 0x7f7b3e744700, query id 690154830 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461881, not started
MySQL thread id 89, OS thread handle 0x7f7b3e807700, query id 690154939 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119019148, not started
MySQL thread id 90, OS thread handle 0x7f7b3e7c6700, query id 690154669 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710883, not started
MySQL thread id 86, OS thread handle 0x7f7b3e8ca700, query id 690154710 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118463825, not started
MySQL thread id 85, OS thread handle 0x7f7b3e90b700, query id 690154823 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461910, not started
MySQL thread id 88, OS thread handle 0x7f7b3e848700, query id 690154866 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461876, not started
MySQL thread id 87, OS thread handle 0x7f7b3e889700, query id 690154955 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461883, not started
MySQL thread id 84, OS thread handle 0x7f7b3e94c700, query id 690154938 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710521, not started
MySQL thread id 83, OS thread handle 0x7f7b3e98d700, query id 690154759 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710628, not started
MySQL thread id 82, OS thread handle 0x7f7b3e9ce700, query id 690154729 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710569, not started
MySQL thread id 81, OS thread handle 0x7f7b3ea0f700, query id 690154800 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461901, not started
MySQL thread id 79, OS thread handle 0x7f7b3ea91700, query id 690154891 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461896, not started
MySQL thread id 78, OS thread handle 0x7f7b3ead2700, query id 690154909 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710877, not started
MySQL thread id 80, OS thread handle 0x7f7b3ea50700, query id 690154713 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461891, not started
MySQL thread id 77, OS thread handle 0x7f7b3eb13700, query id 690154925 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118711920, not started
MySQL thread id 76, OS thread handle 0x7f7b3eb54700, query id 690154687 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118462111, not started
MySQL thread id 75, OS thread handle 0x7f7b3eb95700, query id 690154854 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118711823, not started
MySQL thread id 74, OS thread handle 0x7f7b3ebd6700, query id 690154700 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118462108, not started
MySQL thread id 73, OS thread handle 0x7f7b3ec17700, query id 690154835 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461763, not started
MySQL thread id 72, OS thread handle 0x7f7b3ec58700, query id 690154941 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710577, not started
MySQL thread id 71, OS thread handle 0x7f7b3ec99700, query id 690154784 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461925, not started
MySQL thread id 70, OS thread handle 0x7f7b3ecda700, query id 690154862 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710591, not started
MySQL thread id 68, OS thread handle 0x7f7b3ed5c700, query id 690154744 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461904, not started
MySQL thread id 69, OS thread handle 0x7f7b3ed1b700, query id 690154895 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710192, not started
MySQL thread id 67, OS thread handle 0x7f7b3ed9d700, query id 690154772 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461909, not started
MySQL thread id 66, OS thread handle 0x7f7b3edde700, query id 690154889 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119080985, not started
MySQL thread id 65, OS thread handle 0x7f7b3ee1f700, query id 690163716 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119086608, not started
MySQL thread id 63, OS thread handle 0x7f7b3eea1700, query id 690212127 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461866, not started
MySQL thread id 61, OS thread handle 0x7f7b3ef23700, query id 690154967 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461897, not started
MySQL thread id 64, OS thread handle 0x7f7b3ee60700, query id 690154916 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461886, not started
MySQL thread id 62, OS thread handle 0x7f7b3eee2700, query id 690154883 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710597, not started
MySQL thread id 60, OS thread handle 0x7f7b3ef64700, query id 690154731 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461872, not started
MySQL thread id 57, OS thread handle 0x7f7b3f027700, query id 690154959 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461868, not started
MySQL thread id 58, OS thread handle 0x7f7b3efe6700, query id 690154960 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119079983, not started
MySQL thread id 59, OS thread handle 0x7f7b3efa5700, query id 690154690 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119086091, not started
MySQL thread id 56, OS thread handle 0x7f7b3f068700, query id 690207683 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710595, not started
MySQL thread id 55, OS thread handle 0x7f7b3f0a9700, query id 690154732 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461849, not started
MySQL thread id 54, OS thread handle 0x7f7b3f0ea700, query id 690154975 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118462112, not started
MySQL thread id 53, OS thread handle 0x7f7b3f12b700, query id 690154839 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710587, not started
MySQL thread id 51, OS thread handle 0x7f7b3f1ad700, query id 690154748 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119079987, not started
MySQL thread id 52, OS thread handle 0x7f7b3f16c700, query id 690154760 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119080975, not started
MySQL thread id 49, OS thread handle 0x7f7b3f22f700, query id 690163641 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710575, not started
MySQL thread id 48, OS thread handle 0x7f7b3f270700, query id 690154786 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710593, not started
MySQL thread id 50, OS thread handle 0x7f7b3f1ee700, query id 690154737 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461894, not started
MySQL thread id 47, OS thread handle 0x7f7b3f2b1700, query id 690154920 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119079989, not started
MySQL thread id 46, OS thread handle 0x7f7b3f2f2700, query id 690154793 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118711927, not started
MySQL thread id 44, OS thread handle 0x7f7b3f374700, query id 690154680 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461831, not started
MySQL thread id 43, OS thread handle 0x7f7b3f3b5700, query id 690154940 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710629, not started
MySQL thread id 45, OS thread handle 0x7f7b3f333700, query id 690154726 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710570, not started
MySQL thread id 42, OS thread handle 0x7f7b3f3f6700, query id 690154798 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118462106, not started
MySQL thread id 41, OS thread handle 0x7f7b3f437700, query id 690154837 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461858, not started
MySQL thread id 39, OS thread handle 0x7f7b3f4b9700, query id 690154907 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118462114, not started
MySQL thread id 40, OS thread handle 0x7f7b3f478700, query id 690154848 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710689, not started
MySQL thread id 37, OS thread handle 0x7f7b3f53b700, query id 690154715 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461783, not started
MySQL thread id 38, OS thread handle 0x7f7b3f4fa700, query id 690154971 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119085890, not started
MySQL thread id 36, OS thread handle 0x7f7b3f57c700, query id 690205719 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710626, not started
MySQL thread id 35, OS thread handle 0x7f7b3f5bd700, query id 690154730 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461911, not started
MySQL thread id 34, OS thread handle 0x7f7b3f5fe700, query id 690154893 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710579, not started
MySQL thread id 32, OS thread handle 0x7f7b44099700, query id 690154767 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118711917, not started
MySQL thread id 33, OS thread handle 0x7f7b44058700, query id 690154684 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119079980, not started
MySQL thread id 31, OS thread handle 0x7f7b440da700, query id 690154642 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461869, not started
MySQL thread id 20, OS thread handle 0x7f7bb4080700, query id 690154863 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461867, not started
MySQL thread id 22, OS thread handle 0x7f7b4411b700, query id 690154968 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118462124, not started
MySQL thread id 25, OS thread handle 0x7f7b4419d700, query id 690154831 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118462091, not started
MySQL thread id 27, OS thread handle 0x7f7b441de700, query id 690154856 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119079979, not started
MySQL thread id 26, OS thread handle 0x7f7b44260700, query id 690154626 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 119085251, not started
MySQL thread id 28, OS thread handle 0x7f7b4421f700, query id 690200241 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710576, not started
MySQL thread id 29, OS thread handle 0x7f7b442e2700, query id 690154785 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461832, not started
MySQL thread id 24, OS thread handle 0x7f7b4415c700, query id 690154984 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118461863, not started
MySQL thread id 23, OS thread handle 0x7f7bb40c1700, query id 690154982 localhost 127.0.0.1 pd4 cleaning up
---TRANSACTION 118710498, not started
MySQL thread id 21, OS thread handle 0x7f7b442a1700, query id 690154814 localhost 127.0.0.1 pd4 cleaning up
--------
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 (write thread)
I/O thread 7 state: waiting for completed aio requests (write thread)
I/O thread 8 state: waiting for completed aio requests (write thread)
I/O thread 9 state: waiting for completed aio requests (write thread)
Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 0
8144857 OS file reads, 9515908 OS file writes, 2924954 OS fsyncs
3.73 reads/s, 16384 avg bytes/read, 7.46 writes/s, 0.92 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 20721, seg size 20723, 589630 merges
merged operations:
insert 1026816, delete mark 351138, delete 108511
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 2365241, node heap has 7543 buffer(s)
454627.17 hash searches/s, 42349.33 non-hash searches/s
---
LOG
---
Log sequence number 41241814085
Log flushed up to 41241814085
Pages flushed up to 41235822320
Last checkpoint at 41235822320
0 pending log writes, 0 pending chkp writes
3370051 log i/o's done, 7.46 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 1098907648; in additional pool allocated 0
Dictionary memory allocated 1319365
Buffer pool size 65528
Free buffers 8193
Database pages 49792
Old database pages 18216
Modified db pages 2751
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 48934858, not young 431146861
42.23 youngs/s, 40.38 non-youngs/s
Pages read 8144697, created 110646, written 5732549
3.73 reads/s, 0.15 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: 49792, unzip_LRU len: 0
I/O sum[1824]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size 8191
Free buffers 1024
Database pages 6237
Old database pages 2282
Modified db pages 539
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 5611591, not young 47314706
4.42 youngs/s, 4.31 non-youngs/s
Pages read 945827, created 19345, written 975773
0.62 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: 6237, unzip_LRU len: 0
I/O sum[228]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size 8191
Free buffers 1024
Database pages 6222
Old database pages 2276
Modified db pages 195
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 3345838, not young 34290293
18.15 youngs/s, 2.46 non-youngs/s
Pages read 701285, created 9876, written 486257
0.31 reads/s, 0.08 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: 6222, unzip_LRU len: 0
I/O sum[228]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size 8191
Free buffers 1024
Database pages 6226
Old database pages 2278
Modified db pages 450
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 5592401, not young 43377145
3.08 youngs/s, 2.38 non-youngs/s
Pages read 965084, created 13477, written 740194
0.42 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: 6226, unzip_LRU len: 0
I/O sum[228]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size 8191
Free buffers 1024
Database pages 6227
Old database pages 2278
Modified db pages 429
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 10208091, not young 80712031
4.19 youngs/s, 4.27 non-youngs/s
Pages read 1390907, created 15835, written 810472
0.58 reads/s, 0.04 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: 6227, unzip_LRU len: 0
I/O sum[228]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size 8191
Free buffers 1025
Database pages 6218
Old database pages 2275
Modified db pages 331
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 6199462, not young 61268875
3.81 youngs/s, 13.92 non-youngs/s
Pages read 1099539, created 11459, written 825309
0.35 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: 6218, unzip_LRU len: 0
I/O sum[228]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size 8191
Free buffers 1024
Database pages 6218
Old database pages 2275
Modified db pages 253
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 6032180, not young 56325470
1.73 youngs/s, 7.88 non-youngs/s
Pages read 987240, created 12810, written 577256
0.77 reads/s, 0.04 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: 6218, unzip_LRU len: 0
I/O sum[228]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size 8191
Free buffers 1024
Database pages 6222
Old database pages 2276
Modified db pages 294
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 6337048, not young 56804505
3.65 youngs/s, 1.62 non-youngs/s
Pages read 1041737, created 13906, written 631445
0.31 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: 6222, unzip_LRU len: 0
I/O sum[228]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size 8191
Free buffers 1024
Database pages 6222
Old database pages 2276
Modified db pages 260
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 5608247, not young 51053836
3.19 youngs/s, 3.54 non-youngs/s
Pages read 1013078, created 13938, written 685843
0.38 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: 6222, unzip_LRU len: 0
I/O sum[228]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
Main thread process no. 829, id 140167454029568, state: sleeping
Number of rows inserted 5010091, updated 4718629, deleted 1214346, read 45230977962
8.23 inserts/s, 11.11 updates/s, 2.19 deletes/s, 526566.59 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================