Tuning the Database Kernel

Purpose

Modify the source code of the MySQL database to improve the database performance. To use the database kernel optimization patch, you need to recompile the database.

Procedure

MySQL database kernel tuning involves two scenarios: online transaction processing (OLTP) and online analytical processing (OLAP). Different optimization patches are used in different scenarios.

• OLTP is a transaction-oriented processing system. It mainly processes small transactions and queries and responds quickly to user operations. For details about the OLTP kernel optimization patch, see MySQL Fine-Grained Lock Tuning.
• OLAP analyzes and queries current and historical data and generates reports to support management and decision-making. For details about the OLAP kernel tuning patch, see MySQL Parallel Query Tuning.