I want to order by Time,but seems no way to do that ? mysql> show processlist; +--------+-------------+--------------------+------+---------+--------+----------------------------------+--------...

When I issue SHOW PROCESSLIST query, only the first 100 characters of the running SQL query are returned in the info column. Is it possible to change MySQL config or issue a different kind of reque...

How do I get a process list of all running processes from Python, on Unix, containing then name of the command/process and process id, so I can filter and kill processes.

How We Kill mysql sleep processes Like: +------+-----------+-----------+------------------------+---------+------+----------------+----------------------------------------------------------------...

I connect to mysql from my Linux shell. Every now and then I run a SELECT query that is too big. It prints and prints and I already know this is not what I meant. I would like to stop the query. H...

When I run SHOW PROCESSLIST in MySQL database, I get this output: mysql> show full processlist; +--------+------+-----------+--------+---------+-------+-------+-----------------------+ | Id | ...

When I did show processlist in mysql I got list of process. One of the process with binlog dump running from quit long time. What is binlog dump? do I need to kill this. what happen if i kill this ...

I have a script running a batch of very similar queries. All of them, except one, run without any problem. Only one query is getting stuck. In "show processlist" the query has state=null Accord...