inserts on large tables (60G) very slow

[Jie Wu]

A project of mine involves loading data to several MyISAM tables by using insert statement(mysql load command is not an option for us). Two of the biggest tables are 63G and 82G respectively. Just a couple of days ago the inserts ran ok speed-wise. Now suddenly it becomes much much more slower. There is no environment change and I have checked the server performance and the server is neither CPU or IO bound. While it was inserting one of the big tables, I actually ran a test to insert 1M rows into another table (end up to be 74mb in size) in 7 minutes. So the system seems health. But what happened to the inserts to my two big tables.

Thanks for sharing ideas.

Jie