The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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:
    87
    Likes Received:
    2
    Trophy Points:
    8
    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 Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,762
    Likes Received:
    662
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  3. iso99

    iso99 Well-Known Member

    Joined:
    Jan 5, 2011
    Messages:
    87
    Likes Received:
    2
    Trophy Points:
    8
    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 Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,762
    Likes Received:
    662
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page