Solved: See live queries

[mister_v]

Hi,

How can I see all the queries that are currently running on the database?
I use mysql.
I know you can use mysql_slow.log, but that only show the slow running queries and only after.
I want to know the ones that are currently running.

[chris]

You can run

Code: Select all

mysql> SHOW FULL PROCESSLIST

That show the queries that are running.

You can also use the following command form the command prompt

Code: Select all

mysqladmin -u root -p -i 1 processlist;

-i 1 = interval of 1 second

[mister_v]

Ok thanks

thats works.