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) [EMAIL PROTECTED] [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
