===================================== 2022-03-14 14:31:36 0x7f1115291700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 2 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 0 srv_active, 0 srv_shutdown, 1026796 srv_idle srv_master_thread log flush and writes: 1026776 ---------- SEMAPHORES ---------- ------------ TRANSACTIONS ------------ Trx id counter 518325580 Purge done for trx's n:o < 518319123 undo n:o < 0 state: running History list length 3211 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 518325579, ACTIVE 0 sec 6 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 4 MariaDB thread id 10629674, OS thread handle 139711354578688, query id 895865051 10.254.28.150 fccUser ---TRANSACTION (0x7f51d4b9af30), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f51d4b98d30), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f51d4b95a30), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f51d4b94930), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f51d4b93830), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f51d4b92730), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f51d4b8f430), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f51d4b8e330), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f51d4b89f30), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f51d4b5f730), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f51d4b88e30), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f51d4b8d230), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f51d4b8c130), ACTIVE 5 sec mysql tables in use 2, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 10626351, OS thread handle 139711347414784, query id 895858761 10.254.28.149 fccUser Sending data SET STATEMENT max_statement_time=180 FOR SELECT GROUP_CONCAT(DISTINCT d.customer ORDER BY customer ASC) AS customers, GROUP_CONCAT(DISTINCT d.country ORDER BY country ASC) AS countrys, GROUP_CONCAT(DISTINCT d.deviceType ORDER BY deviceType ASC) AS deviceTypes, COUNT(DISTINCT deviceId) AS sumDevices, GROUP_CONCAT(DISTINCT d.atmType ORDER BY atmType ASC) AS atmTypes, GROUP_CONCAT(DISTINCT calendarWeek ORDER BY calendarWeek DESC) AS weeks, COUNT(DISTINCT flightRecordId) AS sumFlightRecords FROM Device AS d JOIN Flightrecord AS fr USING(deviceId) WHERE NOT d.isInternal AND d.country IN ("US_Unite Trx read view will not see trx with id >= 518325401, sees < 518319787 ---TRANSACTION (0x7f51d4b8b030), ACTIVE 132 sec mysql tables in use 4, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 10626304, OS thread handle 139711347107584, query id 895825847 10.254.28.149 fccUser Creating sort index SET STATEMENT max_statement_time=180 FOR SELECT systemSerialNumber AS serialNumber, country, customer, atmtype, `system`, sreq.param2 AS param2, sreq.solved AS solved FROM device AS d1 JOIN (SELECT systemSerialNUmber, systemHash FROM device AS d JOIN flightRecord AS fr USING(deviceId) WHERE type != 'IGNORED' AND NOT ignoreSnr AND systemSerialNumber IS NOT NULL AND systemSerialNumber NOT IN ('XXXXXXXX', 'UNKNOWN') GROUP BY systemSerialNumber HAVING COUNT(DISTINCT systemHash) = 1 ) AS tmp_dev USING(systemHash) LEFT JOIN structureRequest AS sreq ON(sreq.param1 = CONCAT(country, '\\', customer, '\ Trx read view will not see trx with id >= 518325123, sees < 518319787 ---TRANSACTION 518320378, ACTIVE 572 sec inserting mysql tables in use 1, locked 1 7 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 13 MariaDB thread id 10625747, OS thread handle 139711348029184, query id 895798910 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518320377, ACTIVE 573 sec inserting mysql tables in use 1, locked 1 8 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 24 MariaDB thread id 10625746, OS thread handle 139711348741888, query id 895798897 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518320374, ACTIVE 575 sec inserting mysql tables in use 1, locked 1 8 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 15 MariaDB thread id 10625744, OS thread handle 139711349049088, query id 895798830 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518320373, ACTIVE 576 sec inserting mysql tables in use 1, locked 1 10 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 134 MariaDB thread id 10625743, OS thread handle 139711349356288, query id 895798814 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518320372, ACTIVE 576 sec inserting mysql tables in use 1, locked 1 11 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 29 MariaDB thread id 10625742, OS thread handle 139711349970688, query id 895798798 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518320370, ACTIVE 577 sec inserting mysql tables in use 1, locked 1 8 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 153 MariaDB thread id 10625741, OS thread handle 139711349663488, query id 895798732 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518320368, ACTIVE 577 sec inserting mysql tables in use 1, locked 1 9 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 42 MariaDB thread id 10625739, OS thread handle 139711350585088, query id 895798709 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518320367, ACTIVE 577 sec inserting mysql tables in use 1, locked 1 7 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 13 MariaDB thread id 10625738, OS thread handle 139711350277888, query id 895798688 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518320362, ACTIVE 577 sec inserting mysql tables in use 1, locked 1 13 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 39 MariaDB thread id 10625735, OS thread handle 139711350892288, query id 895798588 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518320361, ACTIVE 578 sec inserting mysql tables in use 1, locked 1 8 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 6 MariaDB thread id 10625734, OS thread handle 139711351813888, query id 895798556 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518320358, ACTIVE 578 sec inserting mysql tables in use 1, locked 1 15 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 81 MariaDB thread id 10625732, OS thread handle 139711351199488, query id 895798492 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518320355, ACTIVE 578 sec inserting mysql tables in use 1, locked 1 8 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 16 MariaDB thread id 10625729, OS thread handle 139711351506688, query id 895798401 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518320348, ACTIVE 578 sec inserting mysql tables in use 1, locked 1 10 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 134 MariaDB thread id 10625725, OS thread handle 139711352121088, query id 895798252 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518320347, ACTIVE 578 sec inserting mysql tables in use 1, locked 1 8 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 24 MariaDB thread id 10625724, OS thread handle 139711352428288, query id 895798236 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518320346, ACTIVE 578 sec inserting mysql tables in use 1, locked 1 14 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 65 MariaDB thread id 10625722, OS thread handle 139711352735488, query id 895798219 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518320343, ACTIVE 578 sec inserting mysql tables in use 1, locked 1 6 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 3 MariaDB thread id 10625720, OS thread handle 139711353042688, query id 895798140 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518320342, ACTIVE 578 sec inserting mysql tables in use 1, locked 1 8 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 30 MariaDB thread id 10625719, OS thread handle 139711354271488, query id 895798130 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518320339, ACTIVE 579 sec inserting mysql tables in use 1, locked 1 7 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 13 MariaDB thread id 10625716, OS thread handle 139711354885888, query id 895798062 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518320338, ACTIVE 579 sec inserting mysql tables in use 1, locked 1 7 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 13 MariaDB thread id 10625715, OS thread handle 139711355500288, query id 895798049 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518320331, ACTIVE 579 sec inserting mysql tables in use 1, locked 1 7 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 13 MariaDB thread id 10625711, OS thread handle 139711360108288, query id 895797899 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518320329, ACTIVE 579 sec inserting mysql tables in use 1, locked 1 10 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 48 MariaDB thread id 10625710, OS thread handle 139711357036288, query id 895797886 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518320328, ACTIVE 579 sec inserting mysql tables in use 1, locked 1 8 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 163 MariaDB thread id 10625709, OS thread handle 139711356729088, query id 895797867 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518320323, ACTIVE 579 sec inserting mysql tables in use 1, locked 1 7 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 13 MariaDB thread id 10625706, OS thread handle 139711357957888, query id 895797736 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518320299, ACTIVE 580 sec inserting mysql tables in use 1, locked 1 14 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 450 MariaDB thread id 10625693, OS thread handle 139711358265088, query id 895797170 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518320272, ACTIVE 581 sec inserting mysql tables in use 1, locked 1 15 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 114 MariaDB thread id 10625679, OS thread handle 139711356114688, query id 895796415 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518320093, ACTIVE 585 sec inserting mysql tables in use 1, locked 1 15 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 457 MariaDB thread id 10625588, OS thread handle 139711357650688, query id 895792589 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518319908, ACTIVE 590 sec inserting mysql tables in use 1, locked 1 15 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 576 MariaDB thread id 10625495, OS thread handle 139989426898688, query id 895787434 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518319853, ACTIVE 592 sec inserting mysql tables in use 1, locked 1 13 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 593 MariaDB thread id 10625465, OS thread handle 139711353657088, query id 895785803 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518319846, ACTIVE 592 sec inserting mysql tables in use 1, locked 1 12 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 452 MariaDB thread id 10625461, OS thread handle 139711340865280, query id 895785614 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518319830, ACTIVE 593 sec inserting mysql tables in use 1, locked 1 15 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 344 MariaDB thread id 10625454, OS thread handle 139711355807488, query id 895785445 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518319822, ACTIVE 593 sec inserting mysql tables in use 1, locked 1 16 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 1156 MariaDB thread id 10625448, OS thread handle 139711357343488, query id 895785408 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518319815, ACTIVE 593 sec inserting mysql tables in use 1, locked 1 9 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 542 MariaDB thread id 10625445, OS thread handle 139711358572288, query id 895784653 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518319812, ACTIVE 593 sec inserting mysql tables in use 1, locked 1 13 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 123 MariaDB thread id 10625443, OS thread handle 139989426591488, query id 895784527 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518319811, ACTIVE 593 sec inserting mysql tables in use 1, locked 1 13 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 540 MariaDB thread id 10625441, OS thread handle 139711359493888, query id 895784603 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518319795, ACTIVE 594 sec inserting mysql tables in use 1, locked 1 13 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 416 MariaDB thread id 10625432, OS thread handle 139711356421888, query id 895784085 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION 518319787, ACTIVE 594 sec inserting mysql tables in use 1, locked 1 15 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 459 MariaDB thread id 10625427, OS thread handle 139711355193088, query id 895783879 10.254.28.150 fccUser Update insert into InventoryData (constructionLevelFru, eepromName, electronicsRelease, inventoryType, mechanicsRelease, objectId, sdateFru, slaveFirmwareRelease, snoElectronic, snoFru, tcnFru, traceIndex, flightRecordId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ---TRANSACTION (0x7f51d4b61930), ACTIVE 624 sec starting index read mysql tables in use 10, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 10625016, OS thread handle 139711358879488, query id 895744630 10.254.28.149 fccUser Sending data SET STATEMENT max_statement_time=180 FOR SELECT DATE_FORMAT(fr.date,'%x/%v') AS TimeSpan, MIN(fr.date) AS MinDate, MAX(fr.date) AS MaxDate, COUNT(DISTINCT fr.deviceId) AS Devices, COUNT(DISTINCT fr.flightRecordId) AS Days, sum(r.safeDispensedNotes) AS safeDispensedNotes, sum(r.customerRejectedNotes) AS customerRejectedNotes, sum(r.mechanicalRejectedNotes) AS mechanicalRejectedNotes, sum(r.otherRejectedNotes) AS otherRejectedNotes, sum(r.collateralRejectedNotes) AS collateralNotes, sum(r.rejectedNotes) AS rejectedNotes, sum(r.bvmRejectedNotes) AS bvmRejectedNotes, sum(r.cat2RejectedNotes) AS ca Trx read view will not see trx with id >= 518319129, sees < 518319129 ---TRANSACTION (0x7f51d4b5e630), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f51d4b5b330), ACTIVE 624 sec fetching rows mysql tables in use 8, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 10625014, OS thread handle 139711348336384, query id 895744628 10.254.28.149 fccUser Sending data SET STATEMENT max_statement_time=180 FOR SELECT DISTINCT CONCAT(r.denomination, ' ', r.currency) AS Banknote FROM Device AS d JOIN Flightrecord AS fr USING(deviceId) JOIN rm4flightrecord AS rm4Fr USING(flightRecordId) JOIN (SELECT flightRecordId FROM Device AS d JOIN Flightrecord AS fr USING(deviceId) JOIN rm4flightrecord AS rm4Fr USING(flightRecordId) JOIN inventorydata AS inv USING(flightRecordId) WHERE NOT d.isInternal AND d.deviceType IN ("RM4H") AND d.country IN ("DE_Germany") AND fr.type = 'RM4' AND fr.calendarWeek >= 202125 AND (inv.objectId = -233828863) AND inv.tcnFru IN ("01750357308 Trx read view will not see trx with id >= 518319129, sees < 518319129 ---TRANSACTION (0x7f51d4b5d530), ACTIVE 624 sec fetching rows mysql tables in use 9, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 10625013, OS thread handle 139711359186688, query id 895744618 10.254.28.149 fccUser Sending data SET STATEMENT max_statement_time=180 FOR SELECT GROUP_CONCAT(DISTINCT d.customer ORDER BY customer ASC) AS customers, GROUP_CONCAT(DISTINCT d.country ORDER BY country ASC) AS countrys, GROUP_CONCAT(DISTINCT d.deviceType ORDER BY deviceType ASC) AS deviceTypes, COUNT(DISTINCT deviceId) AS sumDevices, GROUP_CONCAT(DISTINCT calendarWeek ORDER BY calendarWeek DESC) AS weeks, COUNT(DISTINCT flightRecordId) AS sumFlightRecords, SUM(p.movedMedia) AS sumMovedMedia, GROUP_CONCAT(DISTINCT CONCAT_WS(' ',inv.objectId, inv.eepromName) ORDER BY inv.objectId ASC) AS inventoryItems, GROUP_CONCAT(DISTINCT re Trx read view will not see trx with id >= 518319126, sees < 518319115 ---TRANSACTION (0x7f51d4b5a230), ACTIVE 624 sec fetching rows mysql tables in use 9, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 10624865, OS thread handle 139711353349888, query id 895744479 10.254.28.149 fccUser Sending data SET STATEMENT max_statement_time=180 FOR SELECT GROUP_CONCAT(DISTINCT d.customer ORDER BY customer ASC) AS customers, GROUP_CONCAT(DISTINCT d.country ORDER BY country ASC) AS countrys, GROUP_CONCAT(DISTINCT d.deviceType ORDER BY deviceType ASC) AS deviceTypes, COUNT(DISTINCT deviceId) AS sumDevices, GROUP_CONCAT(DISTINCT calendarWeek ORDER BY calendarWeek DESC) AS weeks, COUNT(DISTINCT flightRecordId) AS sumFlightRecords, SUM(p.movedMedia) AS sumMovedMedia, GROUP_CONCAT(DISTINCT CONCAT_WS(' ',inv.objectId, inv.eepromName) ORDER BY inv.objectId ASC) AS inventoryItems, GROUP_CONCAT(DISTINCT re Trx read view will not see trx with id >= 518319123, sees < 518319115 ---TRANSACTION (0x7f51d4b59130), ACTIVE 518 sec starting index read mysql tables in use 9, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 10624785, OS thread handle 139711359801088, query id 895799109 10.254.28.149 fccUser Sending data SET STATEMENT max_statement_time=180 FOR SELECT GROUP_CONCAT(DISTINCT d.customer ORDER BY customer ASC) AS customers, GROUP_CONCAT(DISTINCT d.country ORDER BY country ASC) AS countrys, GROUP_CONCAT(DISTINCT d.deviceType ORDER BY deviceType ASC) AS deviceTypes, COUNT(DISTINCT deviceId) AS sumDevices, GROUP_CONCAT(DISTINCT calendarWeek ORDER BY calendarWeek DESC) AS weeks, COUNT(DISTINCT flightRecordId) AS sumFlightRecords, SUM(p.movedMedia) AS sumMovedMedia, GROUP_CONCAT(DISTINCT CONCAT_WS(' ',inv.objectId, inv.eepromName) ORDER BY inv.objectId ASC) AS inventoryItems, GROUP_CONCAT(DISTINCT re Trx read view will not see trx with id >= 518320399, sees < 518319787 ---TRANSACTION (0x7f51d4b60830), ACTIVE 624 sec starting index read mysql tables in use 14, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 10614803, OS thread handle 139711353964288, query id 895744616 10.254.28.149 fccUser Sending data SET STATEMENT max_statement_time=180 FOR SELECT fr.deviceId AS DeviceId, d.Country, d.Customer, d.AtmType, d.DeviceType, d.System, GROUP_CONCAT(DISTINCT mfr.configInfo) AS configInfo, GROUP_CONCAT(DISTINCT fr.systemSerialNumber ORDER BY fr.systemSerialNumber) AS systemSerialNumber, GROUP_CONCAT(DISTINCT fr.firmwareVersion ORDER BY fr.firmwareVersion) AS firmwareVersion, GROUP_CONCAT(DISTINCT fr.jddVersion ORDER BY fr.jddVersion) AS jddVersion, GROUP_CONCAT(DISTINCT fr.moveVersion ORDER BY fr.moveVersion) AS moveVersion, COUNT(DISTINCT fr.flightRecordId) AS Days, SUM(p.movedMedia) AS MovedNotes Trx read view will not see trx with id >= 518319124, sees < 518319115 ---TRANSACTION (0x7f51d4b5c430), not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- Pending flushes (fsync) log: 0; buffer pool: 0 25118723 OS file reads, 269549945 OS file writes, 1820414 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 1.00 writes/s, 1.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1400, free list len 379808, seg size 381209, 1570 merges merged operations: insert 25288, delete mark 4356, delete 4356 discarded operations: insert 0, delete mark 0, delete 0 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 27203446748756 Log flushed up to 27203446651095 Pages flushed up to 27203135953809 Last checkpoint at 27203135953759 0 pending log flushes, 0 pending chkp writes 802143 log i/o's done, 1.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 275012124672 Dictionary memory allocated 1700338776 Buffer pool size 16613376 Free buffers 1 Database pages 24144034 Old database pages 8912523 Modified db pages 159573 Percent of dirty pages(LRU & free pages): 0.661 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0 Pages made young 27222523, not young 1080787653 0.00 youngs/s, 0.00 non-youngs/s Pages read 25099610, created 29044423, written 268752070 0.00 reads/s, 16.49 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 24144034, unzip_LRU len: 2414569 I/O sum[1]:cur[0], unzip sum[12]:cur[2] -------------- ROW OPERATIONS -------------- 8 read views open inside InnoDB Process ID=0, Main thread ID=0, state: sleeping Number of rows inserted 1915792509, updated 12950583, deleted 342913081, read 147542650240 1648.68 inserts/s, 58.97 updates/s, 0.00 deletes/s, 317704.15 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================