major / MySQLTuner-perl

MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability.
GNU General Public License v3.0
8.88k stars 1.28k forks source link

Perfermance scheme update to mariadb >10.x #747

Closed spirillen closed 8 months ago

spirillen commented 8 months ago

Request:

would it be possible to have the performance_scheme updated to match Mariadb >=11.X (Optional Performance schema and Sysschema installation for MariaDB < 10.6) as the < 10.6 are returning an error do to a change on the way MariaDB handles STATUS

ERROR 1054 (42S22) at line 78 in file: './views/p_s/metrics_56.sql': Unknown column 'STATUS' in 'field list'
jmrenouard commented 8 months ago

Last readme version include documentation around this topics

In fact, error in mariadb_sys is related to issue from sysschema project not MySQLtuner project

spirillen commented 7 months ago

Thanks