Answers for "view all current mysql queries"

SQL
1

mysql show current queries

show processlist;
Posted by: Guest on April-01-2020
0

mysql view current queries

mysql> show processlistG

*************************** 6. row ***************************
     Id: 708163
   User: root
   Host: localhost
     db: NULL
Command: Query
   Time: 0
  State: NULL
   Info: show processlist
*************************** 7. row ***************************
     Id: 708174
   User: test
   Host: localhost
     db: test
Command: Query
   Time: 3
  State: Copying to tmp table
   Info: select dist.name, dist.filename, count(*)
from orders_header h
inner join orders_detail d on h.ord
2 rows in set (0.00 sec)
Posted by: Guest on April-21-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language