mysql show current queries

Solutions on MaxInterview for mysql show current queries by the best coders in the world

showing results for - "mysql show current queries"
Addilyn
15 Jan 2020
1show processlist;
2
Jana
06 Nov 2017
1mysql> show processlistG
2
3*************************** 6. row ***************************
4     Id: 708163
5   User: root
6   Host: localhost
7     db: NULL
8Command: Query
9   Time: 0
10  State: NULL
11   Info: show processlist
12*************************** 7. row ***************************
13     Id: 708174
14   User: test
15   Host: localhost
16     db: test
17Command: Query
18   Time: 3
19  State: Copying to tmp table
20   Info: select dist.name, dist.filename, count(*)
21from orders_header h
22inner join orders_detail d on h.ord
232 rows in set (0.00 sec)