MySQL Forums
Forum List  »  InnoDB

Re: Innodb bogs down on complicated query(ies)
Posted by: Lee Krawczyk
Date: May 30, 2006 05:39PM

Howdy,

I've since added a couple more indexes and changed the tmp directory to tmpfs on another drive, and while the slow down has gotten mostly better, we did have a major bottle neck problem today. Not sure why but the CPU got pinned a couple of times during the spell. I couldn't even open another session for a couple of minutes. The only thing that cleared it up was to restart Apache.

Is it possible that somehow preparing to send a more than usual amount of data (2M) through Apache to the client is causing a strain? I don't see any new forks being created from Apache 1.3.34.

I'm also wondering if it might have something to do with DBD::Mysql. We are using the latest version though.

Lee

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Innodb bogs down on complicated query(ies)
1848
May 30, 2006 05:39PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.