Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am thinking of creating a dedicated partition on the harddisk for the mysql database data files in /var/lib/mysql , while considering those 2 points:

  1. a dedicated partition will avoid any file fragmentation that might occur, even if fragmentation occurred it would be very limited.

  2. benefit from the faster throughput and lower latency at the beginning of the mechanical harddisk.

What are the (other) benefits and possible drawbacks of such system ?

Edit:

More details about my situation:

I have 1 harddisk, actually it is 2 harddisks but in RAID1

It will contain: the database, the webserver, the os and other services.

Os will be Debian 6/7. Filesystem will be EXT3/EXT4

share|improve this question
    
on the same disk as the OS or seperate Disk? What is the OS and what disk format you use? –  Raymond Nijland Aug 14 '13 at 13:40
    
@RaymondN question answered as an edit to the question. –  sharp12345 Aug 14 '13 at 13:58

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.