MySQL Forums
Forum List  »  Newbie

How to find out block size of database?
Posted by: Daren Tay
Date: October 12, 2009 08:02PM

Hi people,

I am doing sizing for shared storage and virtualization for database, and I am asked by my vendor "What's the block size of the DB"?

I tried searching but came out with no answers.
It was suggested to me that the default block size is 4096 for most MYSQL, but I wanted to be sure.

Under show variables, I see the following fields which I "THINK" could be the value that I need, but I am not sure.

1) key_cache_block_size (1024)
2) transaction_alloc_block_size (8192)
3) transaction_prealloc_size (4096)

Values in the bracket are the values of the dB servers.

This is asked so that they can calculate the IOPS for the application (MySQL in this case).

Many thankks!

Options: ReplyQuote

Written By
How to find out block size of database?
October 12, 2009 08:02PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.