openstack team mailing list archive

["Pitucha, Stanislaw Izaak" <stanislaw.pitucha@xxxxxx>]

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