Re: Innodb bogs down on complicated query(ies)
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.
Lee
Subject
Views
Written By
Posted
3740
May 03, 2006 02:08PM
2127
May 04, 2006 02:26AM
2010
May 04, 2006 12:53PM
2198
May 05, 2006 01:39AM
2075
May 05, 2006 11:12AM
2235
May 08, 2006 05:56AM
Re: Innodb bogs down on complicated query(ies)
2062
May 08, 2006 02:05PM
2055
May 10, 2006 05:14AM
2162
May 09, 2006 08:28PM
2006
May 10, 2006 10:11AM
2972
May 18, 2006 07:41AM
2082
May 30, 2006 05:39PM
2348
June 15, 2006 02:13AM
2087
June 21, 2006 12:23AM
2109
August 10, 2006 12:09PM
3353
August 14, 2006 06:08AM
1986
August 14, 2006 12:26PM
2065
September 28, 2006 01:07PM
1992
October 04, 2006 07:52AM
1911
October 04, 2006 12:12PM
1991
October 06, 2006 03:00AM
2044
October 11, 2006 11:36AM
2078
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.