Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have written a crone job which reorganizes last max value partition every week into 2 new partitions , one for the previous week , and one for the future data (new max value partition which initially is empty).

I have noticed that the previous max value partition is copied to a 2 new files (one for the previous week partition and one for the new max value partition), the second file is empty since it represents a partition for future not existing data.

Then i wondered why recopying data from previous max value partition to new partition file and then deleting the previous max value file, and creating a new empty max value partition file, it seems as a big waste of time.

I have to mention i deal with MyISAM tables, Additionally i have stumbled on this reported bug which describes very similar conditions.

  1. Is there a workaround method to achieve the behavior i have suggested (renaming the partition of max value to a new partition name and replacing the max value constrain by a new current max value measurement, then creating a new max value empty partition?

  2. Can you suggest other way to close a partition -> activate some command that will close (add max limitation on the previous max value partition) an open a new max value partition?

share|improve this question
add comment

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.