MySQL Forums
Forum List  »  InnoDB

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

I've added an index that seems to have helped. We get a bit of a slow down, but the hanging has stopped (for now). This makes me wonder if all this has to do with temporary disk storage. I've read in some of the performance posts that setting /tmp up as tmpfs has helped. Is this something you would advocate? Where exactly does mysql and innodb set up its temporary space?

Thanks for all your help.


Options: ReplyQuote

Written By
Re: Innodb bogs down on complicated query(ies)
May 08, 2006 02:05PM

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.