nice and fast NVMe SSD disks I see :D
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
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 |