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. Thanks, Jeff --------------------------------------------------------------------- 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
