Troubleshooting of MySQLTuner: Difference between revisions
Jump to navigation
Jump to search
How to resolve: Performance schema should be activated for better diagnostics
(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 == | ||