The Slow Query Log. If your server is above 516 you can set the slow query log in the runtime itself. By identifying queries that are particularly slow in their execution you can address them by restructuring the application that triggers your queries.
The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least min_examined_row_limit rows to be examined. To enable this log use the slow-query-log option either from the command-line when starting the MySQL server or enter the option in the configuration file for MySQL mycnf or myini depending on your system. Just saw one that took 0000563s.
Set global log_slow_queries 1.
This allows you to find inefficient SQL queries that can be optimized to improve database performance. Note that if your queries contain users passwords the slow query log may contain passwords too. The full list of mysqldumpslow options is available here. By identifying queries that are particularly slow in their execution you can address them by restructuring the application that triggers your queries.