Hi peoples, I'm slightly confused as to exactly what 'Sending data' means in a processlist command. I have a query whch outputs precisely one row, and it takes 40+ seconds to 'Send data'. I'd assumed that this was simply the sending of the query result from server -> client...am I incorrect ? regards, P mysql> show processlist; +------+------+-----------+------+---------+------+--------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+------+-----------+------+---------+------+--------------+------------------------------------------------------------------------------------------------------+ | 7568 | hot | localhost | hot | Query | 55 | Sending data | select count(distinct(cookie)) from tbl_webevents where event_time >= from_unixtime(983833200) and e | +------+------+-----------+------+---------+------+--------------+------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> show processlist; +------+------+-----------+------+---------+------+--------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+------+-----------+------+---------+------+--------------+------------------------------------------------------------------------------------------------------+ | 7568 | hot | localhost | hot | Query | 63 | Sending data | select count(distinct(cookie)) from tbl_webevents where event_time >= from_unixtime(983833200) and e | +------+------+-----------+------+---------+------+--------------+------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> show processlist; +------+------+-----------+------+---------+------+--------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+------+-----------+------+---------+------+--------------+------------------------------------------------------------------------------------------------------+ | 7568 | hot | localhost | hot | Query | 67 | Sending data | select count(distinct(cookie)) from tbl_webevents where event_time >= from_unixtime(983833200) and e | +------+------+-----------+------+---------+------+-------------- -- ----------------------------------------------- Peter Skipworth Perl Developer/Unix Systems Administrator [EMAIL PROTECTED] +44 795 055 0029 ----------------------------------------------- 4c 61 20 6c 6f 79 52 75 62 20 73 41 20 65 52 61 20 45 65 62 4f 4c 47 6e 74 20 20 4f 53 75 00 0a --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
