Comment 7 for bug 1648766

Reviewed: https://review.openstack.org/413112
Committed: https://git.openstack.org/cgit/openstack/fuel-library/commit/?id=095d0092067373691309230ee442845f2b17bc67
Submitter: Jenkins
Branch: stable/newton

commit 095d0092067373691309230ee442845f2b17bc67
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_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

    DocImpact
    Closes-Bug: #1648766

    Change-Id: Ia48f94936fcd3090208e4e485d7c9cbfea3c0ed4
    Signed-off-by: Sergii Golovatiuk <email address hidden>