Troubleshooting of MySQLTuner: Difference between revisions
Jump to navigation
Jump to search
→How to resolve: Performance schema should be activated for better diagnostics
mNo edit summary |
|||
| Line 74: | Line 74: | ||
* Verify the MySQL setting. Execute the SQL query {{kbd | key=<nowiki>SHOW VARIABLES LIKE 'performance_schema'</nowiki>}}. The result should be OFF. | * 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. | * 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 | * Open the MySQL configuration file named {{kbd | key=<nowiki>my.ini</nowiki>}} on {{Win}} or {{kbd | key=<nowiki>my.cnf</nowiki>}} on {{Linux}} The file maybe located in different path e.g. C:\xampp\mysql\bin\my.ini on {{Win}} | ||
* Edit the MySQL configuration file | * Edit the MySQL configuration file | ||