install mySQL, partition question

feetyouwell · 12-20-2004, 08:55 AM

i am about to set up a mysql server, i would assume that the db itself should have its own partition. Which one is that? can anyone tell me the correct way to set it up? thanks

cyto · 12-20-2004, 10:22 AM

I dont think that db itself have its own partition. I use slackware as my server, and it has mysql so u dont have to compile it. I bet u that most of the distros have Mysql by default. U need to select it to install it.

rjlee · 12-20-2004, 10:49 AM

You can put the database on its own partition if you want to. It might help you, for instance if you want to use software-RAID for speed or reliability. (http://www.tldp.org/HOWTO/Software-RAID-HOWTO.html) You probably only want to do this if you have a very high load on the database, though, as it can be very expensive in terms of disk space.

The default database location is /var/lib/mysql (installing from RPM), which is used for database files and logs. /usr/local/var is used by default when building from source. (http://dev.mysql.com/doc/mysql/en/In...n_layouts.html)

The installation guide is at http://dev.mysql.com/doc/mysql/en/Installing.html