How can artificially create a slow query in mysql?
- by Gray Race
I'm giving a hands on presentation in a couple weeks. Part of this demo is for basic mysql trouble shooting including use of the slow query log. I've generated a database and installed our app but its a clean database and therefore difficult to generate enough problems.
I've tried the following to get queries in the slow query log:
Set slow query…