MySql query execution time

I am using MySQL Workbench on Windows. How do I find out the time taken to execute a query like

Select * from employers where employerid > 200

Is there a statement I can enter that returns the execution time for this query? Thanks

This question and answers originated from www.stackoverflow.com
Question by (7/19/2011 8:46:56 PM)

Answer

MySQL workbench is the way to go for things like this (optimization, benchmarking of queries, etc.). You say you're not familiar with it, so I'd recommend reading a tutorial from the good folks at MySQL

Answer by
Find More Answers
Related Topics  mysql  query  time  execution  workbench
Related Questions

  • mysql query execution time | reduce query

    I have a query which let me to change users order. here is my query: update test set orderID = case orderID when (select orderID from ( select * from test where orderID > ( select …

  • MYSQL query execution time

    I have a question for you. I have this database with 250.000 recordings, with 2 text fields each containing up to 300 words. And I want do select all the data that meets some criteria and put it in …

  • mysql query execution time - can i get this in milliseconds?

    I'm comparing a few different approaches to getting some data in mysql, directly at the console, using the SQL_NO_CACHE option to make sure mysql keeps running the full query every time. Mysql gives…

  • mysql execution time

    Is there a way to get the execution time of the last executed query in mysql?

  • Query Execution Time

    I am querying a SQL server 2008 database table having more than 500 million records. The query I fired to move around 10 million records to temp table took 9 hours. Similar query I fired which has b…

  • How to controll Mysql query execution time?

    I have several EVENTS executing every two seconds, I would like to kill those which are running longer than 1 second. Are there way to control query execution time on MySQL 5.5? cheers Arman.…

  • MySQL query execution return value?

    I'm constructing an adapter for MySQL in PHP and I was wondering what should MySQL query execution method return? Should it return a result set? Or the last id / affected rows?

  • oracle query execution time

    I would like to get my guery execution time from Oracle DB. I dont want the time when Oracle finish to print results. In MySQL it is easy to get execution time from shell, but in SQL Plus there are …

  • Anyway to Limit MySQL Query Execution time?

    Hi I'm having issues on my server at the minute because some of the MySQL queries are taking a very long time to run, and hogging the resources on the server. I'm already in the process of optimi…

  • Strange mysql query execution time behavior

    hello i'm having a strange execution time behavior over almost same sql queries q1: SELECT `t1`.`id`, `t1`.`key`, `t1`.`module`, `t2`.`value` FROM `translates` AS `t1` LEFT JOIN `translates_…