MariaDB My.cnf configuration script after ram upgrade/downgrade ?

There isn't a script or command to do 100% of re-optimisations but for between 32-64GB ram the base template my.cnf is the same, just some of the values are auto tuned based of detected server resources etc.

For PHP-FPM, you can recompile PHP via centmin.sh menu option 5 so auto redetects memory and server resources and manually re-run /usr/local/src/centminmod/tools/setio.sh as follows

Code (Text):

/usr/local/src/centminmod/tools/setio.sh set

which will recalculate MariaDB MySQL innodb I/O variable values to set

i.e.

Code (Text):

/usr/local/src/centminmod/tools/setio.sh set
Full Reads: 24975
Full Writes: 59362

set innodb_flush_neighbors = 0

innodb_io_capacity = 2900

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

+------------------------+-------+
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

 

setio.sh is only for change in SSD/disk performance (which changes over time) not related to cpu/ram

 

yup