> 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 release some memory. ;-)
Yeah, that's the thing, the tables don't change. I add maybe 50,000 records in total every three months, but that's about it. Also, no one USES the databse. only like one a day for a few queries. I am thinking that redhat linux, and not mysql, is the culprit since the top reveals that the buffer size is increasing in memory. It's just weird that it gets slower over time, I suspect it's due to RAM.
I am using myISAM tables. Is that innodb or bdb?
Neither. MyISAM, InnoDB, and BDB are three different storage engines supported by MySQL.
- Steve
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
