MySQL Forums :: Partitioning :: Count(*) query is slower on partitioned table


Advanced Search

Re: Count(*) query is slower on partitioned table
Posted by: Rick James ()
Date: December 10, 2016 12:30AM

Yet another reason for not using PARTITIONing.

I cannot explain your third case, which should have limited itself to the one partition.

There is perhaps never a performance advantage in PARTITION BY RANGE(the-primary-key). Is that your actual case?

Here are my comments on partitioning: https://mariadb.com/kb/en/mariadb/partition-maintenance/ , including the only 4 use cases (that I know of) for which performance is benefited.

Another pet peeve of mine: Notice how useless Profiling is. (BTW, it is deprecated and going away.)

Options: ReplyQuote


Subject Views Written By Posted
Count(*) query is slower on partitioned table 624 Darren Demicoli 12/03/2016 11:53AM
Re: Count(*) query is slower on partitioned table 218 Rick James 12/10/2016 12:30AM
Re: Count(*) query is slower on partitioned table 261 Darren Demicoli 12/10/2016 06:48AM
Re: Count(*) query is slower on partitioned table 212 Rick James 12/12/2016 01:56PM
Re: Count(*) query is slower on partitioned table 239 Darren Demicoli 12/13/2016 02:50PM
Re: Count(*) query is slower on partitioned table 174 Rick James 12/21/2016 12:35AM


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.