Generalization Verification

Verify the generalization of the GCC CFGO feature in MySQL databases to ensure that GCC CFGO is suited for online transaction processing (OLTP) services and the database performance will not deteriorate in online analytical processing (OLAP) scenarios.

Major database services can be classified into OLTP and OLAP services. OLTP services are mainly used for processing basic and routine transactions such as bank transactions. OLAP services are mainly used for analyzing aggregated data.

MySQL is a typical OLTP database. The sysbench and TPC-C tests, as designed in the run script of automatic FDO, simulate OLTP services to test the MySQL performance. For OLAP services, TPC-H can be used to test whether MySQL performance deteriorates after the GCC CFGO feature is applied. Specifically, use TPC-H to test OLAP capabilities of MySQL databases that have and have not applied GCC CFGO. It is expected that the database performance after GCC CFGO is applied does not deteriorate.

1. Install the MySQL database that has not applied GCC CFGO. For details, see MySQL Installation Guide.
2. Use TPC-H to test the performance of the MySQL databases without and with the GCC CFGO feature applied, and record the performance metrics in detail. For details, see TPC-H Test Guide.

   Compare the performance metrics, for example, the query response time, of the two MySQL instances in the TPC-H tests, and evaluate whether GCC CFGO has negative impact on MySQL performance in OLAP scenarios.

   According to the analysis result, the GCC CFGO feature does not deteriorate the TPC-H comprehensive performance of MySQL in OLAP service scenarios.