[Openstack] Nova DB Connection Pooling

Devin Carlen devin.carlen at gmail.com
Tue Sep 27 01:26:39 UTC 2011


We really need to hear from Sandy Walsh on this thread so he can elaborate on how the distributed scheduling works (with multiple mysql databases).

Devin


On Sep 26, 2011, at 6:41 AM, Soren Hansen wrote:

> 2011/9/26 Pitucha, Stanislaw Izaak <stanislaw.pitucha at hp.com>:
>> 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 ;)
> 
> Hm.. It doesn't take many racks full of blade servers to get into 4
> digit numbers of compute nodes. Certainly fewer than I was expecting
> to see in a garden variety Nova zone.
> 
> -- 
> Soren Hansen        | http://linux2go.dk/
> Ubuntu Developer    | http://www.ubuntu.com/
> OpenStack Developer | http://www.openstack.org/
> 
> _______________________________________________
> Mailing list: https://launchpad.net/~openstack
> Post to     : openstack at lists.launchpad.net
> Unsubscribe : https://launchpad.net/~openstack
> More help   : https://help.launchpad.net/ListHelp





More information about the Openstack mailing list