Re: XFS TRIM Support on Debian 6.0.5 ?
On 8/31/2012 2:37 AM, Andy Chandra wrote:
> Hi Stan,
Hi Andy,
Please always make sure you reply to, or CC, the list so all people see
all posts and so they get archived for those searching Google.
> Thank you for your clue.
>
> Because it looks like little bit complicated,
If you see that as complicated I'm surprised you're managing servers.
No offense intended here, just being frank. What I mentioned is utterly
simple compared to most of what people on this list do every day.
> What if I just use EXT4?
Doesn't matter which filesystem you use. The FITRIM code is common to
all Linux filesystems. But if you've read my follow up email you'll
realize you're not going to be able to use TRIM anyway, not with RAID.
> Will Debian 6.0.5 TRIM my SSD automatically?
NO. It must manually be enabled. And again it won't work with RAID.
> And for MySQL, Will XFS helps me lot than EXT4?
The application doesn't matter, whether mysql, pgsql, apache, SMTP,
IMAP, etc. It's the load on the application that matters, i.e.
concurrent user accesses per unit time. For light/medium load EXT4 is
usually fine. For heavy/insane load you should use XFS. XFS is better
all around due to superior performance and tools. I use XFS
exclusively. I've never used EXT3/4, Reiser, or JFS. XFS is simply
superior with parallel workloads. Most server workloads are parallel.
I get the feeling you manage your servers from a GUI, and don't have
much command line experience. If this is the case then it doesn't
matter what you use. People who manage from a GUI never have high load.
Why? If you have high load you must master the command line to
diagnose, troubleshoot, tweak, etc for maximum performance and
efficiency. If you have high load and don't master the command line,
becoming a competent system administrator, then that high load turns
into no load, as all your users leave because the server is slow or
returns errors due to timeouts and the like.
> Thank you again for your help and attention, I really appreciate it.
> On Aug 31, 2012 1:44 PM, "Stan Hoeppner" <stan@hardwarefreak.com> wrote:
>
>> On 8/30/2012 10:15 PM, Andy Chandra wrote:
>>
>>> I was wondering if Debian 6.0.5 support TRIM (for Solid-state Disks)
>> using XFS filesystem on Debian 6.0.5?
>>
>> Not with the default kernel. Read on.
>>
>>> Anyone has clue about installing XFS filesystem on Debian 6.0.5?
>>
>> The XFS driver will load as a module. To create an XFS filesystem:
>>
>> ~$ mkfs.xfs /dev/[device]
>> ~$ mkfs.xfs /dev/sdb
>>
>>> I'm planning for using MySQL (/var) on XFS filesystem on my SSD.
>>
>> After creating the XFS you'd mount it at /var. Instructions for
>> mounting and enabling automatic FITRIM in XFS are found here:
>>
>> http://xfs.org/index.php/FITRIM/discard
>>
>> The default 6.0.5 kernel is 2.6.32-5 which is very old and does not
>> support TRIM. As mentioned in the XFS FITRIM FAQ, you'll need at
>> minimum kernel 2.6.38 for batch mode TRIM and 3.0.0 for realtime TRIM.
>>
>> Debian doesn't offer a 2.6.38 kernel, but the backports repository does
>> offer a 3.2 kernel. The package name is:
>>
>> linux-image-3.2.0-0.bpo.3-amd64
>>
>> This kernel allows using either FITRIM mode. For instructions to install
>> packages from the backports repo see:
>>
>> http://backports-master.debian.org/Instructions/
--
Stan
Reply to: