Fil_init mainly refers to the initialization file opening pointer hash table. All opened files are recorded in fil_system, And the buf_pool_init memory buffer pool Initialization is constructed for the hash table searched by name, corresponding to the buf_pool_ptr array, the memory log_init of adaptive hash index is also initialized to initialize the log buffer. The default size is 512*16 k, the size of each log page is # define OS _FILE_LOG_BLOCK_SIZE 512. During the creation of the log file, the system lock is initialized without the system cache www.2cto.com lock_sys_create. A HASH table is created, lock_sys recv_recovery_from_checkpoint_start starts to execute "Recover dict_boot" to initialize the table structure cache. dict_sys creates two hash tables, which can be searched based on the table name and table ID. When the system table is initialized, four SYS_TABLES SYS_COLUMNS; initialize the insert buffer. Each tablespace corresponds to one. Read the content in the above four system tables into the trx_sys_init_at_db_start preliminary transaction structure trx_sys; creates the global purge system control structure and inits the history dict_create_or_check_foreign_constraint_tables create the other two system tables SYS_FOREIGN SYS_FOREIGN_COLS www.2cto.com startup threads. There are 10 IO threads in total, you can configure 1 insert buffer thread 1 log thread 4 aio read thread 4 aio write thread 1 lock timeout thread A thread which wakes up threads whose lock wait may have lasted through Parameters too long 1 error monitor thread A thread which prints warnings about semaphore waits which have lasted too long 1 monitor thread A thread which prints the info output by various InnoDB monitors 1 master thread master thread controlling the server 1 thread handle shutdown 1 handle connections socket specifically used to handle the connection 1 Rollback the uncommitted transactions which have no user session www.2cto.com struct st_mysql_plugin * handle [] = {builtin_innobase_plugin, struct, plugin, 0}; struct st_mysql_plugin * plugin [] = {builtin_binlog_plugin, plugin, delimiter, 0}; initialized binlog memory myisam innodb pefformance_schema partition author spche