Re: COUNT(*) very slowly in large InnoDB table
Posted by:
wayne r
Date: July 20, 2010 10:38PM
Rick James Wrote:
-------------------------------------------------------
> ACID considerations require InnoDB to scan at
> least an index to do COUNT(*).
What is ACID?
Subject
Views
Written By
Posted
31145
July 13, 2010 11:43AM
9741
July 14, 2010 11:04PM
7407
July 15, 2010 02:24AM
7203
July 15, 2010 08:51AM
3952
July 15, 2010 09:48AM
3741
July 15, 2010 09:09PM
3224
July 16, 2010 12:58AM
4129
July 19, 2010 12:18PM
4657
July 19, 2010 12:45PM
3944
July 19, 2010 09:25PM
Re: COUNT(*) very slowly in large InnoDB table
3271
July 20, 2010 10:38PM
2620
July 21, 2010 11:52AM
3759
July 21, 2010 12:11PM
3958
July 22, 2010 03:23AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.