[I'm marking this OT as it's looking increasingly like a database issue]
From: Chris Cherrett [mailto:[EMAIL PROTECTED]
Tomcat averaged 15% CPU
Mysql spiked the CPU usage to 100% when hit with long queries.
Bloody. Would you expect that to be the case? Naively, I'd be looking
at my
On Tuesday 30 November 2004 12:42, Peter Crowther wrote:
Bloody. Would you expect that to be the case? Naively, I'd be looking
at my database indexing at this point and seeing what was causing mySQL
to have problems.
I had a similar problem with PostgresQL. Created some indexes and now the
The queries are very complex in this case. I will look into indexing and see
what I can do. Thanks for the help. I will post back to tell you what I come
up with.
Thanks
On November 30, 2004 03:46 am, Quinton Delpeche wrote:
On Tuesday 30 November 2004 12:42, Peter Crowther wrote:
Bloody.
From: Chris Cherrett [mailto:[EMAIL PROTECTED]
The queries are very complex in this case. I will look into
indexing and see
what I can do. Thanks for the help. I will post back to tell
you what I come up with.
Best of luck! I find that capturing a workload and replaying it is the
only