Re: Innodb bogs down on complicated query(ies)
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
Subject
Views
Written By
Posted
3820
May 03, 2006 02:08PM
2153
May 04, 2006 02:26AM
2033
May 04, 2006 12:53PM
2254
May 05, 2006 01:39AM
2104
May 05, 2006 11:12AM
2264
May 08, 2006 05:56AM
2092
May 08, 2006 02:05PM
2080
May 10, 2006 05:14AM
2181
May 09, 2006 08:28PM
2029
May 10, 2006 10:11AM
3011
May 18, 2006 07:41AM
Re: Innodb bogs down on complicated query(ies)
2115
May 30, 2006 05:39PM
2382
June 15, 2006 02:13AM
2112
June 21, 2006 12:23AM
2136
August 10, 2006 12:09PM
3383
August 14, 2006 06:08AM
2013
August 14, 2006 12:26PM
2087
September 28, 2006 01:07PM
2012
October 04, 2006 07:52AM
1931
October 04, 2006 12:12PM
2011
October 06, 2006 03:00AM
2075
October 11, 2006 11:36AM
2119
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.