...
Most database administrations tools e.g. MySQL Workbench, PHPMyAdmin, etc., have a graphical user interface for this. You can also do this from the command line on the server.
I have included links to the MySQL, PostgreSQL and MSSQL documentation below and we will add this to our how-to article for logging slow queries.
Note |
---|
Only enable slow query logging long enough to test slow queries and immediately disable after testing. |