This topic describes how AnalyticDB for MySQL processes queries. You can use slow query tables and query statistics to troubleshoot query performance issues. For more information, see Slow query table and Query details page.
AnalyticDB for MySQL uses SQL statements to help you connect to data stored in the system. After an SQL statement is submitted to a frontend controller node, AnalyticDB for MySQL parses the SQL statement to generate a syntax tree, generates a logical execution plan, optimizes the plan, and then generates a final logical execution plan. An executor node further converts the logical execution plan into a physical execution plan. The physical execution plan consists of physical operators that are used to process data based on specific rules. The final results of data processing are returned to your client and written to AnalyticDB for MySQL tables or external storage systems.