Re: myisamchk error when using symbolic links
Posted by:
Rick James
Date: April 23, 2011 01:14PM
The benefit of "do not use the same physical directory for data and indexes." is a myth. The typical query will first hit an index, then hits the data. That is, no overlap is possible. Yeah, there are other situations where there can be overlap.
Much better is RAID striping. This can do things that separating data and index cannot -- an index scan or a table scan _may_ run N times as fast when you stripe N drives.
Certain operations screw up when you have linked files. When recreating a table (ALTER, REPAIR, etc) it _may_ forget the symlink and create a new file in the .../mysql/data/dbname/ directory.
Subject
Views
Written By
Posted
4209
April 19, 2011 12:52PM
1474
April 19, 2011 01:08PM
Re: myisamchk error when using symbolic links
1638
April 23, 2011 01:14PM
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.