The pain starts when your max memory usage crosses what you have available.
Check http://dev.mysql.com/doc/refman/5.1/en/memory-use.html - especially 
comments which calculate the needed memory for N connections for both innodb 
and isam. (mysqltuner.pl will also calculate that for you)

Hundreds of connections should be ok. Thousands... you should rethink it ;)

If you want to improve connection pooling, look at the "Mysql proxy" project.

Regards,
Stanisław Pitucha
Cloud Services 
Hewlett Packard

Attachment: smime.p7s
Description: S/MIME cryptographic signature

_______________________________________________
Mailing list: https://launchpad.net/~openstack
Post to     : openstack@lists.launchpad.net
Unsubscribe : https://launchpad.net/~openstack
More help   : https://help.launchpad.net/ListHelp

Reply via email to