- 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_options
hash, as these settings are galera specific, so they should be
explicitly in wsrep_options hash
- Remove myisam_sort_buffer_size. OpenStack services use InnoDB engine,
so MyISAM optimazation should be disabled. The only DB which uses
MyISAM is 'mysql'. The default value 8M is enough
Reviewed: https:/ /review. openstack. org/412431 /git.openstack. org/cgit/ openstack/ fuel-library/ commit/ ?id=09ea28e73d6 56c3da56eac993e 3395b5f3944c05
Committed: https:/
Submitter: Jenkins
Branch: master
commit 09ea28e73d656c3 da56eac993e3395 b5f3944c05
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 options sort_buffer_ size. OpenStack services use InnoDB engine,
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 90208e4e485d7c9 cbfea3c0ed4
Signed-off-by: Sergii Golovatiuk <email address hidden>