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
> 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
> table
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 who