homepage Welcome to WebmasterWorld Guest from 54.224.53.192
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
using multiple drives
why wouldn't you?
LifeinAsia

WebmasterWorld Administrator lifeinasia us a WebmasterWorld Top Contributor of All Time 5+ Year Member



 
Msg#: 4609357 posted 6:31 pm on Sep 12, 2013 (gmt 0)

I'm from a MS SQL shop, and i know things are a little different on the MySQL side of the world, so I am trying to learn as I go.

Let's say your MySQL setup has 2 hard drives:
- 20G partition on a SATA drive (slow)
- 140G partition on a SAS drive (fast)

Is there any reason why you would NOT want to have all your data files on the SAS drive from the setup?

And even assuming you originally set things up with just the SATA drive (later added the SAS drive), is there a compelling reason NOT to move the data files to the SAS drive?

Note- the server is not yet in production. So shutting down MySQL and moving the files will not affect any users.

 

coopster

WebmasterWorld Administrator coopster us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 4609357 posted 2:30 am on Sep 17, 2013 (gmt 0)

I cannot speak to this question personally but have a look at this PDF from Percona
[percona.com...]
Let me know what you deduce!

LifeinAsia

WebmasterWorld Administrator lifeinasia us a WebmasterWorld Top Contributor of All Time 5+ Year Member



 
Msg#: 4609357 posted 1:31 pm on Sep 17, 2013 (gmt 0)

I may or may not need to have alcohol involved to make a deduction. ;)

Interesting page- it's going to take a while to absorb it all. Thanks!

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved