You can use the SHOW PROCESSLIST command to see running processes in MySQL.

Here's a link: http://dev.mysql.com/doc/refman/5.0/en/show-processlist.html.

• 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…

• How to set a maximum execution time for a mysql query?

  I would like to set a maximum execution time for sql queries like set_time_limit() in php. How can I do ?

• How to get the execution time of a MySQL query from PHP?

  I execute MySQL queries from PHP and would like to know how time consuming they are. Is there any way to get the execution time of a MySQL query from PHP? I also wonder if the execution time depe…

• 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 …

• 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…

• 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?

• How to do time_to_minute in Mysql?

  How to make time to time_to_minute unit? (same like time_to_sec) mysql> select time_to_min('00:00:1'); ERROR 1305 (42000): FUNCTION web145-mydb.time_to_min does not exist mysql> select time…

• 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_…