国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 數據庫 > MySQL > 正文

MySQL連接查詢流程源碼

2024-07-24 12:31:32
字體：大 中 小
來源：轉載
供稿：網友
       初始化:
       點擊(此處)折疊或打開
 
main
    |-mysqld
        |-my_init // 初始話線程變量，互斥量
        |-load_defaults // 獲取配置
        |-init_common_variables // 初始化變量
        |-init_server_components // 初始化插件
        | |-plugin_init
        | | |-plugin_initialize
        | |-initialize_storage_engine
        |-network_init // 監聽網絡
        |-grant_init
        |-servers_init
        |-udf_init
 
插件啟動:
 
點擊(此處)折疊或打開
 
main
    |-mysqld_main
        |-init_server_components
            |-plugin_init
                |-plugin_initialize
                    |-ha_initialize_handlerton
                        |-innobase_init
 
登錄過程:
 
點擊(此處)折疊或打開
 
main
    |-mysqld_main
        |-network_init // 建立socket監聽，一個針對網絡，一個針對unix域
        |-handle_connections_sockets
            |-poll
            |-mysql_socket_accept // 和客戶端建立連接
            |-create_new_thread // 針對每個socket連接建立一個新的線程
                |-create_thread_to_handle_connection
                    |-waiting_thd_list->push_back(thd);mysql_cond_signal(&COND_thread_cache); // 已有連接處理線程時，通過信號喚醒，處理線程函數為pfs_spawn_thread
                    |-mysql_thread_create(啟動的線程執行函數，inline_mysql_thread_create)
                        |-spawn_thread_v1
                            |-pthread_create(pfs_spawn_thread)
 
處理連接:
 
 
點擊(此處)折疊或打開
 
pfs_spawn_thread
    |-handle_one_connection
        |-do_handle_one_connection
            |-MYSQL_CALLBACK_ELSE(thread_scheduler, init_new_connection_thread, (), 0)
            | |-init_new_connection_handler_thread
            |-thd_prepare_connection
            | |-login_connection // 判斷是否可以login，不可以則斷開連接返回錯誤
            | | |-check_connection
            | | | |-acl_authenticate
            | | | |-do_auth_once
            | | | |-native_password_authenticate
            | | | |-server_mpvio_write_packet
            | | | | |-send_server_handshake_packet // 發送handshake包到客戶端
            | | | | |-my_net_write
            | | | | | |-net_write_buff // 將數據寫入到內存
            | | | | |-net_flush // 將內存中數據發送到網絡
            | | | |-server_mpvio_read_packet // 從客戶端接收Login Request信息
            | | | |-my_net_read
            | | |-Protocol::end_statement
            | | |-Protocol::send_ok
            | | |-net_send_ok // 發送response ok
            | | |-my_net_write
            | |-prepare_new_connection_state
            |-do_command
                |-dispatch_command
                    |-mysql_parse
 
select命令:
 
 
點擊(此處)折疊或打開
 
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

（編輯：武林網）

發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
主站蜘蛛池模板： 乐安县| 仪征市| 正镶白旗| 丰城市| 浠水县| 武山县| 汉源县| 格尔木市| 库伦旗| 金坛市| 嘉峪关市| 蒙阴县| 即墨市| 新野县| 余江县| 华安县| 石景山区| 兴城市| 金昌市| 华宁县| 湘乡市| 本溪| 贵溪市| 当涂县| 文登市| 广南县| 和硕县| 明水县| 开阳县| 广河县| 林周县| 湖南省| 景德镇市| 桃源县| 九江市| 雷山县| 开化县| 江安县| 巍山| 鄂尔多斯市| 定远县|