ベンチマークツール - HTN20190109の日記

Oracle

SET SERVEROUTPUT ON
DECLARE
lat INTEGER;
iops INTEGER;
mbps INTEGER;
BEGIN
-- DBMS_RESOURCE_MANAGER.CALIBRATE_IO (<DISKS>, <MAX_LATENCY>, iops, mbps, lat);
DBMS_RESOURCE_MANAGER.CALIBRATE_IO (2, 10, iops, mbps, lat);

DBMS_OUTPUT.PUT_LINE ('max_iops = ' || iops);
DBMS_OUTPUT.PUT_LINE ('latency = ' || lat);
dbms_output.put_line('max_mbps = ' || mbps);
end;
/

--Swingbench

https://www.arihisa.com/blog/2017/12/07/%E3%83%87%E3%83%BC%E3%82%BF%E3%83%99%E3%83%BC%E3%82%B9%E3%81%AB%E8%B2%A0%E8%8D%B7%E3%82%92%E4%B8%8E%E3%81%88%E3%82%8B%E3%81%AE%E3%81%AFswingbench%E3%81%8C%E4%BE%BF%E5%88%A9/

MySQL

--mysqlslap

mysqlslap -a -x 5 -y 5 -c 16 -i 1000 -e innodb --commit=100

--sysbench

https://www.s-style.co.jp/blog/2018/03/1605/

curl -s https://packagecloud.io/install/repositories/akopytov/sysbench/script.rpm.sh | sudo bash
sudo yum -y install sysbench

sysbench --db-driver=mysql --mysql-user=root --mysql-password='Aaa!1234' \
--tables=10 --table_size=10000 --mysql-db=test oltp_read_write prepare

sysbench --db-driver=mysql --mysql-user=root --mysql-password='Aaa!1234' \
--tables=10 --table_size=10000 --mysql-db=test --time=60 --events=0 --threads=16 oltp_read_write run

sysbench --db-driver=mysql --mysql-user=root --mysql-password='Aaa!1234' \
--tables=10 --table_size=10000 --mysql-db=test oltp_read_write cleanup

sysbench --test=cpu --cpu-max-prime=20000 run

sysbench --test=fileio --file-total-size=2G prepare
sysbench --test=fileio --file-total-size=2G --file-test-mode=rndrw \
--max-time=300 --max-requests=0 run
sysbench --test=fileio --file-total-size=2G cleanup

--mysql-bench

yum install mysql-bench
cd /usr/share/sql-bench
./run-all-tests --server=mysql --user=root --log --fast --password='Aaa!1234'