MySQL footprint keeps growing...

[John Lawton]

I noticed that the resources used by MySQL grow continually. I recently restarted our MySQL server because the process had grown to 259MB. MySQL is used by our Webserver running CGI scripts with roughly 57,000 connections in the last couple of days. Currently the process is using 18MB of memory.

I was wondering how big will mysqld get? What is a reasonable amount of memory to give mysqld running on a 750 MHz machine with 500MB RAM serving roughly ten sites. What can I do to minimize and or limit the memory consumed by MySQL, whithout degrading performance?

We have one table with 200,000k entries, all other tables have no more than a couple hundred entries. So I'd consider the DB relatively small. Let me know if additional information is required.

thanks in advance,

-john


---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php