Modify memory calculation formula for MySQL

Bug #1651453 reported by OpenStack Infra
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Fuel for OpenStack
Won't Fix
Medium
Fuel Documentation Team

Bug Description

https://review.openstack.org/412431
Dear bug triager. This bug was created since a commit was marked with DOCIMPACT.

commit 09ea28e73d656c3da56eac993e3395b5f3944c05
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>

Changed in fuel:
assignee: nobody → Fuel Documentation Team (fuel-docs)
tags: added: area-docs
Changed in fuel:
milestone: none → 9.x-updates
importance: Undecided → Medium
status: New → Confirmed
Revision history for this message
Oleksiy Molchanov (omolchanov) wrote :

We are not going to fix this bug.

Changed in fuel:
status: Confirmed → Won't Fix
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.