Is there a simple query that would take > 2 sec so that I can test the slow query logger?
I am looking for something like a generic recursive or iterative statement.
A simple query would be:
You want to iterate it?
Alternatively if you just want to test your slow_query_log, change 'long_query_time' to 0 (to log all queries):
Here is a pretty horrible query. It is a Cartesian product, using non-ansi style join.