TIDB加压处理

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。

  • 【TiDB 版本】:tidb4.0 RC
  • 【问题描述】: 通过jmeter3.0对表LINEITEM在进行20000个写操作,同时对表进行10000个读操作。CPU的使用已经是WAIT状态了,如下

[2020/05/26 09:52:30.249 -04:00] [WARN] [retry_interceptor.go:61] [“retrying of unary invoker failed”] [target=endpoint://client-6b07415a-7392-454b-9595-92644577fce2/192.168.10.126:2379] [attempt=0] [error=“rpc error: code = DeadlineExceeded desc = context deadline exceeded”]
{“level”:“warn”,“ts”:“2020-05-26T09:52:30.615-0400”,“caller”:“clientv3/retry_interceptor.go:61”,“msg”:“retrying of unary invoker failed”,“target”:“endpoint://client-8f7cba90-d33f-40bb-ad74-4ea0e3c1dd71/192.168.10.126:2379”,“attempt”:0,“error”:“rpc error: code = DeadlineExceeded desc = context deadline exceeded”}
[2020/05/26 09:52:31.449 -04:00] [WARN] [retry_interceptor.go:61] [“retrying of unary invoker failed”] [target=endpoint://client-6b07415a-7392-454b-9595-92644577fce2/192.168.10.126:2379] [attempt=0] [error=“rpc error: code = DeadlineExceeded desc = context deadline exceeded”]
[2020/05/26 09:52:32.649 -04:00] [WARN] [retry_interceptor.go:61] [“retrying of unary invoker failed”] [target=endpoint://client-6b07415a-7392-454b-9595-92644577fce2/192.168.10.126:2379] [attempt=0] [error=“rpc error: code = DeadlineExceeded desc = context deadline exceeded”]
[2020/05/26 09:52:33.850 -04:00] [WARN] [retry_interceptor.go:61] [“retrying of unary invoker failed”] [target=endpoint://client-6b07415a-7392-454b-9595-92644577fce2/192.168.10.126:2379] [attempt=0] [error=“rpc error: code = DeadlineExceeded desc = context deadline exceeded”]
[2020/05/26 09:52:35.050 -04:00] [WARN] [retry_interceptor.go:61] [“retrying of unary invoker failed”] [target=endpoint://client-6b07415a-7392-454b-9595-92644577fce2/192.168.10.126:2379] [attempt=0] [error=“rpc error: code = DeadlineExceeded desc = context deadline exceeded”]
{“level”:“warn”,“ts”:“2020-05-26T09:52:40.083-0400”,“caller”:“clientv3/retry_interceptor.go:61”,“msg”:“retrying of unary invoker failed”,“target”:“endpoint://client-8f7cba90-d33f-40bb-ad74-4ea0e3c1dd71/192.168.10.126:2379”,“attempt”:0,“error”:“rpc error: code = DeadlineExceeded desc = context deadline exceeded”}
{“level”:“warn”,“ts”:“2020-05-26T09:52:40.616-0400”,“caller”:“clientv3/retry_interceptor.go:61”,“msg”:“retrying of unary invoker failed”,“target”:“endpoint://client-8f7cba90-d33f-40bb-ad74-4ea0e3c1dd71/192.168.10.126:2379”,“attempt”:0,“error”:“rpc error: code = DeadlineExceeded desc = context deadline exceeded”}
{“level”:“warn”,“ts”:“2020-05-26T09:52:41.718-0400”,“caller”:“clientv3/retry_interceptor.go:61”,“msg”:“retrying of unary invoker failed”,“target”:“endpoint://client-8f7cba90-d33f-40bb-ad74-4ea0e3c1dd71/192.168.10.126:2379”,“attempt”:0,“error”:“rpc error: code = DeadlineExceeded desc = context deadline exceeded”}

1 个赞
  1. 您好,看起来是系统已经到瓶颈了,请问,您需要查看什么问题?
  2. 如果是希望进一步优化,麻烦发送 over-view,tidb,detail-tikv 监控,多谢。可以使用以下方法

(1)、chrome 安装这个插件https://chrome.google.com/webstore/detail/full-page-screen-capture/fdpohaocaechififmbbbbbknoalclacl

(2)、鼠标焦点置于 Dashboard 上,按 ?可显示所有快捷键,先按 d 再按 E 可将所有 Rows 的 Panels 打开,需等待一段时间待页面加载完成。

(3)、使用这个 full-page-screen-capture 插件进行截屏保存