mysql查询解析过程_MySQL连接查询流程源码分析

pfs_swpawn_thread

|-handle_one_connection

|-do_handle_one_connection

|-do_command

|-dispatch_command

|-mysql_parse

|-parse_sql

| |-MYSQLparse

|-mysql_execute_command

|-select_precheck

| |-check_table_access

|-execute_sqlcom_select

| |-open_normal_and_derived_tables

| |-open_tables

| | |-open_and_process_table

| | |-open_table(THD *thd, TABLE_LIST *table_list, Open_table_context *ot_ctx)

| | |-Table_cache::get_table

| | |-get_table_share_with_discover

| | | |-get_table_share

| | | |-open_table_def

| | |-my_malloc // 申请表数据结构

| | |-open_table_from_share

| | |-handler::ha_open

| | |-ha_innobase::open

| | |-dict_table_open_on_name

| | |-dict_load_table

| | |-btr_pcur_is_on_user_rec

| | |-dict_load_table_low

| | | |-dict_mem_table_create

| | |-fil_space_for_table_exists_in_mem

| | |-fil_open_single_table_tablespace // 打开表空间文件

| |-mysql_handle_derived

|-handle_select

|-mysql_select

|-mysql_prepare_select

| |-JOIN::prepare

|-mysql_execute_select

|-JOIN::exec

|-select_send::send_result_set_metadata

| |-Protocol::send_result_set_metadata

|-do_select

|-sub_select

|-evaluate_join_record

|-end_send

|-select_send::send_data

|-Protocol::write