Re: Block size of filesystem

[Iñigo Medina García <imedina@xxxxxxxxxxxxxxx>]

Thanks, Aaron.

>> Will you be using the MyISAM or InnoDB table engines?

Both, but InnoDB more.

>> I had heard that InnoDB uses 16k blocks internally, so that might be
a good starting point, though I'd love to have someone confirm or deny
that this is actually true.

Ok, that's interesting.  :-)  I'll check it.

   Iñigo



Aaron Blew wrote:
> Will you be using the MyISAM or InnoDB table engines?
> 
> I had heard that InnoDB uses 16k blocks internally, so that might be a good
> starting point, though I'd love to have someone confirm or deny that this is
> actually true.
> 
> -Aaron
> 
> 
> On Fri, May 9, 2008 at 12:01 AM, Iñigo Medina García <
> imedina@xxxxxxxxxxxxxxx> 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
>>
>> --
>> --------
>> Iñigo Medina García
>> Librería Díaz de Santos
>> imedina@xxxxxxxxxxxxxxx
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:    http://lists.mysql.com/mysql?unsub=aaronblew@xxxxxxxxx
>>
>>
> 


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