Raid1 + 0 stripesizeforMySQLInnoDB

How can I configure the size of MySQLInnoDB using Raid1 + 0stripesize? By: Tan junqing @ MySQL lab to understand Raid1 + 0, we first need to understand Raid0, see: 4 kbstripesize on the left; 64 kbstripesize on the right: Red: 4kiB, Blue: 20kiB, Green: 100kiB, purple: 500 kiBRa

How can I configure the size of MySQL InnoDB Raid 1 + 0 stripe? By: Tan junqing @ MySQL lab to understand Raid 1 + 0, we first need to understand Raid 0, see: the picture on the left is 4kb stripe size; the picture on the right is 64kb stripe size: RED: 4kiB, Blue: 20kiB, Green: 100kiB, purple: 500kiB Ra

How can I configure the size of MySQL InnoDB Raid 1 + 0 stripe?

By: Tan junqing @ MySQL lab

To understand Raid 1 + 0, we must first understand Raid 0:

4 kb stripe size in the left and 64 kB stripe size in the right
Storage file size: Red: 4kiB, Blue: 20kiB, Green: 100kiB, purple: 500kiB

Raid 0 should be called AID 0 accurately
As you can see, if the stripe size is too large, it will not speed up in the case of a single thread. Setting too small will produce multiple IO operations. Therefore, we can estimate the stripe size (stripe size = IO_SIZE/DISK_NUM) by dividing the size (IO_SIZE) of most requested file blocks by the disk quantity (DISK_NUM) of RAID 0 ).

For example, in MySQL InnoDB, assume that the size of most request file blocks is 1 MB (16 KB * 64 ), in the case of RAID 1 + 0 consisting of eight disks, stripe size = 1024kb/4 = 256kb. In this case, it is appropriate to set the size of the Raid strip to kb. The usage of the MyISAM storage engine is relatively complex.

In fact, there is a certain amount of overhead for management and disk positioning. More importantly, the size of the requested file block varies greatly with different services, therefore, in the actual environment, it is difficult to say how big the stripe size is to be the best. Therefore, after estimation, you can float up and down the evaluation and select the stripe size that suits your system's optimal size.

By the way, we found in two groups in the MySQL lab that the size of stripe is 64 KB and 50% kb respectively.

---------------

SDO: The best strip size for eight or more disks is 256k.

Comments Network: 256 k

Changyou: the comprehensive effect of 512 k is better (source comment)

Continue Statistics Updates...

Related posts:

1. InnoDB Plugin 1.0.4 for MySQL 5.1.37
2. InnoDB plugin 1.0.7
3. From NoSQL to MySQL + Memcache (d) Heavy-tree MySQL
4. Performance Comparison and test of MySQL5.5 and MySQL5.1
5. MySQL Cluster fatal disadvantage

? Tan junqing published a study on MySQL performance, MySQL Cluster, and MySQL HA High Availability-MySQL laboratory, 2011.
The source and author information of an article can be reproduced at will.
Link: http://www.mysqlab.net/blog/2011/12/raid10-stripe-size-for-mysql-innodb/

Label: Raid, stripe size