Mysql-Sysbench性能测试
（3）清理数据sysbench --test=/usr/local/share/sysbench/tests/include/oltp_legacy/oltp.lua--oltp-table-size=1000000 --mysql-user=root --mysql-password='123456' --mysql-socket=/usr/local/mysql/mysql.sock cleanup
SQL statistics:
queries performed:
read: 313488 --读总数
write: 89568--写总数
other: 44784 --其他操作(CURD之外的操作，例如COMMIT)
total: 447840 --全部总数
transactions: 22392(186.27 per sec.) --总事务数(每秒事务数)
queries: 447840 (3725.43 per sec.) --总数(每秒总数)
ignored errors: 0 (0.00 per sec.)--总忽略错误总数(每秒忽略次数)
reconnects: 0 (0.00 per sec.) --重连总数(每秒重连次数)
General statistics:
total time: 120.2098s --总耗时
total number of events: 22392 --共发生多少事务数
Latency (ms):
min: 105.91 --最小耗时
avg: 160.86 --平均耗时
max: 850.77 --最长耗时
95th percentile: 223.34 --超过95%平均耗时
sum: 3601892.56
Threads fairness:
events (avg/stddev): 746.4000/4.95 --总处理事件数/标准偏差
execution time (avg/stddev):120.0631/0.05--总执行时间/标准偏差
页:
[1]