Hi, Heikki£¬i also meet this problem. The innodb data file ibdata1 grew from 10MB to 100GB£¬there are parameters about innodb: +---------------------------------+--------------------------+ | Variable_name | Value | +---------------------------------+--------------------------+ | innodb_additional_mem_pool_size | 16777216 | | innodb_autoextend_increment | 8 | | innodb_buffer_pool_awe_mem_mb | 0 | | innodb_buffer_pool_size | 2147483648 | | innodb_checksums | ON | | innodb_commit_concurrency | 0 | | innodb_concurrency_tickets | 500 | | innodb_data_file_path | ibdata1:1024M:autoextend | | innodb_data_home_dir | | | innodb_doublewrite | ON | | innodb_fast_shutdown | 1 | | innodb_file_io_threads | 4 | | innodb_file_per_table | ON | | innodb_flush_log_at_trx_commit | 1 | | innodb_flush_method | | | innodb_force_recovery | 0 | | innodb_lock_wait_timeout | 120 | | innodb_locks_unsafe_for_binlog | OFF | | innodb_log_arch_dir | | | innodb_log_archive | OFF | | innodb_log_buffer_size | 16777216 | | innodb_log_file_size | 419430400 | | innodb_log_files_in_group | 3 | | innodb_log_group_home_dir | ./ | | innodb_max_dirty_pages_pct | 90 | | innodb_max_purge_lag | 0 | | innodb_mirrored_log_groups | 1 | | innodb_open_files | 300 | | innodb_support_xa | ON | | innodb_sync_spin_loops | 20 | | innodb_table_locks | ON | | innodb_thread_concurrency | 16 | | innodb_thread_sleep_delay | 10000 | +---------------------------------+--------------------------+ the output of "SHOW ENGINE INNODB STATUS": ===================================== 070912 14:00:45 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 48 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 79067935, signal count 73038436 Mutex spin waits 0, rounds 186702134, OS waits 29568133 RW-shared spins 102515259, OS waits 35250122; RW-excl spins 77488694, OS waits 3463709 ------------ TRANSACTIONS ------------ Trx id counter 0 1744848328 Purge done for trx's n:o < 0 1744843798 undo n:o < 0 0 History list length 63 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 0, not started, process no 17425, OS thread id 890731440 MySQL thread id 98976683, query id 1511540388 10.19.30.20 root ---TRANSACTION 0 1744848294, not started, process no 17425, OS thread id 1003715504 mysql tables in use 2, locked 0 MySQL thread id 98976667, query id 1511540403 10.19.30.20 root Select pro.id,pro.name as name,pro.brief,pro.product_line_id,pro.stop,pro.regdate,pro.editdate,pro.level, pro.last_price_date, manufacturerid,subcategoryid,pro.photoid,manu.valid,manu.parent_id as parentid,manu.name as mname from products as pro,manufacturer as manu where pro.id='89231' and manu.id=pro.manufacturerid ---TRANSACTION 0 1744848256, not started, process no 17425, OS thread id 1024932784 MySQL thread id 98976650, query id 1511540033 10.19.30.20 root ---TRANSACTION 0 1744848247, not started, process no 17425, OS thread id 1137626032 MySQL thread id 98976651, query id 1511540007 10.19.30.20 root ---TRANSACTION 0 1744848195, not started, process no 17425, OS thread id 880200624 MySQL thread id 98976634, query id 1511539771 10.19.30.20 root ---TRANSACTION 0 1744848277, not started, process no 17425, OS thread id 874511280 MySQL thread id 98976624, query id 1511540161 10.19.30.20 root ---TRANSACTION 0 1744848317, not started, process no 17425, OS thread id 872504240 MySQL thread id 98976485, query id 1511540357 10.19.30.20 root ---TRANSACTION 0 1744848327, not started, process no 17425, OS thread id 802622384 MySQL thread id 98976458, query id 1511540399 10.19.30.20 root storing result in query cache select domain,self_domain,is_directed from site_main where userid='50011' and user_type='dealer'#price.tech.qq.com in /detail/sources/pro_page_publish.php ---TRANSACTION 0 0, not started, process no 17425, OS thread id 882699184 MySQL thread id 98975745, query id 1511512645 10.19.30.20 root ---TRANSACTION 0 1744842581, not started, process no 17425, OS thread id 1016069040 MySQL thread id 98975677, query id 1511510457 10.19.30.20 root ---TRANSACTION 0 1744838938, not started, process no 17425, OS thread id 956300208 MySQL thread id 98975168, query id 1511487485 10.19.30.20 root ---TRANSACTION 0 1744848149, not started, process no 17425, OS thread id 1128332208 MySQL thread id 98974350, query id 1511539458 10.19.30.20 root ---TRANSACTION 0 1744835179, not started, process no 17425, OS thread id 1004456880 MySQL thread id 98974234, query id 1511465350 10.19.30.20 root ---TRANSACTION 0 0, not started, process no 17425, OS thread id 765639600 MySQL thread id 98966852, query id 1511540405 localhost root show innodb status ---TRANSACTION 0 1744848240, not started, process no 17425, OS thread id 1001876400 MySQL thread id 98232450, query id 1511540372 10.19.30.20 root ---TRANSACTION 0 1744848326, not started, process no 17425, OS thread id 869850032 MySQL thread id 98232353, query id 1511540406 10.19.30.20 root cleaning up ---TRANSACTION 0 1744848275, not started, process no 17425, OS thread id 1153313712 MySQL thread id 9, query id 1511540157 Has read all relay log; waiting for the slave I/O thread to update it -------- 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 (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 120165545 OS file reads, 36088272 OS file writes, 1863595 OS fsyncs 212.79 reads/s, 21752 avg bytes/read, 33.96 writes/s, 1.56 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 23, free list len 19, seg size 43, 5336917 inserts, 5333354 merged recs, 1128716 merges Hash table size 6225619, used cells 2618076, node heap has 3334 buffer(s) 43118.35 hash searches/s, 5220.52 non-hash searches/s --- LOG --- Log sequence number 32 2426592551 Log flushed up to 32 2426585937 Last checkpoint at 32 2417295373 0 pending log writes, 0 pending chkp writes 31770866 log i/o's done, 32.92 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 1769621771; in additional pool allocated 16777088 Buffer pool size 96000 Free buffers 0 Database pages 92666 Modified db pages 1064 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 193816264, created 693369, written 6552282 282.64 reads/s, 0.67 creates/s, 1.52 writes/s Buffer pool hit rate 999 / 1000 -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread process no. 17425, id 1172601776, state: sleeping Number of rows inserted 10084546, updated 43494826, deleted 4056046, read 331697895 26.54 inserts/s, 33.25 updates/s, 67.75 deletes/s, 343240.47 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ and the output of innodb_tablespace_monitor looked like: ================================================ 070912 16:27:26 INNODB TABLESPACE MONITOR OUTPUT ================================================ FILE SPACE INFO: id 0 size 7736960, free limit 7697792, free extents 2 not full frag extents 1: used pages 55, full frag extents 120273 first seg id not used 0 116075324 SEGMENT id 0 1 space 0; page 2; res 2 used 2; full ext 0 fragm pages 2; free extents 0; not full extents 0: pages 0 SEGMENT id 0 2 space 0; page 2; res 1 used 1; full ext 0 .......... SEGMENT id 0 108471277 space 0; page 585; res 1 used 1; full ext 0 fragm pages 1; free extents 0; not full extents 0: pages 0 .......... SEGMENT id 0 108471495 space 0; page 19403; res 1 used 1; full ext 0 fragm pages 1; free extents 0; not full extents 0: pages 0 .......... SEGMENT id 0 116075032 space 0; page 7697302; res 1 used 1; full ext 0 fragm pages 1; free extents 0; not full extents 0: pages 0 .......... SEGMENT id 0 116075321 space 0; page 7697646; res 1 used 1; full ext 0 fragm pages 1; free extents 0; not full extents 0: pages 0 SEGMENT id 0 116075322 space 0; page 7697646; res 1 used 1; full ext 0 fragm pages 1; free extents 0; not full extents 0: pages 0 SEGMENT id 0 116075323 space 0; page 7697646; res 1 used 1; full ext 0 fragm pages 1; free extents 0; not full extents 0: pages 0 NUMBER of file segments: 7604278 Validating tablespace InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 611466160 has waited at trx0undo.c line 1682 for 785.00 seconds the semaphore: Mutex at 0xb2d6a66c created file trx0rseg.c line 150, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 623606704 has waited at trx0undo.c line 1682 for 785.00 seconds the semaphore: Mutex at 0xb2d6a66c created file trx0rseg.c line 150, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 667855792 has waited at trx0purge.c line 454 for 782.00 seconds the semaphore: Mutex at 0xb2d6a66c created file trx0rseg.c line 150, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 617286576 has waited at trx0undo.c line 1682 for 778.00 seconds the semaphore: Mutex at 0xb2d6a66c created file trx0rseg.c line 150, lock var 1 waiters flag 1 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 Validation ok --------------------------------------- END OF INNODB TABLESPACE MONITOR OUTPUT ======================================= the output in error log were up to 900MB+,so i can't paste them all,sorry thanks much