← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1602407] Re: MySQL tests significantly slower than PostgreSQL tests

 

[Expired for OpenStack Identity (keystone) because there has been no
activity for 60 days.]

** Changed in: keystone
       Status: Incomplete => Expired

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Identity (keystone).
https://bugs.launchpad.net/bugs/1602407

Title:
  MySQL tests significantly slower than PostgreSQL tests

Status in OpenStack Identity (keystone):
  Expired

Bug description:
  Running the keystone opportunistic mysql and postgresql tests locally
  I noticed that the mysql tests run in 18-19seconds each and the
  postgresql tests run in 4-5seconds each. This may be a performance
  issue in keystone itself, in mysql, or in the test framework but it is
  likely a good idea to sort it out.

  My setup is an Ubuntu Xenial virtual machine running mysql 5.7 and
  postgres 9.5. I am running the tests serially so that they do not
  interfere with each other.

  To reproduce make sure you have mysql and postgresql configured as in
  the gate and run:

    tox -epy27 -- --concurrency 1

  Then compare the test run times.

To manage notifications about this bug go to:
https://bugs.launchpad.net/keystone/+bug/1602407/+subscriptions


References