Re: Block size of filesystem

[Ben Clewett]

I would use as large a block size as you dare, especially with InnoDB. 
Makes reading and writing faster as custs down seek time as cuts down 
disk fragmenation and avoids block table reads.  With MyIsam you have 
lots of files, but if you only have a few again might work well with a 
large block size.

Also have a look at the stripe size of your raid system, might work well 
aligning them if you can.  This URL also gives some tips for an ext3 
file system on RAID, look for 'stride':

http://insights.oetiker.ch/linux/raidoptimization.html

Ben

Iñigo Medina García wrote:
> Hi friends,
> 
> we're developing a new web application that works with a db around 1gb
> and 30 tables.
> 
> We work with linux, and I'm evaluating the benefit of making an specific
> partition (ext3) for mysql in order to have a bigger Block Size. Block
> Size by default in / partition is 4096.
> 
> Do you think that could be good? Any experience?
> 
>      Iñigo
> 

*************************************************************************
This e-mail is confidential and may be legally privileged. It is intended
solely for the use of the individual(s) to whom it is addressed. Any
content in this message is not necessarily a view or statement from Road
Tech Computer Systems Limited but is that of the individual sender. If
you are not the intended recipient, be advised that you have received
this e-mail in error and that any use, dissemination, forwarding,
printing, or copying of this e-mail is strictly prohibited. We use
reasonable endeavours to virus scan all e-mails leaving the company but
no warranty is given that this e-mail and any attachments are virus free.
You should undertake your own virus checking. The right to monitor e-mail
communications through our networks is reserved by us

  Road Tech Computer Systems Ltd. Shenley Hall, Rectory Lane, Shenley,
  Radlett, Hertfordshire, WD7 9AN. - VAT Registration No GB 449 3582 17
  Registered in England No: 02017435, Registered Address: Charter Court, 
  Midland Road, Hemel Hempstead,  Hertfordshire, HP2 5GE. 
*************************************************************************