I was using myisam tables and converted them to innodb
with Alter table 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:
What you sent is important information to diagnosing your problem but it
would have really helped if you had posted your query along with an
EXPLAIN of it.
Also, it is a WELL KNOWN fact that InnoDB does NOT know exactly how many
rows are in a table at any particular moment (because of the