As more and more students choose to use TiDB, the ease of use of TiDB has received more and more users’ attention, so it becomes more and more important to make TiDB better. In order to create a truly easy-to-use TiDB, we launched the “My TiDB Listens to Me” campaign and solicited the opinions of the TiDB User Group(TUG) expert Group to select the 20 most important and urgent usability requirements.

In early March, we launched the TiDB Ease-of-use Challenge in the community around the top 20 requirements. After the competition started, everyone was full of flowers and contention. At present the race has already half, we first to see the record!

First, let’s take a look at the teams involved this season:

As of today, we have received a total of 93 teams (including individual team members and multi-team members), totaling 136 competitors. There are five teams on the leaderboard with more than 2000 points:

At present, individual participants have made outstanding achievements, among which:

  • No.1 winner: GausS1314 (individual contestant), ease of use optimization for TiDB.

  • Second place: SSebo (individual entrant), usability optimized for TiKV.

I hope these two students can make persistent efforts to break through language and project boundaries and benefit multiple REPOS at the same time. I also hope that other teams can surpass these two students as soon as possible, so that we can compete for the first prize

Finally, let’s take a look at this season’s overall mission completion:

As shown above, blue represents the number of tasks claimed and red represents the number of tasks completed, meaning that as of press time, 215 tasks have been claimed and 93 of them have been completed.

The completion of so many tasks surprised the author, considering that the competition group only gave 20 project options at the beginning of the activity! Let’s take a look at the top scorers so far:

UCP: Support the operation of adding multi-columns

  • Score: 2996

  • Team: GausS1314 (individual participant)

  • Warehouse: TiDB

  • The project is one of 20 urgent needs

UCP: Extract tidb_query into different workspaces

  • Score: 2530

  • Team: SSebo (Individual participant)

  • Warehouse: TiKV

UCP: Support auto flush metrics

  • Score: 2530

  • Team: BABAIsWatchingYou

  • Warehouse: TiKV

UCP: Add WAL write duration metric

  • Score: 1300

  • Team: hawking&chacha

  • Warehouse: TiKV

UCP: Output slow logs to a dedicated file

  • Score: 950

  • Team:. *

  • Warehouse: TiKV

UCP: Support slow log in log searching

  • Score: 605

  • Team:. *

  • Warehouse: TiKV

UCP: Privilege check in statement summary tables

  • Score: 300

  • Team: blueshit

  • Warehouse: TiDB

Limit the usage of storage in TiDB by total queries

  • Score: 300

  • Team: Yisaer (individual participant)

  • Warehouse: TiDB

If you are careful, you may have noticed that only one of the above tasks is among the 20 options given at the start of the competition, which means that all the other tasks are “self-produced” by us players. I was both amazed and deeply impressed by the players’ imagination and execution. With the tournament only half over, I wonder how many surprises there are to come.

Finally, no matter whether you are listed or not, don’t be proud and don’t lose heart. Keep calm. The second half has just begun, and there are still a lot of high-scoring projects waiting for you to challenge.

TiDB Ease-of-use Challenge tasks are divided into three levels: Easy, Medium, and Hard, and each task has a certain number of points. This time we have optimized the grading system for this season: if you are new to the challenge for the first time, the Easy task can be played directly; Veteran players (with 200 points or more in the Repo history) can go straight to Medium and above!

After the competition, players can exchange points for rich prizes. Besides TiDB limited peripheral items (T-shirts, hoodies, backpacks, office five-piece sets, black and white game charger, bookmark calendar sets), There’s a one-year license for any of the jetBrain Toolbox software, an honorary seat at PingCAP’s annual conference, and even a charter wine trip to Silicon Valley! In addition, players who complete any one of the missions will also receive a “finishing badge”.

Registration:

Initiate an Issue to Pingcap /tidb-challenge-program/ Register repo (go to pingcap/tidb-challenge-program/ Register repo through [read the original text] and click “Register now” to initiate an Issue quickly).

Welcome to Join TiDB Community Slack Workspace. Please feel free to contact us via # tidb-challenge-Program channel if you have any questions during the competition.

Extended reading:

Hi, you have a copy of TiDB usability Challenge “Score Guide” please check

TiDB ease-of-use Challenge open: Solve users’ pain points, make TiDB easier to use!