Raid1+0 stripe size for MySQL InnoDB
MySQL InnoDB使用 Raid 1+0 stripe size 大小该如何配置？ By: 谭俊青@MySQL实验室 要理解Raid 1+0，我们首先要先理解Raid 0，看下图： 左图为 4kb stripe size；右图为 64kb stripe size 存储文件大小：红色:4kiB，蓝色:20kiB，绿色:100kiB，紫色:500kiB Ra
MySQL InnoDB使用 Raid 1+0 stripe size 大小该如何配置？
By: 谭俊青@MySQL实验室
要理解Raid 1+0，我们首先要先理解Raid 0，看下图：
左图为 4kb stripe size；右图为 64kb stripe size
存储文件大小：红色:4kiB，蓝色:20kiB，绿色:100kiB，紫色:500kiB
Raid 0 准确的来说应该称 AID 0
大家可以看到，如果stripe size设置过大，在单线程的情况下起不到提速作用。而设置过小又会产生多次IO操作。因此我们通过简化模型，将大部分请求的文件块大小（IO_SIZE）除以RAID0 的磁盘数量（DISK_NUM）来估算stripe size大小（stripe size＝IO_SIZE / DISK_NUM）。
比如MySQL InnoDB，假设平时大部分请求文件块的大小为1M（16kb＊64）,那么在8块盘组成的Raid1＋0的情况下stripe size＝1024kb / 4 = 256kb。这时候将Raid的条带大小配置为256kb是比较合适的。MyISAM存储引擎使用情况相对复杂。
实际上管理和磁盘定位等还有一定开销，更为主要的是不同的业务，请求的文件块大小相差很大，所以在实际环境中很难一刀切说多大的stripe size最佳，因此在估算之后可以上下浮动评测，选择适合自己系统的最优大小的stripe size。
顺便今天在MySQL实验室的2个群里调查了下，stripe size大小为64kb、256kb基本各占50％。
－－ －－－－－－－－－－－－－
SDO：测试下8块及以上盘阵 strip size 256k最佳
点评网：256k
畅游：512k 综合效果更好 （来源评论）
继续统计更新…
Related posts:
- InnoDB Plugin 1.0.4 for MySQL 5.1.37
- InnoDB plugin 1.0.7
- NoSQL到MySQL+Memcache(d)重树MySQL王者地位
- MySQL5.5与MySQL5.1 性能(比较)对比测试
- MySQL Cluster致命缺点
? 谭俊青 发布在 MySQL性能、MySQL Cluster集群、MySQL HA高可用等研究 - MySQL实验室, 2011.
可以任意转载, 但转载时务必以超链接形式标明文章原始出处 和 作者信息。
链接: http://www.mysqlab.net/blog/2011/12/raid10-stripe-size-for-mysql-innodb/
标签: Raid, stripe size
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1664
14
1421
52
1315
25
1266
29
1239
24
MySQL's Role: Databases in Web Applications
Apr 17, 2025 am 12:23 AM
The main role of MySQL in web applications is to store and manage data. 1.MySQL efficiently processes user information, product catalogs, transaction records and other data. 2. Through SQL query, developers can extract information from the database to generate dynamic content. 3.MySQL works based on the client-server model to ensure acceptable query speed.
Laravel Introduction Example
Apr 18, 2025 pm 12:45 PM
Laravel is a PHP framework for easy building of web applications. It provides a range of powerful features including: Installation: Install the Laravel CLI globally with Composer and create applications in the project directory. Routing: Define the relationship between the URL and the handler in routes/web.php. View: Create a view in resources/views to render the application's interface. Database Integration: Provides out-of-the-box integration with databases such as MySQL and uses migration to create and modify tables. Model and Controller: The model represents the database entity and the controller processes HTTP requests.
MySQL and phpMyAdmin: Core Features and Functions
Apr 22, 2025 am 12:12 AM
MySQL and phpMyAdmin are powerful database management tools. 1) MySQL is used to create databases and tables, and to execute DML and SQL queries. 2) phpMyAdmin provides an intuitive interface for database management, table structure management, data operations and user permission management.
Solve database connection problem: a practical case of using minii/db library
Apr 18, 2025 am 07:09 AM
I encountered a tricky problem when developing a small application: the need to quickly integrate a lightweight database operation library. After trying multiple libraries, I found that they either have too much functionality or are not very compatible. Eventually, I found minii/db, a simplified version based on Yii2 that solved my problem perfectly.
MySQL vs. Other Programming Languages: A Comparison
Apr 19, 2025 am 12:22 AM
Compared with other programming languages, MySQL is mainly used to store and manage data, while other languages such as Python, Java, and C are used for logical processing and application development. MySQL is known for its high performance, scalability and cross-platform support, suitable for data management needs, while other languages have advantages in their respective fields such as data analytics, enterprise applications, and system programming.
Laravel framework installation method
Apr 18, 2025 pm 12:54 PM
Article summary: This article provides detailed step-by-step instructions to guide readers on how to easily install the Laravel framework. Laravel is a powerful PHP framework that speeds up the development process of web applications. This tutorial covers the installation process from system requirements to configuring databases and setting up routing. By following these steps, readers can quickly and efficiently lay a solid foundation for their Laravel project.
MySQL for Beginners: Getting Started with Database Management
Apr 18, 2025 am 12:10 AM
The basic operations of MySQL include creating databases, tables, and using SQL to perform CRUD operations on data. 1. Create a database: CREATEDATABASEmy_first_db; 2. Create a table: CREATETABLEbooks(idINTAUTO_INCREMENTPRIMARYKEY, titleVARCHAR(100)NOTNULL, authorVARCHAR(100)NOTNULL, published_yearINT); 3. Insert data: INSERTINTObooks(title, author, published_year)VA
MySQL: Structured Data and Relational Databases
Apr 18, 2025 am 12:22 AM
MySQL efficiently manages structured data through table structure and SQL query, and implements inter-table relationships through foreign keys. 1. Define the data format and type when creating a table. 2. Use foreign keys to establish relationships between tables. 3. Improve performance through indexing and query optimization. 4. Regularly backup and monitor databases to ensure data security and performance optimization.
