国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 數據庫 > MySQL > 正文

mysql sysbench 1.0.X

2024-07-24 12:32:29
字體:
來源:轉載
供稿:網友
        mysql sysbench 1.0.X:

      1.安裝sysbench
      yum install sysbench
     2.download source code
      sysbench-1.0.14/src/lua,所有文件上傳Linux /opt目錄
 
3.準備mysql
 
CREATE DATABASE tdb01;
CREATE USER 'root'@'192.168.0.130' IDENTIFIED BY 'root123';
GRANT ALL PRIVILEGES ON tdb01.* TO ‘'root'@'192.168.0.130';
FLUSH PRIVILEGES;
 
4.執行步驟
/ prepare /
sysbench /opt/lua/oltp_read_write.lua --db-driver=mysql --mysql-host=192.168.0.130 --mysql-db=tdb01 --mysql-user=root --mysql-password=root123 --table_size=5000000 --tables=10 --threads=300 --time=60 --report-interval=10 prepare
/ run /
sysbench /opt/lua/oltp_read_write.lua --db-driver=mysql --mysql-host=192.168.0.130 --mysql-db=tdb01 --mysql-user=root --mysql-password=root123 --table_size=5000000 --tables=10 --threads=300 --time=60 --report-interval=10 run
/ clean /
sysbench /opt/lua/oltp_read_write.lua --db-driver=mysql --mysql-host=192.168.0.130 --mysql-db=tdb01 --mysql-user=root --mysql-password=root123 --table_size=5000000 --tables=10 --threads=300 --time=60 --report-interval=10 cleanup
 
5.執行過程
 
[root@mdb01 lua]# sysbench /opt/lua/oltp_read_write.lua --db-driver=mysql --mysql-host=192.168.0.130 --mysql-db=tdb01 --mysql-user=root --mysql-password=root123 --table_size=5000000 --tables=10 --threads=300 --time=60 --report-interval=10 prepare
sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
 
Initializing worker threads...
 
Creating table 'sbtest10'...
Creating table 'sbtest1'...
Creating table 'sbtest7'...
Creating table 'sbtest9'...
Creating table 'sbtest6'...
Creating table 'sbtest8'...
Creating table 'sbtest3'...
Creating table 'sbtest2'...
Creating table 'sbtest5'...
Creating table 'sbtest4'...
Inserting 5000000 records into 'sbtest1'
Inserting 5000000 records into 'sbtest2'
Inserting 5000000 records into 'sbtest7'
Inserting 5000000 records into 'sbtest5'
Inserting 5000000 records into 'sbtest10'
Inserting 5000000 records into 'sbtest4'
Inserting 5000000 records into 'sbtest3'
Inserting 5000000 records into 'sbtest9'
Inserting 5000000 records into 'sbtest6'
Inserting 5000000 records into 'sbtest8'
Creating a secondary index on 'sbtest4'...
Creating a secondary index on 'sbtest6'...
Creating a secondary index on 'sbtest5'...
Creating a secondary index on 'sbtest1'...
Creating a secondary index on 'sbtest9'...
Creating a secondary index on 'sbtest8'...
Creating a secondary index on 'sbtest2'...
Creating a secondary index on 'sbtest7'...
Creating a secondary index on 'sbtest10'...
Creating a secondary index on 'sbtest3'...
[root@mdb01 lua]#
 
[root@mdb01 opt]# sysbench /opt/lua/oltp_read_write.lua --db-driver=mysql --mysql-host=192.168.0.130 --mysql-db=tdb01 --mysql-user=root --mysql-password=root123 --table_size=5000000 --tables=10 --threads=300 --time=60 --report-interval=10 run
sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
 
Running the test with following options:
Number of threads: 300
Report intermediate results every 10 second(s)
Initializing random number generator from current time
 
Initializing worker threads...
 
Threads started!
 
[ 10s ] thds: 300 tps: 28.98 qps: 998.95 (r/w/o: 753.86/157.17/87.92) lat (ms,95%): 9799.46 err/s: 0.00 reconn/s: 0.00
[ 20s ] thds: 300 tps: 44.61 qps: 921.51 (r/w/o: 644.08/188.22/89.21) lat (ms,95%): 12163.09 err/s: 0.00 reconn/s: 0.00
[ 30s ] thds: 300 tps: 43.02 qps: 892.44 (r/w/o: 643.05/163.36/86.03) lat (ms,95%): 12163.09 err/s: 0.00 reconn/s: 0.00
[ 40s ] thds: 300 tps: 51.40 qps: 997.46 (r/w/o: 686.07/208.59/102.80) lat (ms,95%): 16819.24 err/s: 0.00 reconn/s: 0.00
[ 50s ] thds: 300 tps: 47.00 qps: 978.98 (r/w/o: 680.65/204.32/94.01) lat (ms,95%): 14302.94 err/s: 0.00 reconn/s: 0.00
[ 60s ] thds: 300 tps: 58.69 qps: 1103.34 (r/w/o: 783.19/202.77/117.38) lat (ms,95%): 10531.32 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 42518
write: 12148
other: 6074
total: 60740
transactions: 3037 (48.99 per sec.)
queries: 60740 (979.77 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
 
General statistics:
total time: 61.9920s
total number of events: 3037
 
Latency (ms):
min: 114.27
avg: 6085.46
max: 26580.90
95th percentile: 12609.11
sum: 18481536.44
 
Threads fairness:
events (avg/stddev): 10.1233/1.86
execution time (avg/stddev): 61.6051/0.23
 
[root@mdb01 opt]#
sysbench /opt/lua/oltp_read_write.lua --db-driver=mysql --mysql-host=192.168.0.130 --mysql-db=tdb01 --mysql-user=root --mysql-password=root123 --table_size=5000000 --tables=10 --threads=300 --time=60 --report-interval=10 cleanup
sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
 
Dropping table 'sbtest1'...
Dropping table 'sbtest2'...
Dropping table 'sbtest3'...
Dropping table 'sbtest4'...
Dropping table 'sbtest5'...
Dropping table 'sbtest6'...
Dropping table 'sbtest7'...
Dropping table 'sbtest8'...
Dropping table 'sbtest9'...
Dropping table 'sbtest10'...
[root@mdb01 opt]#
 
6.注意事項
1).max_prepared_stmt_count參數應該設置的高一點否則會提示超過閾值
2).由于數據庫數據需要裝載到內存變成熱數據,run應該執行多次,第一次的TPS,QPS一般偏低,應該取執行幾次后的值作為參考。

(編輯:武林網)

發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
主站蜘蛛池模板: 鄱阳县| 田林县| 鹤壁市| 兴安县| 梅州市| 鸡西市| 景东| 缙云县| 南华县| 隆子县| 九龙县| 潼关县| 海淀区| 金坛市| 深泽县| 马边| 壤塘县| 阳朔县| 武平县| 安平县| 上思县| 高雄市| 福清市| 花莲县| 浦东新区| 清原| 汉沽区| 瑞昌市| 舟山市| 嘉兴市| 玉林市| 呼伦贝尔市| 读书| 高台县| 安仁县| 拉萨市| 左权县| 山西省| 固安县| 高阳县| 山西省|