Iozone Filesystem Benchmark. LMDD(8) - LMBENCH man page. Evaluating IO subsystem performance for MySQL Needs | MySQL Perf. I’m often asked how one can evaluate IO subsystem (Hard drive RAID or SAN) performance for MySQL needs so I’ve decided to write some simple steps you can take to get a good feeling about it, it is not perfect but usually can tell you quite a lot of what you should expect from the system. What I usually look for MySQL is performance in random reads and random writes. Sequential reads and writes are rarely the problem for OLTP workloads, so we will not look at them. I also prefer to look at performance with O_DIRECT flag set to bypass OS cache. This may execute separate code path in kernel and so has a bit different performance pattern compared to buffered IO (even followed by fsync regularly) , but it allows to easily bypass OS cache both for reads and for writes and so does not require creating large working sets for boxes with significant amounts of memory (or reducing amount of usable memory).
To prepare small 128MB single file working set we can use the following command: . How To Measure Linux Filesystem I/O Performance With iozone. Following are few situations where you may be interested in performing a filesystem benchmarking. => Deploying a new application that is very read and write intensive. => Purchased a new storage system and would like to measure the performance. => Changing the RAID level and would like to measure the performance of the new RAID. => Changing the storage parameters and would like to know the performance impact of this change This article gives you a jumpstart on performing benchmark on filesystem using iozone a free Filesystem Benchmark utility. 1.
Download and Install iozone software Go to iozone and download the iozone for your appropriate platform. Preparing... ########################################### [100%] 1:iozone ########################################### [100%] Note: You can install iozone under any UNIX / Linux or Windows operating system. 2. Execute the following command in the background to begin the performance test. 3. (Fig.01: iozone in action) References: Using Bonnie++ for filesystem performance benchmarking. Bonnie++ is available for openSUSE 10.3 as a 1-Click, for Ubuntu Hardy, and in the standard Fedora 9 repositories. I installed Bonnie++ from the 64-bit Fedora 9 repositories. The packages for Ubuntu and Fedora both install Bonnie++ into /usr/sbin, while openSUSE installs into /usr/bin.
Bonnie++ will complain and fail to work if invoked as the root user, but if Bonnie++ is installed into /usr/sbin instead of /usr/bin, to invoke Bonnie++ as a regular user you will probably have to include its full path. Bonnie++ uses autoconf to generate its Makefile, and the install-bin target is hardwired to install Bonnie++ into sbin, so to package it in /usr/bin you have to move it there after installation even if building from source. Bonnie++ benchmarks three things: data read and write speed, number of seeks that can be performed per second, and number of file metadata operations that can be performed per second.
The number of seeks per second should be fairly bound by your hardware.