Re: How to find out block size of database?
Posted by:
Rick James
Date: October 13, 2009 11:47PM
IOPs counts can be fooled by readahead, caching, RAID controllers, and by the basic disk block size.
MyISAM uses 4KB for index blocks. Data is not blocked.
InnoDB uses 16KB blocks for data and index.
Transactions, replication, etc, do whatever they feel like.
Subject
Written By
Posted
Re: How to find out block size of database?
October 13, 2009 11:47PM
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.