05 threads running, 0001293 successful queries. 0000023 failed queries (2.166667 QPS). 05 threads running, 0001294 successful queries. 0000023 failed queries (0.083333 QPS). 05 threads running, 0001296 successful queries. 0000023 failed queries (0.166667 QPS). 05 threads running, 0001341 successful queries. 0000023 failed queries (3.461538 QPS). 05 threads running, 0001343 successful queries. 0000023 failed queries (0.166667 QPS). 05 threads running, 0001351 successful queries. 0000023 failed queries (0.666667 QPS). 05 threads running, 0001380 successful queries. 0000023 failed queries (2.416667 QPS). 05 threads running, 0001390 successful queries. 0000023 failed queries (0.833333 QPS). 05 threads running, 0001390 successful queries. 0000023 failed queries (0.000000 QPS). 05 threads running, 0001390 successful queries. 0000023 failed queries (0.000000 QPS). 05 threads running, 0001390 successful queries. 0000023 failed queries (0.000000 QPS). 05 threads running, 0001390 successful queries. 0000023 failed queries (0.000000 QPS). 05 threads running, 0001390 successful queries. 0000023 failed queries (0.000000 QPS). 05 threads running, 0001390 successful queries. 0000023 failed queries (0.000000 QPS). 05 threads running, 0001390 successful queries. 0000023 failed queries (0.000000 QPS). 05 threads running, 0001390 successful queries. 0000023 failed queries (0.000000 QPS). 05 threads running, 0001390 successful queries. 0000023 failed queries (0.000000 QPS). 05 threads running, 0001390 successful queries. 0000023 failed queries (0.000000 QPS). 05 threads running, 0001390 successful queries. 0000023 failed queries (0.000000 QPS). 05 threads running, 0001390 successful queries. 0000023 failed queries (0.000000 QPS). 05 threads running, 0001390 successful queries. 0000023 failed queries (0.000000 QPS). 05 threads running, 0001390 successful queries. 0000023 failed queries (0.000000 QPS). 05 threads running, 0001390 successful queries. 0000023 failed queries (0.000000 QPS). 05 threads running, 0001390 successful queries. 0000023 failed queries (0.000000 QPS). 05 threads running, 0001390 successful queries. 0000023 failed queries (0.000000 QPS). 05 threads running, 0001390 successful queries. 0000023 failed queries (0.000000 QPS). 05 threads running, 0001390 successful queries. 0000023 failed queries (0.000000 QPS). 05 threads running, 0001390 successful queries. 0000023 failed queries (0.000000 QPS). 05 threads running, 0001390 successful queries. 0000023 failed queries (0.000000 QPS). 05 threads running, 0001390 successful queries. 0000023 failed queries (0.000000 QPS). 05 threads running, 0001390 successful queries. 0000023 failed queries (0.000000 QPS). waiting for threads to finish query failed (1053) - Server shutdown in progress: alter table `table5` discard ta [...] query failed in repetition 0 query failed (2013) - Lost connection to MySQL server during query: select * from `table5` where `c [...] query failed (2013) - Lost connection to MySQL server during query: update ignore `view_table5` set [...] query failed in repetition 0 mysql> show processlist; +----+------+------+------+---------+------+-------------------+---------------------------------------------------------------------- | Id | User | Host | db | Command | Time | State | Info +----+------+------+------+---------+------+-------------------+---------------------------------------------------------------------- | 4 | root | | test | Query | 0 | NULL | show processlist | 10 | root | | test | Query | 600 | init | update ignore `view_table5` set `col0`=if(abs(-5885)%100<20,null,"'De | 11 | root | | test | Query | 583 | Flushing tables | flush table `table5` | 12 | root | | test | Query | 589 | Flushing tables | flush table `table5` | 13 | root | | test | Query | 507 | Waiting for table | alter table `table5` discard tablespace | 14 | root | | test | Query | 598 | statistics | select * from `table5` where `col83` = '47583' +----+------+------+------+---------+------+-------------------+---------------------------------------------------------------------- 6 rows in set (0.03 sec) mysql> show innodb status\G *************************** 1. row *************************** Status: ===================================== 080914 11:34:36 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 38 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 14, signal count 14 Mutex spin waits 0, rounds 0, OS waits 0 RW-shared spins 26, OS waits 13; RW-excl spins 1, OS waits 1 ------------ TRANSACTIONS ------------ Trx id counter 0 1483089 Purge done for trx's n:o < 0 1483007 undo n:o < 0 0 History list length 0 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 1483072, not started, OS thread id 3780 MySQL thread id 13, query id 1534 127.0.0.1 root Waiting for table alter table `table5` discard tablespace ---TRANSACTION 0 1483004, not started, OS thread id 4728 MySQL thread id 12, query id 1404 127.0.0.1 root Flushing tables flush table `table5` ---TRANSACTION 0 1483015, not started, OS thread id 4740 MySQL thread id 11, query id 1419 127.0.0.1 root Flushing tables flush table `table5` ---TRANSACTION 0 1483008, not started, OS thread id 2744 estimating records in index range mysql tables in use 1, locked 1 MySQL thread id 10, query id 1330 127.0.0.1 root init update ignore `view_table5` set `col0`=if(abs(-5885)%100<20,null,"'Deacon\'s'"),`col1`=if(abs(-24665)%100<20,null,"'Admiral'"), (-3586)%100<20,null,"'polypeptides'"),`col13`=if(abs(-19273)%100<20,null,"'nobly'"),`col14`=if(abs(- ---TRANSACTION 0 1483088, not started, OS thread id 2216 MySQL thread id 4, query id 1589 127.0.0.1 root show innodb status ---TRANSACTION 0 1483009, ACTIVE 504 sec, OS thread id 4580 estimating records in index range mysql tables in use 1, locked 0 2 lock struct(s), heap size 368 MySQL thread id 14, query id 1345 127.0.0.1 root statistics select * from `table5` where `col83` = '47583' Trx read view will not see trx with id >= 0 1483013, sees < 0 1483004 -------- FILE I/O -------- I/O thread 0 state: wait Windows aio (insert buffer thread) I/O thread 1 state: wait Windows aio (log thread) I/O thread 2 state: wait Windows aio (read thread) I/O thread 3 state: wait Windows aio (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 41 OS file reads, 1137 OS file writes, 549 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 1.89 writes/s, 0.39 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 3 merges Hash table size 17393, used cells 791, node heap has 2 buffer(s) 428.67 hash searches/s, 4.16 non-hash searches/s --- LOG --- Log sequence number 0 86966387 Log flushed up to 0 86966387 Last checkpoint at 0 86966387 0 pending log writes, 0 pending chkp writes 80 log i/o's done, 0.13 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 19436906; in additional pool allocated 1046016 Buffer pool size 512 Free buffers 176 Database pages 334 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 30, created 519, written 624 0.00 reads/s, 0.97 creates/s, 1.55 writes/s Buffer pool hit rate 1000 / 1000 -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread id 2436, state: waiting for server activity Number of rows inserted 32878, updated 0, deleted 0, read 33246 431.15 inserts/s, 0.00 updates/s, 0.00 deletes/s, 431.15 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 080914 11:26:46 InnoDB: Error: trying to access tablespace 15 page no. 9, InnoDB: but the tablespace does not exist or is just being dropped. 11GB of this