mysql 记录号_MySQL：简单记录信号处理

码版本：5.7.29

简单记录信号如何生效的。poll收到信号后如何中断后如何处理的，需要确认。

一

初始化信号处理方式，设置信号的处理的处理方式，屏蔽某些信号，并且继承到子线程(pthread_sigmask)，主要屏蔽的为SIGTERM、SIGQUIT、SIGHUP、SIGTSTP四个。其他信号按照默认处理方式，但是处理前打印crash栈，handle_fatal_signal

对于siguser1 进行捕获，处理函数为空empty_signal_handler

#0 my_init_signals () at /home/mysql/soft/percona-server-5.7.29-32/sql/mysqld.cc:2225

#1 0x00000000015fefc9 in mysqld_main (argc=79, argv=0x2e22368) at /home/mysql/soft/percona-server-5.7.29-32/sql/mysqld.cc:4846

#2 0x0000000000e8795d in main (argc=4, argv=0x7fffffffe538) at /home/mysql/soft/percona-server-5.7.29-32/sql/main.cc:32

二

启动信号处理线程start_signal_handler线程调用函数为 signal_hand,

使用sigwait获取未决信号集合，如果为SIGTERM和SIGQUIT，设置abort_loop= true;

并且发送sigusr1个主线程，准备正常退出pthread_kill(main_thread_id, SIGUSR1)) //给主线程发送sigusr1信号

如果为SIGHUP则重载一下reload_acl_and_cache相关缓存。

start_signal_handler线程调用函数为 signal_hand

#0 start_signal_handler () at /home/mysql/soft/percona-server-5.7.29-32/sql/mysqld.cc:2301

#1 0x00000000015fff70 in mysqld_main (argc=79, argv=0x2e22368) at /home/mysql/soft/percona-server-5.7.29-32/sql/mysqld.cc:5407

#2 0x0000000000e8795d in main (argc=4, argv=0x7fffffffe538) at /home/mysql/soft/percona-server-5.7.29-32/sql/main.cc:32

三、

如果为SIGTERM和SIGQUIT，主线程(main)正在poll接受连接，收到了sigusr1 信号后进行中断处理，接下来进行判断

全局变量abort_loop，然后进入正常退出流程。

#0 empty_signal_handler (sig=32767) at /home/mysql/soft/percona-server-5.7.29-32/sql/mysqld.cc:2219

#1

#2 0x00007ffff5f20c3d in poll () from /lib64/libc.so.6

#3 0x00000000015ec077 in Mysqld_socket_listener::listen_for_connection_event (this=0x35a76f0) at /home/mysql/soft/percona-server-5.7.29-32/sql/conn_handler/socket_connection.cc:883

#4 0x0000000001607542 in Connection_acceptor::connection_event_loop (this=0x35a70e0)

at /home/mysql/soft/percona-server-5.7.29-32/sql/conn_handler/connection_acceptor.h:73

#5 0x00000000016001f2 in mysqld_main (argc=79, argv=0x2e22368) at /home/mysql/soft/percona-server-5.7.29-32/sql/mysqld.cc:5513

#6 0x0000000000e8795d in main (argc=4, argv=0x7fffffffe538) at /home/mysql/soft/percona-server-5.7.29-32/sql/main.cc:32

main thread

mysqld_socket_acceptor->connection_event_loop(); //监听3306 端口

#endif /* _WIN32 */

server_operational_state= SERVER_SHUTTING_DOWN; //这里开始进行关闭处理

DBUG_PRINT("info", ("No longer listening for incoming connections"));

mysql_audit_notify(MYSQL_AUDIT_SERVER_SHUTDOWN_SHUTDOWN, Mysqld_socket_listener::listen_for_connection_event

MYSQL_AUDIT_SERVER_SHUTDOWN_REASON_SHUTDOWN,

MYSQLD_SUCCESS_EXIT);

terminate_compress_gtid_table_thread();