MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability.
We write our software with the PHP framework CakePHP.
For internal database migrations there is a database table called phinxlog which by default has a different collation than the rest of the tables. Currently, this always causes MySQLTuner to report collation mismatchtes.
It would be great if there was a CLI option to ignore certain tables which don't need to be checked.
How to reproduce:
A database where all tables have the same collation except one or a few that could be ignored.
If this feature is implemented I would gladly test this feature.
We write our software with the PHP framework CakePHP. For internal database migrations there is a database table called
phinxlogwhich by default has a different collation than the rest of the tables. Currently, this always causes MySQLTuner to report collation mismatchtes.It would be great if there was a CLI option to ignore certain tables which don't need to be checked.
How to reproduce:
A database where all tables have the same collation except one or a few that could be ignored.
If this feature is implemented I would gladly test this feature.