:
> X-Virus-Checked: Checked
> X-Spam-Checker-Version: SpamAssassin 3.0.2 (2004-11-16) on c.spam
> X-Spam-Status: No, score=1.1 required=5.0 tests=DNS_FROM_AHBL_RHSBL,
> HTML_MESSAGE,HTML_TAG_EXIST_TBODY,NORMAL_HTTP_TO_IP,NO_REAL_NAME,
> WEIRD_PORT autolearn=disabled version
I was using myisam tables and converted them to innodb
with Alter table TYPE=INNODB; A query that used
to take 23 minutes, does not complete in hours. There
about 33M rows in the table and I was doing a count of
the rows. Some queries with more conditions seem fine.
Here is the table:
dspam_