MySQL Forums
Forum List  »  Partitioning

Re: timestamp, datetime as default value as current_timestamp [PARTITION]
Posted by: Mattias Jonsson
Date: August 31, 2012 06:00PM

> Inserting single rows in partitions is slow. Whenever you insert a record, the partitioning engine locks the entire table (all-partitions), the partitioning engine will lock all partitions before the insert, and unlock them after the insert.

Have you tested this with 5.6.6? It now prunes partitioning lock requests too and includes pruning on inserts too, i.e. fixed the old bug#37252.

Also partitioning does add any table lock, it simply forwards the lock request to the partitions (which gave a big overhead for small queries before 5.6.6, since it had to forward the request to all partitions every time). But for InnoDB there where never any table lock from partitioning!

Regards
Mattias Jonsson, MySQL Partitioning developer

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: timestamp, datetime as default value as current_timestamp [PARTITION]
2114
August 31, 2012 06:00PM


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.