设为首页 加入收藏

TOP

TIDB 数据库集群部署(三)
2018-12-27 14:14:32 】 浏览:548
Tags:TIDB 数据库 集群 部署
cd leader, skip campaign leader and check later
2018/11/23 14:21:10.071 coordinator.go:570: [info] [region 1093] send schedule command: transfer leader from store 7 to store 2
FATAL: mysql_drv_query() returned error 1105 (Information schema is out of date)
------------------------------------end-----------------------------------------------
# 调整线程数为10,表数量为10,表数据为2000000 做测试
sysbench /usr/share/sysbench/oltp_common.lua --mysql-host=172.16.5.50 --mysql-port=4000 --mysql-user=root --tables=1 --table_size=2000000 --threads=10 --max-requests=0 prepare
--------------------------------------start--------------------------------------------
FATAL: mysql_drv_query() returned error 1105 (Information schema is out of date) 超时报错
成功写入2张表,其余8张表数据并未写满,写好索引
# 对tidb集群进行读写测试
sysbench /usr/share/sysbench/oltp_read_write.lua --mysql-host=172.16.5.50 --mysql-port=4000 --mysql-user=root --tables=1 --table_size=2000000 --threads=10 --max-requests=0 run
----------------------------------------start--------------------------------------
Number of threads: 10
Initializing random number generator from current time
Initializing worker threads...
Threads started!
SQL statistics:
queries performed:
read: 868
write: 62
other: 310
total: 1240
transactions: 62 (5.60 per sec.)
queries: 1240 (112.10 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 11.0594s
total number of events: 62
Latency (ms):
min: 944.55
avg: 1757.78
max: 2535.05
95th percentile: 2320.55
sum: 108982.56
Threads fairness:
events (avg/stddev): 6.2000/0.40
execution time (avg/stddev): 10.8983/0.31
------------------------------------end----------------------------------------
# 使用mysql对比测试
mysql -uroot -P 3306 -h 172.15.5.154
create database sbtest
sysbench /usr/share/sysbench/oltp_common.lua --mysql-host=172.16.5.154 --mysql-port=3306 --mysql-user=root --mysql-password=root --tables=20 --table_size=20000000 --threads=10 --max-requests=0 prepare
使用mysql 做测试未发现报错情况


4.3、业务数据测试


sysbench /usr/share/sysbench/oltp_read_write.lua --mysql-host=172.16.5.50 --mysql-port=4000 --mysql-user=root --tables=20 --table_size=2000000 --threads=10 --max-requests=0 run


首页 上一页 1 2 3 4 5 6 下一页 尾页 3/6/6
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
上一篇MySQL NULL值特性 下一篇SQL Server 2008无备份误删数据的..

最新文章

热门文章

Hot 文章

Python

C 语言

C++基础

大数据基础

linux编程基础

C/C++面试题目