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@diazdesantos.es> 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@diazdesantos.es
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql?unsub=aaronblew@gmail.com
>>
>>
>


--
--------
Iñigo Medina García
Librería Díaz de Santos Madrid (Spain)
imedina@diazdesantos.es facilmejor@gmail.com