Re: Innodb bogs down on complicated query(ies)
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
Subject
Views
Written By
Posted
3962
May 03, 2006 02:08PM
2203
May 04, 2006 02:26AM
2095
May 04, 2006 12:53PM
2345
May 05, 2006 01:39AM
2167
May 05, 2006 11:12AM
2314
May 08, 2006 05:56AM
2144
May 08, 2006 02:05PM
Re: Innodb bogs down on complicated query(ies)
2136
May 10, 2006 05:14AM
2238
May 09, 2006 08:28PM
2082
May 10, 2006 10:11AM
3063
May 18, 2006 07:41AM
2173
May 30, 2006 05:39PM
2428
June 15, 2006 02:13AM
2171
June 21, 2006 12:23AM
2186
August 10, 2006 12:09PM
3436
August 14, 2006 06:08AM
2057
August 14, 2006 12:26PM
2140
September 28, 2006 01:07PM
2070
October 04, 2006 07:52AM
1994
October 04, 2006 12:12PM
2061
October 06, 2006 03:00AM
2127
October 11, 2006 11:36AM
2175
October 16, 2006 06:49AM
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.