MySQL Forums
Forum List  »  Partitioning

Re: timestamp, datetime as default value as current_timestamp [PARTITION]
Posted by: Aftab Khan
Date: August 29, 2012 04:21AM

Please provide SHOW CREATE TABLE and SHOW TABLE STATUS info.
Note: MySQL 5.6 is not production ready but you are welcome to use it in your test environment.
What MySQL version are you using now? 5.5?
>As it seeds records almost 5hundered thousands perday and peak time goes to 8 transactions per second on that table. That is the intent of falling on to partitions.

Do do single inserts or batch insert? 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.

How many partitions do you intent to use? Partitioning performance drops drastically with hundreds of partitions,
http://bugs.mysql.com/bug.php?id=37252

Do you purge historic data from the table in question?

Please provide SELECTs that you run against the table.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: timestamp, datetime as default value as current_timestamp [PARTITION]
1582
August 29, 2012 04:21AM


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.