K.S. Bhaskar on 18 Jun 2013 04:39:21 -0700 |
[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]
Re: [PLUG] PLUG West - Monday June 17, 2013 - Linux Filesystems and Benchmarking, presented by K.S. Bhaskar (7pm at FIS in Malvern) |
On Tue, Jun 18, 2013 at 12:51 AM, JP Vossen <jp@jpsdomain.org> wrote:One little tip though - put /var/lib/mysql on ext3 and not ext4.
>
> Work stuff aside, 11 out of 13 machines I just checked are running ext3, the
> other 2 are ext4. ÂGuess I'll need to look into that.
>
Ext4, mysql, and barrier support combine to give very poor
performance. ÂMySQL recommends just disabling barriers, which IMHO is
right up there with how their motto used to be "who needs ACID?"
Moving just mysql to ext3 results in a fairly dramatic performance
increase (in fact, I should probably stop allocating so much RAM for
it now).
Otherwise, yes, ext4 is probably your best all-around option until
btrfs is production-ready. ÂI don't like xfs since it can't be shrunk
- I like my filesystems to be flexible (preferably with online
resizing).
Rich
___________________________________________________________________________
Philadelphia Linux Users Group     --    Âhttp://www.phillylinux.org
Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
General Discussion Â-- Â http://lists.phillylinux.org/mailman/listinfo/plug
___________________________________________________________________________ Philadelphia Linux Users Group -- http://www.phillylinux.org Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce General Discussion -- http://lists.phillylinux.org/mailman/listinfo/plug