Beta Branch update my.cnf templates & tools/setio.sh in 123.09beta01

update my.cnf templates & tools/setio.sh in 123.09beta01

---

Updated to support Centmin Mod auto tuning of MariaDB MySQL variables for innodb_flush_neighbors in MariaDB 10.0/10.1 and innodb_flush_neighbor_pages in MariaDB 5.5. When tools/setio.sh which is run on initial MariaDB install detects that measured disk I/O reads is greater than 500 IOPs, set the the variable appropriately to = 0 for greater than or equal to 500 IOPs or leave or set it to = 1 when disk I/O writes is less than 500 IOPs. The threshold is 500 IOPs as still some non-SSD raid configurations can reach that performance level. There's no need to restart MySQL with this auto set changes as the variable is a dynamic variable in MariaDB MySQL. All MariaDB 10 labelled (my-mdb10-*) my.cnf templates default to = 1 value for the variable and is then auto changed at initial MariaDB MySQL install time when tools/setio.sh is ran.

example

Code (Text):

./setio.sh set
Full Reads: 34711
Full Writes: 7585

set innodb_flush_neighbors = 0

innodb_io_capacity = 900

+------------------------+-------+
/etc/my.cnf adjustment
+------------------------+-------+
existing value:
Variable_name   Value
innodb_io_capacity      100
innodb_io_capacity_max  132
new value:
Variable_name   Value
innodb_io_capacity      900
innodb_io_capacity_max  1800

+------------------------+-------+
innodb io threads adjustment
+------------------------+-------+
existing value:
+------------------------+-------+
innodb_read_io_threads = 4
innodb_write_io_threads = 2
+------------------------+-------+
new value:
+------------------------+-------+
innodb_read_io_threads = 4
innodb_write_io_threads = 4
+------------------------+-------+

Restart MySQL server for io thread changes

Continue reading...

123.09beta01 branch

• Branch: GitHub - centminmod/centminmod at 123.09beta01
• Commit History: Commits · centminmod/centminmod · GitHub

 

This update came about after reminder from @negative at MariaDB - Ideal innodb_io_capacity for Raid SSD Disks | Centmin Mod Community