Optimize the query performance on wide table

[zz-jason]

Description

There is a wide table which can be summarized as:

• There is an empty table, no data inside it.
• It has 200 columns, each column is defined as VARCHAR(120).
• It has an int primary key.

The workload is quite simple, which can be summarized as:
select c0, c1, .. from tbl where ${pk} = ${value}

We’ve wrote a sysbench script for this case, see the Wide Table benchmark for more details. After deploying a TiDB cluster, you can simply run the following commands to do all the tests:

# prepare table
./wide_point_select.lua --table-size=1000 --db-driver=mysql --mysql-socket=/tmp/mysql.sock --mysql-user=root --columns=200 prepare 

# run benchmark
./wide_point_select.lua --table-size=1000 --db-driver=mysql --mysql-socket=/tmp/mysql.sock --mysql-user=root --columns=200 run 

Your goal is to improve 50% of the total QPS.

Difficulty

• Medium

Score

• 3000

Mentor(s)

• @zz-jason
• @jackysp

Recommended Skills

• Sysbench
• tidb-ansible
• TiDB Query Execution
• Golang Profiling
• Golang Internals, GC, Scheduling

[Patrick0308]

/pick-up

[ti-challenge-bot]

It is not a pickable issue!

Details

Tip : If you want this issue to be picked, you need to add a challenge-program label to it.

Warning: None

[hidehalo]

@zz-jason Hi, could I pick up this issue?