Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Mysql optimization suggestions?

Discussion in 'Workarounds and Optimization' started by Larkolag, Jan 4, 2018.

  1. Larkolag

    Larkolag Active Member

    Joined:
    May 22, 2017
    Messages:
    35
    Likes Received:
    1
    Trophy Points:
    8
    Location:
    Trabzon
    cPanel Access Level:
    Root Administrator
    Twitter:
    friends hello, cpanel I made mysql optimizations for my centos server, but the usage of ram increased too much what could be the reason I'm writing the server properties below.
    Ram: 11867 MB
    cpu: 8
    Disk:215GB Sas
    Os: Cloudlinux
    The contents of my.cnf file are as follows. what should i do to reduce ram usage. when I use this my.cnf the ram usage is 98% how can i solve this problem?
    Can you help me to organize the best optimized setup file for my server?

    Code:
    [mysqld]
    performance_schema=on
    skip-networking
    innodb_file_per_table=1
    tmpdir=/tmp
    max_connections=500
    max_user_connections=500
    key_buffer_size=1024M
    myisam_sort_buffer_size=512M
    join_buffer_size=8M
    read_buffer_size=8M
    sort_buffer_size=8M
    table_open_cache=1024M
    thread_cache_size=512M
    table_definition_cache=3072
    open_files_limit=64000
    wait_timeout=300
    connect_timeout=300
    tmp_table_size=512M
    read_rnd_buffer_size=786432
    max_heap_table_size=512M
    max_allowed_packet=512M
    max_seeks_for_key=1000
    max_write_lock_count=4
    net_buffer_length=16384
    group_concat_max_len=1024M
    transaction_alloc_block_size=2048
    transaction_prealloc_size=1024
    range_alloc_block_size=1024
    query_prealloc_size=262144
    query_alloc_block_size=65536
    query_cache_limit=30M
    query_cache_size=256M
    query_cache_type=1
    interactive_timeout=300
    max_connect_errors=15
    local-infile=0
    thread_concurrency=16
    query-cache-type=1
    long_query_time=5
    port=3306
    concurrent_insert=2
    max_length_for_sort_data=1024
    local-infile=0
    thread_concurrency=16
    long_query_time=5
    bulk_insert_buffer_size=8M
    port=3306
    concurrent_insert=2
    innodb_buffer_pool_size=512M
    innodb_additional_mem_pool_size=128M
    innodb_thread_concurrency=4
    innodb_log_file_size=128M
    innodb_log_buffer_size=10M
    innodb_flush_method=O_DIRECT
    socket="/var/lib/mysql/mysql.sock"
    default-storage-engine=MyISAM
    
    [isamchk]
    key_buffer=512M
    sort_buffer_size=4M
    read_buffer=4M
    write_buffer=4M
    
    [myisamchk]
    tmpdir=/tmp
    key_buffer=512M
    sort_buffer=4M
    read_buffer=4M
    write_buffer=4M
    sort_buffer_size=512M
    write_buffer_size=256M
    key_buffer_size=512M
    ft_min_word_len=3
    read_buffer_size=128M
    
    [mysqldump]
    max_allowed_packet=512M
    quick
    
    [client]
    port=3306
    socket="/var/lib/mysql/mysql.sock"
    
    bind-address=127.0.0.1
    
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,378
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice