MySQL gets slower over time

2003-07-01 Thread Steve Quezadas
HIdey Ho. I have a fairly large mysql database (a few million records) and queries run pretty damn fast. However, over time (say, over the course of a month), performance gets slower and slower. I am not sure why! I suspected a memory leak so i restarted mysql. No dice. Now, if I reboot the

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 run

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 have