Troubleshooting of MySQLTuner: Difference between revisions

From LemonWiki共筆
Jump to navigation Jump to search
(How to resolve: Performance schema should be activated for better diagnostics)
Line 60: Line 60:
* Specify the host parameter to command line e.g. {{kbd | key=<nowiki>perl mysqltuner.pl --host 127.0.0.1</nowiki>}}
* Specify the host parameter to command line e.g. {{kbd | key=<nowiki>perl mysqltuner.pl --host 127.0.0.1</nowiki>}}
* Check the typo of mysql account and password
* Check the typo of mysql account and password
== How to resolve: Performance schema should be activated for better diagnostics ==
Condition:
<pre>
$ perl mysqltuner.pl
-------- Recommendations ---------------------------------------------------------------------------
General recommendations:
    Performance schema should be activated for better diagnostics
</pre>
Solution:
* Verify the MySQL setting. Execute the SQL query {{kbd | key=<nowiki>SHOW VARIABLES LIKE 'performance_schema'</nowiki>}}. The result should be OFF.
* Stop the MySQL service.
* Open the MySQL configuration file named {{kbd | key=<nowiki>my.ini</nowiki>}} The file maybe located in different path e.g. C:\xampp\mysql\bin\my.ini
* Edit the MySQL configuration file
<pre>
[mysqld]
performance_schema = ON
</pre>
* Restart the MySQL service.
* Verify the MySQL setting again. Execute the SQL query {{kbd | key=<nowiki>SHOW VARIABLES LIKE 'performance_schema'</nowiki>}}. The result should be ON.


== references ==
== references ==

Revision as of 21:18, 8 May 2021

"MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability."[1]

How to resolve: wget command not found

Condition: When I tried to download the MySQLTuner using wget command but met the error.

Solution:

  1. Download the installation file setup-x86_64.exe of Cygwin from Cygwin Installation
  2. Open the command line window
  3. Change to the directory where the file setup-x86_64.exe located e.g. cd C:\Downloads> and than press the key Enter
  4. To install the packages: wget. Keyin setup-x86_64.exe -q -P "wget" or follow the steps on terminal - WGET Command Not Working in Cygwin - Super User if you prefer the GUI window.

How to resolve: couldn't find diagnostic data

Condition: 

$ perl mysqltuner.pl
couldn't find diagnostic data in /usr/share/perl5/5.26/pods/perldiag.pod /usr/local/lib/perl5/site_perl/5.26/x86_64-cygwin-threads /usr/local/share/perl5/site_perl/5.26 /usr/lib/perl5/vendor_perl/5.26/x86_64-cygwin-threads /usr/share/perl5/vendor_perl/5.26 /usr/lib/perl5/5.26/x86_64-cygwin-threads /usr/share/perl5/5.26 mysqltuner.pl at /usr/share/perl5/5.26/diagnostics.pm line 259, <POD_DIAG> line 711.
Compilation failed in require at mysqltuner.pl line 45.
BEGIN failed--compilation aborted at mysqltuner.pl line 45.

Solution:

  1. Download the installation file setup-x86_64.exe of Cygwin from Cygwin Installation
  2. Open the command line window
  3. Change to the directory where the file setup-x86_64.exe located e.g. cd C:\Downloads> and than press the key Enter
  4. To install the packages: perl_pods[2][3]. Keyin setup-x86_64.exe -q -P "perl_pods"

Environment:

  • Windows 2008 R2 standard
  • Cygwin version: CYGWIN_NT-6.1 Win2008R2-0-0 2.9.0(0.318/5/3) 2017-09-12 10:18 x86_64 Cygwin (information returned from uname -a)


How to resolve: unzip: command not found

Condition: 

$ unzip -l sysschema.zip
-bash: unzip: command not found

Solution:

  1. Download the installation file setup-x86_64.exe of Cygwin from Cygwin Installation
  2. Open the command line window
  3. Change to the directory where the file setup-x86_64.exe located e.g. cd C:\Downloads> and than press the key Enter
  4. To install the packages: unzip. Keyin setup-x86_64.exe -q -P unzip

How to resolve: Attempted to use login credentials, but they were invalid.

Condition: 

$ perl mysqltuner.pl
 >>  MySQLTuner 1.7.5 - Major Hayden <[email protected]>
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
 >>  Run with '--help' for additional options and output filtering
Please enter your MySQL administrative login: root
Please enter your MySQL administrative password: [!!] Attempted to use login credentials, but they were invalid.

Solution:

  • Specify the host parameter to command line e.g. perl mysqltuner.pl --host 127.0.0.1
  • Check the typo of mysql account and password

How to resolve: Performance schema should be activated for better diagnostics

Condition: 

$ perl mysqltuner.pl
-------- Recommendations ---------------------------------------------------------------------------
General recommendations:
    Performance schema should be activated for better diagnostics

Solution:

  • Verify the MySQL setting. Execute the SQL query SHOW VARIABLES LIKE 'performance_schema'. The result should be OFF.
  • Stop the MySQL service.
  • Open the MySQL configuration file named my.ini The file maybe located in different path e.g. C:\xampp\mysql\bin\my.ini
  • Edit the MySQL configuration file
[mysqld]
performance_schema = ON
  • Restart the MySQL service.
  • Verify the MySQL setting again. Execute the SQL query SHOW VARIABLES LIKE 'performance_schema'. The result should be ON.

references

  1. ↑ 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.
  2. ↑ cpan - How do I 'use diagnostics' for Perl on Cygwin? - Stack Overflow
  3. ↑ Does Setup accept command-line arguments?


Troubleshooting of ...

Template

Retrieved from "https://wiki.planetoid.info/index.php?title=Troubleshooting_of_MySQLTuner&oldid=22277"