This topic describes how to test the query performance of AnalyticDB for MySQL based on TPC-H queries.
Test environment
The following table describes the information about cluster specifications of AnalyticDB for MySQL used for performance tests.
You must apply for the basic test environment from Alibaba Cloud.
Edition | Specifications | Version |
Enterprise Edition | Single-node specifications of reserved resources: 8 AnalyticDB compute units (ACUs) Number of reserved resource nodes: 12 | 3.2.2.6 |
Test procedure
A performance test consists of the following steps:
For more information about the test procedure, see TPC-H tests.
Test method
Execute the test queries twice to perform pretests.
After pretesting, consecutively execute the test queries three times and calculate the average value of the test results.
Compile the following test script:
while [ $n -lt 23 ]
do
echo "query ${n} starting"
time mysql -f tpch <tpch_${n}.sql
echo "query $n ended!"
n=`expr ${n} + 1`
done