MariaDB high memory usage during scheduled backups

iso99

• May 12, 2015 22:52

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?

• 

  cPanelMichael

  • May 13, 2015 12:40

  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.

  0
• 

  iso99

  • May 20, 2015 02:19

  Still having this problem every backup day. Here's my config file:
  [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
  

  0
• 

  cPanelMichael

  • May 20, 2015 13:33

  You may also want to run a tuner after letting MariaDB run for at least 24 hours. This may prompt more user-feedback. Otherwise, you may want to consult with a system administrator for assistance with optimizing your MariaDB performance:

  0

Please sign in to leave a comment.