How to Test CockroachDB Performance Using Sysbench

CockroachDB uses the PostgreSQL protocol. If you want to use Sysbench for testing, you need to enable pg protocol support in Sysbench. Sysbench already supports the pg protocol,…

June 11, 2018 · 3 min · 600 words · Jack Yu

How to View CMU DB Group's OLTP-Bench

OLTP-Bench is an open-source benchmarking tool platform for OLTP scenarios from CMU’s DB Group. It was designed to provide a simple, easy-to-use, and extensible testing platform.

February 23, 2018 · 4 min · 845 words · Jack Yu

How to Use Monospaced Fonts in VS Code

The English font set in Microsoft’s VS Code is monospaced, while the Chinese font is not.

December 26, 2017 · 1 min · 61 words · Jack Yu

How to Understand F1's Schema Change

The DDL paper on F1 serves as the foundation for TiDB’s DDL implementation. There are two main papers on F1: one provides an overview of F1’s DDL, and the other specifically…

December 25, 2017 · 5 min · 920 words · Jack Yu

Understanding the CAP Theorem

The CAP theorem has become one of the hottest theorems in recent years; when discussing distributed systems, CAP is inevitably mentioned. However, I feel that I haven’t thoroughly…

December 20, 2017 · 3 min · 511 words · Jack Yu

How to Execute Git Push in Travis CI

Travis CI is generally used for automating tests without needing to update the repository with the test outputs. This article explains how to automatically commit the results from…

October 16, 2017 · 4 min · 659 words · Jack Yu

How to Implement MySQL X Protocol on TiDB

Start a new server for TiDB. The relevant configuration parameters such as IP, port, and socket need to be set. 2. Implement the reading and writing functionality for message…

August 16, 2017 · 4 min · 798 words · Jack Yu

How to Configure CentOS 6 NFS Service

Disable SeLinux Edit the configuration file:

June 5, 2014 · 2 min · 297 words · Jack Yu

How to Configure CentOS KVM Network Bridging Mode

Bridging highly simulates a network card, making the router believe that the virtual machine’s network card truly exists. Personally, I feel it’s similar to resistors connected in…

June 5, 2014 · 3 min · 575 words · Jack Yu

How to Install CentOS as a Virtualization Host

Installed Version: CentOS 6.3

June 5, 2014 · 1 min · 162 words · Jack Yu