mysql> SHOW ENGINE INNODB STATUS\G; *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2018-05-07 07:20:22 2bcca3985700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 14 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 8559322 srv_active, 0 srv_shutdown, 146834 srv_idle srv_master_thread log flush and writes: 8706156 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3052668720 OS WAIT ARRAY INFO: signal count 71154022150 Mutex spin waits 81328360176, rounds 123254376057, OS waits 357290343 RW-shared spins 30605097145, rounds 113493450426, OS waits 885051303 RW-excl spins 34813140515, rounds 332798424224, OS waits 1504356899 Spin rounds per wait: 1.52 mutex, 3.71 RW-shared, 9.56 RW-excl ------------------------ LATEST FOREIGN KEY ERROR ------------------------ 2018-05-04 12:44:37 2b7c50295700 Transaction: TRANSACTION 204839317623, ACTIVE 0 sec updating or deleting mysql tables in use 1, locked 1 4 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 1 MySQL thread id 100752248, OS thread handle 0x2b7c50295700, query id 7918719723 localhost root updating update problem set r_eventid=205598863,r_clock=1525378542,r_ns=810644385,userid=0 where eventid=205598838 Foreign key constraint fails for table `zabbix`.`problem`: , CONSTRAINT `c_problem_2` FOREIGN KEY (`r_eventid`) REFERENCES `events` (`eventid`) ON DELETE CASCADE Trying to add in child table, in index `c_problem_2` tuple: DATA TUPLE: 2 fields; 0: len 8; hex 000000000c41308f; asc A0 ;; 1: len 8; hex 000000000c413076; asc A0v;; But in parent table `zabbix`.`events`, in index `PRIMARY`, the closest match we can find is record: PHYSICAL RECORD: n_fields 10; compact format; info bits 0 0: len 8; hex 000000000c41309b; asc A0 ;; 1: len 6; hex 002fadb5486a; asc / Hj;; 2: len 7; hex a40001c0092f87; asc / ;; 3: len 4; hex 80000003; asc ;; 4: len 4; hex 80000000; asc ;; 5: len 8; hex 0000000000136ce0; asc l ;; 6: len 4; hex daeb6e05; asc n ;; 7: len 4; hex 80000001; asc ;; 8: len 4; hex 80000000; asc ;; 9: len 4; hex 86fbe6fb; asc ;; ------------------------ LATEST DETECTED DEADLOCK ------------------------ 2018-05-04 11:11:30 2bcca3903700 *** (1) TRANSACTION: TRANSACTION 204833355867, ACTIVE 34 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 13 lock struct(s), heap size 2936, 4 row lock(s), undo log entries 261 MySQL thread id 1765991, OS thread handle 0x2bc967bdc700, query id 7908901157 localhost 127.0.0.1 zabbix_server updating update problem set r_eventid=205644042,r_clock=1525432255,r_ns=182842437,userid=0 where eventid=205340917 *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 12287 page no 597 n bits 280 index `PRIMARY` of table `zabbix`.`problem` trx id 204833355867 lock_mode X locks rec but not gap waiting *** (2) TRANSACTION: TRANSACTION 204833342047, ACTIVE 53 sec fetching rows mysql tables in use 2, locked 2 1079 lock struct(s), heap size 144936, 69610 row lock(s), undo log entries 380 MySQL thread id 100653709, OS thread handle 0x2bcca3903700, query id 7908877449 localhost 127.0.0.1 zabbix_server Sending data delete from events where clock<1525345756 and events.source=3 and events.object=4 and not exists (select null from problem where events.eventid=problem.eventid or events.eventid=problem.r_eventid) *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 12287 page no 597 n bits 280 index `PRIMARY` of table `zabbix`.`problem` trx id 204833342047 lock mode S *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 12238 page no 94205 n bits 328 index `PRIMARY` of table `zabbix`.`events` trx id 204833342047 lock_mode X locks rec but not gap waiting *** WE ROLL BACK TRANSACTION (1) ------------ TRANSACTIONS ------------ Trx id counter 205050504540 Purge done for trx's n:o < 205050497866 undo n:o < 0 state: running but idle History list length 986 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started MySQL thread id 105672767, OS thread handle 0x2bcca3985700, query id 8255150445 localhost root init SHOW ENGINE INNODB STATUS ---TRANSACTION 205050491771, not started MySQL thread id 105672681, OS thread handle 0x2bc968a55700, query id 8255149794 localhost zabbix_server cleaning up ---TRANSACTION 205050488962, not started MySQL thread id 105672657, OS thread handle 0x2bc965b1b700, query id 8255149294 localhost zabbix_server cleaning up ---TRANSACTION 205050428694, not started MySQL thread id 105597844, OS thread handle 0x2bc965ca1700, query id 8255027759 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205047214457, not started MySQL thread id 105522969, OS thread handle 0x2bcbe8dc6700, query id 8249888480 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205043989762, not started MySQL thread id 105463076, OS thread handle 0x2bcbe8d44700, query id 8244719518 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205034275053, not started MySQL thread id 105301799, OS thread handle 0x2bc96843d700, query id 8229167376 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205048175508, not started MySQL thread id 104951792, OS thread handle 0x2bc968b18700, query id 8251367383 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205048175507, not started MySQL thread id 104878346, OS thread handle 0x2bc966070700, query id 8251367384 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205025644866, not started MySQL thread id 103563989, OS thread handle 0x2bcbe8fce700, query id 8215318648 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205028840973, not started MySQL thread id 103483518, OS thread handle 0x2bc9687cb700, query id 8220420436 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205049168401, not started MySQL thread id 102975240, OS thread handle 0x2bcca3944700, query id 8252907132 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205045994801, not started MySQL thread id 102859583, OS thread handle 0x2bc965da5700, query id 8247843554 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205035264479, not started MySQL thread id 102137811, OS thread handle 0x2bc965995700, query id 8230694245 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205026620275, not started MySQL thread id 102055353, OS thread handle 0x2bc968a14700, query id 8216819910 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205033038546, not started MySQL thread id 101616661, OS thread handle 0x2bc968b59700, query id 8227087739 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205040744906, not started MySQL thread id 100142059, OS thread handle 0x2bcbe8cc2700, query id 8239522911 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050428695, not started MySQL thread id 100077939, OS thread handle 0x2bc965ea9700, query id 8255027758 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205039493657, not started MySQL thread id 98568056, OS thread handle 0x2bcca38c2700, query id 8237418824 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205032043836, not started MySQL thread id 97969200, OS thread handle 0x2bc96880c700, query id 8225545026 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205038501133, not started MySQL thread id 95366993, OS thread handle 0x2bc968645700, query id 8235879623 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205049168402, not started MySQL thread id 95304097, OS thread handle 0x2bc968a96700, query id 8252907133 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 0, not started MySQL thread id 39179509, OS thread handle 0x2b7c084cd700, query id 4143998495 Slave has read all relay log; waiting for the slave I/O thread to update it ---TRANSACTION 205050502871, not started MySQL thread id 1765917, OS thread handle 0x2bc966912700, query id 8255148201 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050482577, not started MySQL thread id 1766491, OS thread handle 0x2bc96884d700, query id 8255115682 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205046962375, not started MySQL thread id 1765945, OS thread handle 0x2bc96702e700, query id 8255137865 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050325739, not started MySQL thread id 1765944, OS thread handle 0x2bc966fed700, query id 8255137821 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205048484037, not started MySQL thread id 1765943, OS thread handle 0x2bc966fac700, query id 8255137767 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205048844041, not started MySQL thread id 1765942, OS thread handle 0x2bc966f6b700, query id 8255137781 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205042322190, not started MySQL thread id 1765941, OS thread handle 0x2bc966f2a700, query id 8255137852 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050494742, not started MySQL thread id 1765940, OS thread handle 0x2bc966ee9700, query id 8255137812 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205049224081, not started MySQL thread id 1765936, OS thread handle 0x2bc966de5700, query id 8255137786 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205048103704, not started MySQL thread id 1765939, OS thread handle 0x2bc966ea8700, query id 8255137808 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205041898812, not started MySQL thread id 1765938, OS thread handle 0x2bc966e67700, query id 8255137838 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050400527, not started MySQL thread id 1765937, OS thread handle 0x2bc966e26700, query id 8255137803 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205049224091, not started MySQL thread id 1765935, OS thread handle 0x2bc966da4700, query id 8255137842 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205039469580, not started MySQL thread id 1765934, OS thread handle 0x2bc966d63700, query id 8255137798 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050300526, not started MySQL thread id 1765933, OS thread handle 0x2bc966d22700, query id 8255137815 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205046986574, not started MySQL thread id 1765930, OS thread handle 0x2bc966c5f700, query id 8255137825 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205048819670, not started MySQL thread id 1765932, OS thread handle 0x2bc966ce1700, query id 8255137790 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205044736044, not started MySQL thread id 1765931, OS thread handle 0x2bc966ca0700, query id 8255137829 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205047353614, not started MySQL thread id 1765929, OS thread handle 0x2bc966c1e700, query id 8255137834 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205049224235, not started MySQL thread id 1765928, OS thread handle 0x2bc966bdd700, query id 8255137849 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205035391105, not started MySQL thread id 1765927, OS thread handle 0x2bc966b9c700, query id 8255137857 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050495857, not started MySQL thread id 1765926, OS thread handle 0x2bc966b5b700, query id 8255138039 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504501, not started MySQL thread id 1765907, OS thread handle 0x2bc966688700, query id 8255150410 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504009, not started MySQL thread id 1765835, OS thread handle 0x2bc965481700, query id 8255149723 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504105, not started MySQL thread id 1765847, OS thread handle 0x2bc96578d700, query id 8255149853 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050502731, not started MySQL thread id 1765881, OS thread handle 0x2bc96602f700, query id 8255147994 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050502565, not started MySQL thread id 1765924, OS thread handle 0x2bc966ad9700, query id 8255147759 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050501838, not started MySQL thread id 1765897, OS thread handle 0x2bc9663fe700, query id 8255146767 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503784, not started MySQL thread id 1765911, OS thread handle 0x2bc96678c700, query id 8255149389 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504492, not started MySQL thread id 1765878, OS thread handle 0x2bc965f6c700, query id 8255150404 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504528, not started MySQL thread id 1765858, OS thread handle 0x2bc965a58700, query id 8255150435 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504158, not started MySQL thread id 1765873, OS thread handle 0x2bc965e27700, query id 8255149974 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504216, not started MySQL thread id 1765868, OS thread handle 0x2bc965ce2700, query id 8255150076 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503594, not started MySQL thread id 1765825, OS thread handle 0x2bc964dd8700, query id 8255149200 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050499281, not started MySQL thread id 1765910, OS thread handle 0x2bc96674b700, query id 8255142464 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503749, not started MySQL thread id 1765888, OS thread handle 0x2bc9661f6700, query id 8255149357 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050502812, not started MySQL thread id 1765887, OS thread handle 0x2bc9661b5700, query id 8255148134 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503941, not started MySQL thread id 1765904, OS thread handle 0x2bc9665c5700, query id 8255149623 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503609, not started MySQL thread id 1765862, OS thread handle 0x2bc965b5c700, query id 8255149208 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504494, not started MySQL thread id 1765906, OS thread handle 0x2bc966647700, query id 8255150405 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050502006, not started MySQL thread id 1765913, OS thread handle 0x2bc96680e700, query id 8255146942 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504422, not started MySQL thread id 1765843, OS thread handle 0x2bc965689700, query id 8255150332 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503464, not started MySQL thread id 1765922, OS thread handle 0x2bc966a57700, query id 8255149062 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050501956, not started MySQL thread id 1765921, OS thread handle 0x2bc966a16700, query id 8255146892 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503596, not started MySQL thread id 1765896, OS thread handle 0x2bc9660b1700, query id 8255149201 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050501832, not started MySQL thread id 1765915, OS thread handle 0x2bc966890700, query id 8255146763 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503363, not started MySQL thread id 1765824, OS thread handle 0x2bc964d97700, query id 8255148954 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503563, not started MySQL thread id 1765898, OS thread handle 0x2bc96643f700, query id 8255149170 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050502356, not started MySQL thread id 1766037, OS thread handle 0x2bc96878a700, query id 8255147524 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504505, not started MySQL thread id 1765857, OS thread handle 0x2bc965a17700, query id 8255150412 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504362, not started MySQL thread id 1765891, OS thread handle 0x2bc9662b9700, query id 8255150263 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050501347, not started MySQL thread id 1765846, OS thread handle 0x2bc96574c700, query id 8255146057 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503598, not started MySQL thread id 1765832, OS thread handle 0x2bc964f9f700, query id 8255149202 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050502146, not started MySQL thread id 1765905, OS thread handle 0x2bc966606700, query id 8255147129 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504004, not started MySQL thread id 1765893, OS thread handle 0x2bc96633b700, query id 8255149709 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504488, not started MySQL thread id 1765892, OS thread handle 0x2bc9662fa700, query id 8255150402 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503744, not started MySQL thread id 1765919, OS thread handle 0x2bc966994700, query id 8255149354 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503753, not started MySQL thread id 1765894, OS thread handle 0x2bc96637c700, query id 8255149360 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050502810, not started MySQL thread id 1765872, OS thread handle 0x2bc965de6700, query id 8255148133 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504159, not started MySQL thread id 1766003, OS thread handle 0x2bc967ee8700, query id 8255149982 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504161, not started MySQL thread id 1766004, OS thread handle 0x2bc967f29700, query id 8255149985 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504211, not started MySQL thread id 1766002, OS thread handle 0x2bc967ea7700, query id 8255150107 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504119, not started MySQL thread id 1766005, OS thread handle 0x2bc967f6a700, query id 8255149958 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504112, not started MySQL thread id 1766001, OS thread handle 0x2bc967e66700, query id 8255149996 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503944, not started MySQL thread id 1765996, OS thread handle 0x2bc967d21700, query id 8255149876 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504011, not started MySQL thread id 1765995, OS thread handle 0x2bc967ce0700, query id 8255149937 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504079, not started MySQL thread id 1765994, OS thread handle 0x2bc967c9f700, query id 8255150057 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503592, not started MySQL thread id 1765840, OS thread handle 0x2bc9655c6700, query id 8255149199 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050502753, not started MySQL thread id 1765889, OS thread handle 0x2bc966237700, query id 8255148044 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050501750, not started MySQL thread id 1765900, OS thread handle 0x2bc9664c1700, query id 8255146663 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503767, not started MySQL thread id 1765851, OS thread handle 0x2bc965891700, query id 8255149372 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050502228, not started MySQL thread id 1765879, OS thread handle 0x2bc965fad700, query id 8255147280 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504503, not started MySQL thread id 1765822, OS thread handle 0x2bc964d15700, query id 8255150411 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504116, not started MySQL thread id 1765902, OS thread handle 0x2bc966543700, query id 8255149901 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050501591, not started MySQL thread id 1765839, OS thread handle 0x2bc965585700, query id 8255146404 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050501597, not started MySQL thread id 1765849, OS thread handle 0x2bc96580f700, query id 8255146420 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050502258, not started MySQL thread id 1765838, OS thread handle 0x2bc965544700, query id 8255147314 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503600, not started MySQL thread id 1765884, OS thread handle 0x2bc9660f2700, query id 8255149203 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503773, not started MySQL thread id 1765866, OS thread handle 0x2bc965c60700, query id 8255149378 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503533, not started MySQL thread id 1765828, OS thread handle 0x2bc964e9b700, query id 8255149138 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050502690, not started MySQL thread id 1765859, OS thread handle 0x2bc965a99700, query id 8255147939 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504486, not started MySQL thread id 1765877, OS thread handle 0x2bc965f2b700, query id 8255150401 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504094, not started MySQL thread id 1765991, OS thread handle 0x2bc967bdc700, query id 8255150036 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504163, not started MySQL thread id 1765987, OS thread handle 0x2bc967ad8700, query id 8255150010 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503991, not started MySQL thread id 1765863, OS thread handle 0x2bc965b9d700, query id 8255149695 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504538, not started MySQL thread id 1765860, OS thread handle 0x2bc965ada700, query id 8255150444 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050499544, not started MySQL thread id 1765916, OS thread handle 0x2bc9668d1700, query id 8255142908 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050499114, not started MySQL thread id 1765920, OS thread handle 0x2bc9669d5700, query id 8255142231 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504490, not started MySQL thread id 1765909, OS thread handle 0x2bc96670a700, query id 8255150403 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050501488, not started MySQL thread id 1765895, OS thread handle 0x2bc9663bd700, query id 8255146214 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504326, not started MySQL thread id 1765830, OS thread handle 0x2bc964f1d700, query id 8255150221 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503613, not started MySQL thread id 1765885, OS thread handle 0x2bc966133700, query id 8255149211 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503301, not started MySQL thread id 1765908, OS thread handle 0x2bc9666c9700, query id 8255148779 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504284, not started MySQL thread id 1765880, OS thread handle 0x2bc965fee700, query id 8255150167 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504109, not started MySQL thread id 1765912, OS thread handle 0x2bc9667cd700, query id 8255149858 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503602, not started MySQL thread id 1765923, OS thread handle 0x2bc966a98700, query id 8255149204 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503799, not started MySQL thread id 1765899, OS thread handle 0x2bc966480700, query id 8255149401 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503082, not started MySQL thread id 1765903, OS thread handle 0x2bc966584700, query id 8255148429 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503875, not started MySQL thread id 1765844, OS thread handle 0x2bc9656ca700, query id 8255149495 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050398039, not started MySQL thread id 1765756, OS thread handle 0x2b7c50254700, query id 8254980073 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050285499, not started MySQL thread id 1765764, OS thread handle 0x2b7c50358700, query id 8254804545 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050491978, not started MySQL thread id 1765755, OS thread handle 0x2b7c0bf6f700, query id 8255132544 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050476762, not started MySQL thread id 1765757, OS thread handle 0x2b7c502d6700, query id 8255107061 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050486801, not started MySQL thread id 1765758, OS thread handle 0x2b7c0850e700, query id 8255124942 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050499925, not started MySQL thread id 1765759, OS thread handle 0x2b7c0beed700, query id 8255143308 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050501609, not started MySQL thread id 1765901, OS thread handle 0x2bc966502700, query id 8255146460 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503877, not started MySQL thread id 1766000, OS thread handle 0x2bc967e25700, query id 8255149841 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504156, not started MySQL thread id 1765999, OS thread handle 0x2bc967de4700, query id 8255149981 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504108, not started MySQL thread id 1765998, OS thread handle 0x2bc967da3700, query id 8255149871 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504113, not started MySQL thread id 1765997, OS thread handle 0x2bc967d62700, query id 8255149900 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503883, not started MySQL thread id 1765993, OS thread handle 0x2bc967c5e700, query id 8255149891 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503911, not started MySQL thread id 1765918, OS thread handle 0x2bc966953700, query id 8255149562 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504152, not started MySQL thread id 1765992, OS thread handle 0x2bc967c1d700, query id 8255149983 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504181, not started MySQL thread id 1765990, OS thread handle 0x2bc967b9b700, query id 8255150025 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503912, not started MySQL thread id 1765986, OS thread handle 0x2bc967a97700, query id 8255149848 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504364, not started MySQL thread id 1765989, OS thread handle 0x2bc967b5a700, query id 8255150274 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504196, not started MySQL thread id 1765988, OS thread handle 0x2bc967b19700, query id 8255150071 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503233, not started MySQL thread id 1766016, OS thread handle 0x2bc968235700, query id 8255148702 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504373, not started MySQL thread id 1766014, OS thread handle 0x2bc9681b3700, query id 8255150282 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050502110, not started MySQL thread id 1765914, OS thread handle 0x2bc96684f700, query id 8255147076 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050502248, not started MySQL thread id 1766015, OS thread handle 0x2bc9681f4700, query id 8255147302 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503668, not started MySQL thread id 1766013, OS thread handle 0x2bc968172700, query id 8255149265 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503746, not started MySQL thread id 1766012, OS thread handle 0x2bc968131700, query id 8255149355 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503232, not started MySQL thread id 1766011, OS thread handle 0x2bc9680f0700, query id 8255148701 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050458296, not started MySQL thread id 1766010, OS thread handle 0x2bc9680af700, query id 8255077716 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503766, not started MySQL thread id 1766009, OS thread handle 0x2bc96806e700, query id 8255149371 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050502740, not started MySQL thread id 1766008, OS thread handle 0x2bc96802d700, query id 8255148002 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503234, not started MySQL thread id 1766007, OS thread handle 0x2bc967fec700, query id 8255148703 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503143, not started MySQL thread id 1766006, OS thread handle 0x2bc967fab700, query id 8255148496 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503707, not started MySQL thread id 1765985, OS thread handle 0x2bc967a56700, query id 8255149316 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503575, not started MySQL thread id 1765984, OS thread handle 0x2bc967a15700, query id 8255149179 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503588, not started MySQL thread id 1765983, OS thread handle 0x2bc9679d4700, query id 8255149193 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503978, not started MySQL thread id 1765982, OS thread handle 0x2bc967993700, query id 8255149680 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503612, not started MySQL thread id 1765981, OS thread handle 0x2bc967952700, query id 8255149210 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503586, not started MySQL thread id 1765980, OS thread handle 0x2bc967911700, query id 8255149191 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050501837, not started MySQL thread id 1765979, OS thread handle 0x2bc9678d0700, query id 8255146766 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050502833, not started MySQL thread id 1765978, OS thread handle 0x2bc96788f700, query id 8255148158 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050501475, not started MySQL thread id 1765977, OS thread handle 0x2bc96784e700, query id 8255146206 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503752, not started MySQL thread id 1765976, OS thread handle 0x2bc96780d700, query id 8255149359 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050501658, not started MySQL thread id 1765975, OS thread handle 0x2bc9677cc700, query id 8255146555 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050501292, not started MySQL thread id 1765974, OS thread handle 0x2bc96778b700, query id 8255145997 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050501821, not started MySQL thread id 1765973, OS thread handle 0x2bc96774a700, query id 8255146744 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503591, not started MySQL thread id 1765972, OS thread handle 0x2bc967709700, query id 8255149198 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504160, not started MySQL thread id 1765971, OS thread handle 0x2bc9676c8700, query id 8255149972 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503538, not started MySQL thread id 1765970, OS thread handle 0x2bc967687700, query id 8255149144 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503584, not started MySQL thread id 1765969, OS thread handle 0x2bc967646700, query id 8255149189 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050502076, not started MySQL thread id 1765968, OS thread handle 0x2bc967605700, query id 8255147013 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503581, not started MySQL thread id 1765967, OS thread handle 0x2bc9675c4700, query id 8255149186 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050502905, not started MySQL thread id 1765966, OS thread handle 0x2bc967583700, query id 8255148232 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503758, not started MySQL thread id 1765965, OS thread handle 0x2bc967542700, query id 8255149363 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503582, not started MySQL thread id 1765964, OS thread handle 0x2bc967501700, query id 8255149187 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050502981, not started MySQL thread id 1765963, OS thread handle 0x2bc9674c0700, query id 8255148322 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050501280, not started MySQL thread id 1765962, OS thread handle 0x2bc96747f700, query id 8255145932 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050502589, not started MySQL thread id 1765961, OS thread handle 0x2bc96743e700, query id 8255147785 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050502828, not started MySQL thread id 1765960, OS thread handle 0x2bc9673fd700, query id 8255148155 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050502003, not started MySQL thread id 1765959, OS thread handle 0x2bc9673bc700, query id 8255146937 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050501485, not started MySQL thread id 1765958, OS thread handle 0x2bc96737b700, query id 8255146212 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503621, not started MySQL thread id 1765957, OS thread handle 0x2bc96733a700, query id 8255149216 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050501397, not started MySQL thread id 1765956, OS thread handle 0x2bc9672f9700, query id 8255146124 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503169, not started MySQL thread id 1765955, OS thread handle 0x2bc9672b8700, query id 8255148590 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503578, not started MySQL thread id 1765954, OS thread handle 0x2bc967277700, query id 8255149183 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504500, not started MySQL thread id 1765953, OS thread handle 0x2bc967236700, query id 8255150409 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503574, not started MySQL thread id 1765952, OS thread handle 0x2bc9671f5700, query id 8255149178 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503706, not started MySQL thread id 1765951, OS thread handle 0x2bc9671b4700, query id 8255149315 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050501654, not started MySQL thread id 1765950, OS thread handle 0x2bc967173700, query id 8255146543 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503568, not started MySQL thread id 1765949, OS thread handle 0x2bc967132700, query id 8255149173 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050501391, not started MySQL thread id 1765948, OS thread handle 0x2bc9670f1700, query id 8255146112 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050502919, not started MySQL thread id 1765947, OS thread handle 0x2bc9670b0700, query id 8255148252 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503145, not started MySQL thread id 1765946, OS thread handle 0x2bc96706f700, query id 8255148498 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050496105, not started MySQL thread id 1765925, OS thread handle 0x2bc966b1a700, query id 8255138317 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050494509, not started MySQL thread id 1765831, OS thread handle 0x2bc964f5e700, query id 8255136048 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050494503, not started MySQL thread id 1765837, OS thread handle 0x2bc965503700, query id 8255136040 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050383345, not started MySQL thread id 1765845, OS thread handle 0x2bc96570b700, query id 8254958835 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050414584, not started MySQL thread id 1765809, OS thread handle 0x2bc8ce104700, query id 8255004654 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050255549, not started MySQL thread id 1765811, OS thread handle 0x2bc8ce186700, query id 8254756147 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050486867, not started MySQL thread id 1765842, OS thread handle 0x2bc965648700, query id 8255125179 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050499160, not started MySQL thread id 1765841, OS thread handle 0x2bc965607700, query id 8255142278 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050487065, not started MySQL thread id 1765806, OS thread handle 0x2bc8ce041700, query id 8255125446 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050475489, not started MySQL thread id 1765803, OS thread handle 0x2bc7ad754700, query id 8255104882 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050501378, not started MySQL thread id 1765798, OS thread handle 0x2bc6583f0700, query id 8255146091 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050423357, not started MySQL thread id 1765800, OS thread handle 0x2bc7ad691700, query id 8255019060 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050496582, not started MySQL thread id 1765813, OS thread handle 0x2bc8ce208700, query id 8255138864 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050463108, not started MySQL thread id 1765808, OS thread handle 0x2bc8ce0c3700, query id 8255085431 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050497984, not started MySQL thread id 1765836, OS thread handle 0x2bc9654c2700, query id 8255140708 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050502677, not started MySQL thread id 1765807, OS thread handle 0x2bc8ce082700, query id 8255147907 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050473768, not started MySQL thread id 1765834, OS thread handle 0x2bc965440700, query id 8255101781 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050475484, not started MySQL thread id 1765805, OS thread handle 0x2bc7ad7d6700, query id 8255104878 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050389154, not started MySQL thread id 1765833, OS thread handle 0x2bc964fe0700, query id 8254967176 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050501960, not started MySQL thread id 1765804, OS thread handle 0x2bc7ad795700, query id 8255146895 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050439726, not started MySQL thread id 1765802, OS thread handle 0x2bc7ad713700, query id 8255046384 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050486636, not started MySQL thread id 1765801, OS thread handle 0x2bc7ad6d2700, query id 8255123728 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050476643, not started MySQL thread id 1765829, OS thread handle 0x2bc964edc700, query id 8255106858 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050474717, not started MySQL thread id 1765827, OS thread handle 0x2bc964e5a700, query id 8255103056 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050365505, not started MySQL thread id 1765826, OS thread handle 0x2bc964e19700, query id 8254930858 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050390874, not started MySQL thread id 1765823, OS thread handle 0x2bc964d56700, query id 8254969602 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050486828, not started MySQL thread id 1765821, OS thread handle 0x2bc964cd4700, query id 8255125103 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050504496, not started MySQL thread id 1765819, OS thread handle 0x2bc8ce38e700, query id 8255150406 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050366439, not started MySQL thread id 1765820, OS thread handle 0x2bc8ce3cf700, query id 8254932122 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050474525, not started MySQL thread id 1765818, OS thread handle 0x2bc8ce34d700, query id 8255102794 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050471609, not started MySQL thread id 1765816, OS thread handle 0x2bc8ce2cb700, query id 8255098860 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050261757, not started MySQL thread id 1765817, OS thread handle 0x2bc8ce30c700, query id 8254767232 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050290194, not started MySQL thread id 1765789, OS thread handle 0x2bb1883f0700, query id 8254811950 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050501381, not started MySQL thread id 1765815, OS thread handle 0x2bc8ce28a700, query id 8255146102 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050469588, not started MySQL thread id 1765814, OS thread handle 0x2bc8ce249700, query id 8255095979 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050384953, not started MySQL thread id 1765799, OS thread handle 0x2bc7ad650700, query id 8254960679 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050499987, not started MySQL thread id 1765797, OS thread handle 0x2bc4083f0700, query id 8255143378 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050383351, not started MySQL thread id 1765812, OS thread handle 0x2bc8ce1c7700, query id 8254958839 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050474592, not started MySQL thread id 1765778, OS thread handle 0x2b98183f0700, query id 8255102888 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050388685, not started MySQL thread id 1765791, OS thread handle 0x2bb6283f0700, query id 8254966544 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050392286, not started MySQL thread id 1765794, OS thread handle 0x2bbd183f0700, query id 8254971627 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050498115, not started MySQL thread id 1765793, OS thread handle 0x2bbac83f0700, query id 8255140863 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050480876, not started MySQL thread id 1765810, OS thread handle 0x2bc8ce145700, query id 8255113438 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050439952, not started MySQL thread id 1765784, OS thread handle 0x2ba5f83f0700, query id 8255046766 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050501992, not started MySQL thread id 1765795, OS thread handle 0x2bbf683f0700, query id 8255146927 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050469284, not started MySQL thread id 1765796, OS thread handle 0x2bc1b83f0700, query id 8255095522 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050466799, not started MySQL thread id 1765785, OS thread handle 0x2ba8483f0700, query id 8255091615 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050499174, not started MySQL thread id 1765781, OS thread handle 0x2b9f083f0700, query id 8255142296 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050490956, not started MySQL thread id 1765783, OS thread handle 0x2ba3a83f0700, query id 8255130982 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050480020, not started MySQL thread id 1765760, OS thread handle 0x2b7c0bff1700, query id 8255112180 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050496486, not started MySQL thread id 1765774, OS thread handle 0x2b8ed83f0700, query id 8255138752 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050326198, not started MySQL thread id 1765754, OS thread handle 0x2b7c0bfb0700, query id 8254868342 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050365466, not started MySQL thread id 1765792, OS thread handle 0x2bb8783f0700, query id 8254930771 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050444233, not started MySQL thread id 1765780, OS thread handle 0x2b9cb83f0700, query id 8255054235 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050500808, not started MySQL thread id 1765790, OS thread handle 0x2bb3d83f0700, query id 8255144415 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050391229, not started MySQL thread id 1765777, OS thread handle 0x2b95c83f0700, query id 8254970146 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050491751, not started MySQL thread id 1765786, OS thread handle 0x2baa983f0700, query id 8255132239 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050415225, not started MySQL thread id 1765787, OS thread handle 0x2bace83f0700, query id 8255005575 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050387568, not started MySQL thread id 1765779, OS thread handle 0x2b9a683f0700, query id 8254964331 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050476719, not started MySQL thread id 1765782, OS thread handle 0x2ba1583f0700, query id 8255106982 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050488230, not started MySQL thread id 1765788, OS thread handle 0x2baf383f0700, query id 8255126843 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050477706, not started MySQL thread id 1765776, OS thread handle 0x2b93783f0700, query id 8255108333 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050468265, not started MySQL thread id 1765772, OS thread handle 0x2b8a383f0700, query id 8255093869 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050401659, not started MySQL thread id 1765773, OS thread handle 0x2b8c883f0700, query id 8254985123 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050455499, not started MySQL thread id 1765775, OS thread handle 0x2b91283f0700, query id 8255073113 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050486800, not started MySQL thread id 1765771, OS thread handle 0x2b87e83f0700, query id 8255124941 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050486793, not started MySQL thread id 1765770, OS thread handle 0x2b85983f0700, query id 8255124915 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050496448, not started MySQL thread id 1765762, OS thread handle 0x2b7c0840a700, query id 8255138709 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050466641, not started MySQL thread id 1765766, OS thread handle 0x2b7c503da700, query id 8255091336 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050452764, not started MySQL thread id 1765767, OS thread handle 0x2b7ea83f0700, query id 8255068917 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050503604, not started MySQL thread id 1765769, OS thread handle 0x2b83483f0700, query id 8255149205 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050355352, not started MySQL thread id 1765768, OS thread handle 0x2b80f83f0700, query id 8254913878 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050502873, not started MySQL thread id 1765765, OS thread handle 0x2b7c50399700, query id 8255148202 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050444118, not started MySQL thread id 1765761, OS thread handle 0x2b7c0848c700, query id 8255054075 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050481788, not started MySQL thread id 1765763, OS thread handle 0x2b7c50317700, query id 8255114643 localhost 127.0.0.1 zabbix_server cleaning up ---TRANSACTION 205050497862, ACTIVE 9 sec mysql tables in use 11, locked 0 MySQL thread id 105672725, OS thread handle 0x2bcbe8c81700, query id 8255140575 localhost zabbix_server Sending data SELECT DISTINCT t.triggerid,t.expression,t.description,t.url,t.priority,t.lastchange,t.comments,t.error,t.state FROM triggers t,functions f,items i,hosts_groups hg WHERE NOT EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid='12' WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY i.hostid HAVING MAX(permission)<'2' OR MIN(permission) IS NULL OR MIN(permission)=0) AND hg.hostid=i.hostid AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND hg.groupid='822' AND NOT EXISTS (SELECT NULL FROM function Trx read view will not see trx with id >= 205050497863, sees < 205050483696 ---TRANSACTION 205050497854, ACTIVE 9 sec starting index read mysql tables in use 11, locked 0 MySQL thread id 105672724, OS thread handle 0x2b7c0844b700, query id 8255140555 localhost zabbix_server Sending data SELECT DISTINCT t.triggerid,t.priority,t.state,t.description,t.error,t.value,t.lastchange,t.expression FROM triggers t,functions f,items i,hosts_groups hg WHERE NOT EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid='12' WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY i.hostid HAVING MAX(permission)<'2' OR MIN(permission) IS NULL OR MIN(permission)=0) AND hg.hostid=i.hostid AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND hg.groupid='822' AND NOT EXISTS (SELECT NULL FROM functions f,items Trx read view will not see trx with id >= 205050497855, sees < 205050483696 -------- 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 76715300 OS file reads, 24213279431 OS file writes, 885504593 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 2958.07 writes/s, 116.49 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 195354, seg size 195356, 513711 merges merged operations: insert 329703, delete mark 2819685, delete 516757 discarded operations: insert 0, delete mark 0, delete 0 1163278.62 hash searches/s, 391067.07 non-hash searches/s --- LOG --- Log sequence number 196733950333966 Log flushed up to 196733950314171 Pages flushed up to 196732855741745 Last checkpoint at 196732855741745 Max checkpoint age 2608479868 Checkpoint age target 2526964873 Modified age 1094592221 Checkpoint age 1094592221 0 pending log writes, 0 pending chkp writes 871977439 log i/o's done, 128.36 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 317011787776; in additional pool allocated 0 Total memory allocated by read views 176808 Internal hash tables (constant factor + variable factor) Adaptive hash index 7232306080 (4821265208 + 2411040872) Page hash 9417368 (buffer pool 0 only) Dictionary cache 1208441420 (1205317936 + 3123484) File system 1147432 (812272 + 335160) Lock system 753421696 (753324856 + 96840) Recovery system 0 (0 + 0) Dictionary memory allocated 3123484 Buffer pool size 18586464 Buffer pool size, bytes 304520626176 Free buffers 32771 Database pages 18406535 Old database pages 6793942 Modified db pages 850765 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 45134186, not young 308002294 0.00 youngs/s, 0.00 non-youngs/s Pages read 76752477, created 892279551, written 22935401049 0.00 reads/s, 134.85 creates/s, 2780.09 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: 18406535, unzip_LRU len: 0 I/O sum[4603008]:cur[78304], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 580827 Buffer pool size, bytes 9516269568 Free buffers 1024 Database pages 575219 Old database pages 212316 Modified db pages 28799 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1452941, not young 11758158 0.00 youngs/s, 0.00 non-youngs/s Pages read 2396746, created 27845207, written 747064476 0.00 reads/s, 13.64 creates/s, 78.49 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: 575219, unzip_LRU len: 0 I/O sum[143844]:cur[2447], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 580827 Buffer pool size, bytes 9516269568 Free buffers 1024 Database pages 575213 Old database pages 212314 Modified db pages 24424 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1393011, not young 10698149 0.00 youngs/s, 0.00 non-youngs/s Pages read 2389068, created 27911960, written 718356193 0.00 reads/s, 4.64 creates/s, 85.78 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: 575213, unzip_LRU len: 0 I/O sum[143844]:cur[2447], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 580827 Buffer pool size, bytes 9516269568 Free buffers 1025 Database pages 575185 Old database pages 212304 Modified db pages 28311 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1390223, not young 10149164 0.00 youngs/s, 0.00 non-youngs/s Pages read 2397862, created 27847449, written 712671693 0.00 reads/s, 4.57 creates/s, 93.92 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 575185, unzip_LRU len: 0 I/O sum[143844]:cur[2447], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 580827 Buffer pool size, bytes 9516269568 Free buffers 1024 Database pages 575141 Old database pages 212287 Modified db pages 24474 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1447332, not young 9444926 0.00 youngs/s, 0.00 non-youngs/s Pages read 2401795, created 27892590, written 716901033 0.00 reads/s, 9.07 creates/s, 77.57 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: 575141, unzip_LRU len: 0 I/O sum[143844]:cur[2447], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 580827 Buffer pool size, bytes 9516269568 Free buffers 1024 Database pages 575233 Old database pages 212321 Modified db pages 26640 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1388795, not young 9266048 0.00 youngs/s, 0.00 non-youngs/s Pages read 2394288, created 27880888, written 716488862 0.00 reads/s, 12.00 creates/s, 82.64 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: 575233, unzip_LRU len: 0 I/O sum[143844]:cur[2447], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 580827 Buffer pool size, bytes 9516269568 Free buffers 1024 Database pages 575183 Old database pages 212303 Modified db pages 27462 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1385471, not young 9808166 0.00 youngs/s, 0.00 non-youngs/s Pages read 2396481, created 27892123, written 714869292 0.00 reads/s, 0.57 creates/s, 91.64 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: 575183, unzip_LRU len: 0 I/O sum[143844]:cur[2447], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 580827 Buffer pool size, bytes 9516269568 Free buffers 1024 Database pages 575186 Old database pages 212304 Modified db pages 24582 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1414985, not young 10800783 0.00 youngs/s, 0.00 non-youngs/s Pages read 2402918, created 27900787, written 718740195 0.00 reads/s, 6.14 creates/s, 74.78 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: 575186, unzip_LRU len: 0 I/O sum[143844]:cur[2447], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 580827 Buffer pool size, bytes 9516269568 Free buffers 1024 Database pages 575191 Old database pages 212306 Modified db pages 27007 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1424240, not young 10192060 0.00 youngs/s, 0.00 non-youngs/s Pages read 2399156, created 27840854, written 712417976 0.00 reads/s, 0.14 creates/s, 83.78 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: 575191, unzip_LRU len: 0 I/O sum[143844]:cur[2447], unzip sum[0]:cur[0] ---BUFFER POOL 8 Buffer pool size 580827 Buffer pool size, bytes 9516269568 Free buffers 1024 Database pages 575137 Old database pages 212286 Modified db pages 27401 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1415370, not young 9643796 0.00 youngs/s, 0.00 non-youngs/s Pages read 2401499, created 27897926, written 716417330 0.00 reads/s, 0.64 creates/s, 92.71 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: 575137, unzip_LRU len: 0 I/O sum[143844]:cur[2447], unzip sum[0]:cur[0] ---BUFFER POOL 9 Buffer pool size 580827 Buffer pool size, bytes 9516269568 Free buffers 1024 Database pages 575250 Old database pages 212328 Modified db pages 25867 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1425914, not young 9146115 0.00 youngs/s, 0.00 non-youngs/s Pages read 2404856, created 27908657, written 714012050 0.00 reads/s, 4.57 creates/s, 86.07 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: 575250, unzip_LRU len: 0 I/O sum[143844]:cur[2447], unzip sum[0]:cur[0] ---BUFFER POOL 10 Buffer pool size 580827 Buffer pool size, bytes 9516269568 Free buffers 1024 Database pages 575201 Old database pages 212310 Modified db pages 26807 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1389673, not young 9086175 0.00 youngs/s, 0.00 non-youngs/s Pages read 2396090, created 27928059, written 717349765 0.00 reads/s, 4.79 creates/s, 93.71 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: 575201, unzip_LRU len: 0 I/O sum[143844]:cur[2447], unzip sum[0]:cur[0] ---BUFFER POOL 11 Buffer pool size 580827 Buffer pool size, bytes 9516269568 Free buffers 1024 Database pages 575240 Old database pages 212324 Modified db pages 25666 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1443063, not young 9836196 0.00 youngs/s, 0.00 non-youngs/s Pages read 2401177, created 27904754, written 716139389 0.00 reads/s, 0.36 creates/s, 90.42 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: 575240, unzip_LRU len: 0 I/O sum[143844]:cur[2447], unzip sum[0]:cur[0] ---BUFFER POOL 12 Buffer pool size 580827 Buffer pool size, bytes 9516269568 Free buffers 1024 Database pages 575171 Old database pages 212298 Modified db pages 27150 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1416853, not young 10344102 0.00 youngs/s, 0.00 non-youngs/s Pages read 2408452, created 27843365, written 714689637 0.00 reads/s, 4.57 creates/s, 86.92 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 575171, unzip_LRU len: 0 I/O sum[143844]:cur[2447], unzip sum[0]:cur[0] ---BUFFER POOL 13 Buffer pool size 580827 Buffer pool size, bytes 9516269568 Free buffers 1024 Database pages 575229 Old database pages 212320 Modified db pages 26513 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1406592, not young 8215912 0.00 youngs/s, 0.00 non-youngs/s Pages read 2392033, created 27912235, written 715796841 0.00 reads/s, 3.14 creates/s, 82.78 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: 575229, unzip_LRU len: 0 I/O sum[143844]:cur[2447], unzip sum[0]:cur[0] ---BUFFER POOL 14 Buffer pool size 580827 Buffer pool size, bytes 9516269568 Free buffers 1024 Database pages 575206 Old database pages 212311 Modified db pages 26129 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1380985, not young 8872580 0.00 youngs/s, 0.00 non-youngs/s Pages read 2405632, created 27915491, written 715876082 0.00 reads/s, 4.57 creates/s, 97.78 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: 575206, unzip_LRU len: 0 I/O sum[143844]:cur[2447], unzip sum[0]:cur[0] ---BUFFER POOL 15 Buffer pool size 580827 Buffer pool size, bytes 9516269568 Free buffers 1024 Database pages 575200 Old database pages 212309 Modified db pages 27741 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1392619, not young 9749312 0.00 youngs/s, 0.00 non-youngs/s Pages read 2395640, created 27909547, written 717967685 0.00 reads/s, 0.07 creates/s, 94.14 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: 575200, unzip_LRU len: 0 I/O sum[143844]:cur[2447], unzip sum[0]:cur[0] ---BUFFER POOL 16 Buffer pool size 580827 Buffer pool size, bytes 9516269568 Free buffers 1024 Database pages 575232 Old database pages 212321 Modified db pages 26540 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1406617, not young 10526821 0.00 youngs/s, 0.00 non-youngs/s Pages read 2400806, created 27894086, written 716639892 0.00 reads/s, 3.71 creates/s, 78.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: 575232, unzip_LRU len: 0 I/O sum[143844]:cur[2447], unzip sum[0]:cur[0] ---BUFFER POOL 17 Buffer pool size 580827 Buffer pool size, bytes 9516269568 Free buffers 1025 Database pages 575280 Old database pages 212339 Modified db pages 25463 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1375729, not young 10588191 0.00 youngs/s, 0.00 non-youngs/s Pages read 2381394, created 27820272, written 713765022 0.00 reads/s, 4.57 creates/s, 94.49 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: 575280, unzip_LRU len: 0 I/O sum[143844]:cur[2447], unzip sum[0]:cur[0] ---BUFFER POOL 18 Buffer pool size 580827 Buffer pool size, bytes 9516269568 Free buffers 1024 Database pages 575254 Old database pages 212329 Modified db pages 27976 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1377625, not young 8713306 0.00 youngs/s, 0.00 non-youngs/s Pages read 2392355, created 27896962, written 714276866 0.00 reads/s, 0.07 creates/s, 86.57 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: 575254, unzip_LRU len: 0 I/O sum[143844]:cur[2447], unzip sum[0]:cur[0] ---BUFFER POOL 19 Buffer pool size 580827 Buffer pool size, bytes 9516269568 Free buffers 1024 Database pages 575252 Old database pages 212328 Modified db pages 26747 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1404869, not young 8460460 0.00 youngs/s, 0.00 non-youngs/s Pages read 2398185, created 27881476, written 714817435 0.00 reads/s, 1.93 creates/s, 82.49 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: 575252, unzip_LRU len: 0 I/O sum[143844]:cur[2447], unzip sum[0]:cur[0] ---BUFFER POOL 20 Buffer pool size 580827 Buffer pool size, bytes 9516269568 Free buffers 1025 Database pages 575205 Old database pages 212311 Modified db pages 27054 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1410356, not young 8275035 0.00 youngs/s, 0.00 non-youngs/s Pages read 2403599, created 27929564, written 719064011 0.00 reads/s, 4.64 creates/s, 76.57 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: 575205, unzip_LRU len: 0 I/O sum[143844]:cur[2447], unzip sum[0]:cur[0] ---BUFFER POOL 21 Buffer pool size 580827 Buffer pool size, bytes 9516269568 Free buffers 1024 Database pages 575183 Old database pages 212303 Modified db pages 26954 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1438478, not young 9838020 0.00 youngs/s, 0.00 non-youngs/s Pages read 2400275, created 27899671, written 716205036 0.00 reads/s, 4.57 creates/s, 74.78 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: 575183, unzip_LRU len: 0 I/O sum[143844]:cur[2447], unzip sum[0]:cur[0] ---BUFFER POOL 22 Buffer pool size 580827 Buffer pool size, bytes 9516269568 Free buffers 1024 Database pages 575211 Old database pages 212313 Modified db pages 26819 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1408970, not young 9869444 0.00 youngs/s, 0.00 non-youngs/s Pages read 2403547, created 27832751, written 712762447 0.00 reads/s, 0.14 creates/s, 75.71 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: 575211, unzip_LRU len: 0 I/O sum[143844]:cur[2447], unzip sum[0]:cur[0] ---BUFFER POOL 23 Buffer pool size 580827 Buffer pool size, bytes 9516269568 Free buffers 1024 Database pages 575193 Old database pages 212307 Modified db pages 27554 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1422920, not young 10270809 0.00 youngs/s, 0.00 non-youngs/s Pages read 2391295, created 27878211, written 715961461 0.00 reads/s, 4.57 creates/s, 86.14 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: 575193, unzip_LRU len: 0 I/O sum[143844]:cur[2447], unzip sum[0]:cur[0] ---BUFFER POOL 24 Buffer pool size 580827 Buffer pool size, bytes 9516269568 Free buffers 1024 Database pages 575211 Old database pages 212313 Modified db pages 25808 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1396965, not young 8991887 0.00 youngs/s, 0.00 non-youngs/s Pages read 2394365, created 27890038, written 713813172 0.00 reads/s, 4.57 creates/s, 74.14 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: 575211, unzip_LRU len: 0 I/O sum[143844]:cur[2447], unzip sum[0]:cur[0] ---BUFFER POOL 25 Buffer pool size 580827 Buffer pool size, bytes 9516269568 Free buffers 1024 Database pages 575154 Old database pages 212292 Modified db pages 26658 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1405638, not young 8179908 0.00 youngs/s, 0.00 non-youngs/s Pages read 2397288, created 27909266, written 716284463 0.00 reads/s, 6.79 creates/s, 105.49 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: 575154, unzip_LRU len: 0 I/O sum[143844]:cur[2447], unzip sum[0]:cur[0] ---BUFFER POOL 26 Buffer pool size 580827 Buffer pool size, bytes 9516269568 Free buffers 1024 Database pages 575176 Old database pages 212300 Modified db pages 24662 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1418714, not young 8814510 0.00 youngs/s, 0.00 non-youngs/s Pages read 2406133, created 27871703, written 716659736 0.00 reads/s, 0.93 creates/s, 86.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: 575176, unzip_LRU len: 0 I/O sum[143844]:cur[2447], unzip sum[0]:cur[0] ---BUFFER POOL 27 Buffer pool size 580827 Buffer pool size, bytes 9516269568 Free buffers 1024 Database pages 575194 Old database pages 212307 Modified db pages 27504 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1428887, not young 11184404 0.00 youngs/s, 0.00 non-youngs/s Pages read 2397666, created 27825724, written 713795356 0.00 reads/s, 4.57 creates/s, 95.35 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: 575194, unzip_LRU len: 0 I/O sum[143844]:cur[2447], unzip sum[0]:cur[0] ---BUFFER POOL 28 Buffer pool size 580827 Buffer pool size, bytes 9516269568 Free buffers 1024 Database pages 575210 Old database pages 212313 Modified db pages 27044 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1453094, not young 11190964 0.00 youngs/s, 0.00 non-youngs/s Pages read 2397600, created 27875337, written 716490333 0.00 reads/s, 9.14 creates/s, 118.13 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: 575210, unzip_LRU len: 0 I/O sum[143844]:cur[2447], unzip sum[0]:cur[0] ---BUFFER POOL 29 Buffer pool size 580827 Buffer pool size, bytes 9516269568 Free buffers 1024 Database pages 575243 Old database pages 212325 Modified db pages 26112 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1394683, not young 9020234 0.00 youngs/s, 0.00 non-youngs/s Pages read 2398096, created 27857299, written 714000628 0.00 reads/s, 0.14 creates/s, 84.21 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: 575243, unzip_LRU len: 0 I/O sum[143844]:cur[2447], unzip sum[0]:cur[0] ---BUFFER POOL 30 Buffer pool size 580827 Buffer pool size, bytes 9516269568 Free buffers 1024 Database pages 575141 Old database pages 212287 Modified db pages 26848 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1409975, not young 8035135 0.00 youngs/s, 0.00 non-youngs/s Pages read 2399815, created 27902945, written 715556763 0.00 reads/s, 7.14 creates/s, 80.49 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: 575141, unzip_LRU len: 0 I/O sum[143844]:cur[2447], unzip sum[0]:cur[0] ---BUFFER POOL 31 Buffer pool size 580827 Buffer pool size, bytes 9516269568 Free buffers 1024 Database pages 575211 Old database pages 212313 Modified db pages 26049 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1412599, not young 9031524 0.00 youngs/s, 0.00 non-youngs/s Pages read 2406365, created 27882354, written 719549929 0.00 reads/s, 3.86 creates/s, 87.85 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: 575211, unzip_LRU len: 0 I/O sum[143844]:cur[2447], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB 2 RW transactions active inside InnoDB 0 RO transactions active inside InnoDB 2 out of 1000 descriptors used ---OLDEST VIEW--- Normal read view Read view low limit trx n:o 205050497855 Read view up limit trx id 205050483696 Read view low limit trx id 205050497855 Read view individually stored trx ids: Read view trx id 205050483696 Read view trx id 205050484068 Read view trx id 205050484273 Read view trx id 205050486589 Read view trx id 205050488962 Read view trx id 205050491771 Read view trx id 205050497841 Read view trx id 205050497845 Read view trx id 205050497853 ----------------- Main thread process no. 5890, id 48141449561856, state: sleeping Number of rows inserted 159333257348, updated 5977578406, deleted 24840080, read 4954382771943 29528.46 inserts/s, 1286.62 updates/s, 0.50 deletes/s, 1541220.13 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 1 row in set (0.01 sec) ERROR: No query specified