Re: insert stops insert in other tables

[Peter Brawley]

Are multiple users using this app? If so, your machine looks under-resourced for what you're trying to do.

If MySQL has access to most of the 4GB, you might improve performance by increasing innodb_buffer_pool_size to 2 or 3 GB. Mutex numbers suggest disk i/o is the bottleneck. If growing the buffer doesn't improve performance, you might consider doing the table copy at off-peak times, or reconsider the need for the copy---is it in fact necessary? If it is, and if such table copying is frequent, you probably need a faster disk and perhaps more RAM.