MariaDB Innodb setup - need suggestion
I am using 10.4.14-MariaDB on my VPS with 4 cores and 4.5gb RAM.
I modified the following variables in the MariaDB configuration file after going through several posts on MariaDB website. Is this a good setting or should I set different values?
innodb_buffer_pool_chunk_size = 256M innodb_buffer_pool_instances = 8 innodb_buffer_pool_size = 2G innodb_write_io_threads = 8 innodb_read_io_threads = 8