How can we tell if we're maxing out MySQL/InnoDB capacity?

2003-01-02 Thread Michael Bacarella
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 were serving about 300% of our normal load. In my opinion MySQL scaled

RE: How can we tell if we're maxing out MySQL/InnoDB capacity?

2003-01-02 Thread Steven Roussey
- 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

Re: How can we tell if we're maxing out MySQL/InnoDB capacity?

2003-01-02 Thread Jeremy Zawodny
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

Re: How can we tell if we're maxing out MySQL/InnoDB capacity?

2003-01-02 Thread Michael Bacarella
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?

RE: How can we tell if we're maxing out MySQL/InnoDB capacity?

2003-01-02 Thread Steven Roussey
- 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