Re: partitioning question?
Posted by:
Rick James
Date: December 16, 2009 11:53PM
Simply turning on file_per_table does not convert existing tables. Only subsequently built tables will be file_per_table.
Search your entire system for a file with a name something like
part#p#p0.ibd
I'm fishing for whether the directory directives were ignored, or something else went wrong.
Note: asmaa must be fully accessible (rwx) by mysql. You could do chmod 777 to be sure.
Until you have benchmarked a large dataset with and without partitioning, and with MyISAM versus with InnoDB, can you be sure one combination is really faster. I find too many cases where someone designs without benchmarking, apparently based on hearsay. I cannot advise on what to choose because there are far too many variables in schema design, SELECT statements, access patterns, etc.
Subject
Views
Written By
Posted
3758
December 14, 2009 08:34AM
2299
December 16, 2009 12:33AM
2154
December 16, 2009 07:44AM
Re: partitioning question?
2292
December 16, 2009 11:53PM
2186
December 17, 2009 02:39AM
2170
December 18, 2009 12:40AM
2238
December 22, 2009 02:50AM
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.