How hard to get MySQL data served from a separate physical drive?

sneakyimp · 09-18-2007, 05:09 PM

I ran some sysstat diagnostics on one of my servers and it would seem that the disk drive is getting a real workout. I plan to add more RAM to alleviate the memory paging/swapping that's going on, but am hoping to prepare for future growth. I'd like to try and put the MySQL data onto a separate physical disk drive so that Linux, Apache, and PHP can all use one drive and MySQL data will be retrieved from another. How hard is it to configure MySQL to use a different drive for its data?

FragInHell · 09-18-2007, 06:15 PM

I dont know if this is right,but it worked for me.
Edit the my.cnf configuration file (was in /etc for me on redhat).
stop mysql
Change the datadir to your new location
copy the data to the new location
re-start mysql

sneakyimp · 09-18-2007, 09:53 PM

Thanks FragInHell, I think that is going to work for me. A buddy said the same thing.