MySQL Forums
Forum List  »  General

Re: CREATE TABLE ignores DATA DIRECTORY option
Posted by: Rick James
Date: October 03, 2010 12:06PM

(I don't know why it failed for you. And I would like to hear the results you get.) But I am pessimistic...

For a single thread, splitting data/index across disks is totally useless. Why? Because first you fetch index block(s), then you fetch data blocks.

For multi-thread usage, there may be a chance of one thread reading an index block at the same time another thread is reading a data block.

Index blocks are cached in the key_buffer; if the indexes are so small that all the blocks are cached, then you are not reading from the indexes. Ditto if the data is cached.

RAID striping is simpler and gives you more benefit in most cases.

Options: ReplyQuote




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.