Re: show processlist: status

2001-11-12 Thread Heikki Tuuri
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

show processlist: status

2001-11-12 Thread Jeff Isom
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 st