The Slow Queries. Debugging SQL and slow queries can help you resolve slowness issues in an instance. 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.
Slow Queries Affect Other Parts of a System. These queries tend to process a lot of data as compared. A good script i found a while ago on SQL server performance will help get you started.
To analyze the slow query log file you can parse it directly to review its contents.
However it may also be a good idea to check the queries that are being run against that database. The slow query log is a record of SQL queries that took a long time to perform. It is typically obvious when a window is opened and a component takes time before database data is displayed. Use the command mysqldumpslow to analyze it and print summary of the slow query logfile.