Use iostat -x while the query is running. You are likely I/O bound doing a
table scan on the protected (BIG) table.
There has been alot of discussion about RAM and CPU on this thread regarding
performance, but nothing regarding disk I/O. If you're going to put tens of
millions of records in a
Hi All,
First thanks to all who worked on InnoDB, it is truely exciting to get its
features in an open-source DB. We've had an excellent experience thus far
with a few exceptions. Any help on solving the problem below is greatly
appreciated ...
We experienced a hard lockup a few days ago with