MySQL Forums
Forum List  »  Partitioning

problem about partition
Posted by: h ch
Date: April 15, 2010 08:01PM

for instance, i have a table with myisam engine,with unpartition table i get 2 file
mytable.MYI and mytable.MYD, but when i split the table into 2 partitions,i get 4 file ,mytable#P#p0.MYI mytable#P#p1.MYI mytable#P#p0.MYD mytable#P#p1.MYD ,that's means when i use mytable,i need 2 extra file handles ,so when i have a table with 100 partitions ,when i open the table ,the file handles number is big,that a big problem!! anyone can explain this??

Options: ReplyQuote


Subject
Views
Written By
Posted
problem about partition
2847
April 15, 2010 08:01PM
1880
April 16, 2010 10:08PM
1854
April 18, 2010 08:16PM


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.