MySQL database gets slower over time

2003-07-08 Thread Steve Quezadas
have you done any optimize to your tables ? it should help improving the query performance. it's normal to have memory lower on each day, because your index files are growing, and takes memory. if you're not using innodb or bdb, you can try to run flush threads and flush tables. it might

Re: MySQL database gets slower over time

2003-07-08 Thread Paul DuBois
At 14:35 -0700 7/8/03, Steve Quezadas wrote: have you done any optimize to your tables ? it should help improving the query performance. it's normal to have memory lower on each day, because your index files are growing, and takes memory. if you're not using innodb or bdb, you can try to

MySQL database gets slower over time

2003-07-07 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