Below were the steps and commands used to create the partitions.
For ext3 fs:
fdisk /dev/sda mke2fs -t ext3 /dev/sda4 mount /dev/sda4 /bench -t ext3 bonnie++ -d /bench/ -c 5 -s 1G -n 32 -m ext3
For ext4 fs:
fdisk /dev/sda mke2fs -t ext4 /dev/sda4 mount /dev/sda4 /bench -t ext4 bonnie++ -d /bench/ -c 5 -s 1G -n 32 -m ext4
For xfs fs:
fdisk /dev/sda /sbin/mkfs.xfs /dev/sda4 mount /dev/sda4 /bench -t xfs bonnie++ -d /bench/ -c 5 -s 1G -n 32 -m xfs
The results:
1. xfs is having highest SO_PC_KPS (Sequential Output,Per Char,k/sec).
2. ext4 is having highest SI_PC_KPS (Sequential Input,Per Char,k/sec).
3. ext4 is having highest RS_PS (Random Seek,/sec).
4. ext4 is having highest SCC_PS (Sequential Create Create, /sec).
5. ext4 is having highest SCD_PS (Sequential Create Delete, /sec).
6. ext4 is having highest RCC_PS (Random Create Create, /sec).
7. ext4 is having highest RCD_PS (Random Create Delete, /sec).
Yeah I was also surprised that mysql 5.1 on ext4 on a centos 6.4 machine was actually faster in inserting 100 million rows than the same configuration with xfs, did not use to be that way :) The benchmark I like to use for that is mysqlslap.
ReplyDeleteGlad that you have the same result. I guess ext4 was improved along the way. Cheers.
Delete