I'm concerned about memory usage of mysql connections. I've been reading the mailing list archives but I'm still clueless.
I need to buy a new server for a mysql database that will have at least 500 persistent connections from an Apache server with mod_perl. I'm checking the memory usage of the development server. I've used Apache::VMonitor to find out the apache shared memory issues. But I'm unable to see what's happening with the mysql connections. Here is the output of VMonitor: ## PID UID Size Share VSize Rss TTY St Command 1 23902 mysql 21M 2.2M 71M 21M S mysqld 2 23904 mysql 21M 2.2M 71M 21M S mysqld 3 23905 mysql 21M 2.2M 71M 21M S mysqld 4 23906 mysql 21M 2.2M 71M 21M S mysqld .... Does this mean every connection uses 21M of memory, 2.2 MB shared with the rest of mysql clients ? Any hint for the memory required for this server ? thank you very much. --------------------------------------------------------------------- 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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
