How to estimate SQL query timing?
This can be done when using SHOW PROFILES syntax. When you open a MySQL session, you could set the variable “profiling” to 1 or ON. mysql> SET profiling = 1; So all the statements sent to the server will be profiled and stored in a historical and shown later by typing the command: mysql> SHOW … Read more