# mysqladmin proc +-----+--------+-----------+--------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +-----+--------+-----------+--------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+ | 762 | revgrp | localhost | revgrp_admin | Query | 10 | Copying to tmp table | SELECT * FROM invoices i, customers c where i.customers_id = c.customers_id order by invoices_id d | | 770 | root | localhost | | Query | 0 | | show processlist | +-----+--------+-----------+--------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+ # mysqladmin proc +-----+--------+-----------+--------------+---------+------+--------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +-----+--------+-----------+--------------+---------+------+--------------------+------------------------------------------------------------------------------------------------------+ | 762 | revgrp | localhost | revgrp_admin | Query | 11 | removing tmp table | SELECT * FROM invoices i, customers c where i.customers_id = c.customers_id order by invoices_id d | | 772 | root | localhost | | Query | 0 | | show processlist | +-----+--------+-----------+--------------+---------+------+--------------------+------------------------------------------------------------------------------------------------------+