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!

MariaDB high memory usage during scheduled backups

Discussion in 'Workarounds and Optimization' started by iso99, May 12, 2015.

  1. iso99

    iso99 Well-Known Member

    Joined:
    Jan 5, 2011
    Messages:
    112
    Likes Received:
    7
    Trophy Points:
    68
    cPanel Access Level:
    Root Administrator
    Mariadb usually consumes 10-11% (as reported by Process Manager) on regular days but when my scheduled incremental backup runs, it shoots to 30% and doesn't return back to normal without being restarted.

    I just recently upgraded from MySQL 5.6 to MariaDB a few weeks ago. I'm using tokudb by default storage engine (as recommended) while old tables are still with MyISAM and InnoDB. InnoDB cache is set to 5GB.

    Any advice?
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,809
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    I've moved this thread to our "Optimization" forum. You are more likely to receive user-feedback regarding improving the performance of MariaDB here.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. iso99

    iso99 Well-Known Member

    Joined:
    Jan 5, 2011
    Messages:
    112
    Likes Received:
    7
    Trophy Points:
    68
    cPanel Access Level:
    Root Administrator
    Still having this problem every backup day. Here's my config file:

    Code:
    [mysqld]
    local-infile=0
    datadir="/var/lib/mysql"
    socket="/var/lib/mysql/mysql.sock"
    innodb_buffer_pool_size=6G
    max_allowed_packet=268435456
    open_files_limit=100000
    query_cache_limit=4M
    query_cache_size=192M
    query_cache_type=1
    query_cache_min_res_unit=3000
    max_user_connections=50
    max_connections=100
    interactive_timeout=100
    wait_timeout=100
    thread_cache_size=128
    key_buffer=20M
    join_buffer_size=4M
    table_open_cache=10000
    table_definition_cache=1000
    sort_buffer_size=2M
    read_buffer_size=2M
    read_rnd_buffer_size=2M
    innodb_buffer_pool_instances=4
    innodb_read_io_threads=4
    innodb_write_io_threads=4
    performance_schema=OFF
    innodb_file_per_table=1
    #default-storage-engine=MyISAM
    plugin-load=ha_tokudb
    default_storage_engine=TokuDB
    thread_handling=pool-of-threads
    tokudb_cache_size=4294967296
    
     
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,809
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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