lilinghai

TICASE-1959，TICASE-1961 suite.jsonnet 中的 case 没有找到
TICASE-2576，TICASE-547，TICASE-546，TICASE-1268，TICASE-562，TICASE-595
，TICASE-563 TICASE-607，TICASE-568 ，TICASE-567，TICASE-622 ，TICASE-519，
TICASE-520，TICASE-521 ，TICASE-581，TICASE-586，TICASE-585 ,TICASE-588, 
TICASE-1273 ,TICASE-1274,TICASE-606 ,TICASE-583,TICASE-1269,TICASE-1270,
TICASE-1271,TICASE-564,TICASE-560,TICASE-565,TICASE-1272 ,TICASE-584,
TICASE-566,TICASE-580 ,TICASE-559,TICASE-545,TICASE-589,TICASE-587 ,
TICASE-1314,TICASE-1311 ,TICASE-1310,TICASE-1367 client has multi-statement capability disabled
TICASE-1962，TICASE-1963 tidb_enable_table_partition 系统变量值大小写
TICASE-629,TICASE-628,TICASE-627，TICASE-626，TICASE-625，TICASE-624， 系统变量大小写

lilinghai

import codecs
import os
import re
import json
import time
from datetime import datetime
from influxdb import InfluxDBClient
from error_log import _LOG_PATH_PAT

ci_base_link = "https://internal.pingcap.net/idc-jenkins/blue/organizations/jenkins/{job}/detail/{job}/{" \

lilinghai

1.start thriftserver
./sbin/start-thriftserver.sh

2.go hive program

package main

import (
	"context"
	"github.com/beltran/gohive"

lilinghai

# -*- coding:utf-8 -*-
# lib
# google.golang.org/grpc
# github.com/pingcap/kvproto
# github.com/pingcap/tipb
# github.com/pingcap/parser


# repo
# tidb pd tikv tidb-binlog tidb-lightning ticdc br dm

lilinghai

分别在 release-4.0（未 cherry-pick）和 release-3.0 （cherry-pick）测试
测试命令：
为了防止 pessimistic lock retry limit reached 错误 ，设置 [pessimistic-txn] max-retry-count =10000
sysbench waiter_manager.lua --table-size=10000 prepare & run

结果对比：
release-4.0:
Threads   TPS   latency 95th
100       59.92     5607.61
500       20.32     32745.49

lilinghai

drop table if exists city;
 CREATE TABLE `city` (
 `id` varchar(70) NOT NULL,
 `province_id` int(15) DEFAULT NULL,
 `city_name` varchar(90) DEFAULT NULL,
 `description` varchar(90) DEFAULT NULL,
 PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
 load stats "s/explain_union_scan.json";
 insert into city values("06766b3ef41d484d8878606393f1ed0b", 88, "chongqing", "chongqing city");

lilinghai

1.在tidb/planner/core/planbuilder.go 文件
  func (b *PlanBuilder) Build(ctx context.Context, node ast.Node) (Plan, error) 函数中加入日志
    case *ast.SelectStmt:
      p,err:= b.buildSelect(ctx, x)
      var sb2 strings.Builder
      node.Restore(format.NewRestoreCtx(format.DefaultRestoreFlags, &sb2))
      logutil.Logger(context.Background()).Info("restore", zap.String("stmt",sb2.String()))
      return p,err
    
2.编译运行tidb，连接数据库，执行