------=_NextPart_000_01E4_01C34425.7A6BCDF0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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.=20

- Steve


------=_NextPart_000_01E4_01C34425.7A6BCDF0--