-
Yesterday happened to be one of the busiest days for us ever
on our MySQL backed web site. For the entire day MySQL was
hit with up to 1200 queries/second, and many queries were
being delayed at least 2-15 seconds.
-
I know how you feel. We were hitting 7700
On Thu, Jan 02, 2003 at 10:30:50AM -0500, Michael Bacarella wrote:
Hi,
Yesterday happened to be one of the busiest days for us ever on our
MySQL backed web site. For the entire day MySQL was hit with up to
1200 queries/second, and many queries were being delayed at least
2-15 seconds. We
However, I can't figure out exactly why it was slow. Key efficiency
was at 100%, and I *believe* the InnoDB buffer pool was large enough
as the InnoDB monitor was reporting 1000 / 1000 cache hits.
iostat showed the usual levels of disk I/O.
What other statistics can I look at?
-
Yesterday happened to be one of the busiest days for us ever
on our MySQL backed web site. For the entire day MySQL was
hit with up to 1200 queries/second, and many queries were
being delayed at least 2-15 seconds.
-
I know how you feel. We were hitting 7700