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.98k stars 1.29k forks source link

Wrong physical memory on remote host #779

Closed vlatan closed 4 months ago

vlatan commented 7 months ago

When running mysqltuner on a remote host - whether using --forcemem or not - it determines wrong physical memory.

For example if you run it with --forcemem 2000 the physical memory determined by mysqltuner will be:

[--] Physical Memory: 2.0K

And thus subsequently it will produce the following bogus warnings, because it had determined incorrect, very small physical memory.

*** MySQL's maximum memory usage is dangerously high ***
*** Add RAM before increasing MySQL buffer variables ***

PR #780