--Thread 1530194240 has waited at srv0srv.c line 1703 for 447.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1519012160 has waited at srv0srv.c line 1703 for 447.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1499576640 has waited at srv0srv.c line 1703 for 447.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1538713920 has waited at srv0srv.c line 1703 for 447.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1559480640 has waited at srv0srv.c line 1703 for 447.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1574922560 has waited at srv0srv.c line 1703 for 447.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1104435520 has waited at srv0srv.c line 1703 for 447.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1525401920 has waited at srv0srv.c line 1703 for 447.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1512356160 has waited at srv0srv.c line 1703 for 447.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1494784320 has waited at srv0srv.c line 1703 for 447.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1515551040 has waited at srv0srv.c line 1703 for 447.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1521940800 has waited at srv0srv.c line 1703 for 447.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1571461440 has waited at srv0srv.c line 1703 for 447.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1520343360 has waited at srv0srv.c line 1703 for 447.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1535785280 has waited at srv0srv.c line 1703 for 447.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1545636160 has waited at srv0srv.c line 1703 for 447.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1535519040 has waited at srv0srv.c line 1703 for 447.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1547766080 has waited at srv0srv.c line 1703 for 447.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1553889600 has waited at srv0srv.c line 1703 for 447.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1567201600 has waited at srv0srv.c line 1703 for 447.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1564539200 has waited at srv0srv.c line 1703 for 447.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1538447680 has waited at srv0srv.c line 1703 for 447.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1519810880 has waited at srv0srv.c line 1703 for 447.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1512622400 has waited at lock0lock.c line 4005 for 447.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1531525440 has waited at lock0lock.c line 5246 for 447.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1520077120 has waited at lock0lock.c line 5571 for 447.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1533389120 has waited at trx0trx.c line 1684 for 447.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1463048512 has waited at srv0srv.c line 2338 for 447.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1536317760 has waited at trx0trx.c line 1684 for 447.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1503570240 has waited at trx0trx.c line 405 for 395.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 Mutex spin waits 18263551666, rounds 380247505145, OS waits 4527306165 RW-shared spins 46147485, rounds 478171921, OS waits 12656216 RW-excl spins 25622633, rounds 665118905, OS waits 13920069 Spin rounds per wait: 20.82 mutex, 10.36 RW-shared, 25.96 RW-excl FAIL TO OBTAIN KERNEL MUTEX, SKIP LOCK INFO PRINTING -------- 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 (read thread) I/O thread 11 state: waiting for completed aio requests (read thread) I/O thread 12 state: waiting for completed aio requests (read thread) I/O thread 13 state: waiting for completed aio requests (read thread) I/O thread 14 state: waiting for completed aio requests (read thread) I/O thread 15 state: waiting for completed aio requests (read thread) I/O thread 16 state: waiting for completed aio requests (read thread) I/O thread 17 state: waiting for completed aio requests (read thread) I/O thread 18 state: waiting for completed aio requests (write thread) I/O thread 19 state: waiting for completed aio requests (write thread) I/O thread 20 state: waiting for completed aio requests (write thread) I/O thread 21 state: waiting for completed aio requests (write thread) I/O thread 22 state: waiting for completed aio requests (write thread) I/O thread 23 state: waiting for completed aio requests (write thread) I/O thread 24 state: waiting for completed aio requests (write thread) I/O thread 25 state: waiting for completed aio requests (write thread) I/O thread 26 state: waiting for completed aio requests (write thread) I/O thread 27 state: waiting for completed aio requests (write thread) I/O thread 28 state: waiting for completed aio requests (write thread) I/O thread 29 state: waiting for completed aio requests (write thread) I/O thread 30 state: waiting for completed aio requests (write thread) I/O thread 31 state: waiting for completed aio requests (write thread) I/O thread 32 state: waiting for completed aio requests (write thread) I/O thread 33 state: waiting for completed aio requests (write thread) Pending normal aio reads: 0 [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 8242562 OS file reads, 46299403 OS file writes, 2810312 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 507501, seg size 507503, 173354 merges merged operations: insert 13287, delete mark 57245744, delete 14016224 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 99608347, node heap has 75417 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 19036496876841 Log flushed up to 19036496862530 Last checkpoint at 19035950826294 0 pending log writes, 0 pending chkp writes 239069 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 51511296000; in additional pool allocated 0 Dictionary memory allocated 6146995 Buffer pool size 3071999 Free buffers 1 Database pages 2996056 Old database pages 1105945 Modified db pages 155123 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 15821453, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 8232146, created 1680840, written 45153875 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 2996056, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 48 queries inside InnoDB, 78 queries in queue 30 read views open inside InnoDB Main thread process no. 23408, id 1494518080, state: flushing log Number of rows inserted 112405194, updated 68775775, deleted 126773712, read 28818307409 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 1522739520 has waited at trx0trx.c line 1684 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1569065280 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1494518080 has waited at lock0lock.c line 3241 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1558415680 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1574656320 has waited at lock0lock.c line 4005 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1549097280 has waited at trx0trx.c line 2039 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1543506240 has waited at trx0trx.c line 1684 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1512089920 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1496115520 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1571195200 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1533921600 has waited at trx0trx.c line 754 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1495316800 has waited at trx0trx.c line 1684 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1532324160 has waited at trx0trx.c line 1684 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1529395520 has waited at trx0trx.c line 2039 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1520609600 has waited at trx0trx.c line 1684 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1575721280 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1509427520 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1518213440 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1541376320 has waited at trx0trx.c line 2039 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1562409280 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1560811840 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1537116480 has waited at lock0lock.c line 4005 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1105766720 has waited at trx0trx.c line 2039 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1495583040 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1566136640 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1542707520 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1102969152 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1552292160 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1497180480 has waited at trx0trx.c line 1684 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1573325120 has waited at trx0trx.c line 754 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1535252800 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1497446720 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1496381760 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1530194240 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1519012160 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1499576640 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1538713920 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1559480640 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1574922560 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1104435520 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1525401920 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1512356160 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1494784320 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1515551040 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1521940800 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1571461440 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1520343360 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1535785280 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1545636160 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1535519040 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1547766080 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1553889600 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1567201600 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1564539200 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1538447680 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1519810880 has waited at srv0srv.c line 1703 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1512622400 has waited at lock0lock.c line 4005 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1531525440 has waited at lock0lock.c line 5246 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1520077120 has waited at lock0lock.c line 5571 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1533389120 has waited at trx0trx.c line 1684 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1463048512 has waited at srv0srv.c line 2338 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1536317760 has waited at trx0trx.c line 1684 for 458.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1503570240 has waited at trx0trx.c line 405 for 406.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 131011 12:40:11 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 86350 1_second, 86306 sleeps, 8635 10_second, 0 background, 0 flush srv_master_thread log flush and writes: 140711 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 5810851000, signal count 4250563260 --Thread 1522739520 has waited at trx0trx.c line 1684 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1569065280 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1494518080 has waited at lock0lock.c line 3241 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1558415680 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1574656320 has waited at lock0lock.c line 4005 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1549097280 has waited at trx0trx.c line 2039 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1543506240 has waited at trx0trx.c line 1684 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1512089920 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1496115520 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1571195200 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1533921600 has waited at trx0trx.c line 754 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1495316800 has waited at trx0trx.c line 1684 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1532324160 has waited at trx0trx.c line 1684 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1529395520 has waited at trx0trx.c line 2039 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1520609600 has waited at trx0trx.c line 1684 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1575721280 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1509427520 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1518213440 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1541376320 has waited at trx0trx.c line 2039 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1562409280 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1560811840 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1537116480 has waited at lock0lock.c line 4005 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1105766720 has waited at trx0trx.c line 2039 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1495583040 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1566136640 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1542707520 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1102969152 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1552292160 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1497180480 has waited at trx0trx.c line 1684 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1573325120 has waited at trx0trx.c line 754 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1535252800 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1497446720 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1496381760 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1530194240 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1519012160 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1499576640 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1538713920 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1559480640 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1574922560 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1104435520 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1525401920 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1512356160 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1494784320 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1515551040 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1521940800 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1571461440 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1520343360 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1535785280 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1545636160 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1535519040 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1547766080 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1553889600 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1567201600 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1564539200 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1538447680 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1519810880 has waited at srv0srv.c line 1703 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1512622400 has waited at lock0lock.c line 4005 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1531525440 has waited at lock0lock.c line 5246 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1520077120 has waited at lock0lock.c line 5571 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1533389120 has waited at trx0trx.c line 1684 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1463048512 has waited at srv0srv.c line 2338 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1536317760 has waited at trx0trx.c line 1684 for 467.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1503570240 has waited at trx0trx.c line 405 for 415.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 Mutex spin waits 18263551666, rounds 380247505145, OS waits 4527306165 RW-shared spins 46147485, rounds 478171921, OS waits 12656216 RW-excl spins 25622633, rounds 665118905, OS waits 13920069 Spin rounds per wait: 20.82 mutex, 10.36 RW-shared, 25.96 RW-excl FAIL TO OBTAIN KERNEL MUTEX, SKIP LOCK INFO PRINTING -------- 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 (read thread) I/O thread 11 state: waiting for completed aio requests (read thread) I/O thread 12 state: waiting for completed aio requests (read thread) I/O thread 13 state: waiting for completed aio requests (read thread) I/O thread 14 state: waiting for completed aio requests (read thread) I/O thread 15 state: waiting for completed aio requests (read thread) I/O thread 16 state: waiting for completed aio requests (read thread) I/O thread 17 state: waiting for completed aio requests (read thread) I/O thread 18 state: waiting for completed aio requests (write thread) I/O thread 19 state: waiting for completed aio requests (write thread) I/O thread 20 state: waiting for completed aio requests (write thread) I/O thread 21 state: waiting for completed aio requests (write thread) I/O thread 22 state: waiting for completed aio requests (write thread) I/O thread 23 state: waiting for completed aio requests (write thread) I/O thread 24 state: waiting for completed aio requests (write thread) I/O thread 25 state: waiting for completed aio requests (write thread) I/O thread 26 state: waiting for completed aio requests (write thread) I/O thread 27 state: waiting for completed aio requests (write thread) I/O thread 28 state: waiting for completed aio requests (write thread) I/O thread 29 state: waiting for completed aio requests (write thread) I/O thread 30 state: waiting for completed aio requests (write thread) I/O thread 31 state: waiting for completed aio requests (write thread) I/O thread 32 state: waiting for completed aio requests (write thread) I/O thread 33 state: waiting for completed aio requests (write thread) Pending normal aio reads: 0 [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 8242562 OS file reads, 46299403 OS file writes, 2810312 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 507501, seg size 507503, 173354 merges merged operations: insert 13287, delete mark 57245744, delete 14016224 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 99608347, node heap has 75417 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 19036496876841 Log flushed up to 19036496862530 Last checkpoint at 19035950826294 0 pending log writes, 0 pending chkp writes 239069 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 51511296000; in additional pool allocated 0 Dictionary memory allocated 6146995 Buffer pool size 3071999 Free buffers 1 Database pages 2996056 Old database pages 1105945 Modified db pages 155123 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 15821453, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 8232146, created 1680840, written 45153875 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 2996056, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 48 queries inside InnoDB, 78 queries in queue 30 read views open inside InnoDB Main thread process no. 23408, id 1494518080, state: flushing log Number of rows inserted 112405194, updated 68775775, deleted 126773712, read 28818307409 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 131011 12:40:31 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 86350 1_second, 86306 sleeps, 8635 10_second, 0 background, 0 flush srv_master_thread log flush and writes: 140711 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 5810851000, signal count 4250563260 --Thread 1522739520 has waited at trx0trx.c line 1684 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1569065280 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1494518080 has waited at lock0lock.c line 3241 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1558415680 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1574656320 has waited at lock0lock.c line 4005 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1549097280 has waited at trx0trx.c line 2039 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1543506240 has waited at trx0trx.c line 1684 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1512089920 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1496115520 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1571195200 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1533921600 has waited at trx0trx.c line 754 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1495316800 has waited at trx0trx.c line 1684 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1532324160 has waited at trx0trx.c line 1684 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1529395520 has waited at trx0trx.c line 2039 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1520609600 has waited at trx0trx.c line 1684 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1575721280 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1509427520 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1518213440 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1541376320 has waited at trx0trx.c line 2039 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1562409280 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1560811840 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1537116480 has waited at lock0lock.c line 4005 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1105766720 has waited at trx0trx.c line 2039 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1495583040 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1566136640 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1542707520 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1102969152 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1552292160 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1497180480 has waited at trx0trx.c line 1684 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1573325120 has waited at trx0trx.c line 754 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1535252800 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1497446720 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1496381760 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1530194240 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1519012160 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1499576640 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1538713920 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1559480640 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1574922560 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1104435520 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1525401920 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1512356160 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1494784320 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1515551040 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1521940800 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1571461440 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1520343360 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1535785280 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1545636160 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1535519040 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1547766080 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1553889600 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1567201600 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1564539200 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1538447680 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1519810880 has waited at srv0srv.c line 1703 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1512622400 has waited at lock0lock.c line 4005 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1531525440 has waited at lock0lock.c line 5246 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1520077120 has waited at lock0lock.c line 5571 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1533389120 has waited at trx0trx.c line 1684 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1463048512 has waited at srv0srv.c line 2338 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1536317760 has waited at trx0trx.c line 1684 for 487.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1503570240 has waited at trx0trx.c line 405 for 435.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 Mutex spin waits 18263551666, rounds 380247505145, OS waits 4527306165 RW-shared spins 46147485, rounds 478171921, OS waits 12656216 RW-excl spins 25622633, rounds 665118905, OS waits 13920069 Spin rounds per wait: 20.82 mutex, 10.36 RW-shared, 25.96 RW-excl FAIL TO OBTAIN KERNEL MUTEX, SKIP LOCK INFO PRINTING -------- 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 (read thread) I/O thread 11 state: waiting for completed aio requests (read thread) I/O thread 12 state: waiting for completed aio requests (read thread) I/O thread 13 state: waiting for completed aio requests (read thread) I/O thread 14 state: waiting for completed aio requests (read thread) I/O thread 15 state: waiting for completed aio requests (read thread) I/O thread 16 state: waiting for completed aio requests (read thread) I/O thread 17 state: waiting for completed aio requests (read thread) I/O thread 18 state: waiting for completed aio requests (write thread) I/O thread 19 state: waiting for completed aio requests (write thread) I/O thread 20 state: waiting for completed aio requests (write thread) I/O thread 21 state: waiting for completed aio requests (write thread) I/O thread 22 state: waiting for completed aio requests (write thread) I/O thread 23 state: waiting for completed aio requests (write thread) I/O thread 24 state: waiting for completed aio requests (write thread) I/O thread 25 state: waiting for completed aio requests (write thread) I/O thread 26 state: waiting for completed aio requests (write thread) I/O thread 27 state: waiting for completed aio requests (write thread) I/O thread 28 state: waiting for completed aio requests (write thread) I/O thread 29 state: waiting for completed aio requests (write thread) I/O thread 30 state: waiting for completed aio requests (write thread) I/O thread 31 state: waiting for completed aio requests (write thread) I/O thread 32 state: waiting for completed aio requests (write thread) I/O thread 33 state: waiting for completed aio requests (write thread) Pending normal aio reads: 0 [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 8242562 OS file reads, 46299403 OS file writes, 2810312 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 507501, seg size 507503, 173354 merges merged operations: insert 13287, delete mark 57245744, delete 14016224 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 99608347, node heap has 75417 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 19036496876841 Log flushed up to 19036496862530 Last checkpoint at 19035950826294 0 pending log writes, 0 pending chkp writes 239069 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 51511296000; in additional pool allocated 0 Dictionary memory allocated 6146995 Buffer pool size 3071999 Free buffers 1 Database pages 2996056 Old database pages 1105945 Modified db pages 155123 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 15821453, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 8232146, created 1680840, written 45153875 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 2996056, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 48 queries inside InnoDB, 78 queries in queue 30 read views open inside InnoDB Main thread process no. 23408, id 1494518080, state: flushing log Number of rows inserted 112405194, updated 68775775, deleted 126773712, read 28818307409 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 1522739520 has waited at trx0trx.c line 1684 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1569065280 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1494518080 has waited at lock0lock.c line 3241 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1558415680 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1574656320 has waited at lock0lock.c line 4005 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1549097280 has waited at trx0trx.c line 2039 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1543506240 has waited at trx0trx.c line 1684 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1512089920 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1496115520 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1571195200 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1533921600 has waited at trx0trx.c line 754 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1495316800 has waited at trx0trx.c line 1684 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1532324160 has waited at trx0trx.c line 1684 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1529395520 has waited at trx0trx.c line 2039 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1520609600 has waited at trx0trx.c line 1684 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1575721280 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1509427520 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1518213440 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1541376320 has waited at trx0trx.c line 2039 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1562409280 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1560811840 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1537116480 has waited at lock0lock.c line 4005 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1105766720 has waited at trx0trx.c line 2039 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1495583040 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1566136640 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1542707520 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1102969152 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1552292160 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1497180480 has waited at trx0trx.c line 1684 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1573325120 has waited at trx0trx.c line 754 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1535252800 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1497446720 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1496381760 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1530194240 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1519012160 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1499576640 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1538713920 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1559480640 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1574922560 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1104435520 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1525401920 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1512356160 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1494784320 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1515551040 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1521940800 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1571461440 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1520343360 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1535785280 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1545636160 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1535519040 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1547766080 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1553889600 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1567201600 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1564539200 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1538447680 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1519810880 has waited at srv0srv.c line 1703 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1512622400 has waited at lock0lock.c line 4005 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1531525440 has waited at lock0lock.c line 5246 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1520077120 has waited at lock0lock.c line 5571 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1533389120 has waited at trx0trx.c line 1684 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1463048512 has waited at srv0srv.c line 2338 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1536317760 has waited at trx0trx.c line 1684 for 489.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1503570240 has waited at trx0trx.c line 405 for 437.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 131011 12:40:51 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 86350 1_second, 86306 sleeps, 8635 10_second, 0 background, 0 flush srv_master_thread log flush and writes: 140711 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 5810851000, signal count 4250563260 --Thread 1522739520 has waited at trx0trx.c line 1684 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1569065280 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1494518080 has waited at lock0lock.c line 3241 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1558415680 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1574656320 has waited at lock0lock.c line 4005 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1549097280 has waited at trx0trx.c line 2039 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1543506240 has waited at trx0trx.c line 1684 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1512089920 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1496115520 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1571195200 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1533921600 has waited at trx0trx.c line 754 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1495316800 has waited at trx0trx.c line 1684 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1532324160 has waited at trx0trx.c line 1684 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1529395520 has waited at trx0trx.c line 2039 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1520609600 has waited at trx0trx.c line 1684 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1575721280 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1509427520 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1518213440 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1541376320 has waited at trx0trx.c line 2039 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1562409280 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1560811840 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1537116480 has waited at lock0lock.c line 4005 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1105766720 has waited at trx0trx.c line 2039 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1495583040 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1566136640 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1542707520 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1102969152 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1552292160 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1497180480 has waited at trx0trx.c line 1684 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1573325120 has waited at trx0trx.c line 754 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1535252800 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1497446720 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1496381760 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1530194240 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1519012160 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1499576640 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1538713920 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1559480640 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1574922560 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1104435520 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1525401920 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1512356160 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1494784320 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1515551040 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1521940800 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1571461440 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1520343360 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1535785280 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1545636160 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1535519040 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1547766080 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1553889600 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1567201600 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1564539200 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1538447680 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1519810880 has waited at srv0srv.c line 1703 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1512622400 has waited at lock0lock.c line 4005 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1531525440 has waited at lock0lock.c line 5246 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1520077120 has waited at lock0lock.c line 5571 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1533389120 has waited at trx0trx.c line 1684 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1463048512 has waited at srv0srv.c line 2338 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1536317760 has waited at trx0trx.c line 1684 for 507.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1503570240 has waited at trx0trx.c line 405 for 455.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 Mutex spin waits 18263551666, rounds 380247505145, OS waits 4527306165 RW-shared spins 46147485, rounds 478171921, OS waits 12656216 RW-excl spins 25622633, rounds 665118905, OS waits 13920069 Spin rounds per wait: 20.82 mutex, 10.36 RW-shared, 25.96 RW-excl FAIL TO OBTAIN KERNEL MUTEX, SKIP LOCK INFO PRINTING -------- 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 (read thread) I/O thread 11 state: waiting for completed aio requests (read thread) I/O thread 12 state: waiting for completed aio requests (read thread) I/O thread 13 state: waiting for completed aio requests (read thread) I/O thread 14 state: waiting for completed aio requests (read thread) I/O thread 15 state: waiting for completed aio requests (read thread) I/O thread 16 state: waiting for completed aio requests (read thread) I/O thread 17 state: waiting for completed aio requests (read thread) I/O thread 18 state: waiting for completed aio requests (write thread) I/O thread 19 state: waiting for completed aio requests (write thread) I/O thread 20 state: waiting for completed aio requests (write thread) I/O thread 21 state: waiting for completed aio requests (write thread) I/O thread 22 state: waiting for completed aio requests (write thread) I/O thread 23 state: waiting for completed aio requests (write thread) I/O thread 24 state: waiting for completed aio requests (write thread) I/O thread 25 state: waiting for completed aio requests (write thread) I/O thread 26 state: waiting for completed aio requests (write thread) I/O thread 27 state: waiting for completed aio requests (write thread) I/O thread 28 state: waiting for completed aio requests (write thread) I/O thread 29 state: waiting for completed aio requests (write thread) I/O thread 30 state: waiting for completed aio requests (write thread) I/O thread 31 state: waiting for completed aio requests (write thread) I/O thread 32 state: waiting for completed aio requests (write thread) I/O thread 33 state: waiting for completed aio requests (write thread) Pending normal aio reads: 0 [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 8242562 OS file reads, 46299403 OS file writes, 2810312 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 507501, seg size 507503, 173354 merges merged operations: insert 13287, delete mark 57245744, delete 14016224 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 99608347, node heap has 75417 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 19036496876841 Log flushed up to 19036496862530 Last checkpoint at 19035950826294 0 pending log writes, 0 pending chkp writes 239069 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 51511296000; in additional pool allocated 0 Dictionary memory allocated 6146995 Buffer pool size 3071999 Free buffers 1 Database pages 2996056 Old database pages 1105945 Modified db pages 155123 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 15821453, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 8232146, created 1680840, written 45153875 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 2996056, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 48 queries inside InnoDB, 78 queries in queue 30 read views open inside InnoDB Main thread process no. 23408, id 1494518080, state: flushing log Number of rows inserted 112405194, updated 68775775, deleted 126773712, read 28818307409 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 1522739520 has waited at trx0trx.c line 1684 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1569065280 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1494518080 has waited at lock0lock.c line 3241 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1558415680 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1574656320 has waited at lock0lock.c line 4005 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1549097280 has waited at trx0trx.c line 2039 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1543506240 has waited at trx0trx.c line 1684 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1512089920 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1496115520 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1571195200 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1533921600 has waited at trx0trx.c line 754 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1495316800 has waited at trx0trx.c line 1684 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1532324160 has waited at trx0trx.c line 1684 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1529395520 has waited at trx0trx.c line 2039 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1520609600 has waited at trx0trx.c line 1684 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1575721280 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1509427520 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1518213440 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1541376320 has waited at trx0trx.c line 2039 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1562409280 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1560811840 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1537116480 has waited at lock0lock.c line 4005 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1105766720 has waited at trx0trx.c line 2039 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1495583040 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1566136640 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1542707520 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1102969152 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1552292160 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1497180480 has waited at trx0trx.c line 1684 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1573325120 has waited at trx0trx.c line 754 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1535252800 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1497446720 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1496381760 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1530194240 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1519012160 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1499576640 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1538713920 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1559480640 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1574922560 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1104435520 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1525401920 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1512356160 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1494784320 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1515551040 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1521940800 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1571461440 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1520343360 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1535785280 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1545636160 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1535519040 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1547766080 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1553889600 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1567201600 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1564539200 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1538447680 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1519810880 has waited at srv0srv.c line 1703 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1512622400 has waited at lock0lock.c line 4005 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1531525440 has waited at lock0lock.c line 5246 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1520077120 has waited at lock0lock.c line 5571 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1533389120 has waited at trx0trx.c line 1684 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1463048512 has waited at srv0srv.c line 2338 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1536317760 has waited at trx0trx.c line 1684 for 520.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1503570240 has waited at trx0trx.c line 405 for 468.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 131011 12:41:11 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 86350 1_second, 86306 sleeps, 8635 10_second, 0 background, 0 flush srv_master_thread log flush and writes: 140711 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 5810851000, signal count 4250563260 --Thread 1522739520 has waited at trx0trx.c line 1684 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1569065280 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1494518080 has waited at lock0lock.c line 3241 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1558415680 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1574656320 has waited at lock0lock.c line 4005 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1549097280 has waited at trx0trx.c line 2039 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1543506240 has waited at trx0trx.c line 1684 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1512089920 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1496115520 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1571195200 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1533921600 has waited at trx0trx.c line 754 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1495316800 has waited at trx0trx.c line 1684 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1532324160 has waited at trx0trx.c line 1684 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1529395520 has waited at trx0trx.c line 2039 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1520609600 has waited at trx0trx.c line 1684 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1575721280 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1509427520 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1518213440 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1541376320 has waited at trx0trx.c line 2039 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1562409280 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1560811840 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1537116480 has waited at lock0lock.c line 4005 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1105766720 has waited at trx0trx.c line 2039 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1495583040 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1566136640 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1542707520 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1102969152 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1552292160 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1497180480 has waited at trx0trx.c line 1684 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1573325120 has waited at trx0trx.c line 754 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1535252800 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1497446720 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1496381760 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1530194240 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1519012160 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1499576640 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1538713920 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1559480640 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1574922560 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1104435520 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1525401920 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1512356160 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1494784320 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1515551040 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1521940800 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1571461440 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1520343360 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1535785280 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1545636160 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1535519040 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1547766080 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1553889600 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1567201600 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1564539200 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1538447680 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1519810880 has waited at srv0srv.c line 1703 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1512622400 has waited at lock0lock.c line 4005 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1531525440 has waited at lock0lock.c line 5246 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1520077120 has waited at lock0lock.c line 5571 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1533389120 has waited at trx0trx.c line 1684 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1463048512 has waited at srv0srv.c line 2338 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1536317760 has waited at trx0trx.c line 1684 for 527.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1503570240 has waited at trx0trx.c line 405 for 475.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 Mutex spin waits 18263551666, rounds 380247505145, OS waits 4527306165 RW-shared spins 46147485, rounds 478171921, OS waits 12656216 RW-excl spins 25622633, rounds 665118905, OS waits 13920069 Spin rounds per wait: 20.82 mutex, 10.36 RW-shared, 25.96 RW-excl FAIL TO OBTAIN KERNEL MUTEX, SKIP LOCK INFO PRINTING -------- 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 (read thread) I/O thread 11 state: waiting for completed aio requests (read thread) I/O thread 12 state: waiting for completed aio requests (read thread) I/O thread 13 state: waiting for completed aio requests (read thread) I/O thread 14 state: waiting for completed aio requests (read thread) I/O thread 15 state: waiting for completed aio requests (read thread) I/O thread 16 state: waiting for completed aio requests (read thread) I/O thread 17 state: waiting for completed aio requests (read thread) I/O thread 18 state: waiting for completed aio requests (write thread) I/O thread 19 state: waiting for completed aio requests (write thread) I/O thread 20 state: waiting for completed aio requests (write thread) I/O thread 21 state: waiting for completed aio requests (write thread) I/O thread 22 state: waiting for completed aio requests (write thread) I/O thread 23 state: waiting for completed aio requests (write thread) I/O thread 24 state: waiting for completed aio requests (write thread) I/O thread 25 state: waiting for completed aio requests (write thread) I/O thread 26 state: waiting for completed aio requests (write thread) I/O thread 27 state: waiting for completed aio requests (write thread) I/O thread 28 state: waiting for completed aio requests (write thread) I/O thread 29 state: waiting for completed aio requests (write thread) I/O thread 30 state: waiting for completed aio requests (write thread) I/O thread 31 state: waiting for completed aio requests (write thread) I/O thread 32 state: waiting for completed aio requests (write thread) I/O thread 33 state: waiting for completed aio requests (write thread) Pending normal aio reads: 0 [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 8242562 OS file reads, 46299403 OS file writes, 2810312 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 507501, seg size 507503, 173354 merges merged operations: insert 13287, delete mark 57245744, delete 14016224 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 99608347, node heap has 75417 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 19036496876841 Log flushed up to 19036496862530 Last checkpoint at 19035950826294 0 pending log writes, 0 pending chkp writes 239069 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 51511296000; in additional pool allocated 0 Dictionary memory allocated 6146995 Buffer pool size 3071999 Free buffers 1 Database pages 2996056 Old database pages 1105945 Modified db pages 155123 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 15821453, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 8232146, created 1680840, written 45153875 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 2996056, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 48 queries inside InnoDB, 78 queries in queue 30 read views open inside InnoDB Main thread process no. 23408, id 1494518080, state: flushing log Number of rows inserted 112405194, updated 68775775, deleted 126773712, read 28818307409 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 131011 12:41:31 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 86350 1_second, 86306 sleeps, 8635 10_second, 0 background, 0 flush srv_master_thread log flush and writes: 140711 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 5810851000, signal count 4250563260 --Thread 1522739520 has waited at trx0trx.c line 1684 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1569065280 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1494518080 has waited at lock0lock.c line 3241 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1558415680 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1574656320 has waited at lock0lock.c line 4005 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1549097280 has waited at trx0trx.c line 2039 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1543506240 has waited at trx0trx.c line 1684 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1512089920 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1496115520 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1571195200 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1533921600 has waited at trx0trx.c line 754 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1495316800 has waited at trx0trx.c line 1684 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1532324160 has waited at trx0trx.c line 1684 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1529395520 has waited at trx0trx.c line 2039 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1520609600 has waited at trx0trx.c line 1684 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1575721280 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1509427520 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1518213440 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1541376320 has waited at trx0trx.c line 2039 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1562409280 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1560811840 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1537116480 has waited at lock0lock.c line 4005 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1105766720 has waited at trx0trx.c line 2039 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1495583040 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1566136640 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1542707520 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1102969152 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1552292160 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1497180480 has waited at trx0trx.c line 1684 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1573325120 has waited at trx0trx.c line 754 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1535252800 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1497446720 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1496381760 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1530194240 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1519012160 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1499576640 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1538713920 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1559480640 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1574922560 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1104435520 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1525401920 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1512356160 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1494784320 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1515551040 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1521940800 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1571461440 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1520343360 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1535785280 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1545636160 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1535519040 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1547766080 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1553889600 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1567201600 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1564539200 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1538447680 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1519810880 has waited at srv0srv.c line 1703 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1512622400 has waited at lock0lock.c line 4005 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1531525440 has waited at lock0lock.c line 5246 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1520077120 has waited at lock0lock.c line 5571 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1533389120 has waited at trx0trx.c line 1684 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1463048512 has waited at srv0srv.c line 2338 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1536317760 has waited at trx0trx.c line 1684 for 547.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1503570240 has waited at trx0trx.c line 405 for 495.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 Mutex spin waits 18263551666, rounds 380247505145, OS waits 4527306165 RW-shared spins 46147485, rounds 478171921, OS waits 12656216 RW-excl spins 25622633, rounds 665118905, OS waits 13920069 Spin rounds per wait: 20.82 mutex, 10.36 RW-shared, 25.96 RW-excl FAIL TO OBTAIN KERNEL MUTEX, SKIP LOCK INFO PRINTING -------- 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 (read thread) I/O thread 11 state: waiting for completed aio requests (read thread) I/O thread 12 state: waiting for completed aio requests (read thread) I/O thread 13 state: waiting for completed aio requests (read thread) I/O thread 14 state: waiting for completed aio requests (read thread) I/O thread 15 state: waiting for completed aio requests (read thread) I/O thread 16 state: waiting for completed aio requests (read thread) I/O thread 17 state: waiting for completed aio requests (read thread) I/O thread 18 state: waiting for completed aio requests (write thread) I/O thread 19 state: waiting for completed aio requests (write thread) I/O thread 20 state: waiting for completed aio requests (write thread) I/O thread 21 state: waiting for completed aio requests (write thread) I/O thread 22 state: waiting for completed aio requests (write thread) I/O thread 23 state: waiting for completed aio requests (write thread) I/O thread 24 state: waiting for completed aio requests (write thread) I/O thread 25 state: waiting for completed aio requests (write thread) I/O thread 26 state: waiting for completed aio requests (write thread) I/O thread 27 state: waiting for completed aio requests (write thread) I/O thread 28 state: waiting for completed aio requests (write thread) I/O thread 29 state: waiting for completed aio requests (write thread) I/O thread 30 state: waiting for completed aio requests (write thread) I/O thread 31 state: waiting for completed aio requests (write thread) I/O thread 32 state: waiting for completed aio requests (write thread) I/O thread 33 state: waiting for completed aio requests (write thread) Pending normal aio reads: 0 [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 8242562 OS file reads, 46299403 OS file writes, 2810312 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 507501, seg size 507503, 173354 merges merged operations: insert 13287, delete mark 57245744, delete 14016224 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 99608347, node heap has 75417 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 19036496876841 Log flushed up to 19036496862530 Last checkpoint at 19035950826294 0 pending log writes, 0 pending chkp writes 239069 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 51511296000; in additional pool allocated 0 Dictionary memory allocated 6146995 Buffer pool size 3071999 Free buffers 1 Database pages 2996056 Old database pages 1105945 Modified db pages 155123 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 15821453, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 8232146, created 1680840, written 45153875 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 2996056, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 48 queries inside InnoDB, 78 queries in queue 30 read views open inside InnoDB Main thread process no. 23408, id 1494518080, state: flushing log Number of rows inserted 112405194, updated 68775775, deleted 126773712, read 28818307409 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 1522739520 has waited at trx0trx.c line 1684 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1569065280 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1494518080 has waited at lock0lock.c line 3241 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1558415680 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1574656320 has waited at lock0lock.c line 4005 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1549097280 has waited at trx0trx.c line 2039 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1543506240 has waited at trx0trx.c line 1684 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1512089920 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1496115520 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1571195200 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1533921600 has waited at trx0trx.c line 754 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1495316800 has waited at trx0trx.c line 1684 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1532324160 has waited at trx0trx.c line 1684 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1529395520 has waited at trx0trx.c line 2039 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1520609600 has waited at trx0trx.c line 1684 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1575721280 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1509427520 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1518213440 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1541376320 has waited at trx0trx.c line 2039 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1562409280 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1560811840 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1537116480 has waited at lock0lock.c line 4005 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1105766720 has waited at trx0trx.c line 2039 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1495583040 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1566136640 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1542707520 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1102969152 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1552292160 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1497180480 has waited at trx0trx.c line 1684 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1573325120 has waited at trx0trx.c line 754 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1535252800 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1497446720 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1496381760 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1530194240 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1519012160 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1499576640 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1538713920 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1559480640 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1574922560 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1104435520 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1525401920 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1512356160 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1494784320 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1515551040 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1521940800 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1571461440 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1520343360 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1535785280 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1545636160 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1535519040 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1547766080 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1553889600 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1567201600 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1564539200 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1538447680 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1519810880 has waited at srv0srv.c line 1703 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1512622400 has waited at lock0lock.c line 4005 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1531525440 has waited at lock0lock.c line 5246 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1520077120 has waited at lock0lock.c line 5571 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1533389120 has waited at trx0trx.c line 1684 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1463048512 has waited at srv0srv.c line 2338 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1536317760 has waited at trx0trx.c line 1684 for 551.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 1503570240 has waited at trx0trx.c line 405 for 499.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 131011 12:41:51 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 86350 1_second, 86306 sleeps, 8635 10_second, 0 background, 0 flush srv_master_thread log flush and writes: 140711 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 5810851000, signal count 4250563260 --Thread 1522739520 has waited at trx0trx.c line 1684 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1569065280 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1494518080 has waited at lock0lock.c line 3241 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1558415680 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1574656320 has waited at lock0lock.c line 4005 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1549097280 has waited at trx0trx.c line 2039 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1543506240 has waited at trx0trx.c line 1684 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1512089920 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1496115520 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1571195200 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1533921600 has waited at trx0trx.c line 754 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1495316800 has waited at trx0trx.c line 1684 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1532324160 has waited at trx0trx.c line 1684 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1529395520 has waited at trx0trx.c line 2039 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1520609600 has waited at trx0trx.c line 1684 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1575721280 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1509427520 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1518213440 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1541376320 has waited at trx0trx.c line 2039 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1562409280 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1560811840 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1537116480 has waited at lock0lock.c line 4005 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1105766720 has waited at trx0trx.c line 2039 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1495583040 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1566136640 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1542707520 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1102969152 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1552292160 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1497180480 has waited at trx0trx.c line 1684 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1573325120 has waited at trx0trx.c line 754 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1535252800 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1497446720 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1496381760 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1530194240 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1519012160 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1499576640 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1538713920 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1559480640 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1574922560 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1104435520 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1525401920 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1512356160 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1494784320 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1515551040 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1521940800 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1571461440 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1520343360 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1535785280 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1545636160 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1535519040 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1547766080 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1553889600 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1567201600 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1564539200 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1538447680 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1519810880 has waited at srv0srv.c line 1703 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1512622400 has waited at lock0lock.c line 4005 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1531525440 has waited at lock0lock.c line 5246 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1520077120 has waited at lock0lock.c line 5571 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1533389120 has waited at trx0trx.c line 1684 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1463048512 has waited at srv0srv.c line 2338 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1536317760 has waited at trx0trx.c line 1684 for 567.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 --Thread 1503570240 has waited at trx0trx.c line 405 for 515.00 seconds the semaphore: Mutex at 0x134d3e8 created file srv0srv.c line 1024, lock var 1 waiters flag 1 Mutex spin waits 18263551666, rounds 380247505145, OS waits 4527306165 RW-shared spins 46147485, rounds 478171921, OS waits 12656216 RW-excl spins 25622633, rounds 665118905, OS waits 13920069 Spin rounds per wait: 20.82 mutex, 10.36 RW-shared, 25.96 RW-excl FAIL TO OBTAIN KERNEL MUTEX, SKIP LOCK INFO PRINTING -------- 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 (read thread) I/O thread 11 state: waiting for completed aio requests (read thread) I/O thread 12 state: waiting for completed aio requests (read thread) I/O thread 13 state: waiting for completed aio requests (read thread) I/O thread 14 state: waiting for completed aio requests (read thread) I/O thread 15 state: waiting for completed aio requests (read thread) I/O thread 16 state: waiting for completed aio requests (read thread) I/O thread 17 state: waiting for completed aio requests (read thread) I/O thread 18 state: waiting for completed aio requests (write thread) I/O thread 19 state: waiting for completed aio requests (write thread) I/O thread 20 state: waiting for completed aio requests (write thread) I/O thread 21 state: waiting for completed aio requests (write thread) I/O thread 22 state: waiting for completed aio requests (write thread) I/O thread 23 state: waiting for completed aio requests (write thread) I/O thread 24 state: waiting for completed aio requests (write thread) I/O thread 25 state: waiting for completed aio requests (write thread) I/O thread 26 state: waiting for completed aio requests (write thread) I/O thread 27 state: waiting for completed aio requests (write thread) I/O thread 28 state: waiting for completed aio requests (write thread) I/O thread 29 state: waiting for completed aio requests (write thread) I/O thread 30 state: waiting for completed aio requests (write thread) I/O thread 31 state: waiting for completed aio requests (write thread) I/O thread 32 state: waiting for completed aio requests (write thread) I/O thread 33 state: waiting for completed aio requests (write thread) Pending normal aio reads: 0 [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 8242562 OS file reads, 46299403 OS file writes, 2810312 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 507501, seg size 507503, 173354 merges merged operations: insert 13287, delete mark 57245744, delete 14016224 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 99608347, node heap has 75417 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 19036496876841 Log flushed up to 19036496862530 Last checkpoint at 19035950826294 0 pending log writes, 0 pending chkp writes 239069 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 51511296000; in additional pool allocated 0 Dictionary memory allocated 6146995 Buffer pool size 3071999 Free buffers 1 Database pages 2996056 Old database pages 1105945 Modified db pages 155123 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 15821453, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 8232146, created 1680840, written 45153875 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 2996056, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 48 queries inside InnoDB, 78 queries in queue 30 read views open inside InnoDB Main thread process no. 23408, id 1494518080, state: flushing log Number of rows inserted 112405194, updated 68775775, deleted 126773712, read 28818307409 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================