このページの翻訳:
- 日本語 (ja)
- English (en)
最近の更新
- 2024.04.01 作成
最近の更新
文書の過去の版を表示しています。
新しいsysbenchはちょっとオプションが違った。
# curl -s https://packagecloud.io/install/repositories/akopytov/sysbench/script.rpm.sh | sudo bash # sudo yum -y install sysbench
sysbench /usr/share/sysbench/oltp_read_write.lua \ --db-driver=mysql \ --table-size=100000 \ --mysql-host=localhost \ --mysql-user=root \ --mysql-password=[password] \ --mysql-db=benchmark \ --db-ps-mode=disable \ prepare
sysbench /usr/share/sysbench/oltp_read_write.lua \ --db-driver=mysql \ --table-size=100000 \ --mysql-host=localhost \ --mysql-user=root \ --mysql-password=[password] \ --mysql-db=benchmark \ --time=300 \ --db-ps-mode=disable \ --threads=16 \ run
SQL statistics: queries performed: read: 13620712 write: 3811897 other: 2025506 total: 19458115 transactions: 972895 (3242.90 per sec.) queries: 19458115 (64858.62 per sec.) ignored errors: 13 (0.04 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 300.0066s total number of events: 972895 Latency (ms): min: 2.36 avg: 4.93 max: 273.59 95th percentile: 10.09 sum: 4797901.95 Threads fairness: events (avg/stddev): 60805.9375/188.35 execution time (avg/stddev): 299.8689/0.00