mysql> show engine innodb status \G; *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2020-08-17 14:17:19 3a9738e6700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 25 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 335932 srv_active, 0 srv_shutdown, 4 srv_idle srv_master_thread log flush and writes: 335931 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3346548 OS WAIT ARRAY INFO: signal count 7468410 Mutex spin waits 107939000, rounds 341363480, OS waits 2688104 RW-shared spins 8729087, rounds 45861145, OS waits 441210 RW-excl spins 472092, rounds 14712783, OS waits 88736 Spin rounds per wait: 3.16 mutex, 5.25 RW-shared, 31.17 RW-excl ------------ TRANSACTIONS ------------ Trx id counter 24942012323 Purge done for trx's n:o < 24879562137 undo n:o < 0 state: running but idle History list length 25410112 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 24942011667, not started MySQL thread id 6758851, OS thread handle 0x3a971de7700, query id 107432791 confluence-u.linx.net 192.168.201.214 confluence ---TRANSACTION 0, not started MySQL thread id 6758634, OS thread handle 0x3a97392e700, query id 107426285 webapi1.linx.net 192.168.201.140 api_live_rw ---TRANSACTION 24942009196, not started MySQL thread id 6757352, OS thread handle 0x3a972434700, query id 107428498 jira-u.linx.net 192.168.201.215 jira_rw ---TRANSACTION 24942006960, not started MySQL thread id 6757353, OS thread handle 0x3a97ecd1700, query id 107424088 jira-u.linx.net 192.168.201.215 jira_rw ---TRANSACTION 24942007078, not started MySQL thread id 6757354, OS thread handle 0x3a972535700, query id 107423979 jira-u.linx.net 192.168.201.215 jira_rw ---TRANSACTION 24942001855, not started MySQL thread id 6757788, OS thread handle 0x3a9a4299700, query id 107413038 drive.linx.net 195.66.234.13 seahub ---TRANSACTION 0, not started MySQL thread id 6757785, OS thread handle 0x3a99f7ac700, query id 107413009 drive.linx.net 195.66.234.13 seahub ---TRANSACTION 24941996946, not started MySQL thread id 6757040, OS thread handle 0x3a99d47d700, query id 107404330 drive.linx.net 195.66.234.13 seahub ---TRANSACTION 24942011129, not started MySQL thread id 6755684, OS thread handle 0x3a97e92f700, query id 107432533 confluence-u.linx.net 192.168.201.214 confluence ---TRANSACTION 24942011124, not started MySQL thread id 6754614, OS thread handle 0x3a9ab577700, query id 107432534 confluence-u.linx.net 192.168.201.214 confluence ---TRANSACTION 24942011668, not started MySQL thread id 6752511, OS thread handle 0x3a97e6e3700, query id 107432792 confluence-u.linx.net 192.168.201.214 confluence ---TRANSACTION 0, not started MySQL thread id 6751613, OS thread handle 0x3a97e5fa700, query id 107244567 jira-u.linx.net 192.168.201.215 jira_rw ---TRANSACTION 24941999118, not started MySQL thread id 6751614, OS thread handle 0x3a9737b0700, query id 107407613 jira-u.linx.net 192.168.201.215 jira_rw ---TRANSACTION 24941997038, not started MySQL thread id 6751615, OS thread handle 0x3a99de1a700, query id 107404474 jira-u.linx.net 192.168.201.215 jira_rw ---TRANSACTION 24942004689, not started MySQL thread id 6747452, OS thread handle 0x3a972abc700, query id 107428461 confluence-u.linx.net 192.168.201.214 confluence ---TRANSACTION 0, not started MySQL thread id 6745609, OS thread handle 0x3a97eb4f700, query id 107036256 jira-u.linx.net 192.168.201.215 jira_rw ---TRANSACTION 24941918783, not started MySQL thread id 6745610, OS thread handle 0x3a972ccc700, query id 107196353 jira-u.linx.net 192.168.201.215 jira_rw ---TRANSACTION 24941897645, not started MySQL thread id 6745611, OS thread handle 0x3a972f49700, query id 107183002 jira-u.linx.net 192.168.201.215 jira_rw ---TRANSACTION 24941898262, not started MySQL thread id 6745945, OS thread handle 0x3a97e7fb700, query id 107139369 drive.linx.net 195.66.234.13 seahub ---TRANSACTION 0, not started MySQL thread id 6738450, OS thread handle 0x3a97e55b700, query id 106867348 jira-u.linx.net 192.168.201.215 jira_rw ---TRANSACTION 24941793632, not started MySQL thread id 6738451, OS thread handle 0x3a97e8ba700, query id 106999512 jira-u.linx.net 192.168.201.215 jira_rw ---TRANSACTION 24941842480, not started MySQL thread id 6738452, OS thread handle 0x3a972efb700, query id 107012216 jira-u.linx.net 192.168.201.215 jira_rw ---TRANSACTION 0, not started MySQL thread id 6728118, OS thread handle 0x3a9738e6700, query id 107433302 localhost recep init show engine innodb status ---TRANSACTION 24941771930, not started MySQL thread id 6734451, OS thread handle 0x3a97e11c700, query id 106841508 drive.linx.net 195.66.234.13 seahub ---TRANSACTION 0, not started MySQL thread id 6732349, OS thread handle 0x3a97fe2e700, query id 106764771 jira-u.linx.net 192.168.201.215 jira_rw ---TRANSACTION 24941774863, not started MySQL thread id 6732350, OS thread handle 0x3a97e2a3700, query id 106848092 jira-u.linx.net 192.168.201.215 jira_rw ---TRANSACTION 24941774870, not started MySQL thread id 6732351, OS thread handle 0x3a972c85700, query id 106848131 jira-u.linx.net 192.168.201.215 jira_rw ---TRANSACTION 24941723833, not started MySQL thread id 6724896, OS thread handle 0x3a97341c700, query id 106747459 jira-u.linx.net 192.168.201.215 jira_rw ---TRANSACTION 24941721692, not started MySQL thread id 6724897, OS thread handle 0x3a97e419700, query id 106744323 jira-u.linx.net 192.168.201.215 jira_rw ---TRANSACTION 24942012260, not started MySQL thread id 6698013, OS thread handle 0x3a97ee62700, query id 107433143 captain.ngd.linx.net 192.168.51.50 flowmon_car1_rw ---TRANSACTION 0, not started MySQL thread id 6660303, OS thread handle 0x3a97e007700, query id 107414029 confluence-u.linx.net 192.168.201.214 confluence ---TRANSACTION 24941364107, not started MySQL thread id 6612897, OS thread handle 0x3a9730ce700, query id 107414027 confluence-u.linx.net 192.168.201.214 confluence ---TRANSACTION 24941364113, not started MySQL thread id 6587015, OS thread handle 0x3a97eda8700, query id 107414028 confluence-u.linx.net 192.168.201.214 confluence ---TRANSACTION 24938690581, not started 0 lock struct(s), heap size 488, 0 row lock(s) MySQL thread id 6327917, OS thread handle 0x3a97196d700, query id 100890735 localhost ::1 root ---TRANSACTION 24938673372, not started MySQL thread id 6325784, OS thread handle 0x3a97fc3f700, query id 100864019 localhost ::1 root ---TRANSACTION 0, not started 0 lock struct(s), heap size 488, 0 row lock(s) MySQL thread id 6325590, OS thread handle 0x3a97df7a700, query id 100862424 localhost ::1 root ---TRANSACTION 0, not started MySQL thread id 6311081, OS thread handle 0x3a9a693b700, query id 100695073 localhost ::1 root ---TRANSACTION 0, not started MySQL thread id 6310990, OS thread handle 0x3a99c043700, query id 100681611 localhost ::1 root ---TRANSACTION 0, not started MySQL thread id 6309805, OS thread handle 0x3a9737f9700, query id 100664186 localhost ::1 root ---TRANSACTION 0, not started MySQL thread id 6307294, OS thread handle 0x3a99d267700, query id 100636519 localhost ::1 root ---TRANSACTION 0, not started MySQL thread id 6307072, OS thread handle 0x3a97261b700, query id 100633592 localhost ::1 root ---TRANSACTION 24938515215, not started MySQL thread id 6306255, OS thread handle 0x3a97354a700, query id 100620924 localhost ::1 root ---TRANSACTION 0, not started MySQL thread id 6306205, OS thread handle 0x3a97e3cf700, query id 100620395 localhost ::1 root ---TRANSACTION 24942012252, not started MySQL thread id 65781, OS thread handle 0x3a97f573700, query id 107433139 probe-edge1-pue.sco1.linx.net 192.168.30.205 flowmon_sco1_rw ---TRANSACTION 24942012190, not started MySQL thread id 64963, OS thread handle 0x3a99d3f2700, query id 107433096 probe-edge1-tcj.man1.linx.net 192.168.21.205 flowmon_ixman_rw ---TRANSACTION 24942012270, not started MySQL thread id 64182, OS thread handle 0x3a9a419c700, query id 107433148 probe-edge2-bts.car1.linx.net 192.168.50.206 flowmon_car1_rw ---TRANSACTION 24942011917, not started MySQL thread id 994, OS thread handle 0x3a97f879700, query id 107432823 probe-edge1-tdd.man1.linx.net 192.168.23.5 flowmon_ixman_rw ---TRANSACTION 24942012220, not started MySQL thread id 935, OS thread handle 0x3a97fe8b700, query id 107433122 probe-edge2-stj-jed1.linx.net 192.168.60.250 flowmon_jed1_rw ---TRANSACTION 24942012188, not started MySQL thread id 937, OS thread handle 0x3a99c1ad700, query id 107433095 probe-edge1-tch-lon2.linx.net 192.168.15.220 flowmonitor_e_rw ---TRANSACTION 24942012208, not started MySQL thread id 936, OS thread handle 0x3a97fc9c700, query id 107433109 probe-edge2-pue.sco1.linx.net 192.168.30.206 flowmon_sco1_rw ---TRANSACTION 24942012178, not started MySQL thread id 926, OS thread handle 0x3a97ef62700, query id 107433090 probe1-edge3-stj-jed1.linx.net 192.168.60.251 flowmon_jed1_rw ---TRANSACTION 24942012198, not started MySQL thread id 934, OS thread handle 0x3a99d436700, query id 107433100 probe-core3-tch.linx.net 192.168.15.224 flowmonitor_j_rw ---TRANSACTION 24942011052, not started MySQL thread id 927, OS thread handle 0x3a97f663700, query id 107431445 harrier.linx.net 195.66.232.17 flowmonitor_j_rw ---TRANSACTION 24942012258, not started MySQL thread id 925, OS thread handle 0x3a97f52e700, query id 107433142 probe-edge2-thn-lon2.linx.net 192.168.1.190 flowmonitor_e_rw ---TRANSACTION 24942012278, not started MySQL thread id 922, OS thread handle 0x3a99c261700, query id 107433152 probe-edge4-tch-lon2.linx.net 192.168.15.223 flowmonitor_e_rw ---TRANSACTION 24942012286, not started MySQL thread id 921, OS thread handle 0x3a97f082700, query id 107433156 probe-edge2-rbs-lon2.linx.net 192.168.9.210 flowmonitor_e_rw ---TRANSACTION 24942012321, not started MySQL thread id 907, OS thread handle 0x3a99de60700, query id 107433301 probe-edge1-cor.nva1.linx.net 192.168.41.205 flowmon_nva1_rw ---TRANSACTION 24942012232, not started MySQL thread id 918, OS thread handle 0x3a97f193700, query id 107433128 probe-edge1-in2-lon2.linx.net 192.168.12.220 flowmonitor_e_rw ---TRANSACTION 24942012222, not started MySQL thread id 911, OS thread handle 0x3a97f2a5700, query id 107433123 probe-edge5-eq4.linx.net 192.168.10.173 flowmonitor_j_rw ---TRANSACTION 24942012313, not started MySQL thread id 910, OS thread handle 0x3a97f3ba700, query id 107433283 probe-edge1-th2-lon2.linx.net 192.168.17.206 flowmonitor_e_rw ---TRANSACTION 24942012167, not started MySQL thread id 909, OS thread handle 0x3a97f960700, query id 107433084 probe-edge4-eq4-lon2.linx.net 192.168.10.223 flowmonitor_e_rw ---TRANSACTION 24942012262, not started MySQL thread id 908, OS thread handle 0x3a99c67e700, query id 107433144 probe-edge3-thw-lon2.linx.net 192.168.11.211 flowmonitor_e_rw ---TRANSACTION 24942012292, not started MySQL thread id 906, OS thread handle 0x3a99c33b700, query id 107433159 probe-edge2-tdd.man1.linx.net 192.168.23.6 flowmon_ixman_rw ---TRANSACTION 24942012288, not started MySQL thread id 905, OS thread handle 0x3a97f602700, query id 107433157 probe-edge6-thn-lon2.linx.net 192.168.1.213 flowmonitor_e_rw ---TRANSACTION 24942012303, not started MySQL thread id 904, OS thread handle 0x3a97f4c9700, query id 107433247 probe-edge1-tca-lon2.linx.net 192.168.7.220 flowmonitor_e_rw ---TRANSACTION 24942012268, not started MySQL thread id 891, OS thread handle 0x3a99c45f700, query id 107433147 janeway-u.linx.net 192.168.1.50 flowmonitor_j_rw ---TRANSACTION 24942012196, not started MySQL thread id 890, OS thread handle 0x3a99eee0700, query id 107433099 probe-edge2-thn.linx.net 192.168.1.206 flowmonitor_j_rw ---TRANSACTION 24942012297, not started MySQL thread id 889, OS thread handle 0x3a97f71d700, query id 107433214 probe-edge4-the.lon1.linx.net 192.168.2.209 flowmonitor_j_rw ---TRANSACTION 24942012256, not started MySQL thread id 888, OS thread handle 0x3a97f817700, query id 107433141 probe-edge5-thn-lon2.linx.net 192.168.1.211 flowmonitor_e_rw ---TRANSACTION 24942012280, not started MySQL thread id 875, OS thread handle 0x3a97ff8c700, query id 107433153 probe-edge1-dft.nva1.linx.net 192.168.42.205 flowmon_nva1_rw ---TRANSACTION 24942012212, not started MySQL thread id 885, OS thread handle 0x3a99cfc2700, query id 107433118 probe-core4-tch.linx.net 192.168.15.225 flowmonitor_j_rw ---TRANSACTION 24942012163, not started MySQL thread id 884, OS thread handle 0x3a97f90b700, query id 107433082 probe-edge4-thw-lon2.linx.net 192.168.11.212 flowmonitor_e_rw ---TRANSACTION 24942012171, not started MySQL thread id 883, OS thread handle 0x3a97fa17700, query id 107433086 probe-edge2-thw-lon2.linx.net 192.168.11.210 flowmonitor_e_rw ---TRANSACTION 24942012236, not started MySQL thread id 882, OS thread handle 0x3a97fb54700, query id 107433130 probe-core4-thn.lon1.linx.net 192.168.1.236 flowmonitor_j_rw ---TRANSACTION 24942012298, not started MySQL thread id 881, OS thread handle 0x3a99c541700, query id 107433215 probe-edge2-in2-lon2.linx.net 192.168.12.210 flowmonitor_e_rw ---TRANSACTION 24942012230, not started MySQL thread id 880, OS thread handle 0x3a97fd79700, query id 107433127 probe-core3-thn.linx.net 192.168.1.229 flowmonitor_j_rw ---TRANSACTION 24942012210, not started MySQL thread id 879, OS thread handle 0x3a97fb0d700, query id 107433117 probe-edge1-thw-lon2.linx.net 192.168.11.213 flowmonitor_e_rw ---TRANSACTION 24942012228, not started MySQL thread id 874, OS thread handle 0x3a97ff14700, query id 107433126 probe-core1-m2i.man1.linx.net 192.168.22.4 flowmon_ixman_rw ---TRANSACTION 24942012266, not started MySQL thread id 873, OS thread handle 0x3a99c09d700, query id 107433146 probe-edge1-in2.linx.net 192.168.12.205 flowmonitor_j_rw ---TRANSACTION 24942012282, not started MySQL thread id 872, OS thread handle 0x3a99c77a700, query id 107433154 probe-edge1-rbs-lon2.linx.net 192.168.9.212 flowmonitor_e_rw ---TRANSACTION 24942012290, not started MySQL thread id 871, OS thread handle 0x3a99c156700, query id 107433158 probe-edge1-m2i.man1.linx.net 192.168.22.205 flowmon_ixman_rw ---TRANSACTION 24942012182, not started MySQL thread id 870, OS thread handle 0x3a99c628700, query id 107433092 probe-edge3-tcw.man1.linx.net 192.168.20.205 flowmon_ixman_rw ---TRANSACTION 24942012184, not started MySQL thread id 869, OS thread handle 0x3a99ca73700, query id 107433093 probe-edge1-th2.linx.net 192.168.17.205 flowmonitor_j_rw ---TRANSACTION 24942012319, not started MySQL thread id 868, OS thread handle 0x3a99c3d7700, query id 107433296 probe-edge3-rbs-lon2.linx.net 192.168.9.211 flowmonitor_e_rw ---TRANSACTION 24942012202, not started MySQL thread id 866, OS thread handle 0x3a99c86c700, query id 107433102 probe-edge4-thn.lon1.linx.net 192.168.1.209 flowmonitor_j_rw ---TRANSACTION 24942012234, not started MySQL thread id 867, OS thread handle 0x3a99d396700, query id 107433129 probe-edge4-thn-lon2.linx.net 192.168.1.212 flowmonitor_e_rw ---TRANSACTION 24942012242, not started MySQL thread id 865, OS thread handle 0x3a99c208700, query id 107433133 probe-edge2-eq4-lon2.linx.net 192.168.10.221 flowmonitor_e_rw ---TRANSACTION 24942012246, not started MySQL thread id 864, OS thread handle 0x3a99c41b700, query id 107433136 probe-edge3-tch-lon2.linx.net 192.168.15.222 flowmonitor_e_rw ---TRANSACTION 24942012254, not started MySQL thread id 849, OS thread handle 0x3a99c2ee700, query id 107433140 probe-edge1-thw.lon1.linx.net 192.168.11.205 flowmonitor_j_rw ---TRANSACTION 24942012206, not started MySQL thread id 825, OS thread handle 0x3a99c995700, query id 107433105 probe-edge1-tcm-lon2.linx.net 192.168.3.220 flowmonitor_e_rw ---TRANSACTION 24942012161, not started MySQL thread id 821, OS thread handle 0x3a99c4de700, query id 107433081 probe-edge1-thn-lon2.linx.net 192.168.1.220 flowmonitor_e_rw ---TRANSACTION 24942012264, not started MySQL thread id 820, OS thread handle 0x3a99c5c4700, query id 107433145 probe-edge1-thn.linx.net 192.168.1.205 flowmonitor_j_rw ---TRANSACTION 24942012165, not started MySQL thread id 819, OS thread handle 0x3a99c71e700, query id 107433083 probe-vot-vih-thn-1.linx.net 192.168.14.205 flowmonitor_j_rw ---TRANSACTION 24942012312, not started MySQL thread id 818, OS thread handle 0x3a99f7f3700, query id 107433282 probe-edge1-eq4-lon2.linx.net 192.168.10.220 flowmonitor_e_rw ---TRANSACTION 24942012238, not started MySQL thread id 817, OS thread handle 0x3a99c6dc700, query id 107433131 probe-edge1-tch.lon1.linx.net 192.168.15.205 flowmonitor_j_rw ---TRANSACTION 24942012272, not started MySQL thread id 816, OS thread handle 0x3a99c7f6700, query id 107433149 probe-core1-tcw.man1.linx.net 192.168.20.7 flowmon_ixman_rw ---TRANSACTION 24942012175, not started MySQL thread id 815, OS thread handle 0x3a99c8fe700, query id 107433088 probe-edge1-the-lon2.linx.net 192.168.2.207 flowmonitor_e_rw ---TRANSACTION 24942012194, not started MySQL thread id 814, OS thread handle 0x3a99cbc3700, query id 107433098 planet.tch.linx.net 192.168.15.50 flowmonitor_j_rw ---TRANSACTION 24942012214, not started MySQL thread id 813, OS thread handle 0x3a99cc86700, query id 107433119 probe-edge3-eq4-lon2.linx.net 192.168.10.206 flowmonitor_e_rw ---TRANSACTION 24942012226, not started MySQL thread id 812, OS thread handle 0x3a99ccdb700, query id 107433125 scarlet.tcm.linx.net 192.168.3.50 flowmonitor_j_rw ---TRANSACTION 24942012173, not started MySQL thread id 811, OS thread handle 0x3a99cb43700, query id 107433087 probe-edge4-eq4.linx.net 192.168.10.205 flowmonitor_j_rw ---TRANSACTION 24942012204, not started MySQL thread id 808, OS thread handle 0x3a99d5b5700, query id 107433104 probe-core3-thw.linx.net 192.168.11.214 flowmonitor_j_rw ---TRANSACTION 24942012244, not started MySQL thread id 805, OS thread handle 0x3a99cf0b700, query id 107433134 probe-edge4-tcw.man1.linx.net 192.168.20.9 flowmon_ixman_rw ---TRANSACTION 24942012276, not started MySQL thread id 801, OS thread handle 0x3a99caf8700, query id 107433151 pugwash.rbs.linx.net 192.168.9.50 flowmonitor_j_rw ---TRANSACTION 24942012169, not started MySQL thread id 798, OS thread handle 0x3a99cdc1700, query id 107433085 probe-core1-tcj.man1.linx.net 192.168.21.4 flowmon_ixman_rw ---TRANSACTION 24942012247, not started MySQL thread id 794, OS thread handle 0x3a99ceb2700, query id 107433137 caveman.eq4.linx.net 192.168.10.50 flowmonitor_j_rw ---TRANSACTION 24942012224, not started MySQL thread id 791, OS thread handle 0x3a99d0e0700, query id 107433124 picard.tca.linx.net 192.168.7.50 flowmonitor_j_rw ---TRANSACTION 24942012216, not started MySQL thread id 790, OS thread handle 0x3a9a71b5700, query id 107433120 probe-edge1-dvg.sco1.linx.net 192.168.31.205 flowmon_sco1_rw ---TRANSACTION 24942012200, not started MySQL thread id 787, OS thread handle 0x3a99d125700, query id 107433101 probe-edge3-eq4.linx.net 192.168.10.202 flowmonitor_j_rw ---TRANSACTION 24942012250, not started MySQL thread id 786, OS thread handle 0x3a99d020700, query id 107433138 captain.in2.linx.net 192.168.12.50 flowmonitor_j_rw ---TRANSACTION 24942012218, not started MySQL thread id 783, OS thread handle 0x3a99d350700, query id 107433121 barbosa.thw.linx.net 192.168.11.50 flowmonitor_j_rw ---TRANSACTION 24942008098, not started MySQL thread id 542, OS thread handle 0x3a9a4079700, query id 107426682 selector1-u.linx.net 192.168.202.26 s2ap_ro ---TRANSACTION 24942011403, not started MySQL thread id 485, OS thread handle 0x3a99d30b700, query id 107432059 probe-edge1-rbs.lon1.linx.net 192.168.9.203 flowmonitor_j_rw ---TRANSACTION 24942011277, not started MySQL thread id 411, OS thread handle 0x3a99cd42700, query id 107431906 probe-vot-coa-thn-1.linx.net 192.168.16.205 flowmonitor_j_rw ---TRANSACTION 24942012180, not started MySQL thread id 132, OS thread handle 0x3a9a7aad700, query id 107433091 probe-edge1-stj-jed1.linx.net 192.168.60.249 flowmon_jed1_rw ---TRANSACTION 24942012284, not started MySQL thread id 131, OS thread handle 0x3a9a4fa1700, query id 107433155 probe-edge1-evm.nva1.linx.net 192.168.40.205 flowmon_nva1_rw ---TRANSACTION 24942012274, not started MySQL thread id 121, OS thread handle 0x3a99d097700, query id 107433150 probe-edge2-the-lon2.linx.net 192.168.2.208 flowmonitor_e_rw ---TRANSACTION 24942012240, not started MySQL thread id 89, OS thread handle 0x3a9a4f3a700, query id 107433132 probe-edge2-tch-lon2.linx.net 192.168.15.221 flowmonitor_e_rw ---TRANSACTION 24942012186, not started MySQL thread id 88, OS thread handle 0x3a9a934a700, query id 107433094 probe-edge3-thn-lon2.linx.net 192.168.1.221 flowmonitor_e_rw ---TRANSACTION 24942012192, not started MySQL thread id 20, OS thread handle 0x3a9aa3fb700, query id 107433097 probe-edge1-tcw.man1.linx.net 192.168.20.8 flowmon_ixman_rw ---TRANSACTION 24879562135, ACTIVE 337858 sec MySQL thread id 6873, OS thread handle 0x3a9a7a6b700, query id 107323475 stats-prometheus-jed-u.linx.net 192.168.60.95 website_user Trx read view will not see trx with id >= 24879562136, sees < 24879556808 -------- 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 5354492 OS file reads, 29298258 OS file writes, 625776 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 85.84 writes/s, 2.56 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 97972, seg size 97974, 83334 merges merged operations: insert 148310, delete mark 544189, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 84999163, node heap has 19150 buffer(s) 104417.90 hash searches/s, 2799.37 non-hash searches/s --- LOG --- Log sequence number 7462418546083 Log flushed up to 7462418526146 Pages flushed up to 7462032215501 Last checkpoint at 7462032215501 0 pending log writes, 0 pending chkp writes 27107811 log i/o's done, 77.16 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 46294735881; in additional pool allocated 4194304 Dictionary memory allocated 10331817 Buffer pool size 2621440 Free buffers 8196 Database pages 2594094 Old database pages 957422 Modified db pages 46848 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 3873268, not young 72220008 0.00 youngs/s, 0.00 non-youngs/s Pages read 5349813, created 928169, written 2084305 0.00 reads/s, 1.44 creates/s, 8.32 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: 2594094, unzip_LRU len: 0 I/O sum[3456]:cur[0], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 327680 Free buffers 1024 Database pages 324254 Old database pages 119675 Modified db pages 5855 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 475397, not young 8946712 0.00 youngs/s, 0.00 non-youngs/s Pages read 681777, created 114832, written 261982 0.00 reads/s, 0.04 creates/s, 1.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: 324254, unzip_LRU len: 0 I/O sum[432]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 327680 Free buffers 1024 Database pages 324257 Old database pages 119676 Modified db pages 6132 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 484435, not young 8832628 0.00 youngs/s, 0.00 non-youngs/s Pages read 670391, created 116278, written 266804 0.00 reads/s, 0.88 creates/s, 1.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: 324257, unzip_LRU len: 0 I/O sum[432]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 327680 Free buffers 1024 Database pages 324250 Old database pages 119673 Modified db pages 5205 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 484398, not young 8979510 0.00 youngs/s, 0.00 non-youngs/s Pages read 668543, created 116155, written 252226 0.00 reads/s, 0.40 creates/s, 1.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: 324250, unzip_LRU len: 0 I/O sum[432]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 327680 Free buffers 1025 Database pages 324269 Old database pages 119680 Modified db pages 5560 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 484695, not young 8602285 0.00 youngs/s, 0.00 non-youngs/s Pages read 672092, created 116043, written 262933 0.00 reads/s, 0.00 creates/s, 1.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: 324269, unzip_LRU len: 0 I/O sum[432]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 327680 Free buffers 1024 Database pages 324267 Old database pages 119680 Modified db pages 5840 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 489297, not young 9429962 0.00 youngs/s, 0.00 non-youngs/s Pages read 659389, created 115991, written 254347 0.00 reads/s, 0.04 creates/s, 1.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: 324267, unzip_LRU len: 0 I/O sum[432]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 327680 Free buffers 1025 Database pages 324276 Old database pages 119683 Modified db pages 5877 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 483309, not young 8855209 0.00 youngs/s, 0.00 non-youngs/s Pages read 670653, created 115866, written 265818 0.00 reads/s, 0.00 creates/s, 1.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: 324276, unzip_LRU len: 0 I/O sum[432]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 327680 Free buffers 1024 Database pages 324262 Old database pages 119678 Modified db pages 6109 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 482766, not young 10550465 0.00 youngs/s, 0.00 non-youngs/s Pages read 673267, created 116669, written 254953 0.00 reads/s, 0.08 creates/s, 1.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: 324262, unzip_LRU len: 0 I/O sum[432]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 327680 Free buffers 1026 Database pages 324259 Old database pages 119677 Modified db pages 6270 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 488971, not young 8023237 0.00 youngs/s, 0.00 non-youngs/s Pages read 653701, created 116335, written 265242 0.00 reads/s, 0.00 creates/s, 1.28 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: 324259, unzip_LRU len: 0 I/O sum[432]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 17665, id 4027068696320, state: sleeping Number of rows inserted 2125483, updated 25379619, deleted 1012201, read 56277374080 2.52 inserts/s, 73.04 updates/s, 0.40 deletes/s, 909300.71 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 1 row in set (0.00 sec)