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
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