Mysql needs some tuning in order to work faster
Bug #1728577 reported by
Cédric Jeanneret deactivated
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
tripleo |
Incomplete
|
Wishlist
|
Unassigned |
Bug Description
Dear Stacker,
A bit astonished by the slowness of both Horizon and API calls, we searched a bit in order to find what could be so slow.
After some checks, it appears the Galera cluster is the main culprit. The following output is from the mysql tuner script¹:
http://
It would be good to have a look at that output and, if possible, provide some nice tuning in the tripleO deploy process - most of them are static one, and some are memory-dependent, and might be calculated based on puppet's fact like $::memorysize_mb (it's a float).
Thank you!
Cheers,
C.
Changed in tripleo: | |
status: | New → Triaged |
milestone: | none → queens-2 |
importance: | Undecided → High |
tags: | added: pike-backport-potential |
Changed in tripleo: | |
milestone: | queens-2 → queens-3 |
Changed in tripleo: | |
milestone: | queens-3 → queens-rc1 |
Changed in tripleo: | |
milestone: | queens-rc1 → rocky-1 |
Changed in tripleo: | |
milestone: | rocky-1 → rocky-2 |
Changed in tripleo: | |
milestone: | rocky-2 → rocky-3 |
Changed in tripleo: | |
milestone: | rocky-3 → rocky-rc1 |
Changed in tripleo: | |
milestone: | rocky-rc1 → stein-1 |
Changed in tripleo: | |
milestone: | stein-1 → stein-2 |
Changed in tripleo: | |
milestone: | stein-2 → stein-3 |
Changed in tripleo: | |
milestone: | stein-3 → stein-rc1 |
Changed in tripleo: | |
milestone: | stein-rc1 → train-1 |
Changed in tripleo: | |
milestone: | train-1 → train-2 |
Changed in tripleo: | |
milestone: | train-2 → train-3 |
Changed in tripleo: | |
milestone: | train-3 → ussuri-1 |
Changed in tripleo: | |
milestone: | ussuri-1 → ussuri-2 |
Changed in tripleo: | |
milestone: | ussuri-2 → ussuri-3 |
Changed in tripleo: | |
status: | Triaged → Incomplete |
Changed in tripleo: | |
milestone: | ussuri-3 → ussuri-rc3 |
Changed in tripleo: | |
milestone: | ussuri-rc3 → victoria-1 |
Changed in tripleo: | |
milestone: | victoria-1 → victoria-3 |
Changed in tripleo: | |
importance: | High → Wishlist |
To post a comment you must log in.
As the paste will expire, here's the same log output.