RE: MySQL gets slower over time

2003-07-01 Thread Dathan Vance Pattishall
Run the Analyze table command. It will recalculate the Cardinality of a key structure. -->-Original Message- -->From: Steve Quezadas [mailto:[EMAIL PROTECTED] -->Sent: Tuesday, July 01, 2003 10:37 AM -->To: [EMAIL PROTECTED] -->Subject: MySQL gets slower over time --> -->HIdey Ho. --> -->I

Re: MySQL gets slower over time

2003-07-01 Thread Jerry
MySQL & OS version and hardware ? Jerry - Original Message - From: "Steve Quezadas" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 01, 2003 6:36 PM Subject: MySQL gets slower over time HIdey Ho. I have a fairly large mysql database (a few million records) and queries