Hi all!
Gleb Paharenko wrote:
> Hello.
>
>
>
>>I have a query that is taking days to complete (not good). If I change
>
>
> Really, not good. What does SHOW PROCESSLIST report about the thread of
> this query?
The query has been running for ~5 days now:
Id: 27977
User: root
Host: localhost
db: fractyl
Command: Query
Time: 421540
State: Sending data
Info: select count(*) from msgs where message_id > 1120000000 and
message_id < 1120000111
I also tried using the BETWEEN syntax but it has exactly the same problem.
Any other ideas?
ds
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
