Re: COUNT(*) very slowly in large InnoDB table
Hi!
Thank you very much for this insights - I doubt I would have found them in the manual, probably searching in the completely wrong place. So in some way MySQL does some vertical partitioning automatically for my InnoDB tables :) Given your exsplanations, I understand the performance of the indices much better.
Dominik
Subject
Views
Written By
Posted
31112
July 13, 2010 11:43AM
9736
July 14, 2010 11:04PM
7404
July 15, 2010 02:24AM
7191
July 15, 2010 08:51AM
3940
July 15, 2010 09:48AM
3733
July 15, 2010 09:09PM
Re: COUNT(*) very slowly in large InnoDB table
3217
July 16, 2010 12:58AM
4122
July 19, 2010 12:18PM
4644
July 19, 2010 12:45PM
3936
July 19, 2010 09:25PM
3267
July 20, 2010 10:38PM
2609
July 21, 2010 11:52AM
3752
July 21, 2010 12:11PM
3951
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.