Hi! >I'm trying to understand what the status field of the "SHOW PROCESSLIST" >command means. When I execute a query - "SELECT count(*) as count from >table1 where col1 like "name%";", the query takes a long time to execute. >The table has over 47,000,000 records and is indexed on col1. > >What does the status "sending data" mean? It doesn't seem like there is >that much data that needs to be sent for a count query.
I think it means it is 'sending' rows to the count operator, not to the user. >Thanks, >Jeff Regards, Heikki http://www.innodb.com --------------------------------------------------------------------- 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
