-
Alex T⚜️
MariaDB does not use all the sections in that post, but what it does allow I do have. Most with InnoDB with Maria seems automatic. It would not take my old MySQL for the # of CPU's and Deadlocks. Here is my my.cnf :[mysqld]
innodb_log_file_size=400M
innodb_flush_method=O_DIRECT
innodb_io_capacity=1000
innodb_old_blocks_time=1000
innodb_open_files=5000
key_buffer_size=64M
read_buffer_size=256K
read_rnd_buffer_size=256K
query_cache_size=256M
query_cache_limit=5M
query_cache_type=on
join_buffer_size=4M
sort_buffer_size=4M
max_heap_table_size=128M
tmp_table_size=1024M
table_open_cache=100000
table_definition_cache=4000
thread_cache_size=192
collation-server=utf8mb4_unicode_ci
init-connect='SET NAMES utf8mb4'
character-set-server=utf8mb4
If you know of the options for Maria a may be missing please share.
INNODB LogINNODB Variables Update looks like for rollback for timeout there is only an on and off, so as of now I got
innodb_stats_on_metadata=on
innodb_log_file_size=400M
innodb_flush_method=O_DIRECT
innodb_io_capacity=1000
innodb_old_blocks_time=1000
innodb_open_files=5000
innodb_buffer_pool_size=4096M
innodb_lock_wait_timeout=4
innodb_rollback_on_timeout=on
Maybe delete the extra stuff you do not mention? The others were some things others have mentioned in the CyberPanel community. Sooo it looks like my issue was database related. Looks like some things are different with InnoDB in Maria. For example this one innodb_rollback_on_timeout=on and this line does not exist: binlog_format = MIXED and transaction_isolation = READ-COMMITTED so these were what was throwing off my My.CNF when I deleted the other options. I didn't have to change my pool_instances because mine is on 8 by default. Please still do share if I should remove any of these. GOSH Dangit, nevermind it didnt work :( I just give up.