It takes too long to init service databases

Bug #1237672 reported by aeva black
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
tripleo
Fix Released
High
Unassigned

Bug Description

The various calls to "init-db" take far, far longer than I think they should. See
  https://review.openstack.org/#/c/50745/
for an example of the lengths being taken to accommodate this. Something must be done besides sleep($more)!

My suspicion is that a few well-placed config changes will drastically reduce the time needed to run all these ALTERs on a (mostly) empty data set. This could be adjusting innodb's file-per-table or flush-log-at-trx-commit settings, or mysql's open_files_limit or table_open_cache or sync_binlog settings, or some tuning of the FS to help with performance of many rapid metadata changes (eg, mount with noatime and nodiratime, or change xfs journal size if using xfs). Or something else.

Changed in tripleo:
status: New → Triaged
importance: Undecided → High
Revision history for this message
Gregory Haynes (greghaynes) wrote :

Im fairly certain this has been "fixed" by default now. As evidenced by http://logs.openstack.org/66/148766/2/check-tripleo/check-tripleo-ironic-undercloud-precise-nonha/62791c2/logs/seed_logs/os-collect-config.txt.gz#_Jan_21_01_11_38 where migrations take a couple seconds (and most of that time is just getting to the point where migrations start running).

Changed in tripleo:
status: Triaged → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.