Rackpace.com Cloud Server – CentOS 5.5 64bit install and setup
Rackspace Cloud server – Sysbench fileio benchmark
Installed Sysbench 0.4.12 to run a quick fileio test and ran across my first problem related to where MariaDB 5.2.5 MySQL 64bit installs libmysqlclient_r.so.
wget http://cdnetworks-us-1.dl.sourceforge.net/project/sysbench/sysbench/0.4.12/sysbench-0.4.12.tar.gz tar xvzf sysbench-0.4.12.tar.gz cd sysbench-0.4.12 libtoolize --force --copy ./autogen.sh ./configure make && make install |
at make install stage get error
gcc: /usr/lib64/mysql/libmysqlclient_r.so: No such file or directory make[2]: *** [sysbench] Error 1 make[2]: Leaving directory `/usr/local/src/sysbench-0.4.12/sysbench' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/src/sysbench-0.4.12/sysbench' make: *** [all-recursive] Error 1 |
quick symlink fix
ln -s /usr/lib64/libmysqlclient_r.so /usr/lib64/mysql/libmysqlclient_r.so |
create a small 128MB test file
sysbench --test=fileio --max-time=60 --max-requests=10000 --file-num=1 --file-extra-flags=direct --file-fsync-freq=0 --file-total-size=128M prepare |
ran quick Sysbench random read and random write fileio test
sysbench --test=fileio --max-time=60 --max-requests=10000 --file-num=1 --file-extra-flags=direct --file-fsync-freq=0 --file-total-size=128M --num-threads=1 --file-test-mode=rndrd run sysbench --test=fileio --max-time=60 --max-requests=10000 --file-num=1 --file-extra-flags=direct --file-fsync-freq=0 --file-total-size=128M --num-threads=1 --file-test-mode=rndwr run |
The Sysbench fileio results for Rackspace Cloud server
sysbench --test=fileio --max-time=60 --max-requests=10000 --file-num=1 --file-extra-flags=direct --file-fsync-freq=0 --file-total-size=128M --num-threads=1 --file-test-mode=rndrd run sysbench 0.4.12: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 1 Extra file open flags: 16384 1 files, 128Mb each 128Mb total file size Block size 16Kb Number of random requests for random IO: 10000 Read/Write ratio for combined random IO test: 1.50 Calling fsync() at the end of test, Enabled. Using synchronous I/O mode Doing random read test Threads started! Done. Operations performed: 10000 Read, 0 Write, 0 Other = 10000 Total Read 156.25Mb Written 0b Total transferred 156.25Mb (137.33Mb/sec) 8789.38 Requests/sec executed Test execution summary: total time: 1.1377s total number of events: 10000 total time taken by event execution: 1.1124 per-request statistics: min: 0.09ms avg: 0.11ms max: 1.20ms approx. 95 percentile: 0.15ms Threads fairness: events (avg/stddev): 10000.0000/0.00 execution time (avg/stddev): 1.1124/0.00 |
sysbench --test=fileio --max-time=60 --max-requests=10000 --file-num=1 --file-extra-flags=direct --file-fsync-freq=0 --file-total-size=128M --num-threads=1 --file-test-mode=rndwr run sysbench 0.4.12: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 1 Extra file open flags: 16384 1 files, 128Mb each 128Mb total file size Block size 16Kb Number of random requests for random IO: 10000 Read/Write ratio for combined random IO test: 1.50 Calling fsync() at the end of test, Enabled. Using synchronous I/O mode Doing random write test Threads started! Done. Operations performed: 0 Read, 10000 Write, 1 Other = 10001 Total Read 0b Written 156.25Mb Total transferred 156.25Mb (52.751Mb/sec) 3376.09 Requests/sec executed Test execution summary: total time: 2.9620s total number of events: 10000 total time taken by event execution: 2.9364 per-request statistics: min: 0.11ms avg: 0.29ms max: 112.25ms approx. 95 percentile: 0.20ms Threads fairness: events (avg/stddev): 10000.0000/0.00 execution time (avg/stddev): 2.9364/0.00 |
