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??
Subject
Views
Written By
Posted
problem about partition
2891
April 15, 2010 08:01PM
1904
April 16, 2010 10:08PM
1878
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.