fsync操作

大家好，又见面了，我是你们的朋友全栈君。

/*update 需要刷磁盘的操作*/
#0  os_file_fsync_posix (file=20) at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/os/os0file.cc:3081
#1  0x000000000198c562 in os_file_flush_func (file=20) at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/os/os0file.cc:3191
#2  0x0000000001bd576f in pfs_os_file_flush_func (file=..., src_file=0x228a190 "/data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/fil/fil0fil.cc", src_line=6043) at /data/mysql-boost-5.7.32
/mysql-5.7.32/storage/innobase/include/os0file.ic:513
#3  0x0000000001be638d in fil_flush (space_id=23) at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/fil/fil0fil.cc:6043
#4  0x0000000001be4285 in fil_space_extend (space=0x64f3188, size=1990400) at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/fil/fil0fil.cc:5186
#5  0x0000000001bf0d15 in fsp_try_extend_data_file (space=0x64f3188, header=0x7fff954cc026 "", mtr=0x7fffec18f190) at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/fsp/fsp0fsp.cc:1532
#6  0x0000000001bf6b2b in fsp_reserve_free_extents (n_reserved=0x7fffec18ecb8, space_id=23, n_ext=3, alloc_type=FSP_NORMAL, mtr=0x7fffec18f190, n_pages=2) at /data/mysql-boost-5.7.32/mysql-5.7.3
2/storage/innobase/fsp/fsp0fsp.cc:3448
#7  0x0000000001b2bc08 in btr_cur_pessimistic_update (flags=10, cursor=0x7fff2c00f778, offsets=0x7fffec18edc0, offsets_heap=0x7fffec18f188, entry_heap=0x7fff2c028628, big_rec=0x7fffec18ede0, upd
ate=0x7fff2c026ec0, cmpl_info=1, thr=0x7fff2c027380, trx_id=50948, mtr=0x7fffec18f190) at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/btr/btr0cur.cc:4429
#8  0x0000000001a7f616 in row_upd_clust_rec (flags=0, node=0x7fff2c026da8, index=0x7fff2c010af0, offsets=0x7fff2c028b60, offsets_heap=0x7fffec18f188, thr=0x7fff2c027380, mtr=0x7fffec18f190) at /
data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/row/row0upd.cc:2703
#9  0x0000000001a7ff3a in row_upd_clust_step (node=0x7fff2c026da8, thr=0x7fff2c027380) at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/row/row0upd.cc:2957
#10 0x0000000001a8038b in row_upd (node=0x7fff2c026da8, thr=0x7fff2c027380) at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/row/row0upd.cc:3054
#11 0x0000000001a8086d in row_upd_step (thr=0x7fff2c027380) at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/row/row0upd.cc:3200
#12 0x0000000001a21210 in row_update_for_mysql_using_upd_graph (mysql_rec=0x7fff2c01ff50 "", prebuilt=0x7fff2c026280) at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/row/row0mysql.cc:2
588
#13 0x0000000001a21547 in row_update_for_mysql (mysql_rec=0x7fff2c01ff50 "", prebuilt=0x7fff2c026280) at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/row/row0mysql.cc:2678
#14 0x00000000018d0441 in ha_innobase::update_row (this=0x7fff2c01f870, old_row=0x7fff2c01ff50 "", new_row=0x7fff2c01fc80 "") at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/handler/ha
_innodb.cc:8272
#15 0x0000000000f5a464 in handler::ha_update_row (this=0x7fff2c01f870, old_data=0x7fff2c01ff50 "", new_data=0x7fff2c01fc80 "") at /data/mysql-boost-5.7.32/mysql-5.7.32/sql/handler.cc:8148
#16 0x00000000015ff90f in mysql_update (thd=0x7fff2c000e10, fields=..., values=..., limit=18446744073709551615, handle_duplicates=DUP_ERROR, found_return=0x7fffec190448, updated_return=0x7fffec1
90440) at /data/mysql-boost-5.7.32/mysql-5.7.32/sql/sql_update.cc:894
#17 0x0000000001605a4e in Sql_cmd_update::try_single_table_update (this=0x7fff2c006b68, thd=0x7fff2c000e10, switch_to_multitable=0x7fffec1904ef) at /data/mysql-boost-5.7.32/mysql-5.7.32/sql/sql_
update.cc:2927
#18 0x0000000001605fb5 in Sql_cmd_update::execute (this=0x7fff2c006b68, thd=0x7fff2c000e10) at /data/mysql-boost-5.7.32/mysql-5.7.32/sql/sql_update.cc:3058
#19 0x000000000154cce5 in mysql_execute_command (thd=0x7fff2c000e10, first_level=true) at /data/mysql-boost-5.7.32/mysql-5.7.32/sql/sql_parse.cc:3616
#20 0x0000000001552696 in mysql_parse (thd=0x7fff2c000e10, parser_state=0x7fffec191650) at /data/mysql-boost-5.7.32/mysql-5.7.32/sql/sql_parse.cc:5584
#21 0x0000000001547ccf in dispatch_command (thd=0x7fff2c000e10, com_data=0x7fffec191df0, command=COM_QUERY) at /data/mysql-boost-5.7.32/mysql-5.7.32/sql/sql_parse.cc:1491
#22 0x0000000001546b25 in do_command (thd=0x7fff2c000e10) at /data/mysql-boost-5.7.32/mysql-5.7.32/sql/sql_parse.cc:1032
#23 0x00000000016766fb in handle_connection (arg=0x6ad9050) at /data/mysql-boost-5.7.32/mysql-5.7.32/sql/conn_handler/connection_handler_per_thread.cc:313
#24 0x0000000001cfb194 in pfs_spawn_thread (arg=0x6928d50) at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/perfschema/pfs.cc:2197
#25 0x00007ffff7bbc2de in start_thread () from /lib64/libpthread.so.0
#26 0x00007ffff6211e83 in clone () from /lib64/libc.so.6
/*后台线程调用fsync*/、
#0  os_file_fsync_posix (file=7) at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/os/os0file.cc:3081
#1  0x000000000198c562 in os_file_flush_func (file=7) at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/os/os0file.cc:3191
#2  0x0000000001bd576f in pfs_os_file_flush_func (file=..., src_file=0x228a190 "/data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/fil/fil0fil.cc", src_line=6043) at /data/mysql-boost-5.7.32
/mysql-5.7.32/storage/innobase/include/os0file.ic:513
#3  0x0000000001be638d in fil_flush (space_id=4294967280) at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/fil/fil0fil.cc:6043
#4  0x000000000196a561 in log_write_flush_to_disk_low () at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/log/log0log.cc:1164
#5  0x000000000196b056 in log_write_up_to (lsn=26241090390, flush_to_disk=true) at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/log/log0log.cc:1414
#6  0x000000000196b192 in log_buffer_sync_in_background (flush=true) at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/log/log0log.cc:1455
#7  0x0000000001a90467 in srv_sync_log_buffer_in_background () at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/srv/srv0srv.cc:1972
#8  0x0000000001a90e81 in srv_master_do_idle_tasks () at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/srv/srv0srv.cc:2254
#9  0x0000000001a9130e in srv_master_thread (arg=0x0) at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/srv/srv0srv.cc:2400
#10 0x00007ffff7bbc2de in start_thread () from /lib64/libpthread.so.0
#11 0x00007ffff6211e83 in clone () from /lib64/libc.so.6
/*dobule write*/
#0  os_file_fsync_posix (file=15) at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/os/os0file.cc:3081
#1  0x000000000198c562 in os_file_flush_func (file=15) at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/os/os0file.cc:3191
#2  0x0000000001bd576f in pfs_os_file_flush_func (file=..., src_file=0x228a190 "/data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/fil/fil0fil.cc", src_line=6043) at /data/mysql-boost-5.7.32
/mysql-5.7.32/storage/innobase/include/os0file.ic:513
#3  0x0000000001be638d in fil_flush (space_id=0) at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/fil/fil0fil.cc:6043
#4  0x0000000001b69ee0 in buf_dblwr_flush_buffered_writes () at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/buf/buf0dblwr.cc:1061
#5  0x0000000001b73a4f in buf_flush_end (buf_pool=0x31ea908, flush_type=BUF_FLUSH_LIST) at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/buf/buf0flu.cc:1959
#6  0x0000000001b73bfe in buf_flush_do_batch (buf_pool=0x31ea908, type=BUF_FLUSH_LIST, min_n=125, lsn_limit=18446744073709551615, n_processed=0x7fff817f9928) at /data/mysql-boost-5.7.32/mysql-5.
7.32/storage/innobase/buf/buf0flu.cc:2028
#7  0x0000000001b73e96 in buf_flush_lists (min_n=125, lsn_limit=18446744073709551615, n_processed=0x7fff817f99d8) at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/buf/buf0flu.cc:2132
#8  0x0000000001b7796c in buf_flush_page_cleaner_coordinator (arg=0x0) at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/buf/buf0flu.cc:3355
#9  0x00007ffff7bbc2de in start_thread () from /lib64/libpthread.so.0
#10 0x00007ffff6211e83 in clone () from /lib64/libc.so.6
/*事务提交时 sync磁盘*/
#0  os_file_fsync_posix (file=7) at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/os/os0file.cc:3081
#1  0x000000000198c562 in os_file_flush_func (file=7) at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/os/os0file.cc:3191
#2  0x0000000001bd576f in pfs_os_file_flush_func (file=..., src_file=0x228a190 "/data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/fil/fil0fil.cc", src_line=6043) at /data/mysql-boost-5.7.32
/mysql-5.7.32/storage/innobase/include/os0file.ic:513
#3  0x0000000001be638d in fil_flush (space_id=4294967280) at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/fil/fil0fil.cc:6043
#4  0x000000000196a561 in log_write_flush_to_disk_low () at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/log/log0log.cc:1164
#5  0x000000000196b056 in log_write_up_to (lsn=26241090987, flush_to_disk=true) at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/log/log0log.cc:1414
#6  0x000000000196b0b9 in log_buffer_flush_to_disk (sync=true) at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/log/log0log.cc:1426
#7  0x00000000018c806e in innobase_flush_logs (hton=0x2d973d0, binlog_group_flush=true) at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/handler/ha_innodb.cc:4259
#8  0x0000000000f4cd9f in flush_handlerton (thd=0x0, plugin=0x7fffec18f158, arg=0x7fffec18f1e4) at /data/mysql-boost-5.7.32/mysql-5.7.32/sql/handler.cc:2489
#9  0x000000000157ac67 in plugin_foreach_with_mask (thd=0x0, funcs=0x7fffec18f1c0, type=1, state_mask=4294967287, arg=0x7fffec18f1e4) at /data/mysql-boost-5.7.32/mysql-5.7.32/sql/sql_plugin.cc:2
524
#10 0x000000000157ad0f in plugin_foreach_with_mask (thd=0x0, func=0xf4cd41 <flush_handlerton(THD*, plugin_ref, void*)>, type=1, state_mask=8, arg=0x7fffec18f1e4) at /data/mysql-boost-5.7.32/mysq
l-5.7.32/sql/sql_plugin.cc:2539
#11 0x0000000000f4cdfb in ha_flush_logs (db_type=0x0, binlog_group_flush=true) at /data/mysql-boost-5.7.32/mysql-5.7.32/sql/handler.cc:2499
#12 0x00000000017ee31f in MYSQL_BIN_LOG::process_flush_stage_queue (this=0x2ce8120 <mysql_bin_log>, total_bytes_var=0x7fffec18f2e8, rotate_var=0x7fffec18f2e7, out_queue_var=0x7fffec18f2d8) at /d
ata/mysql-boost-5.7.32/mysql-5.7.32/sql/binlog.cc:8970
#13 0x00000000017ef94f in MYSQL_BIN_LOG::ordered_commit (this=0x2ce8120 <mysql_bin_log>, thd=0x7fff2c000e10, all=false, skip_commit=false) at /data/mysql-boost-5.7.32/mysql-5.7.32/sql/binlog.cc:
9618
#14 0x00000000017edfd7 in MYSQL_BIN_LOG::commit (this=0x2ce8120 <mysql_bin_log>, thd=0x7fff2c000e10, all=false) at /data/mysql-boost-5.7.32/mysql-5.7.32/sql/binlog.cc:8870
#15 0x0000000000f4b71a in ha_commit_trans (thd=0x7fff2c000e10, all=false, ignore_global_read_lock=false) at /data/mysql-boost-5.7.32/mysql-5.7.32/sql/handler.cc:1807
#16 0x000000000164582b in trans_commit_stmt (thd=0x7fff2c000e10) at /data/mysql-boost-5.7.32/mysql-5.7.32/sql/transaction.cc:465
#17 0x0000000001550f7d in mysql_execute_command (thd=0x7fff2c000e10, first_level=true) at /data/mysql-boost-5.7.32/mysql-5.7.32/sql/sql_parse.cc:4995
#18 0x0000000001552696 in mysql_parse (thd=0x7fff2c000e10, parser_state=0x7fffec191650) at /data/mysql-boost-5.7.32/mysql-5.7.32/sql/sql_parse.cc:5584
#19 0x0000000001547ccf in dispatch_command (thd=0x7fff2c000e10, com_data=0x7fffec191df0, command=COM_QUERY) at /data/mysql-boost-5.7.32/mysql-5.7.32/sql/sql_parse.cc:1491
#20 0x0000000001546b25 in do_command (thd=0x7fff2c000e10) at /data/mysql-boost-5.7.32/mysql-5.7.32/sql/sql_parse.cc:1032
#21 0x00000000016766fb in handle_connection (arg=0x6ad9050) at /data/mysql-boost-5.7.32/mysql-5.7.32/sql/conn_handler/connection_handler_per_thread.cc:313
#22 0x0000000001cfb194 in pfs_spawn_thread (arg=0x6928d50) at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/perfschema/pfs.cc:2197
#23 0x00007ffff7bbc2de in start_thread () from /lib64/libpthread.so.0
#24 0x00007ffff6211e83 in clone () from /lib64/libc.so.6
/*文件打开*/
#0  fil_node_open_file (node=0x64b2578) at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/fil/fil0fil.cc:716
#1  0x0000000001bdad1b in fil_open_log_and_system_tablespace_files () at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/fil/fil0fil.cc:1780
#2  0x0000000001a9a3d3 in innobase_start_or_create_for_mysql () at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/srv/srv0start.cc:2122
#3  0x00000000018c7b3e in innobase_init (p=0x2d973d0) at /data/mysql-boost-5.7.32/mysql-5.7.32/storage/innobase/handler/ha_innodb.cc:4091
#4  0x0000000000f4a0b9 in ha_initialize_handlerton (plugin=0x2ef5d40) at /data/mysql-boost-5.7.32/mysql-5.7.32/sql/handler.cc:848
#5  0x00000000015777fd in plugin_initialize (plugin=0x2ef5d40) at /data/mysql-boost-5.7.32/mysql-5.7.32/sql/sql_plugin.cc:1233
#6  0x000000000157844d in plugin_register_builtin_and_init_core_se (argc=0x2cb5550 <remaining_argc>, argv=0x2d94328) at /data/mysql-boost-5.7.32/mysql-5.7.32/sql/sql_plugin.cc:1596
#7  0x0000000000ebf3dd in init_server_components () at /data/mysql-boost-5.7.32/mysql-5.7.32/sql/mysqld.cc:4065
#8  0x0000000000ec0995 in mysqld_main (argc=99, argv=0x2d94328) at /data/mysql-boost-5.7.32/mysql-5.7.32/sql/mysqld.cc:4759
#9  0x0000000000eb8546 in main (argc=3, argv=0x7fffffffe388) at /data/mysql-boost-5.7.32/mysql-5.7.32/sql/main.cc:32