MySQL Forums
Forum List  »  Partitioning

Re: Performance doubt
Posted by: Mattias Jonsson
Date: April 09, 2013 01:49AM

Opening of partitions is not changed in 5.6, but since open tables are reused by the table_cache, it is only a cost taken when opening a new instance of the table, not for each statement.

What is improved is the reduced number of lock calls, by delaying the call for locking the storage engine until after partitioning pruning is done. So that only the used partitions will call for locking.

I.e. in 5.6 a Primary Key lookup only uses one partition and will only call the underlying storage engine to lock once, but in 5.1/5.5 even a PK lookup would do the lock call for every partition, resulting in bad performance for heavily partitioned tables, even if only one partition was read.

Options: ReplyQuote

Written By
March 26, 2013 06:41AM
March 28, 2013 12:34AM
Re: Performance doubt
April 09, 2013 01:49AM

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.