mysql5.7undo 日志purge 流程

/*purge 线程清理undo 日志*/
#0  trx_purge_remove_log_hdr (rseg_hdr=0x7fffcf908026 "\377\377\377\376", log_hdr=0x7fffa5878199 "", mtr=0x7fff8a727700) at storage/innobas
e/trx/trx0purge.cc:423
#1  0x0000000001acf89d in trx_purge_truncate_rseg_history (rseg=0x7b69088, limit=0x7b8e600) at storage/innobase/trx/trx0purge.cc:615
#2  0x0000000001ad1498 in trx_purge_truncate_history (limit=0x7b8e600, view=0x7b8e550) at storage/innobase/trx/trx0purge.cc:1236
#3  0x0000000001ad2c6e in trx_purge_truncate () at storage/innobase/trx/trx0purge.cc:1818
#4  0x0000000001ad30ae in trx_purge (n_purge_threads=2, batch_size=300, truncate=true) at storage/innobase/trx/trx0purge.cc:1916
#5  0x0000000001a9e8f0 in srv_do_purge (n_threads=2, n_total_purged=0x7fff8a727da0) at storage/innobase/srv/srv0srv.cc:2647
#6  0x0000000001a9efcf in srv_purge_coordinator_thread (arg=0x0) at storage/innobase/srv/srv0srv.cc:2820

/*事务提交将事务设置为可用状态*/
#0  trx_write_serialisation_history (trx=0x7fffd78cf480, mtr=0x7fff92fa7a80) at storage/innobase/trx/trx0trx.cc:1583
#1  0x0000000001af5bbb in trx_commit_low (trx=0x7fffd78cf480, mtr=0x7fff92fa7a80) at storage/innobase/trx/trx0trx.cc:2143
#2  0x0000000001af5d2f in trx_commit (trx=0x7fffd78cf480) at storage/innobase/trx/trx0trx.cc:2213
#3  0x0000000001af6436 in trx_commit_for_mysql (trx=0x7fffd78cf480) at storage/innobase/trx/trx0trx.cc:2432
#4  0x00000000018cc992 in innobase_commit_low (trx=0x7fffd78cf480) at storage/innobase/handler/ha_innodb.cc:4296
#5  0x00000000018cce81 in innobase_commit (hton=0x2dd1be0, thd=0x7fff54000b70, commit_trx=true) at storage/innobase/handler/ha_innodb.cc:4458
#6  0x0000000000f42bad in ha_commit_low (thd=0x7fff54000b70, all=true, run_after_commit=false) at sql/handler.cc:1914
#7  0x00000000017f0f33 in MYSQL_BIN_LOG::process_commit_stage_queue (this=0x2d231a0 <mysql_bin_log>, thd=0x7fff54000b70, first=0x7fff54000b70) at sql/binlog.cc:9111
#8  0x00000000017f2b29 in MYSQL_BIN_LOG::ordered_commit (this=0x2d231a0 <mysql_bin_log>, thd=0x7fff54000b70, all=true, skip_commit=false) at sql/binlog.cc:9892
#9  0x00000000017f0800 in MYSQL_BIN_LOG::commit (this=0x2d231a0 <mysql_bin_log>, thd=0x7fff54000b70, all=true) at sql/binlog.cc:8908
#10 0x0000000000f42889 in ha_commit_trans (thd=0x7fff54000b70, all=true, ignore_global_read_lock=false) at sql/handler.cc:1810
#11 0x00000000016432ce in trans_commit (thd=0x7fff54000b70) at sql/transaction.cc:246
#12 0x000000000154bb16 in mysql_execute_command (thd=0x7fff54000b70, first_level=true) at sql/sql_parse.cc:4254
#13 0x000000000154f2f6 in mysql_parse (thd=0x7fff54000b70, parser_state=0x7fff92faa540) at sql/sql_parse.cc:5584
#14 0x00000000015448ee in dispatch_command (thd=0x7fff54000b70, com_data=0x7fff92faacd0, command=COM_QUERY) at sql/sql_parse.cc:1491
#15 0x000000000154373f in do_command (thd=0x7fff54000b70) at sql/sql_parse.cc:1032
#16 0x0000000001674b25 in handle_connection (arg=0x695f0b0) at sql/conn_handler/connection_handler_per_thread.cc:313
#17 0x0000000001d12388 in pfs_spawn_thread (arg=0x6903570) at storage/perfschema/pfs.cc:2197
#18 0x00007ffff7bc6e65 in start_thread () from /lib64/libpthread.so.0
#19 0x00007ffff5f3288d in clone () from /lib64/libc.so.6
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值