Preface This article mainly refers to chapter 5 of "High performance MySQL" and chapter 3 of the book "MySQLDBA Cultivation", which is the practice and...
"This is the 18th day of my participation in the November Text Challenge. The event details view: The Last Text Challenge 2021" Analyze EXPLAIN results...
Database Connection pooling, which is used to manage connections, which can be reused. With pools, we don't have to create a Connection ourselves, but rather...
This article will share some database migration practices from the following aspects: preparation and consideration before migration, identifying target databases, table and data object migration...
TiDB is mainly applied in Toutiao core OLTP system - object storage system, which stores part of the metadata and supports toutiao image and video-related...
Due to the requirements of the company, on-site customer installation of JavaWeb project was carried out all over the country. In order to facilitate the...
In the last article we introduced the data structure behind the index. In this article we will introduce the factor that influences the selection of...
Many friends have learned database related operations. SQL is the standard computer language for accessing and processing databases. There are also many functions that are...
Distributed database has been popular for many years, and there are many products, among which distributed database middleware is the most widely used. This paper...
In October 2017, UCloud, a leading neutral cloud computing vendor in China, formally entered into cooperation with PingCAP, the TiDB team of the domestic open...
First-time TiDB, is through the same routine chief architect Mr Roy's share, at that time with cheng is making development and database comprehensive open source...
A table in MySQL supports multiple indexes. The optimizer chooses indexes to find an optimal execution plan and to execute statements with the least cost....
On February 24, 2018, TiDB released Beta version 1.1. This version has many improvements to MySQL compatibility and system stability over the 1.1 Alpha release....
In MySQL, a table can support multiple indexes. However, when writing SQL statements, you do not actively specify which index to use; MySQL determines which...