Beta Branch update tools/setio.sh use local ffio settings files

nice and fast NVMe SSD disks I see

 

ah it only was written for MariaDB 10.0 and 10.1 at the time so guess need an update

MariaDB 10.3 on 123.09beta01 currently

Code (Text):

tools/setio.sh set
Full Reads: 50257
Full Writes: 38102

set innodb_flush_neighbors = 0

innodb_io_capacity = 2700

+------------------------+-------+
/etc/my.cnf adjustment
+------------------------+-------+
existing value: 
Variable_name   Value
innodb_io_capacity      2300
innodb_io_capacity_max  4600
new value: 
Variable_name   Value
innodb_io_capacity      2700
innodb_io_capacity_max  5400

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

Restart MySQL server for io thread changes

 

yup that is intentional in the code but i should make it enabled

 

FYI, setio.sh script enables proper value dynamically anyway until mysql restarts

Code (Text):

grep innodb_thread_concurrency /etc/my.cnf
#innodb_thread_concurrency = 8

check actual value after setio.sh run

Code (Text):

mysqladmin var | grep innodb_thread_concurrency | tr -s ' '
| innodb_thread_concurrency | 8 |