由于项目后端存储的需要,需要高性能的存储设备。特此比较Fusion IO (80G)和 RAID5 的mysql性能,采用sysbench v0.4.8 来测试 //innodb中创建100k条数据 ./sysbench --test=oltp --mysql-table-engine=innodb --oltp-table-size=1000000 --mysql-socket=/tmp/mysql1.sock prepare --mysql-user=terry --mysql-password=terry mysql> show table status; +--------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+------------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +--------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+------------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+ | sbtest | InnoDB | 10 | Compact | 1000109 | 225 | 225132544 | 0 | 18399232 | 8584691712 | 1000001 | 2011-03-16 10:43:28 | NULL | NULL | utf8_general_ci | NULL | | | +--------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+------------+----------------+---------------------+-------------+------------+--