Solved: See live queries

Post Reply
mister_v
Posts: 188
Joined: Thu Mar 04, 2010 9:19 pm

Solved: See live queries

Post 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.
Last edited by mister_v on Wed Aug 24, 2016 12:20 pm, edited 1 time in total.
chris
Site Admin
Posts: 194
Joined: Mon Jul 21, 2008 9:52 am

Re: See live queries

Post 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
mister_v
Posts: 188
Joined: Thu Mar 04, 2010 9:19 pm

Re: See live queries

Post by mister_v »

Ok thanks

thats works.
Post Reply