MySQL Forums
Forum List  »  InnoDB

Re: Innodb bogs down on complicated query(ies)
Posted by: Marko Mäkelä
Date: May 10, 2006 05:14AM

I'm glad that the problem was solved. I'm not experienced in reading the EXPLAIN SELECT output, and AFAIK there is no way to request the execution plan for other statements than SELECT.

The temporary directory is specified with mysqld --tmpdir=... or with tmpdir=... in the [mysqld] section of my.cnf. The location is not configureable with an environment variable, since MySQL does not use tmpfile() from the standard library.

Marko

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Innodb bogs down on complicated query(ies)
2055
May 10, 2006 05:14AM


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.