MySQL Forums
Forum List  »  Partitioning

Re: Problem in Subpatitioning
Posted by: Phil Hildebrand
Date: January 23, 2008 01:14PM

I was able to do what you are describing with 5.1.22-rc.

Is it possible your open_files_limit or innodb_open_files is not high enough?
do you have innodb_files_per_table on maybe?

(I'm assuming you 12 monthly partitions per year, not 12 per month)

I used partition by range (month(<mydate>) subpartition by hash (day(<mydate>)) subpartitions 31

Options: ReplyQuote


Subject
Views
Written By
Posted
3959
January 23, 2008 12:53AM
Re: Problem in Subpatitioning
2784
January 23, 2008 01:14PM
2670
January 29, 2008 03:15AM
2645
March 25, 2008 11:28AM


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.