Page 1 of 1

Solved: See live queries

Posted: Wed Aug 24, 2016 7:08 am
by 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.

Re: See live queries

Posted: Wed Aug 24, 2016 9:08 am
by 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

Re: See live queries

Posted: Wed Aug 24, 2016 12:19 pm
by mister_v
Ok thanks

thats works.