MySQL Forums
Forum List  »  Partitioning

Partitioning Details
Posted by: Steven Roussey
Date: June 17, 2005 02:03PM

I was wondering about some details on how Mysql is going to handle individual partitions. We do our own in-application poor mans version of partitioning for two reasons: table locking and table maintanence. In a partitioned table, will there still be table locking, or will it lock just a partition? Or will there be row-level-locking at that time that makes my question meaningless? And will we be able to do maintanence on a table one partition at a time, or will it require the whole table to be locked up? In this context, I mean something like OPTIMIZE TABLE or ALTER TABLE ... ORDER BY on a partition.

Thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
Partitioning Details
4021
June 17, 2005 02:03PM
3064
June 18, 2005 02:04AM
2646
June 20, 2005 08:33PM
2750
June 21, 2005 08: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.