Comment to '*Need Help* Timeline Upload Items not working - "Missing Marka.JS.Map" '
  • 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. 

    image_transcoder.php?o=bx_froala_image&h=2848&dpx=1&t=1580289109INNODB 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. 

    0 0 0 0 0 0

    UNA - Social Media Software Framework

    Close