On Fri, 26 Apr 2013, James Harper <james.harper@bendigoit.com.au> wrote:
The system load is ~1.15, and mysqld is highest on the list of processes but is only 1-2%, which I assume means that the cpu is being blocked somewhere due to IO (?).
Disk write performance inside the VM where Bacula and mysql runs is around 90MB/second, which is more than sufficient to insert a few hundred thousand rows.
iostat while all this is going on shows pretty much nothing happening.
What does iostat show for %util? If the overall speed is low but %util is near 100% then it usually means a storage hardware problem. Also 90MB/s isn't the issue for most database stuff, the issue is the number of synchronous operations. Of course for a temporary table it probably shouldn't be synchronising the data, Arjen? -- My Main Blog http://etbe.coker.com.au/ My Documents Blog http://doc.coker.com.au/