New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
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
Comments
Insufficient information for meaningful answers. Run mysqltuner.
The details on MariaDB pages are very confusing. That's why I asked this question here.
On this page https://mariadb.com/kb/en/setting-innodb-buffer-pool-size-dynamically/, it says "The new buffer pool size must be a multiple of innodb_buffer_pool_chunk_size * innodb_buffer_pool_instances."
On this page https://mariadb.com/kb/en/innodb-buffer-pool/, "if innodb_buffer_pool_size is 4GB and innodb_buffer_pool_instances is set to 4, each instance will be 1GB. Each instance should ideally be at least 1GB in size."
The default innodb_buffer_pool_chunk_size was 128M and I changed it to 256M as my DB size is bigger than 128M.
No problem to ask here, but you provided insufficient information to get meaningful answers. How big are the tables? How many read/write transactions? Is it I/O bound or CPU bound? What type of storage/iops on the VPS?
Run mysqltuner and it will give you some recommendations. Ultimately you need to benchmark it yourself - following setup guides is like treating an illness based on what a Google search tells you, i.e. it maybe works OK on average but might turn out badly for someone's specific situation.
PerconaDB for innodb.