To make changes on the MySQL Configuration, do the following:
- Open the configuration file as root user:
Make changes e.g, adjusting some parameters like
Restart MySQL to apply changes:
Slow Query Log
The Slow Query Log is useful to log consists of SQL statements that take more than
long_query_time seconds to execute.
To enable the Slow Query Log, do the following:
Open the configuration file file.
Uncomment the following lines by removing the semicolon in the front:
- Restart MySQL to apply changes: