I have a development MySQL server running on a dedicated CentOS virtual machine, under VirtualBox & Windows.
I've been using it for months with a pretty decent performance, and have an history of SQL patches to create a project's database from scratch that up to now, was taking less than a minute to run.
When I tried to re-run the patches today, it started to take several minutes, which is considerably slower than it used to be.
Here is a
top output when it looks the most "busy":
But most of the time, the output is the following:
mysqladmin status says:
Uptime: 805 Threads: 3 Questions: 894 Slow queries: 0 Opens: 1277 Flush tables: 1 Open tables: 98 Queries per second avg: 1.110
So, for me, the server looks almost idle, although it's actually running a big SQL patch, and making me wait for ages...
Any idea what could be slowing it down?