lock: 0x1dddf40: lock: 0x1dddb20: lock: 0x1dddbe0: lock: 0x1dddca0: lock: 0x1ddf4c0: ===================================== 2018-11-21 07:05:14 0x7f72438e6700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 15 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 2866 srv_active, 0 srv_shutdown, 1 srv_idle srv_master_thread log flush and writes: 2866 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 16543 OS WAIT ARRAY INFO: signal count 14726 RW-shared spins 0, rounds 28070, OS waits 5403 RW-excl spins 0, rounds 124866, OS waits 1083 RW-sx spins 1614, rounds 37158, OS waits 621 Spin rounds per wait: 28070.00 RW-shared, 124866.00 RW-excl, 23.02 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1303691556 Purge done for trx's n:o < 1303691451 undo n:o < 0 state: running but idle History list length 2 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 421623093548120, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093545800, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093542320, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093537680, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093534200, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093520280, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093514480, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093456480, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093455320, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093454160, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093453000, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093451840, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093450680, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093449520, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093446040, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093444880, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093443720, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093441400, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093437920, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093448360, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093427480, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093415880, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093436760, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093435600, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093430960, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093426320, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093422840, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093418200, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093414720, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093413560, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093412400, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093411240, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093410080, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093407760, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093406600, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093404280, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093385720, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093384560, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093379920, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093357880, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093388040, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093408920, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093371800, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093405440, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093356720, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093383400, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093367160, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093382240, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093342800, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093370640, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093345120, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093350920, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093381080, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093403120, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093355560, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093389200, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093366000, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093341640, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093401960, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093362520, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093364840, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093386880, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093354400, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093363680, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093349760, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093400800, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093399640, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093398480, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093397320, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093372960, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093396160, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093395000, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093393840, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093392680, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093391520, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093377600, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093375280, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093374120, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093368320, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093353240, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093348600, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093360200, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093369480, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093390360, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093346280, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093376440, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093378760, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093343960, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093361360, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093352080, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093347440, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421623093340480, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 1303691555, ACTIVE (PREPARED) 0 sec mysql tables in use 1, locked 1 4 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 1 MySQL thread id 28118, OS thread handle 140128548656896, query id 6299442 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602181) UPDATE tbl_eventsongoing SET endtime = ?, accesstime = ?, frames = ?, bytes = ? WHERE cameraid=? AND device_mapping=? ---TRANSACTION 1303691554, ACTIVE (PREPARED) 1 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28115, OS thread handle 140128549455616, query id 6299386 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602180) INSERT INTO tbl_edge_evnts (starttime, endtime, evtype, cameraid, videosource, nasid, userid, format, rate, resolution, evduration, device_mapping, videocodec, audiocodec, recordingid, recording_status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691553, ACTIVE (PREPARED) 1 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28112, OS thread handle 140128550254336, query id 6299337 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602179) INSERT INTO tbl_edge_evnts (starttime, endtime, evtype, cameraid, videosource, nasid, userid, format, rate, resolution, evduration, device_mapping, videocodec, audiocodec, recordingid, recording_status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691552, ACTIVE (PREPARED) 1 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28113, OS thread handle 140128549988096, query id 6299335 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 tblsecuritas wsrep: pre-commit/certification passed (777602178) INSERT INTO tbl_devicestorage_av SET `deviceid` = 'ACCC8EB8689B', `storageid` = 'NetworkShare', `timestamp` = '1542783851606286', `published` = 0 ---TRANSACTION 1303691551, ACTIVE (PREPARED) 1 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 25782, OS thread handle 140129178707712, query id 6299329 prod-db-eu-proxysql-02.node.dc1.consul 10.0.101.117 db_healthg4 wsrep: pre-commit/certification passed (777602177) INSERT INTO tbl_devicestorage_av SET `deviceid` = 'ACCC8E884EC5', `storageid` = 'SD_DISK', `timestamp` = '1542783851077449', `published` = 0 ---TRANSACTION 1303691549, ACTIVE (PREPARED) 1 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28110, OS thread handle 140128550786816, query id 6299315 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602176) INSERT INTO tbl_edge_evnts (starttime, endtime, evtype, cameraid, videosource, nasid, userid, format, rate, resolution, evduration, device_mapping, videocodec, audiocodec, recordingid, recording_status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691548, ACTIVE (PREPARED) 1 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28109, OS thread handle 140128551053056, query id 6299310 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602175) INSERT INTO tbl_edge_evnts (starttime, endtime, evtype, cameraid, videosource, nasid, userid, format, rate, resolution, evduration, device_mapping, videocodec, audiocodec, recordingid, recording_status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691546, ACTIVE (PREPARED) 1 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28100, OS thread handle 140128553449216, query id 6299302 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 securitas_avhs wsrep: pre-commit/certification passed (777602174) INSERT INTO tbl_edge_evnts (starttime, endtime, evtype, cameraid, videosource, nasid, userid, format, rate, resolution, evduration, device_mapping, videocodec, audiocodec, recordingid, recording_status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691545, ACTIVE (PREPARED) 1 sec mysql tables in use 1, locked 1 4 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 1 MySQL thread id 28108, OS thread handle 140128551319296, query id 6299299 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602173) UPDATE tbl_eventsongoing SET endtime = ?, accesstime = ?, frames = ?, bytes = ? WHERE cameraid=? AND device_mapping=? ---TRANSACTION 1303691544, ACTIVE (PREPARED) 1 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28104, OS thread handle 140128552384256, query id 6299292 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602172) INSERT INTO tbl_edge_evnts (starttime, endtime, evtype, cameraid, videosource, nasid, userid, format, rate, resolution, evduration, device_mapping, videocodec, audiocodec, recordingid, recording_status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691542, ACTIVE (PREPARED) 1 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28105, OS thread handle 140128552118016, query id 6299249 prod-db-eu-proxysql-02.node.dc1.consul 10.0.101.117 tblsecuritas wsrep: pre-commit/certification passed (777602171) INSERT INTO tbl_devicestorage_av SET `deviceid` = 'ACCC8E81F993', `storageid` = 'NetworkShare', `timestamp` = '1542783852097250', `published` = 0 ---TRANSACTION 1303691541, ACTIVE (PREPARED) 1 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28102, OS thread handle 140128552916736, query id 6299236 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602170) INSERT INTO tbl_eventsongoing (starttime, endtime, accesstime, evtype, server, cameraid, videosource, nasid, userid, format, rate, evduration, frames, bytes, videocodec, audiocodec, evcomment, resolution, evpath, device_mapping) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691540, ACTIVE (PREPARED) 1 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 17477, OS thread handle 140129178175232, query id 6299232 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 tblsecuritas wsrep: pre-commit/certification passed (777602169) INSERT INTO tbl_devicestorage_av SET `deviceid` = 'ACCC8E9D8726', `storageid` = 'NetworkShare', `timestamp` = '1542783851918281', `published` = 0 ---TRANSACTION 1303691539, ACTIVE (PREPARED) 1 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28099, OS thread handle 140128553715456, query id 6299216 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602168) INSERT INTO tbl_eventsongoing (starttime, endtime, accesstime, evtype, server, cameraid, videosource, nasid, userid, format, rate, evduration, frames, bytes, videocodec, audiocodec, evcomment, resolution, evpath, device_mapping) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691538, ACTIVE (PREPARED) 1 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28098, OS thread handle 140128553981696, query id 6299201 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602167) INSERT INTO tbl_eventsongoing (starttime, endtime, accesstime, evtype, server, cameraid, videosource, nasid, userid, format, rate, evduration, frames, bytes, videocodec, audiocodec, evcomment, resolution, evpath, device_mapping) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691537, ACTIVE (PREPARED) 1 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28097, OS thread handle 140128554247936, query id 6299186 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602166) INSERT INTO tbl_eventsongoing (starttime, endtime, accesstime, evtype, server, cameraid, videosource, nasid, userid, format, rate, evduration, frames, bytes, videocodec, audiocodec, evcomment, resolution, evpath, device_mapping) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691536, ACTIVE (PREPARED) 1 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28093, OS thread handle 140128555312896, query id 6299161 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 securitas_avhs wsrep: pre-commit/certification passed (777602165) INSERT INTO tbl_edge_evnts (starttime, endtime, evtype, cameraid, videosource, nasid, userid, format, rate, resolution, evduration, device_mapping, videocodec, audiocodec, recordingid, recording_status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691535, ACTIVE (PREPARED) 1 sec mysql tables in use 1, locked 1 5 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 1 MySQL thread id 28096, OS thread handle 140128554514176, query id 6299153 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602164) UPDATE tbl_eventsongoing SET endtime = ?, accesstime = ?, frames = ?, bytes = ? WHERE cameraid=? AND device_mapping=? ---TRANSACTION 1303691534, ACTIVE (PREPARED) 1 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28095, OS thread handle 140128554780416, query id 6299136 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602163) INSERT INTO tbl_eventsongoing (starttime, endtime, accesstime, evtype, server, cameraid, videosource, nasid, userid, format, rate, evduration, frames, bytes, videocodec, audiocodec, evcomment, resolution, evpath, device_mapping) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691533, ACTIVE (PREPARED) 1 sec mysql tables in use 1, locked 1 5 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 1 MySQL thread id 28094, OS thread handle 140128555046656, query id 6299112 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602162) UPDATE tbl_eventsongoing SET endtime = ?, accesstime = ?, frames = ?, bytes = ? WHERE cameraid=? AND device_mapping=? ---TRANSACTION 1303691532, ACTIVE 2 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 28086, OS thread handle 140128557176576, query id 6299093 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 securitas_avhs Searching rows for update UPDATE tbl_edge_evnts SET starttime = ?, endtime = ?, evtype = ?, cameraid = ?, videosource = ?, nasid = ?, userid = ?, format = ?, rate = ?, resolution = ?, evduration = ?, device_mapping = ?, videocodec = ?, audiocodec = ?, recordingid = ?, recording_status = ? WHERE device_mapping=? ------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 5866 page no 25704 n bits 248 index device_mapping of table `securitas__350__avhs`.`tbl_edge_evnts` trx id 1303691532 lock_mode X waiting ------------------ ---TRANSACTION 1303691531, ACTIVE (PREPARED) 2 sec mysql tables in use 1, locked 1 4 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 1 MySQL thread id 28091, OS thread handle 140128555845376, query id 6299089 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602161) UPDATE tbl_eventsongoing SET endtime = ?, accesstime = ?, frames = ?, bytes = ? WHERE cameraid=? AND device_mapping=? ---TRANSACTION 1303691530, ACTIVE (PREPARED) 2 sec mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1 MySQL thread id 28057, OS thread handle 140128564897536, query id 6299085 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 demo_avhs wsrep: pre-commit/certification passed (777602160) UPDATE tbl_eventsongoing SET endtime = ?, bytes = ? WHERE starttime=? AND cameraid=? AND evtype=? ---TRANSACTION 1303691529, ACTIVE (PREPARED) 2 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28090, OS thread handle 140128556111616, query id 6299076 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602159) INSERT INTO tbl_edge_evnts (starttime, endtime, evtype, cameraid, videosource, nasid, userid, format, rate, resolution, evduration, device_mapping, videocodec, audiocodec, recordingid, recording_status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691528, ACTIVE (PREPARED) 2 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28087, OS thread handle 140128556910336, query id 6299071 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602158) INSERT INTO tbl_edge_evnts (starttime, endtime, evtype, cameraid, videosource, nasid, userid, format, rate, resolution, evduration, device_mapping, videocodec, audiocodec, recordingid, recording_status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691527, ACTIVE (PREPARED) 2 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28088, OS thread handle 140128556644096, query id 6299053 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602157) INSERT INTO tbl_eventsongoing (starttime, endtime, accesstime, evtype, server, cameraid, videosource, nasid, userid, format, rate, evduration, frames, bytes, videocodec, audiocodec, evcomment, resolution, evpath, device_mapping) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691524, ACTIVE (PREPARED) 2 sec mysql tables in use 1, locked 1 5 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 1 MySQL thread id 28083, OS thread handle 140128557975296, query id 6298939 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602156) UPDATE tbl_eventsongoing SET endtime = ?, accesstime = ?, frames = ?, bytes = ? WHERE cameraid=? AND device_mapping=? ---TRANSACTION 1303691523, ACTIVE 2 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 28085, OS thread handle 140128557442816, query id 6298935 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 securitas_avhs Searching rows for update UPDATE tbl_edge_evnts SET starttime = ?, endtime = ?, evtype = ?, cameraid = ?, videosource = ?, nasid = ?, userid = ?, format = ?, rate = ?, resolution = ?, evduration = ?, device_mapping = ?, videocodec = ?, audiocodec = ?, recordingid = ?, recording_status = ? WHERE device_mapping=? ------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 5866 page no 25704 n bits 248 index device_mapping of table `securitas__350__avhs`.`tbl_edge_evnts` trx id 1303691523 lock_mode X waiting ------------------ ---TRANSACTION 1303691522, ACTIVE (PREPARED) 2 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28081, OS thread handle 140128558507776, query id 6298930 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 securitas_avhs wsrep: pre-commit/certification passed (777602155) INSERT INTO tbl_edge_evnts (starttime, endtime, evtype, cameraid, videosource, nasid, userid, format, rate, resolution, evduration, device_mapping, videocodec, audiocodec, recordingid, recording_status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691521, ACTIVE (PREPARED) 2 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28082, OS thread handle 140128558241536, query id 6298895 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602154) INSERT INTO tbl_eventsongoing (starttime, endtime, accesstime, evtype, server, cameraid, videosource, nasid, userid, format, rate, evduration, frames, bytes, videocodec, audiocodec, evcomment, resolution, evpath, device_mapping) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691520, ACTIVE 2 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 28080, OS thread handle 140128558774016, query id 6298880 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s Searching rows for update UPDATE tbl_edge_evnts SET starttime = ?, endtime = ?, evtype = ?, cameraid = ?, videosource = ?, nasid = ?, userid = ?, format = ?, rate = ?, resolution = ?, evduration = ?, device_mapping = ?, videocodec = ?, audiocodec = ?, recordingid = ?, recording_status = ? WHERE device_mapping=? ------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 5868 page no 127747 n bits 416 index device_mapping of table `g4s__350__avhs`.`tbl_edge_evnts` trx id 1303691520 lock_mode X waiting ------------------ ---TRANSACTION 1303691519, ACTIVE (PREPARED) 2 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28079, OS thread handle 140128559040256, query id 6298873 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602153) INSERT INTO tbl_edge_evnts (starttime, endtime, evtype, cameraid, videosource, nasid, userid, format, rate, resolution, evduration, device_mapping, videocodec, audiocodec, recordingid, recording_status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691518, ACTIVE (PREPARED) 2 sec mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1 MySQL thread id 95, OS thread handle 140148341016320, query id 6298859 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 video_eu_avhs wsrep: pre-commit/certification passed (777602152) UPDATE phpsessions SET session_data = ?, session_expires = ? WHERE id = ? ---TRANSACTION 1303691517, ACTIVE (PREPARED) 2 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28076, OS thread handle 140128559838976, query id 6298856 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 securitas_avhs wsrep: pre-commit/certification passed (777602151) INSERT INTO tbl_edge_evnts (starttime, endtime, evtype, cameraid, videosource, nasid, userid, format, rate, resolution, evduration, device_mapping, videocodec, audiocodec, recordingid, recording_status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691516, ACTIVE (PREPARED) 2 sec mysql tables in use 1, locked 1 5 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 1 MySQL thread id 28075, OS thread handle 140128560105216, query id 6298780 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602150) UPDATE tbl_eventsongoing SET endtime = ?, accesstime = ?, frames = ?, bytes = ? WHERE cameraid=? AND device_mapping=? ---TRANSACTION 1303691515, ACTIVE (PREPARED) 2 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28078, OS thread handle 140128559306496, query id 6298771 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602149) INSERT INTO tbl_eventsongoing (starttime, endtime, accesstime, evtype, server, cameraid, videosource, nasid, userid, format, rate, evduration, frames, bytes, videocodec, audiocodec, evcomment, resolution, evpath, device_mapping) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691514, ACTIVE (PREPARED) 2 sec mysql tables in use 1, locked 1 4 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 1 MySQL thread id 28077, OS thread handle 140128559572736, query id 6298755 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602148) UPDATE tbl_eventsongoing SET endtime = ?, accesstime = ?, frames = ?, bytes = ? WHERE cameraid=? AND device_mapping=? ---TRANSACTION 1303691511, ACTIVE 2 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 28074, OS thread handle 140128560371456, query id 6298704 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 securitas_avhs Searching rows for update UPDATE tbl_edge_evnts SET starttime = ?, endtime = ?, evtype = ?, cameraid = ?, videosource = ?, nasid = ?, userid = ?, format = ?, rate = ?, resolution = ?, evduration = ?, device_mapping = ?, videocodec = ?, audiocodec = ?, recordingid = ?, recording_status = ? WHERE device_mapping=? ------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 5866 page no 25704 n bits 248 index device_mapping of table `securitas__350__avhs`.`tbl_edge_evnts` trx id 1303691511 lock_mode X waiting ------------------ ---TRANSACTION 1303691509, ACTIVE (PREPARED) 3 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28073, OS thread handle 140128560637696, query id 6298635 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602147) INSERT INTO tbl_eventsongoing (starttime, endtime, accesstime, evtype, server, cameraid, videosource, nasid, userid, format, rate, evduration, frames, bytes, videocodec, audiocodec, evcomment, resolution, evpath, device_mapping) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691508, ACTIVE (PREPARED) 3 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28068, OS thread handle 140128561968896, query id 6298619 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 securitas_avhs wsrep: pre-commit/certification passed (777602146) INSERT INTO tbl_edge_evnts (starttime, endtime, evtype, cameraid, videosource, nasid, userid, format, rate, resolution, evduration, device_mapping, videocodec, audiocodec, recordingid, recording_status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691507, ACTIVE (PREPARED) 3 sec mysql tables in use 1, locked 1 4 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 1 MySQL thread id 28072, OS thread handle 140128560903936, query id 6298584 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602145) UPDATE tbl_eventsongoing SET endtime = ?, accesstime = ?, frames = ?, bytes = ? WHERE cameraid=? AND device_mapping=? ---TRANSACTION 1303691506, ACTIVE (PREPARED) 3 sec mysql tables in use 1, locked 1 4 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 1 MySQL thread id 28071, OS thread handle 140128561170176, query id 6298569 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602144) UPDATE tbl_eventsongoing SET endtime = ?, accesstime = ?, frames = ?, bytes = ? WHERE cameraid=? AND device_mapping=? ---TRANSACTION 1303691505, ACTIVE (PREPARED) 3 sec 2 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1 MySQL thread id 12, OS thread handle 140129284749056, query id 6298538 wsrep: committing write set (777602143) ---TRANSACTION 1303691504, ACTIVE (PREPARED) 3 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28070, OS thread handle 140128561436416, query id 6298527 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602142) INSERT INTO tbl_edge_evnts (starttime, endtime, evtype, cameraid, videosource, nasid, userid, format, rate, resolution, evduration, device_mapping, videocodec, audiocodec, recordingid, recording_status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691502, ACTIVE (PREPARED) 3 sec mysql tables in use 1, locked 1 4 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 1 MySQL thread id 28069, OS thread handle 140128561702656, query id 6298520 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602141) UPDATE tbl_eventsongoing SET endtime = ?, accesstime = ?, frames = ?, bytes = ? WHERE cameraid=? AND device_mapping=? ---TRANSACTION 1303691501, ACTIVE (PREPARED) 3 sec mysql tables in use 1, locked 1 4 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 1 MySQL thread id 28065, OS thread handle 140128562767616, query id 6298487 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602140) UPDATE tbl_eventsongoing SET endtime = ?, accesstime = ?, frames = ?, bytes = ? WHERE cameraid=? AND device_mapping=? ---TRANSACTION 1303691500, ACTIVE 3 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 28066, OS thread handle 140128562501376, query id 6298483 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s Searching rows for update UPDATE tbl_edge_evnts SET starttime = ?, endtime = ?, evtype = ?, cameraid = ?, videosource = ?, nasid = ?, userid = ?, format = ?, rate = ?, resolution = ?, evduration = ?, device_mapping = ?, videocodec = ?, audiocodec = ?, recordingid = ?, recording_status = ? WHERE device_mapping=? ------- TRX HAS BEEN WAITING 3 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 5868 page no 127747 n bits 416 index device_mapping of table `g4s__350__avhs`.`tbl_edge_evnts` trx id 1303691500 lock_mode X waiting ------------------ ---TRANSACTION 1303691499, ACTIVE 3 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 28067, OS thread handle 140128562235136, query id 6298464 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s Searching rows for update UPDATE tbl_edge_evnts SET starttime = ?, endtime = ?, evtype = ?, cameraid = ?, videosource = ?, nasid = ?, userid = ?, format = ?, rate = ?, resolution = ?, evduration = ?, device_mapping = ?, videocodec = ?, audiocodec = ?, recordingid = ?, recording_status = ? WHERE device_mapping=? ------- TRX HAS BEEN WAITING 3 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 5868 page no 127747 n bits 416 index device_mapping of table `g4s__350__avhs`.`tbl_edge_evnts` trx id 1303691499 lock_mode X waiting ------------------ ---TRANSACTION 1303691498, ACTIVE (PREPARED) 3 sec mysql tables in use 1, locked 1 5 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 1 MySQL thread id 28062, OS thread handle 140128563566336, query id 6298406 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602139) UPDATE tbl_eventsongoing SET endtime = ?, accesstime = ?, frames = ?, bytes = ? WHERE cameraid=? AND device_mapping=? ---TRANSACTION 1303691497, ACTIVE (PREPARED) 3 sec mysql tables in use 1, locked 1 5 lock struct(s), heap size 1136, 4 row lock(s), undo log entries 1 MySQL thread id 28061, OS thread handle 140128563832576, query id 6298404 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602138) UPDATE tbl_edge_evnts SET starttime = ?, endtime = ?, evtype = ?, cameraid = ?, videosource = ?, nasid = ?, userid = ?, format = ?, rate = ?, resolution = ?, evduration = ?, device_mapping = ?, videocodec = ?, audiocodec = ?, recordingid = ?, recording_status = ? WHERE device_mapping=? ---TRANSACTION 1303691496, ACTIVE (PREPARED) 3 sec mysql tables in use 1, locked 1 4 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 1 MySQL thread id 28064, OS thread handle 140128563033856, query id 6298397 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 securitas_avhs wsrep: pre-commit/certification passed (777602137) UPDATE tbl_edge_evnts SET starttime = ?, endtime = ?, evtype = ?, cameraid = ?, videosource = ?, nasid = ?, userid = ?, format = ?, rate = ?, resolution = ?, evduration = ?, device_mapping = ?, videocodec = ?, audiocodec = ?, recordingid = ?, recording_status = ? WHERE device_mapping=? ---TRANSACTION 1303691495, ACTIVE (PREPARED) 3 sec mysql tables in use 1, locked 1 4 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 1 MySQL thread id 28058, OS thread handle 140128564631296, query id 6298390 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 securitas_avhs wsrep: pre-commit/certification passed (777602136) UPDATE tbl_eventsongoing SET endtime = ?, accesstime = ?, frames = ?, bytes = ? WHERE cameraid=? AND device_mapping=? ---TRANSACTION 1303691494, ACTIVE (PREPARED) 3 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28059, OS thread handle 140128564365056, query id 6298362 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602135) INSERT INTO tbl_edge_evnts (starttime, endtime, evtype, cameraid, videosource, nasid, userid, format, rate, resolution, evduration, device_mapping, videocodec, audiocodec, recordingid, recording_status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691492, ACTIVE (PREPARED) 3 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 16296, OS thread handle 140129179506432, query id 6298351 prod-db-eu-proxysql-02.node.dc1.consul 10.0.101.117 tblsecuritas wsrep: pre-commit/certification passed (777602134) INSERT INTO tbl_devicestorage_av SET `deviceid` = 'ACCC8EB56D57', `storageid` = 'NetworkShare', `timestamp` = '1542783850042963', `published` = 0 ---TRANSACTION 1303691490, ACTIVE (PREPARED) 3 sec mysql tables in use 1, locked 1 4 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 1 MySQL thread id 28056, OS thread handle 140128565163776, query id 6298315 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602133) UPDATE tbl_eventsongoing SET endtime = ?, accesstime = ?, frames = ?, bytes = ? WHERE cameraid=? AND device_mapping=? ---TRANSACTION 1303691489, ACTIVE (PREPARED) 3 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28051, OS thread handle 140128566494976, query id 6298301 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 securitas_avhs wsrep: pre-commit/certification passed (777602132) INSERT INTO tbl_edge_evnts (starttime, endtime, evtype, cameraid, videosource, nasid, userid, format, rate, resolution, evduration, device_mapping, videocodec, audiocodec, recordingid, recording_status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691488, ACTIVE (PREPARED) 3 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28045, OS thread handle 140128568092416, query id 6298291 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 securitas_avhs wsrep: pre-commit/certification passed (777602131) INSERT INTO tbl_eventsongoing (starttime, endtime, accesstime, evtype, server, cameraid, videosource, nasid, userid, format, rate, evduration, frames, bytes, videocodec, audiocodec, evcomment, resolution, evpath, device_mapping) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691487, ACTIVE (PREPARED) 3 sec mysql tables in use 1, locked 1 5 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 1 MySQL thread id 28055, OS thread handle 140128565430016, query id 6298275 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602130) UPDATE tbl_eventsongoing SET endtime = ?, accesstime = ?, frames = ?, bytes = ? WHERE cameraid=? AND device_mapping=? ---TRANSACTION 1303691485, ACTIVE (PREPARED) 3 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28052, OS thread handle 140128566228736, query id 6298207 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602129) INSERT INTO tbl_eventsongoing (starttime, endtime, accesstime, evtype, server, cameraid, videosource, nasid, userid, format, rate, evduration, frames, bytes, videocodec, audiocodec, evcomment, resolution, evpath, device_mapping) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691484, ACTIVE (PREPARED) 3 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28053, OS thread handle 140128565962496, query id 6298175 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602128) INSERT INTO sysevents (evtime, syseventtype, serverid, target_serverid, cameraid, videosource, target_deviceid, userid, target_userid, remoteaddr, evcomment) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691482, ACTIVE (PREPARED) 4 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28050, OS thread handle 140128566761216, query id 6298121 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602127) INSERT INTO tbl_edge_evnts (starttime, endtime, evtype, cameraid, videosource, nasid, userid, format, rate, resolution, evduration, device_mapping, videocodec, audiocodec, recordingid, recording_status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691481, ACTIVE (PREPARED) 4 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28049, OS thread handle 140128567027456, query id 6298102 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602126) INSERT INTO tbl_edge_evnts (starttime, endtime, evtype, cameraid, videosource, nasid, userid, format, rate, resolution, evduration, device_mapping, videocodec, audiocodec, recordingid, recording_status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691480, ACTIVE (PREPARED) 4 sec mysql tables in use 1, locked 1 4 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 1 MySQL thread id 28043, OS thread handle 140128568624896, query id 6298092 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 securitas_avhs wsrep: pre-commit/certification passed (777602125) UPDATE tbl_eventsongoing SET endtime = ?, accesstime = ?, frames = ?, bytes = ? WHERE cameraid=? AND device_mapping=? ---TRANSACTION 1303691479, ACTIVE (PREPARED) 4 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28046, OS thread handle 140128567826176, query id 6298088 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602124) INSERT INTO tbl_edge_evnts (starttime, endtime, evtype, cameraid, videosource, nasid, userid, format, rate, resolution, evduration, device_mapping, videocodec, audiocodec, recordingid, recording_status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691478, ACTIVE (PREPARED) 4 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 164, OS thread handle 140129199499008, query id 6298079 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 video_eu_avhs wsrep: pre-commit/certification passed (777602123) INSERT INTO phpsessions (id, userid, session_expires, session_data) VALUES (?, ?, ?, ?) ---TRANSACTION 1303691476, ACTIVE (PREPARED) 4 sec mysql tables in use 1, locked 1 4 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 1 MySQL thread id 28044, OS thread handle 140128568358656, query id 6298055 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602122) UPDATE tbl_eventsongoing SET endtime = ?, accesstime = ?, frames = ?, bytes = ? WHERE cameraid=? AND device_mapping=? ---TRANSACTION 1303691475, ACTIVE (PREPARED) 4 sec mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1 MySQL thread id 28047, OS thread handle 140128567559936, query id 6298051 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 demo_avhs wsrep: pre-commit/certification passed (777602121) UPDATE tbl_eventsongoing SET endtime = ?, bytes = ? WHERE starttime=? AND cameraid=? AND evtype=? ---TRANSACTION 1303691474, ACTIVE (PREPARED) 4 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 13697, OS thread handle 140129199232768, query id 6297968 prod-db-eu-proxysql-02.node.dc1.consul 10.0.101.117 db_healthg4 wsrep: pre-commit/certification passed (777602120) INSERT INTO tbl_devicestorage_av SET `deviceid` = 'ACCC8E350FB6', `storageid` = 'SD_DISK', `timestamp` = '1542783848223394', `published` = 0 ---TRANSACTION 1303691472, ACTIVE (PREPARED) 4 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28042, OS thread handle 140128568891136, query id 6297963 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602119) INSERT INTO tbl_edge_evnts (starttime, endtime, evtype, cameraid, videosource, nasid, userid, format, rate, resolution, evduration, device_mapping, videocodec, audiocodec, recordingid, recording_status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691470, ACTIVE (PREPARED) 4 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28041, OS thread handle 140128569157376, query id 6297898 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602118) INSERT INTO tbl_edge_evnts (starttime, endtime, evtype, cameraid, videosource, nasid, userid, format, rate, resolution, evduration, device_mapping, videocodec, audiocodec, recordingid, recording_status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691469, ACTIVE (PREPARED) 4 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28040, OS thread handle 140128569423616, query id 6297875 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_healthg4 wsrep: pre-commit/certification passed (777602117) INSERT INTO tbl_devicestorage_av SET `deviceid` = 'ACCC8E6FF2CF', `storageid` = 'SD_DISK', `timestamp` = '1542783848230478', `published` = 0 ---TRANSACTION 1303691468, ACTIVE (PREPARED) 4 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28038, OS thread handle 140128569956096, query id 6297874 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602116) INSERT INTO tbl_eventsongoing (starttime, endtime, accesstime, evtype, server, cameraid, videosource, nasid, userid, format, rate, evduration, frames, bytes, videocodec, audiocodec, evcomment, resolution, evpath, device_mapping) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691467, ACTIVE (PREPARED) 4 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28039, OS thread handle 140128569689856, query id 6297864 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 securitas_avhs wsrep: pre-commit/certification passed (777602115) INSERT INTO tbl_edge_evnts (starttime, endtime, evtype, cameraid, videosource, nasid, userid, format, rate, resolution, evduration, device_mapping, videocodec, audiocodec, recordingid, recording_status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691466, ACTIVE (PREPARED) 4 sec mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1 MySQL thread id 6153, OS thread handle 140129197901568, query id 6297850 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 securitas_avhs wsrep: pre-commit/certification passed (777602114) UPDATE phpsessions SET session_data = ?, session_expires = ? WHERE id = ? ---TRANSACTION 1303691465, ACTIVE (PREPARED) 4 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 8099, OS thread handle 140129197102848, query id 6297844 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 securitas_avhs wsrep: pre-commit/certification passed (777602113) INSERT INTO sysevents (evtime, syseventtype, serverid, target_serverid, cameraid, videosource, target_deviceid, userid, target_userid, remoteaddr, evcomment) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691464, ACTIVE (PREPARED) 4 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28037, OS thread handle 140128570222336, query id 6297826 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602112) INSERT INTO tbl_eventsongoing (starttime, endtime, accesstime, evtype, server, cameraid, videosource, nasid, userid, format, rate, evduration, frames, bytes, videocodec, audiocodec, evcomment, resolution, evpath, device_mapping) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691463, ACTIVE (PREPARED) 4 sec mysql tables in use 1, locked 1 4 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 1 MySQL thread id 28035, OS thread handle 140128570754816, query id 6297796 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602111) UPDATE tbl_eventsongoing SET endtime = ?, accesstime = ?, frames = ?, bytes = ? WHERE cameraid=? AND device_mapping=? ---TRANSACTION 1303691462, ACTIVE (PREPARED) 4 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28036, OS thread handle 140128570488576, query id 6297792 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 demo_avhs wsrep: pre-commit/certification passed (777602110) INSERT INTO tbl_eventsongoing (starttime, endtime, accesstime, evtype, server, cameraid, videosource, nasid, userid, format, rate, evduration, frames, bytes, videocodec, audiocodec, evcomment, resolution, evpath, device_mapping) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691461, ACTIVE (PREPARED) 4 sec mysql tables in use 1, locked 1 6 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 1 MySQL thread id 28031, OS thread handle 140128571819776, query id 6297774 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602109) UPDATE tbl_edge_evnts SET starttime = ?, endtime = ?, evtype = ?, cameraid = ?, videosource = ?, nasid = ?, userid = ?, format = ?, rate = ?, resolution = ?, evduration = ?, device_mapping = ?, videocodec = ?, audiocodec = ?, recordingid = ?, recording_status = ? WHERE device_mapping=? ---TRANSACTION 1303691460, ACTIVE (PREPARED) 4 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28034, OS thread handle 140128571021056, query id 6297765 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602108) INSERT INTO tbl_edge_evnts (starttime, endtime, evtype, cameraid, videosource, nasid, userid, format, rate, resolution, evduration, device_mapping, videocodec, audiocodec, recordingid, recording_status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691459, ACTIVE (PREPARED) 4 sec mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1 MySQL thread id 28033, OS thread handle 140128571287296, query id 6297755 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 demo_avhs wsrep: pre-commit/certification passed (777602107) UPDATE tbl_eventsongoing SET endtime = ?, bytes = ? WHERE starttime=? AND cameraid=? AND evtype=? ---TRANSACTION 1303691458, ACTIVE (PREPARED) 4 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 28032, OS thread handle 140128571553536, query id 6297734 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602106) INSERT INTO tbl_edge_evnts (starttime, endtime, evtype, cameraid, videosource, nasid, userid, format, rate, resolution, evduration, device_mapping, videocodec, audiocodec, recordingid, recording_status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691457, ACTIVE (PREPARED) 4 sec mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1 MySQL thread id 97, OS thread handle 140148340750080, query id 6297714 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 securitas_avhs wsrep: pre-commit/certification passed (777602105) UPDATE events_sync SET starttime = ?, endtime = ? WHERE deviceid=? ---TRANSACTION 1303691456, ACTIVE (PREPARED) 4 sec mysql tables in use 1, locked 1 5 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 1 MySQL thread id 1684, OS thread handle 140129201096448, query id 6297683 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602104) UPDATE tbl_eventsongoing SET endtime = ?, accesstime = ?, frames = ?, bytes = ? WHERE cameraid=? AND device_mapping=? ---TRANSACTION 1303691455, ACTIVE (PREPARED) 4 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 167, OS thread handle 140129198966528, query id 6297669 prod-db-eu-proxysql-02.node.dc1.consul 10.0.101.117 db_healthg4 wsrep: pre-commit/certification passed (777602103) INSERT INTO tbl_devicestorage_av SET `deviceid` = 'ACCC8E997365', `storageid` = 'SD_DISK', `timestamp` = '1542783848048198', `published` = 0 ---TRANSACTION 1303691454, ACTIVE (PREPARED) 4 sec mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1 MySQL thread id 98, OS thread handle 140148340483840, query id 6297649 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 demo_avhs wsrep: pre-commit/certification passed (777602102) UPDATE phpsessions SET session_data = ?, session_expires = ? WHERE id = ? ---TRANSACTION 1303691453, ACTIVE (PREPARED) 4 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 115, OS thread handle 140129200297728, query id 6297634 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602101) INSERT INTO tbl_edge_evnts (starttime, endtime, evtype, cameraid, videosource, nasid, userid, format, rate, resolution, evduration, device_mapping, videocodec, audiocodec, recordingid, recording_status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691452, ACTIVE (PREPARED) 4 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 102, OS thread handle 140129201628928, query id 6297617 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602100) INSERT INTO tbl_eventsongoing (starttime, endtime, accesstime, evtype, server, cameraid, videosource, nasid, userid, format, rate, evduration, frames, bytes, videocodec, audiocodec, evcomment, resolution, evpath, device_mapping) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 1303691451, ACTIVE (PREPARED) 4 sec 3 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 2 MySQL thread id 99, OS thread handle 140129202427648, query id 6297601 prod-db-eu-proxysql-01.node.dc1.consul 10.0.101.53 db_g4s wsrep: pre-commit/certification passed (777602099) COMMIT -------- FILE I/O -------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread) I/O thread 1 state: waiting for completed aio requests (log thread) I/O thread 2 state: waiting for completed aio requests (read thread) I/O thread 3 state: waiting for completed aio requests (read thread) I/O thread 4 state: waiting for completed aio requests (read thread) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (read thread) I/O thread 7 state: waiting for completed aio requests (read thread) I/O thread 8 state: waiting for completed aio requests (read thread) I/O thread 9 state: waiting for completed aio requests (read thread) I/O thread 10 state: waiting for completed aio requests (write thread) I/O thread 11 state: waiting for completed aio requests (write thread) I/O thread 12 state: waiting for completed aio requests (write thread) I/O thread 13 state: waiting for completed aio requests (write thread) I/O thread 14 state: waiting for completed aio requests (write thread) I/O thread 15 state: waiting for completed aio requests (write thread) I/O thread 16 state: waiting for completed aio requests (write thread) I/O thread 17 state: waiting for completed aio requests (write thread) Pending normal aio reads: [0, 0, 0, 0, 0, 0, 0, 0] , aio writes: [0, 0, 0, 0, 0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 0; buffer pool: 0 500350 OS file reads, 219216 OS file writes, 3998 OS fsyncs 0.13 reads/s, 16384 avg bytes/read, 181.59 writes/s, 16.67 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 2984, seg size 2986, 3755 merges merged operations: insert 4074, delete mark 4888, delete 3260 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4730347, node heap has 45 buffer(s) Hash table size 4730347, node heap has 25 buffer(s) Hash table size 4730347, node heap has 14 buffer(s) Hash table size 4730347, node heap has 306 buffer(s) Hash table size 4730347, node heap has 158 buffer(s) Hash table size 4730347, node heap has 1567 buffer(s) Hash table size 4730347, node heap has 26 buffer(s) Hash table size 4730347, node heap has 16 buffer(s) 1092.06 hash searches/s, 2227.12 non-hash searches/s --- LOG --- Log sequence number 1062840130637 Log flushed up to 1062840104554 Pages flushed up to 1062612253246 Last checkpoint at 1062612253246 Max checkpoint age 1738750649 Checkpoint age target 1684414692 Modified age 227877391 Checkpoint age 227877391 0 pending log flushes, 0 pending chkp writes 215956 log i/o's done, 46.13 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 17884512256 Dictionary memory allocated 9831227 Internal hash tables (constant factor + variable factor) Adaptive hash index 338116160 (302742208 + 35373952) Page hash 1107112 (buffer pool 0 only) Dictionary cache 85516779 (75685552 + 9831227) File system 1301416 (812272 + 489144) Lock system 42706072 (42500456 + 205616) Recovery system 0 (0 + 0) Buffer pool size 1048448 Buffer pool size, bytes 17177772032 Free buffers 543801 Database pages 502490 Old database pages 185761 Modified db pages 13117 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 317, not young 0 0.13 youngs/s, 0.00 non-youngs/s Pages read 499713, created 2777, written 2672 0.13 reads/s, 0.73 creates/s, 133.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: 502490, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 33924 Database pages 31469 Old database pages 11635 Modified db pages 723 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 17, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 31430, created 39, written 167 0.00 reads/s, 0.07 creates/s, 8.33 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: 31469, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 35056 Database pages 30340 Old database pages 11216 Modified db pages 870 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 19, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 30225, created 115, written 167 0.00 reads/s, 0.20 creates/s, 8.33 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: 30340, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 34325 Database pages 31069 Old database pages 11483 Modified db pages 614 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 20, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 31029, created 40, written 167 0.00 reads/s, 0.07 creates/s, 8.33 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: 31069, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 34313 Database pages 31082 Old database pages 11492 Modified db pages 694 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 24, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 30940, created 142, written 167 0.07 reads/s, 0.00 creates/s, 8.33 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: 31082, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 32962 Database pages 32438 Old database pages 11991 Modified db pages 774 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 9, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 32235, created 203, written 167 0.00 reads/s, 0.00 creates/s, 8.33 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: 32438, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 34024 Database pages 31369 Old database pages 11595 Modified db pages 801 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 15, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 31163, created 206, written 167 0.00 reads/s, 0.00 creates/s, 8.33 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: 31369, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 33994 Database pages 31400 Old database pages 11610 Modified db pages 977 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 13, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 31211, created 189, written 167 0.07 reads/s, 0.00 creates/s, 8.33 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: 31400, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 34439 Database pages 30955 Old database pages 11443 Modified db pages 883 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 25, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 30740, created 215, written 167 0.00 reads/s, 0.07 creates/s, 8.33 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: 30955, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 8 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 33344 Database pages 32046 Old database pages 11846 Modified db pages 772 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 13, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 31774, created 272, written 167 0.00 reads/s, 0.27 creates/s, 8.33 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: 32046, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 9 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 34005 Database pages 31388 Old database pages 11604 Modified db pages 953 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 21, not young 0 0.07 youngs/s, 0.00 non-youngs/s Pages read 31078, created 310, written 167 0.00 reads/s, 0.00 creates/s, 8.33 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: 31388, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 10 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 33364 Database pages 32026 Old database pages 11840 Modified db pages 712 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 26, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 31851, created 175, written 167 0.00 reads/s, 0.00 creates/s, 8.33 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: 32026, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 11 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 34058 Database pages 31333 Old database pages 11585 Modified db pages 876 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 17, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 31093, created 240, written 167 0.00 reads/s, 0.00 creates/s, 8.33 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: 31333, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 12 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 33176 Database pages 32214 Old database pages 11911 Modified db pages 858 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 19, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 32113, created 101, written 167 0.00 reads/s, 0.00 creates/s, 8.33 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: 32214, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 13 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 34803 Database pages 30594 Old database pages 11309 Modified db pages 1138 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 30, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 30373, created 221, written 167 0.00 reads/s, 0.00 creates/s, 8.33 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: 30594, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 14 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 34165 Database pages 31223 Old database pages 11543 Modified db pages 719 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 28, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 31138, created 85, written 167 0.00 reads/s, 0.07 creates/s, 8.33 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: 31223, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 15 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 33849 Database pages 31544 Old database pages 11658 Modified db pages 753 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 21, not young 0 0.07 youngs/s, 0.00 non-youngs/s Pages read 31320, created 224, written 167 0.00 reads/s, 0.00 creates/s, 8.33 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: 31544, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB 90 RW transactions active inside InnoDB Process ID=1552, Main thread ID=140129435219712, state: sleeping Number of rows inserted 687655, updated 79958, deleted 68116, read 597831698 28.66 inserts/s, 20.53 updates/s, 4.53 deletes/s, 105355.78 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================