Modify memory calculation formula for MySQL
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Fuel for OpenStack |
Won't Fix
|
Medium
|
Fuel Documentation Team |
Bug Description
https:/
Dear bug triager. This bug was created since a commit was marked with DOCIMPACT.
commit 0d7f92adb595914
Author: Sergii Golovatiuk <email address hidden>
Date: Mon Dec 19 12:15:47 2016 +0100
Modify memory calculation formula for MySQL
- Optimize memory calculation formula. From one hand we want to limit
MySQL to allocate not more than 50% of RAM. From other hand we want to
have 1024 or greater connections. So, if environment has 2GB MySQL
will allocate 1720Mb, if environment has 3 GB it will allocate 1984Mb
of RAM. It will allocate 50% of RAM if server has 4.5+ GB. The higher
limit will have action if server has 37+GB. In that case MySQL will
allocate less than 50% of RAM.
- Pass key_buffer_size in megabytes rather than bytes.
- Remove query_cache_type, query_cache_type from fuel_override_
hash, as these settings are galera specific, so they should be
explicitly in wsrep_options hash
- Remove myisam_
so MyISAM optimazation should be disabled. The only DB which uses
MyISAM is 'mysql'. The default value 8M is enough
DocImpact
Closes-Bug: #1648766
Change-Id: Ia48f94936fcd30
Signed-off-by: Sergii Golovatiuk <email address hidden>
Changed in fuel: | |
assignee: | nobody → Fuel Documentation Team (fuel-docs) |
Changed in fuel: | |
milestone: | none → 9.x-updates |
importance: | Undecided → Medium |
status: | New → Confirmed |
We are not going to fix this bug.