search

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

New CLI-Option "nondedicated" for non-dedicated servers #748

Closed Staubiii closed 7 months ago

Staubiii commented 8 months ago

MySQLTuner always assumes a server is dedicated to running MySQL and will give recommendations that don't make sense for a non-dedicated server.

Such messages include:

Consider stopping or dedicate server for additional process other than mysqld. DON'T APPLY SETTINGS BECAUSE THERE ARE TOO MANY PROCESSES RUNNING ON THIS SERVER. OOM KILL CAN OCCUR!

Since we dont host dedicated database servers we always have to ignore these irrelevant recommendations among the other useful ones.

It would be nice if MySQLTuner could ignore these recommendations through a new CLI option, e.g. nondedicated. If set, all recommendations relating to dedicated servers would not be given.

How to reproduce: Having a server with MySQL, on which at least 15% of the memory is used by other processes than the database server, i.e. a backup software and/or a web application.

If this feature ends up being implemented I would be happy to help test it.

jmrenouard commented 8 months ago

hi @Staubiii Can you test --nondedicated option ?

Staubiii commented 7 months ago

@jmrenouard works perfectly.

Thank you!