100128 10:00:44 mysqld_safe Starting mysqld daemon with databases from /mysql01/data InnoDB: The InnoDB memory heap is disabled InnoDB: Mutexes and rw_locks use GCC atomic builtins 100128 10:00:45 InnoDB: highest supported file format is Barracuda. 100128 10:12:34 InnoDB Plugin 1.0.6-9 started; log sequence number 16956030908627 100128 10:12:34 [Note] Event Scheduler: Loaded 0 events 100128 10:12:34 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.1.42-percona' socket: '/var/lib/mysql/mysql.sock' port: 12001 MySQL Community Server (GPL), XtraDB 9, Revision 50 100128 11:52:16 [Warning] Invalid (old?) table or database name '#sql2-2992-f9' InnoDB: Warning: a long semaphore wait: --Thread 1204422992 has waited at row/row0ins.c line 1541 for 241.00 seconds the semaphore: S-lock on RW-latch at 0xd3e640 '&dict_operation_lock' a writer (thread id 1200163152) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row/row0ins.c line 1541 Last time write locked in file row/row0mysql.c line 3043 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 100128 12:28:19 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 32 seconds ---------- BACKGROUND THREAD ---------- srv_master_thread loops: 3513 1_second, 3513 sleeps, 348 10_second, 238 background, 238 flush srv_master_thread log flush and writes: 3641 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 128370, signal count 445350 --Thread 1204422992 has waited at row/row0ins.c line 1541 for 252.00 seconds the semaphore: S-lock on RW-latch at 0xd3e640 '&dict_operation_lock' a writer (thread id 1200163152) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row/row0ins.c line 1541 Last time write locked in file row/row0mysql.c line 3043 --Thread 1191237968 has waited at buf/buf0flu.c line 986 for 251.00 seconds the semaphore: S-lock on RW-latch at 0xd3e440 '&page_hash_latch' a writer (thread id 1200163152) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file buf/buf0buf.c line 2209 Last time write locked in file buf/buf0lru.c line 367 --Thread 1199630672 has waited at buf/buf0buf.c line 2209 for 247.00 seconds the semaphore: S-lock on RW-latch at 0xd3e440 '&page_hash_latch' a writer (thread id 1200163152) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file buf/buf0buf.c line 2209 Last time write locked in file buf/buf0lru.c line 367 Mutex spin waits 1419109, rounds 7072057, OS waits 67659 RW-shared spins 205802, OS waits 32363; RW-excl spins 250652, OS waits 7413 Spin rounds per wait: 4.98 mutex, 7.67 RW-shared, 3.60 RW-excl ------------------------ LATEST FOREIGN KEY ERROR ------------------------ 100128 11:52:16 Error in dropping of a foreign key constraint of table "tmp_p3_p20931_Des_autot"."geneticelem_elementgrp", in SQL command ALTER TABLE `geneticelem_elementgrp` MODIFY COLUMN `elementgrp_id` SMALLINT UNSIGNED NOT NULL, DROP FOREIGN KEY `fk_geneticelem_elementgrp_02` Cannot find a constraint with the given id "fk_geneticelem_elementgrp_02". InnoDB: Renaming table `tmp_p3_p20931_Des_autot`.`geneticelem_elementgrp` to `tmp_p3_p20931_Des_autot`. failed! -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (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 230305 OS file reads, 60780 OS file writes, 17320 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 45207, seg size 45209, 166 inserts, 166 merged recs, 7 merges Hash table size 8850461, node heap has 272 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 16975058959659 Log flushed up to 16975058959659 Last checkpoint at 16974456073778 Max checkpoint age 678766142 Checkpoint age target 657554701 Modified age 551632438 Checkpoint age 602885881 0 pending log writes, 0 pending chkp writes 18248 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 4401922048; in additional pool allocated 0 Internal hash tables (constant factor + variable factor) Adaptive hash index 75264344 (70803688 + 4460656) Page hash 4426024 Dictionary cache 20638376 (17702416 + 2935960) File system 36899440 (82672 + 36816768) Lock system 10630568 (10625704 + 4864) Recovery system 0 (0 + 0) Threads 408216 (406936 + 1280) Dictionary memory allocated 2935960 InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 1204422992 has waited at row/row0ins.c line 1541 for 272.00 seconds the semaphore: S-lock on RW-latch at 0xd3e640 '&dict_operation_lock' a writer (thread id 1200163152) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row/row0ins.c line 1541 Last time write locked in file row/row0mysql.c line 3043 InnoDB: Warning: a long semaphore wait: --Thread 1191237968 has waited at buf/buf0flu.c line 986 for 271.00 seconds the semaphore: S-lock on RW-latch at 0xd3e440 '&page_hash_latch' a writer (thread id 1200163152) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file buf/buf0buf.c line 2209 Last time write locked in file buf/buf0lru.c line 367 InnoDB: Warning: a long semaphore wait: --Thread 1199630672 has waited at buf/buf0buf.c line 2209 for 267.00 seconds the semaphore: S-lock on RW-latch at 0xd3e440 '&page_hash_latch' a writer (thread id 1200163152) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file buf/buf0buf.c line 2209 Last time write locked in file buf/buf0lru.c line 367 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 1204422992 has waited at row/row0ins.c line 1541 for 304.00 seconds the semaphore: S-lock on RW-latch at 0xd3e640 '&dict_operation_lock' a writer (thread id 1200163152) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row/row0ins.c line 1541 Last time write locked in file row/row0mysql.c line 3043 InnoDB: Warning: a long semaphore wait: --Thread 1191237968 has waited at buf/buf0flu.c line 986 for 303.00 seconds the semaphore: S-lock on RW-latch at 0xd3e440 '&page_hash_latch' a writer (thread id 1200163152) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file buf/buf0buf.c line 2209 Last time write locked in file buf/buf0lru.c line 367 InnoDB: Warning: a long semaphore wait: --Thread 1199630672 has waited at buf/buf0buf.c line 2209 for 299.00 seconds the semaphore: S-lock on RW-latch at 0xd3e440 '&page_hash_latch' a writer (thread id 1200163152) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file buf/buf0buf.c line 2209 Last time write locked in file buf/buf0lru.c line 367 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 InnoDB: ###### Diagnostic info printed to the standard error stream Buffer pool size 262143 Buffer pool size, bytes 4294950912 Free buffers 34394 Database pages 180391 Old database pages 66609 Modified db pages 28553 Pending reads 0 Pending writes: LRU 0, flush list 1, single page 0 Pages made young 409047, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 215654, created 706890, written 823522 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 LRU len: 180391, unzip_LRU len: 134955 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread process no. 10642, id 1191237968, state: flushing log Number of rows inserted 7451043, updated 442, deleted 5, read 3678230 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ------------ TRANSACTIONS ------------ Trx id counter CC3E29C Purge done for trx's n:o < CC3E28C undo n:o < 0 History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION CC3E296, not started, process no 10642, OS thread id 1200163152 MySQL thread id 249, query id 14322 acouchis.gsf.de 146.107.217.183 pedant3 rename result table ALTER TABLE `evidencedata` MODIFY COLUMN `elementgrp_id` SMALLINT UNSIGNED ---TRANSACTION CC3E276, not started, process no 10642, OS thread id 1203358032 MySQL thread id 187, query id 13909 acouchis.gsf.de 146.107.217.183 pedant3 ---TRANSACTION 0, not started, process no 10642, OS thread id 1203890512 MySQL thread id 185, query id 14319 acouchis.gsf.de 146.107.217.183 pedant3 ---TRANSACTION 0, not started, process no 10642, OS thread id 1201228112 MySQL thread id 137, query id 14479 acouchis.gsf.de 146.107.217.183 pedant3 ---TRANSACTION CC3E29B, ACTIVE 2187 sec, process no 10642, OS thread id 1200163152 dropping table 16 lock struct(s), heap size 3024, 52 row lock(s), undo log entries 42 MySQL thread id 249, query id 14322 acouchis.gsf.de 146.107.217.183 pedant3 rename result table ALTER TABLE `evidencedata` MODIFY COLUMN `elementgrp_id` SMALLINT UNSIGNED TABLE LOCK table `SYS_TABLES` trx id CC3E29B lock mode IS RECORD LOCKS space id 0 page no 280890 n bits 72 index `CLUST_IND` of table `SYS_TABLES` trx id CC3E29B lock mode S locks rec but not gap RECORD LOCKS space id 0 page no 147468 n bits 240 index `CLUST_IND` of table `SYS_TABLES` trx id CC3E29B lock mode S locks rec but not gap TABLE LOCK table `SYS_FOREIGN` trx id CC3E29B lock mode IS RECORD LOCKS space id 0 page no 63611 n bits 328 index `FOR_IND` of table `SYS_FOREIGN` trx id CC3E29B lock mode S locks rec but not gap TABLE LOCK table `SYS_INDEXES` trx id CC3E29B lock mode IS RECORD LOCKS space id 0 page no 64383 n bits 248 index `CLUST_IND` of table `SYS_INDEXES` trx id CC3E29B lock mode S locks rec but not gap TABLE LOCK table `SYS_FIELDS` trx id CC3E29B lock mode IX RECORD LOCKS space id 0 page no 58492 n bits 296 index `CLUST_IND` of table `SYS_FIELDS` trx id CC3E29B lock_mode X locks rec but not gap TABLE LOCK table `SYS_INDEXES` trx id CC3E29B lock mode IX TOO LOCKS PRINTED FOR THIS TRX: SUPPRESSING FURTHER PRINTS ---TRANSACTION CC3E22A, ACTIVE 3137 sec, process no 10642, OS thread id 1204422992 inserting mysql tables in use 1, locked 1 2 lock struct(s), heap size 368, 0 row lock(s), undo log entries 1435795 MySQL thread id 313, query id 13810 jerboas.gsf.de 146.107.217.21 pedant3 LOAD DATA LOCAL INFILE '/dev/stdin' INTO TABLE evidence TABLE LOCK table `p3_p15691_Myc_absce`.`evidence` trx id CC3E22A lock mode IX TABLE LOCK table `p3_p15691_Myc_absce`.`evidence` trx id CC3E22A lock mode AUTO-INC ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: Warning: a long semaphore wait: --Thread 1204422992 has waited at row/row0ins.c line 1541 for 2187.0 seconds the semaphore: S-lock on RW-latch at 0xd3e640 '&dict_operation_lock' a writer (thread id 1200163152) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row/row0ins.c line 1541 Last time write locked in file row/row0mysql.c line 3043 InnoDB: Warning: a long semaphore wait: --Thread 1191237968 has waited at buf/buf0flu.c line 986 for 2186.0 seconds the semaphore: S-lock on RW-latch at 0xd3e440 '&page_hash_latch' number of readers 0, waiters flag 0, lock_word: 100000 Last time read locked in file buf/buf0buf.c line 2209 Last time write locked in file buf/buf0lru.c line 367 InnoDB: Warning: a long semaphore wait: --Thread 1199630672 has waited at buf/buf0buf.c line 2209 for 2182.0 seconds the semaphore: S-lock on RW-latch at 0xd3e440 '&page_hash_latch' number of readers 0, waiters flag 0, lock_word: 100000 Last time read locked in file buf/buf0buf.c line 2209 Last time write locked in file buf/buf0lru.c line 367 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 100128 13:00:35 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 1 seconds ---------- BACKGROUND THREAD ---------- srv_master_thread loops: 3514 1_second, 3513 sleeps, 348 10_second, 238 background, 238 flush srv_master_thread log flush and writes: 3641 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 128381, signal count 445362 Mutex spin waits 1419161, rounds 7072571, OS waits 67668 RW-shared spins 205806, OS waits 32364; RW-excl spins 250653, OS waits 7413 Spin rounds per wait: 4.98 mutex, 7.67 RW-shared, 3.60 RW-excl ------------------------ LATEST FOREIGN KEY ERROR ------------------------ 100128 11:52:16 Error in dropping of a foreign key constraint of table "tmp_p3_p20931_Des_autot"."geneticelem_elementgrp", in SQL command ALTER TABLE `geneticelem_elementgrp` MODIFY COLUMN `elementgrp_id` SMALLINT UNSIGNED NOT NULL, DROP FOREIGN KEY `fk_geneticelem_elementgrp_02` Cannot find a constraint with the given id "fk_geneticelem_elementgrp_02". InnoDB: Renaming table `tmp_p3_p20931_Des_autot`.`geneticelem_elementgrp` to `tmp_p3_p20931_Des_autot`. failed! -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (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 230336 OS file reads, 60792 OS file writes, 17325 OS fsyncs 1 pending preads, 0 pending pwrites 30.97 reads/s, 16384 avg bytes/read, 11.99 writes/s, 5.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 45207, seg size 45209, 167 inserts, 166 merged recs, 7 merges Hash table size 8850461, node heap has 272 buffer(s) 54599.40 hash searches/s, 23545.45 non-hash searches/s --- LOG --- Log sequence number 16975064002901 Log flushed up to 16975061092284 Last checkpoint at 16974456073778 Max checkpoint age 678766142 Checkpoint age target 657554701 Modified age 555731423 Checkpoint age 607929123 0 pending log writes, 0 pending chkp writes 18251 log i/o's done, 3.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 4401922048; in additional pool allocated 0 Internal hash tables (constant factor + variable factor) Adaptive hash index 75264344 (70803688 + 4460656) Page hash 4426024 Dictionary cache 20638376 (17702416 + 2935960) File system 36899016 (82672 + 36816344) Lock system 10629384 (10625704 + 3680) Recovery system 0 (0 + 0) Threads 408216 (406936 + 1280) Dictionary memory allocated 2935960 Buffer pool size 262143 Buffer pool size, bytes 4294950912 Free buffers 34154 Database pages 180563 Old database pages 66633 Modified db pages 28664 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 409078, not young 0 30.97 youngs/s, 0.00 non-youngs/s Pages read 215685, created 707030, written 823586 30.97 reads/s, 139.86 creates/s, 63.94 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 LRU len: 180563, unzip_LRU len: 135090 I/O sum[0]:cur[31], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread process no. 10642, id 1191237968, state: sleeping Number of rows inserted 7455667, updated 442, deleted 5, read 3678235 4619.38 inserts/s, 0.00 updates/s, 0.00 deletes/s, 5.00 reads/s ------------ TRANSACTIONS ------------ Trx id counter CC3E2A7 Purge done for trx's n:o < CC3E29D undo n:o < 0 History list length 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION CC3E2A4, not started, process no 10642, OS thread id 1206552912 MySQL thread id 368, query id 14499 jerboas.gsf.de 146.107.217.21 pedant3 ---TRANSACTION CC3E2A3, not started, process no 10642, OS thread id 1205754192 MySQL thread id 363, query id 14497 jerboas.gsf.de 146.107.217.21 pedant3 ---TRANSACTION CC3E2A0, not started, process no 10642, OS thread id 1200429392 MySQL thread id 343, query id 14492 mips-fs03.gsf.de 146.107.217.15 pedantservice ---TRANSACTION CC3E29E, not started, process no 10642, OS thread id 1200695632 MySQL thread id 339, query id 14495 mips-fs03.gsf.de 146.107.217.15 pedantservice ---TRANSACTION CC3E29D, not started, process no 10642, OS thread id 1204689232 MySQL thread id 338, query id 14487 mips-fs03.gsf.de 146.107.217.15 pedantservice ---TRANSACTION CC3E276, not started, process no 10642, OS thread id 1203358032 MySQL thread id 187, query id 13909 acouchis.gsf.de 146.107.217.183 pedant3 ---TRANSACTION 0, not started, process no 10642, OS thread id 1203890512 MySQL thread id 185, query id 14525 acouchis.gsf.de 146.107.217.183 pedant3 ---TRANSACTION 0, not started, process no 10642, OS thread id 1201228112 MySQL thread id 137, query id 14479 acouchis.gsf.de 146.107.217.183 pedant3 ---TRANSACTION CC3E2A6, ACTIVE 0 sec, process no 10642, OS thread id 1202825552 estimating records in index range mysql tables in use 1, locked 0 MySQL thread id 349, query id 14526 mips-fs03.gsf.de 146.107.217.15 pedantservice statistics select userproper0_.analysis_id as analysis1___, userproper0_.userpropertyset_id as userprop2___, userproper0_.ordernum as ordernum__ from analysis_userpropertyset userproper0_ where userproper0_.analysis_id=24959 ---TRANSACTION CC3E22A, ACTIVE 3138 sec, process no 10642, OS thread id 1204422992 inserting mysql tables in use 1, locked 1 2 lock struct(s), heap size 368, 0 row lock(s), undo log entries 1440417 MySQL thread id 313, query id 13810 jerboas.gsf.de 146.107.217.21 pedant3 LOAD DATA LOCAL INFILE '/dev/stdin' INTO TABLE evidence TABLE LOCK table `p3_p15691_Myc_absce`.`evidence` trx id CC3E22A lock mode IX TABLE LOCK table `p3_p15691_Myc_absce`.`evidence` trx id CC3E22A lock mode AUTO-INC ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 100128 13:00:51 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- BACKGROUND THREAD ---------- srv_master_thread loops: 3529 1_second, 3528 sleeps, 350 10_second, 238 background, 238 flush srv_master_thread log flush and writes: 3656 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 128826, signal count 445901 Mutex spin waits 1419680, rounds 7081501, OS waits 67869 RW-shared spins 206253, OS waits 32591; RW-excl spins 250674, OS waits 7426 Spin rounds per wait: 4.99 mutex, 7.69 RW-shared, 3.60 RW-excl ------------------------ LATEST FOREIGN KEY ERROR ------------------------ 100128 11:52:16 Error in dropping of a foreign key constraint of table "tmp_p3_p20931_Des_autot"."geneticelem_elementgrp", in SQL command ALTER TABLE `geneticelem_elementgrp` MODIFY COLUMN `elementgrp_id` SMALLINT UNSIGNED NOT NULL, DROP FOREIGN KEY `fk_geneticelem_elementgrp_02` Cannot find a constraint with the given id "fk_geneticelem_elementgrp_02". InnoDB: Renaming table `tmp_p3_p20931_Des_autot`.`geneticelem_elementgrp` to `tmp_p3_p20931_Des_autot`. failed! -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (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 231546 OS file reads, 62163 OS file writes, 18629 OS fsyncs 0 pending preads, 1 pending pwrites 75.62 reads/s, 18794 avg bytes/read, 85.68 writes/s, 81.49 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 45207, seg size 45209, 538 inserts, 532 merged recs, 15 merges Hash table size 8850461, node heap has 294 buffer(s) 12018.81 hash searches/s, 3942.88 non-hash searches/s --- LOG --- Log sequence number 16975096259976 Log flushed up to 16975092275945 Last checkpoint at 16974534261185 Max checkpoint age 678766142 Checkpoint age target 657554701 Modified age 556154118 Checkpoint age 561998791 0 pending log writes, 0 pending chkp writes 18644 log i/o's done, 24.56 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 4401922048; in additional pool allocated 0 Internal hash tables (constant factor + variable factor) Adaptive hash index 75624792 (70803688 + 4821104) Page hash 4426024 Dictionary cache 20973304 (17702416 + 3270888) File system 36910040 (82672 + 36827368) Lock system 10629752 (10625704 + 4048) Recovery system 0 (0 + 0) Threads 408376 (406936 + 1440) Dictionary memory allocated 3270888 Buffer pool size 262143 Buffer pool size, bytes 4294950912 Free buffers 30367 Database pages 184098 Old database pages 67938 Modified db pages 28410 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 410464, not young 0 86.62 youngs/s, 0.00 non-youngs/s Pages read 217084, created 709901, written 826140 87.43 reads/s, 179.43 creates/s, 159.62 writes/s Buffer pool hit rate 999 / 1000, young-making rate 1 / 1000 not 0 / 1000 Pages read ahead 12.00/s, evicted without access 0.00/s LRU len: 184098, unzip_LRU len: 136287 I/O sum[0]:cur[1238], unzip sum[0]:cur[609] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread process no. 10642, id 1191237968, state: sleeping Number of rows inserted 7467651, updated 628, deleted 7, read 3692893 748.95 inserts/s, 11.62 updates/s, 0.12 deletes/s, 916.07 reads/s ------------ TRANSACTIONS ------------ Trx id counter CC3E54E Purge done for trx's n:o < CC3E3F6 undo n:o < 0 History list length 148 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION CC3E544, not started, process no 10642, OS thread id 1207085392 MySQL thread id 388, query id 15746 mips-fs03.gsf.de 146.107.217.15 pedant3 ---TRANSACTION CC3E549, not started, process no 10642, OS thread id 1206552912 MySQL thread id 390, query id 15759 mips-fs03.gsf.de 146.107.217.15 pedant3 ---TRANSACTION CC3E542, not started, process no 10642, OS thread id 1204689232 MySQL thread id 385, query id 15755 mips-fs03.gsf.de 146.107.217.15 pedant3 ---TRANSACTION CC3E53E, not started, process no 10642, OS thread id 1200961872 MySQL thread id 387, query id 15742 mips-fs03.gsf.de 146.107.217.15 pedant3 ---TRANSACTION CC3E545, not started, process no 10642, OS thread id 1200695632 MySQL thread id 386, query id 15784 mips-fs03.gsf.de 146.107.217.15 pedant3 ---TRANSACTION CC3E54C, not started, process no 10642, OS thread id 1206819152 MySQL thread id 384, query id 15786 mips-fs03.gsf.de 146.107.217.15 pedant3 ---TRANSACTION CC3E53A, not started, process no 10642, OS thread id 1200429392 MySQL thread id 382, query id 15602 mips-fs03.gsf.de 146.107.217.15 pedantservice ---TRANSACTION CC3E276, not started, process no 10642, OS thread id 1203358032 MySQL thread id 187, query id 13909 acouchis.gsf.de 146.107.217.183 pedant3 ---TRANSACTION 0, not started, process no 10642, OS thread id 1203890512 MySQL thread id 185, query id 14683 acouchis.gsf.de 146.107.217.183 pedant3 ---TRANSACTION 0, not started, process no 10642, OS thread id 1201228112 MySQL thread id 137, query id 14479 acouchis.gsf.de 146.107.217.183 pedant3 ---TRANSACTION CC3E2AD, ACTIVE 15 sec, process no 10642, OS thread id 1204422992 inserting mysql tables in use 1, locked 1 2 lock struct(s), heap size 368, 0 row lock(s), undo log entries 8237 MySQL thread id 374, query id 14589 jerboas.gsf.de 146.107.217.21 pedant3 LOAD DATA LOCAL INFILE '/dev/stdin' INTO TABLE evidencedata TABLE LOCK table `p3_p15691_Myc_absce`.`evidencedata` trx id CC3E2AD lock mode IX TABLE LOCK table `p3_p15691_Myc_absce`.`evidencedata` trx id CC3E2AD lock mode AUTO-INC ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream