binlog 切换时，调用流程

最新推荐文章于 2024-07-24 22:53:04 发布
原创最新推荐文章于 2024-07-24 22:53:04 发布 · 217 阅读
0 ·
CC 4.0 BY-SA版权
文章标签：
#binlog #rotate
mysql 源码笔记专栏收录该内容
38 篇文章
订阅专栏
/* 关闭文件前写入数据，写入binlog的数据*/
(gdb) where
#0  Rotate_log_event::write (this=0x7fff92fa7d50, file=0x2d114e8 <mysql_bin_log+840>) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/log_event.cc:6625
#1  0x00000000017eb6ce in MYSQL_BIN_LOG::new_file_impl (this=0x2d111a0 <mysql_bin_log>, need_lock_log=false, extra_description_event=0x0) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/binlog.cc:7
046
#2  0x00000000017eb257 in MYSQL_BIN_LOG::new_file_without_locking (this=0x2d111a0 <mysql_bin_log>, extra_description_event=0x0) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/binlog.cc:6941
#3  0x00000000017eceec in MYSQL_BIN_LOG::rotate (this=0x2d111a0 <mysql_bin_log>, force_rotate=false, check_purge=0x7fff92fa81b7) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/binlog.cc:7594
#4  0x00000000017f2408 in MYSQL_BIN_LOG::ordered_commit (this=0x2d111a0 <mysql_bin_log>, thd=0x7fff54000b70, all=false, skip_commit=false) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/binlog.cc:
9816
#5  0x00000000017f02b0 in MYSQL_BIN_LOG::commit (this=0x2d111a0 <mysql_bin_log>, thd=0x7fff54000b70, all=false) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/binlog.cc:8870
#6  0x0000000000f4258f in ha_commit_trans (thd=0x7fff54000b70, all=false, ignore_global_read_lock=false) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/handler.cc:1807
#7  0x0000000001643621 in trans_commit_stmt (thd=0x7fff54000b70) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/transaction.cc:465
#8  0x000000000154d76c in mysql_execute_command (thd=0x7fff54000b70, first_level=true) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/sql_parse.cc:4995
#9  0x000000000154eeae in mysql_parse (thd=0x7fff54000b70, parser_state=0x7fff92faa540) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/sql_parse.cc:5584
#10 0x00000000015444a6 in dispatch_command (thd=0x7fff54000b70, com_data=0x7fff92faacd0, command=COM_QUERY) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/sql_parse.cc:1491
#11 0x00000000015432f7 in do_command (thd=0x7fff54000b70) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/sql_parse.cc:1032
#12 0x00000000016746dd in handle_connection (arg=0x696b5c0) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/conn_handler/connection_handler_per_thread.cc:313
#13 0x0000000001d10b38 in pfs_spawn_thread (arg=0x69401a0) at /root/mysql-boost-5.7.32/mysql-5.7.32/storage/perfschema/pfs.cc:2197
#14 0x00007ffff7bc6e65 in start_thread () from /lib64/libpthread.so.0
#15 0x00007ffff5f3288d in clone () from /lib64/libc.so.6



/*当前文件的关闭动作*/
(gdb) where
#0  my_sync (fd=33, my_flags=16) at /root/mysql-boost-5.7.32/mysql-5.7.32/mysys/my_sync.c:97
#1  0x00000000017ddcdf in inline_mysql_file_sync (src_file=0x21bd068 "/root/mysql-boost-5.7.32/mysql-5.7.32/sql/binlog.cc", src_line=8302, fd=33, flags=16) at /root/mysql-boost-5.7.32/mysql-5.7.
32/include/mysql/psi/mysql_file.h:1427
#2  0x00000000017ee7df in MYSQL_BIN_LOG::close (this=0x2d111a0 <mysql_bin_log>, exiting=3, need_lock_log=false, need_lock_index=false) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/binlog.cc:8302
#3  0x00000000017eb871 in MYSQL_BIN_LOG::new_file_impl (this=0x2d111a0 <mysql_bin_log>, need_lock_log=false, extra_description_event=0x0) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/binlog.cc:7
069
#4  0x00000000017eb257 in MYSQL_BIN_LOG::new_file_without_locking (this=0x2d111a0 <mysql_bin_log>, extra_description_event=0x0) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/binlog.cc:6941
#5  0x00000000017eceec in MYSQL_BIN_LOG::rotate (this=0x2d111a0 <mysql_bin_log>, force_rotate=false, check_purge=0x7fff92fa81b7) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/binlog.cc:7594
#6  0x00000000017f2408 in MYSQL_BIN_LOG::ordered_commit (this=0x2d111a0 <mysql_bin_log>, thd=0x7fff50000b70, all=false, skip_commit=false) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/binlog.cc:
9816
#7  0x00000000017f02b0 in MYSQL_BIN_LOG::commit (this=0x2d111a0 <mysql_bin_log>, thd=0x7fff50000b70, all=false) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/binlog.cc:8870
#8  0x0000000000f4258f in ha_commit_trans (thd=0x7fff50000b70, all=false, ignore_global_read_lock=false) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/handler.cc:1807
#9  0x0000000001643621 in trans_commit_stmt (thd=0x7fff50000b70) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/transaction.cc:465
#10 0x000000000154d76c in mysql_execute_command (thd=0x7fff50000b70, first_level=true) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/sql_parse.cc:4995
#11 0x000000000154eeae in mysql_parse (thd=0x7fff50000b70, parser_state=0x7fff92faa540) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/sql_parse.cc:5584
#12 0x00000000015444a6 in dispatch_command (thd=0x7fff50000b70, com_data=0x7fff92faacd0, command=COM_QUERY) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/sql_parse.cc:1491
#13 0x00000000015432f7 in do_command (thd=0x7fff50000b70) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/sql_parse.cc:1032
#14 0x00000000016746dd in handle_connection (arg=0x6983cf0) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/conn_handler/connection_handler_per_thread.cc:313
#15 0x0000000001d10b38 in pfs_spawn_thread (arg=0x692e8d0) at /root/mysql-boost-5.7.32/mysql-5.7.32/storage/perfschema/pfs.cc:2197
#16 0x00007ffff7bc6e65 in start_thread () from /lib64/libpthread.so.0
#17 0x00007ffff5f3288d in clone () from /lib64/libc.so.6

/*打开一个新的文件*/
#0  my_open (FileName=0x2d11220 <mysql_bin_log+128> "./mysql-bin.000038", Flags=65, MyFlags=16) at /root/mysql-boost-5.7.32/mysql-5.7.32/mysys/my_open.c:61
#1  0x00000000017dd68f in inline_mysql_file_open (key=2, src_file=0x21bd068 "/root/mysql-boost-5.7.32/mysql-5.7.32/sql/binlog.cc", src_line=3770, filename=0x2d11220 <mysql_bin_log+128> "./mysql-
bin.000038", flags=65, myFlags=16) at /root/mysql-boost-5.7.32/mysql-5.7.32/include/mysql/psi/mysql_file.h:1066
#2  0x00000000017e3df2 in MYSQL_BIN_LOG::open (this=0x2d111a0 <mysql_bin_log>, log_file_key=2, log_name=0x652a530 "mysql-bin", new_name=0x7fff92fa7ec0 "./mysql-bin.000038") at /root/mysql-boost-
5.7.32/mysql-5.7.32/sql/binlog.cc:3770
#3  0x00000000017e6d7a in MYSQL_BIN_LOG::open_binlog (this=0x2d111a0 <mysql_bin_log>, log_name=0x652a530 "mysql-bin", new_name=0x7fff92fa7ec0 "./mysql-bin.000038", max_size_arg=4096, null_create
d_arg=true, need_lock_index=false, need_sid_lock=true, extra_description_event=0x0) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/binlog.cc:5009
#4  0x00000000017eb9cf in MYSQL_BIN_LOG::new_file_impl (this=0x2d111a0 <mysql_bin_log>, need_lock_log=false, extra_description_event=0x0) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/binlog.cc:7
100
#5  0x00000000017eb257 in MYSQL_BIN_LOG::new_file_without_locking (this=0x2d111a0 <mysql_bin_log>, extra_description_event=0x0) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/binlog.cc:6941
#6  0x00000000017eceec in MYSQL_BIN_LOG::rotate (this=0x2d111a0 <mysql_bin_log>, force_rotate=false, check_purge=0x7fff92fa81b7) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/binlog.cc:7594
#7  0x00000000017f2408 in MYSQL_BIN_LOG::ordered_commit (this=0x2d111a0 <mysql_bin_log>, thd=0x7fff50000b70, all=false, skip_commit=false) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/binlog.cc:
9816
#8  0x00000000017f02b0 in MYSQL_BIN_LOG::commit (this=0x2d111a0 <mysql_bin_log>, thd=0x7fff50000b70, all=false) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/binlog.cc:8870
#9  0x0000000000f4258f in ha_commit_trans (thd=0x7fff50000b70, all=false, ignore_global_read_lock=false) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/handler.cc:1807
#10 0x0000000001643621 in trans_commit_stmt (thd=0x7fff50000b70) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/transaction.cc:465
#11 0x000000000154d76c in mysql_execute_command (thd=0x7fff50000b70, first_level=true) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/sql_parse.cc:4995
#12 0x000000000154eeae in mysql_parse (thd=0x7fff50000b70, parser_state=0x7fff92faa540) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/sql_parse.cc:5584
#13 0x00000000015444a6 in dispatch_command (thd=0x7fff50000b70, com_data=0x7fff92faacd0, command=COM_QUERY) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/sql_parse.cc:1491
#14 0x00000000015432f7 in do_command (thd=0x7fff50000b70) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/sql_parse.cc:1032
#15 0x00000000016746dd in handle_connection (arg=0x6983cf0) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/conn_handler/connection_handler_per_thread.cc:313
#16 0x0000000001d10b38 in pfs_spawn_thread (arg=0x692e8d0) at /root/mysql-boost-5.7.32/mysql-5.7.32/storage/perfschema/pfs.cc:2197
#17 0x00007ffff7bc6e65 in start_thread () from /lib64/libpthread.so.0
#18 0x00007ffff5f3288d in clone () from /lib64/libc.so.6
/*补充 启动时打开binlog文件*/
#0  MYSQL_BIN_LOG::open_binlog (this=0x2d111a0 <mysql_bin_log>, log_name=0x2e8de20 "mysql-bin", new_name=0x0, max_size_arg=1073741824, null_created_arg=false, need_lock_index=true, need_sid_lock
=true, extra_description_event=0x0) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/binlog.cc:5021
#1  0x0000000000eb5eae in init_server_components () at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/mysqld.cc:4265
#2  0x0000000000eb6cab in mysqld_main (argc=99, argv=0x2dbdef8) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/mysqld.cc:4759
#3  0x0000000000eae607 in main (argc=3, argv=0x7fffffffe3b8) at /root/mysql-boost-5.7.32/mysql-5.7.32/sql/main.cc:32