Shulou(Shulou.com)06/01 Report--

Source: Internet

Version: unknown, for reference only

Initialize:

Click (here) to collapse or open

Main

| |-mysqld |

| |-my_init / / initial thread variables, mutexes |

| |-load_defaults / / get the configuration |

| |-init_common_variables / / initialize variables |

| |-init_server_components / / initialize plug-in |

| |-plugin_init |

| | |-plugin_initialize |

| |-initialize_storage_engine |

| |-network_init / / listen to the network |

| |-grant_init |

| |-servers_init |

| |-udf_init |

Plug-in launch:

Click (here) to collapse or open

Main

| |-mysqld_main |

| |-init_server_components |

| |-plugin_init |

| |-plugin_initialize |

| |-ha_initialize_handlerton |

| |-innobase_init |

Login process:

Click (here) to collapse or open

Main

| |-mysqld_main |

| |-network_init / / establish socket snooping, one for network and one for Unix domain |

| |-handle_connections_sockets |

| |-poll |

| |-mysql_socket_accept / / establish a connection with the client |

| |-create_new_thread / / create a new thread for each socket connection |

| |-create_thread_to_handle_connection |

| |-waiting_thd_list- > push_back (thd); mysql_cond_signal (& COND_thread_cache); / / Wake up by signal when there is a connection processing thread, and the processing thread function is pfs_spawn_thread |

| |-mysql_thread_create (started thread executes function, inline_mysql_thread_create) |

| |-spawn_thread_v1 |

| |-pthread_create (pfs_spawn_thread) |

Working with connections:

Click (here) to collapse or open

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 / / determines whether login is allowed. If not, an error is returned when disconnecting. |

| | |-check_connection |

| |-acl_authenticate |

| |-do_auth_once |

| |-native_password_authenticate |

| |-server_mpvio_write_packet |

| |-send_server_handshake_packet / / send a handshake packet to the client |

| |-my_net_write |

| |-net_write_buff / / write data to memory |

| |-net_flush / / send in-memory data to the network |

| |-server_mpvio_read_packet / / receives Login Request information from the client |

| |-my_net_read |

| | |-Protocol::end_statement |

| | |-Protocol::send_ok |

| | |-net_send_ok / / send response ok |

| | |-my_net_write |

| |-prepare_new_connection_state |

| |-do_command |

| |-dispatch_command |

| |-mysql_parse |

Select command:

Click (here) to collapse or open

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 / / data structure of the application form |

| | |-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 / / Open tablespace file |

| |-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 |

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.