Today, I am in Boston for training, I am shadowing Ronald Bradford, another MySQL consultant. It is fun and I learn a lot although it is not always easy to follow someone else mind. But we needed to evaluate the performance and the stability of a SAN. Do do so, we have used the bonnie++ tool. The server has 32 GB of memory and the filesystem was mounted under /data3. The command line used was the following:
mkdir /data3/testbonnie; nohup bonnie++ -d /data3/testbonnie -s 65000 -n 10 -r 32000 -x 5 -u root -g root &
After more six hours… the results were the following:
cat nohup.out | grep proddb | bon_csv2txt
Version @version@ ——Sequential Output—— –Sequential Input- –Random-
-Per Chr- –Block– -Rewrite- -Per Chr- –Block– –Seeks–
Machine Size K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP /sec %CP
proddb06 65000M 71639 84 67884 13 54084 7 60194 60 126326 7 572.7 0
proddb06 65000M 79194 92 73790 14 53934 7 60226 60 125639 7 566.9 0
proddb06 65000M 78795 94 65855 12 53893 7 60292 60 126335 7 576.1 1
proddb06 65000M 80131 94 66034 12 53338 7 60308 60 125753 7 587.5 1
proddb06 65000M 79590 95 67575 13 54467 7 60745 60 126381 7 589.7 0
——Sequential Create—— ——–Random Create——–
-Create– –Read— -Delete– -Create– –Read— -Delete–
files:max:min /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP
proddb06 10 9133 99 +++++ +++ +++++ +++ 9375 99 +++++ +++ +++++ +++
proddb06 10 9085 99 +++++ +++ +++++ +++ 9330 100 +++++ +++ +++++ +++
proddb06 10 9002 99 +++++ +++ +++++ +++ 9386 99 +++++ +++ +++++ +++
proddb06 10 9165 100 +++++ +++ +++++ +++ 9436 99 +++++ +++ +++++ +++
proddb06 10 9140 99 +++++ +++ +++++ +++ 9398 99 +++++ +++ +++++ +++
Which is typical of a medium range San using Raid5. It is worth notice that the first time we ran bonnie++, we actually frose the server. Bonnie++ stressed the disk I/O to a point that showed a problem with the fiber channel adapter driver. Good to have catch this problem before going into production.
