[openstack-dev] [Ceilometer]Collector's performance

Roman Podoliaka rpodolyaka at mirantis.com
Tue Mar 11 22:59:53 UTC 2014


Hi all,

FWIW, just an assumption.

>> i am curious as to why postgresql passes but not mysql? is postgres actually faster or are it's default configurations set up better?

If eventlet green threads are used, psycopg2 allows context switching
on blocking IO, while python-mysqldb blocks the whole process. That's
why we run multiple API/conductor processes in e.g. Nova to handle
concurrent requests.

And yes, PostgreSQL defaults are usually way better :)

Thanks,
Roman

On Tue, Mar 11, 2014 at 3:49 PM, Gordon Chung <chungg at ca.ibm.com> wrote:
> i did notice the collector service was only ever writing one db connection
> at a time. i've opened a bug for that here:
> https://bugs.launchpad.net/ceilometer/+bug/1291054
>
> i am curious as to why postgresql passes but not mysql? is postgres actually
> faster or are it's default configurations set up better?
>
> cheers,
> gordon chung
> openstack, ibm software standards
> _______________________________________________
> OpenStack-dev mailing list
> OpenStack-dev at lists.openstack.org
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>



More information about the OpenStack-dev mailing list