MySQL Forums
Forum List  »  Performance

Re: COUNT(*) very slowly in large InnoDB table
Posted by: Dominik Leiner
Date: July 16, 2010 12:58AM

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

Options: ReplyQuote




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.