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 whole *server*, then performance jumps back up. I have a ton of RAM (3 gigs). But could it be that the server is using more and more RAM for a memory cache and thus giving less of it to mysql over time, thus making it go slower? This is my theory, but not sure why. Here is are some tops:
First day: Mem: 3098984K av, 1159340K used, 1939644K free, 0K shrd, 8168K buff Swap: 1052248K av, 0K used, 1052248K free 1068688K cached a week and a half later: Mem: 3098984K av, 1764340K used, 1334644K free, 0K shrd, 66416K buff Swap: 1052248K av, 0K used, 1052248K free 1585156K cached 40 days later: Mem: 3098984K av, 2487488K used, 611496K free, 0K shrd, 70360K buff Swap: 1052248K av, 0K used, 1052248K free 2274124K cached Seems the "memory free" keeps on getting lower. Also I did *not* copy "my-huge.cnf" to "my.cnf". The server is a production machien and I didn't realize this later. I am thinking this might help my problem, but would like some feedback. - Steve