使用 Mariadb-bench 測試

安裝方法

yum install mariadb-bench

執行

# cd /usr/share/sql-bench
# ./run-all-tests --server=mysql --cmp=mysql,pg,solid --user=root --password=密碼 --log

結果

Test finished. You can find the result in:
output/RUN-mysql-Linux_3.10.0_957.12.2.el7.x86_64_x86_64-cmp-mysql,pg,solid

其他工具

bench-count-distinct
bench-init.pl
compare-results
copy-db
crash-me
graph-compare-results
innotest1
innotest1a
innotest1b
innotest2
innotest2a
innotest2b
run-all-tests
server-cfg
test-alter-table
test-ATIS
test-big-tables
test-connect
test-create
test-insert
test-select
test-table-elimination
test-transactions
test-wisconsin

MariaDB 10.3 安裝 mariadb-bench 問題

MariaDB 從 5.5 升級到 10.3 要先移除 mariadb-bench ，升級後 MariaDB 10.3 沒有相對應的 mariadb-bench，改用其他的 rpm

# wget http://download-ib01.fedoraproject.org/pub/fedora/linux/updates/29/Everything/x86_64/Packages/m/mariadb-bench-10.3.12-10.fc29.x86_64.rpm
# rpm -i mariadb-bench-10.3.12-10.fc29.x86_64.rpm --nodeps

測試結果