Added to Cart
    You have items in your cart
    You have 1 item in your cart
    Check Out Continue Shopping

    The suggestions you receive will be based on the data you provide from your system.

    (After analysis of your GLOBAL STATUS and GLOBAL VARIABLES data from your system. Your specific server's analysis results will likely be ONLY similar).

    Suggestions for your my.cnf OR my.ini [mysqld] section
    or your AWS Aurora Parameters group
    or your AWS RDS Parameters group
    or your Azure portal, SETTINGS, Server parameters
    or your Google Cloud Database flags

    time saving tip for you, place at the END of [mysqld] section to replace old requests.
    Last one processed, will be used for the instance.

    Leave old values by leading the LINE with # and space character followed by ccyymmdd hh:mm - for example # 20181211 11:45 and you will have a history of all changes, in chronological order.

    To avoid long term confusion (and lose your chronological history), you may wish to retain only the LAST used variable to avoid multiple lines with the same named variable in your my.cfg or my.ini.

    Your my.cnf likely includes 4 lines that should be removed preferably (or disabled with leading # and space character, they are A) sort_buffer_size B) read_buffer_size C) read_rnd_buffer_size D) join_buffer_size - these are all per connection RAM requirements and may be driving your RAM footprint much higher than necessary.  

    Let the DEFAULTS work for you to improve response time with room to breathe in RAM.

    Consider adjusting the following in your my.cnf OR my.ini [mysqld] section, please
    key_buffer_size=512M # from 1G because 200M is used now
    innodb_buffer_pool_size=4G # lesser of =< 65% RAM OR
       (Data in Innodb tables * 1.4 ) reported by MySQLTuner
    max_connections=100 # from 500, until more than 8 are used
    thread_cache_size=100 # from 192 MySQL see v 8 refman
                        that recommends CAP of 100 to avoid OOM crash
    query_cache_limit remove to allow default of 1M rather than 32M
    query_cache_min_res_unit=512 # from 4K to store more RESULTS in QC
    table_open_cache=10000 # from 2000 to support ~ 28,000 tbls opened

    No more than one SUGGESTION per day to be applied, monitor. 

    Many of these variables may be DYNAMICALLY modified (with SET GLOBAL variable_name=xxxx;) and will be in effect AFTER the NEXT User Login for the sessions they run.

    Updating your active my.cnf OR my.ini [mysqld] section will be applicable AFTER services shutdown/restart of your instance for this server.

    Refer to your user manual for details.

    Our 4 business day clock STARTS when you have emailed your links
    as requested at the end of "Data We Need".
    If we can not read/use your data, we will attempt to reach you via
    your email address with specifics on TEXT data requirements and the
    4 business day START date/time will be reset when new links are provided
    and we can read/use your data.