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 -------------- next part -------------- A non-text attachment was scrubbed... Name: smime.p7s Type: application/x-pkcs7-signature Size: 6216 bytes Desc: not available URL: <http://lists.openstack.org/pipermail/openstack/attachments/20110926/55c5c92d/attachment.bin>