Is there a way to get the execution time of the last executed query in mysql?
相关问题
- SQL join to get the cartesian product of 2 columns
- sql execution latency when assign to a variable
- Difference between Types.INTEGER and Types.NULL in
- php PDO::FETCH_ASSOC doesnt detect select after ba
- sqlyog export query result as csv
mysql has a builtin profiler. You can enable profiling by issuing
set profiling=1;
and useshow profiles;
to get execution times.if using PHP .. you can use microtime() before the query and after the query to figure out how long it took for the query to execute.
Try this...