MySQL Forums
Forum List  »  MySQL & Storage

when to put logs on separate volume?
Posted by: Jed Reynolds
Date: December 15, 2006 02:40AM

I'm trying to plan out a disk system for my next pair of mysql servers.
Right now I'm doing about 300qps with ratios like 53/24/15/00 and generating
6 GB of binary logs a day. The disk setup I have for my two servers now is
two RAID0 300gb 10krm for /var/lib/mysql, and two 15krpm 36GB RAID0 for /tmp, where temp tables are going.

These numbers reflect a healthy cache setup using memcached, and as memcached fails or memcached is being flushed (as those numbers above actually represent), I presume I'm using my /tmp volume, and a lot of my queries take 2-4 seconds.

I'm kinda thinking that my setup for /tmp is overkill, but as my dataset and traffic grows, I'm going to want to move the binlogs off the data volume. Should I consider that now, or should I care yet?

With the amount of caching I'm doing, I'm considering going down to 4x 10krpm 300GB raid 10 setup. But that might not leave me with a lot of headroom for load spikes, so I'm also considering something like a 12 disk chassis starting like
4x300Gb raid10 /var/lib/mysql
2x36Gb raid 1 /var/log, binlogs
2x36Gb raid 0 /tmp, temp tables

Opinions? Suggestions?

Edited 1 time(s). Last edit at 12/15/2006 02:40AM by Jed Reynolds.

Options: ReplyQuote

Written By
when to put logs on separate volume?
December 15, 2006 02:40AM

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.