Web lists-archives.org

Re: Block size of filesystem

Thanks Ben.

>> 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.

Perfect. That sounds the way Aaron explain about 16k blocks in InnoDb.
And actually we have more InnoDB tables tan MyISAM.

>> 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

Perfect. I'll check it.

      Iñigo



Ben Clewett wrote:
> 
> 
> 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.
> *************************************************************************
> 


-- 
--------
Iñigo Medina García			
Librería Díaz de Santos		Madrid (Spain)
imedina@xxxxxxxxxxxxxxx		facilmejor@xxxxxxxxx

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx