公眾號 MySQL學習

簡單記錄
---
```
static bool login_connection(THD *thd) {
  int error;
  DBUG_TRACE;
  DBUG_PRINT("info",
             ("login_connection called by thread %u", thd->thread_id()));

/* Use "connect_timeout" value during connection phase */
  thd->get_protocol_classic()->set_read_timeout(connect_timeout);
  thd->get_protocol_classic()->set_write_timeout(connect_timeout);

error = check_connection(thd);
  thd->send_statement_status();

if (error) {  // Wrong permissions
#ifdef _WIN32
    if (vio_type(thd->get_protocol_classic()->get_vio()) == VIO_TYPE_NAMEDPIPE)
      my_sleep(1000); /* must wait after eof() */
#endif
    return true;
  }
  /* Connect completed, set read/write timeouts back to default */
  thd->get_protocol_classic()->set_read_timeout(
      thd->variables.net_read_timeout);
  thd->get_protocol_classic()->set_write_timeout(
      thd->variables.net_write_timeout);
  return false;
}
```
```
(gdb) n
700       thd->get_protocol_classic()->set_read_timeout(connect_timeout);
(gdb) n
701       thd->get_protocol_classic()->set_write_timeout(connect_timeout);
(gdb) p connect_timeout
$1 = 10
(gdb) 
```
用於handshake階段，驗證資訊階段的超時，stack如下：
```
(gdb) bt
#0  net_write_packet (net=0x7ffee4368c68, packet=0x7ffee4000b10 "P", length=84) at /opt/mysql/mysql-8.0.21/sql-common/net_serv.cc:1274
#1  0x000000000390e119 in net_flush (net=0x7ffee4368c68) at /opt/mysql/mysql-8.0.21/sql-common/net_serv.cc:276
#2  0x0000000003d3e7d8 in Protocol_classic::flush (this=0x7ffee43a7900) at /opt/mysql/mysql-8.0.21/sql/protocol_classic.cc:2863
#3  0x0000000003999721 in send_server_handshake_packet (mpvio=0x7fff60089130, data=0x7fff60088bb0 "xP>X\016uo~\033\001kHg\027S\020\017\020\062\036", data_len=21)
    at /opt/mysql/mysql-8.0.21/sql/auth/sql_authentication.cc:1463
#4  0x000000000399d4b9 in server_mpvio_write_packet (param=0x7fff60089130, packet=0x7fff60088bb0 "xP>X\016uo~\033\001kHg\027S\020\017\020\062\036", packet_len=21)
    at /opt/mysql/mysql-8.0.21/sql/auth/sql_authentication.cc:2853
#5  0x0000000003a49db7 in caching_sha2_password_authenticate (vio=0x7fff60089130, info=0x7fff60089158) at /opt/mysql/mysql-8.0.21/sql/auth/sha2_password.cc:946
#6  0x000000000399da4d in do_auth_once (thd=0x7ffee4367140, auth_plugin_name=..., mpvio=0x7fff60089130) at /opt/mysql/mysql-8.0.21/sql/auth/sql_authentication.cc:2996
#7  0x000000000399ec49 in acl_authenticate (thd=0x7ffee4367140, command=COM_CONNECT) at /opt/mysql/mysql-8.0.21/sql/auth/sql_authentication.cc:3327
#8  0x00000000036aa0b7 in check_connection (thd=0x7ffee4367140) at /opt/mysql/mysql-8.0.21/sql/sql_connect.cc:648
#9  0x00000000036aa258 in login_connection (thd=0x7ffee4367140) at /opt/mysql/mysql-8.0.21/sql/sql_connect.cc:703
#10 0x00000000036ab10c in thd_prepare_connection (thd=0x7ffee4367140) at /opt/mysql/mysql-8.0.21/sql/sql_connect.cc:876
#11 0x000000000391532f in handle_connection (arg=0x97e5d90) at /opt/mysql/mysql-8.0.21/sql/conn_handler/connection_handler_per_thread.cc:298
#12 0x00000000054bf7d1 in pfs_spawn_thread (arg=0xa7c23d0) at /opt/mysql/mysql-8.0.21/storage/perfschema/pfs.cc:2880
#13 0x00007ffff7bc6ea5 in start_thread () from /lib64/libpthread.so.0
#14 0x00007ffff5e388dd in clone () from /lib64/libc.so.6
(gdb) c
Continuing.

Breakpoint 3, net_write_packet (net=0x7ffee4368c68, packet=0x7ffee4000b10 "\a", length=11) at /opt/mysql/mysql-8.0.21/sql-common/net_serv.cc:1274
1274      DBUG_TRACE;
(gdb) bt
#0  net_write_packet (net=0x7ffee4368c68, packet=0x7ffee4000b10 "\a", length=11) at /opt/mysql/mysql-8.0.21/sql-common/net_serv.cc:1274
#1  0x000000000390e119 in net_flush (net=0x7ffee4368c68) at /opt/mysql/mysql-8.0.21/sql-common/net_serv.cc:276
#2  0x0000000003d3ced4 in net_send_ok (thd=0x7ffee4367140, server_status=2, statement_warn_count=0, affected_rows=0, id=0, message=0x7ffee4369710 "", eof_identifier=false)
    at /opt/mysql/mysql-8.0.21/sql/protocol_classic.cc:964
#3  0x0000000003d3d5ce in Protocol_classic::send_ok (this=0x7ffee43a7900, server_status=2, statement_warn_count=0, affected_rows=0, last_insert_id=0, message=0x7ffee4369710 "")
    at /opt/mysql/mysql-8.0.21/sql/protocol_classic.cc:1302
#4  0x000000000369aa07 in THD::send_statement_status (this=0x7ffee4367140) at /opt/mysql/mysql-8.0.21/sql/sql_class.cc:2646
#5  0x00000000036aa267 in login_connection (thd=0x7ffee4367140) at /opt/mysql/mysql-8.0.21/sql/sql_connect.cc:704
#6  0x00000000036ab10c in thd_prepare_connection (thd=0x7ffee4367140) at /opt/mysql/mysql-8.0.21/sql/sql_connect.cc:876
#7  0x000000000391532f in handle_connection (arg=0x97e5d90) at /opt/mysql/mysql-8.0.21/sql/conn_handler/connection_handler_per_thread.cc:298
#8  0x00000000054bf7d1 in pfs_spawn_thread (arg=0xa7c23d0) at /opt/mysql/mysql-8.0.21/storage/perfschema/pfs.cc:2880
#9  0x00007ffff7bc6ea5 in start_thread () from /lib64/libpthread.so.0
#10 0x00007ffff5e388dd in clone () from /lib64/libc.so.6
```

平時do command用的是 read timeout和read timeout 引數

MySQL：connect_timeout引數簡單記錄

相關文章