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 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]