MySQL Test Run (MTR) Framework Architecture and Execution Flow

This article provides a comprehensive overview of the MySQL Test Run (MTR) framework, which is divided into two main components: a Perl script (mysql-test-run.pl) and a C++ binary (mysqltest). The Perl script handles control flow including starting/stopping processes, identifying test cases, creating directories, and collecting results, while mysqltest executes the test cases by reading files, parsing specific syntax, and running the tests.

The framework's execution flow is illustrated through a timing diagram. The Perl script's control framework operates in several stages: initialization (determining test case execution scope, organizing test cases in memory, initializing databases), running tests (starting worker threads based on parallel parameters, managing client-server communication between main thread and workers), and handling execution results.

The C++ execution framework, concentrated in mysqltest.cc, reads test case files (*.test) and executes predefined commands such as --source, --replace_column, and shutdown_server. The framework processes SQL statements and control statements that manage special behaviors of the MySQL client.

The article includes detailed diagrams showing the framework's architecture and execution flow, providing insights into how MySQL testing is structured and executed within the MTR framework.