The Slow Query Log Is Written As. Queries are written to the slow query log after all locks have been released. If your server is above 516 you can set the slow query log in the runtime itself.
It may work great from his local MacBookPro inside a 10 dollar skinny soy latte artisan coffee. Or alternatively you can set the this options in the mycnfmyini option files. A In MySQL the slow query log is written as text so it is viewable with any file display program.
It happens all the time such as when a fellow engineer writes a query to search for all database records in existence without a filter.
You can then use the Amazon CloudWatch metrics to check if the amount of work done on your instance has increased. However I know that Opster has an excellent article about analyzing slow logs. The slow query logs will show you a list of queries that have been identified as slow based on the given values in the system variables as mentioned earlier. It can also log queries that.