Re: Slow server - any idea?

2004-07-26 Thread Julien Lavigne du Cadet
<[EMAIL PROTECTED]> Sent: Monday, July 26, 2004 3:06 PM Subject: RE: Slow server - any idea? > How often do you optimize/analyze your tables? Have you checked the index > cardinality? What does an explain plan show? > > -Original Message- > From: Julien Lavigne du Cadet &

RE: Slow server - any idea?

2004-07-26 Thread Victor Pendleton
How often do you optimize/analyze your tables? Have you checked the index cardinality? What does an explain plan show? -Original Message- From: Julien Lavigne du Cadet To: [EMAIL PROTECTED] Sent: 7/25/04 4:26 PM Subject: Slow server - any idea? Hi eveybody, I've got problems since

Slow server - any idea?

2004-07-25 Thread Julien Lavigne du Cadet
Hi eveybody, I've got problems since a few weeks with my mysql server. There are a lot of slow queries (about 1200 in less than 48 hours), even some that should absolutely not be slow like this one which is performing on a HEAP table : SELECT * FROM vb3_session WHERE sessionhash = '31d429cc3820a

mysql slow server after crash

2004-05-15 Thread Jim Nachlin
Hi List, Recently, a machine running an instance of mySQL crashed and had to be rebooted. Cause still unknown, but could have been RAID controller problem. Since then, the mySQL sserver has been extremely slow. For instance, a SELECT that would have taken < 1 second can take > 70 seconds. A

slow server

2001-10-19 Thread Neil Tompkins
Hello, I'm running the following Redhat Linux IASP 2.0 mySQL If my site is continually viewed the iASP engine or mySQL seems to slow down Any ideas on why or how to correct this problem Thanks Neil - Before posting, p