mysql> show processlist -> ; +----+------+-----------+-------+---------+------+--------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+------+-----------+-------+---------+------+--------------+------------------------------------------------------------------------------------------------------+ | 3 | root | localhost | cdrdb | Query | 19 | Sending data | INSERT INTO bench (SELECT * FROM temp JOIN (select CONCAT(call_src_realm,'-',SUBSTRING(start_time,1, | | 13 | root | localhost | NULL | Query | 0 | NULL | show processlist | +----+------+-----------+-------+---------+------+--------------+------------------------------------------------------------------------------------------------------+