← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1602407] [NEW] MySQL tests significantly slower than PostgreSQL tests

 

Public bug reported:

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.

** Affects: keystone
     Importance: Undecided
         Status: New

-- 
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):
  New

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


Follow ups