mysql 夏令时_mysql 时区 , 夏令时,冬令时

(gdb) bt

#0 0x00007ff8c1c1c1c0 in localtime_r () from /lib64/libc.so.6#1 0x00000000008a40ef in Time_zone_system::gmt_sec_to_TIME (this=0x180ee30 , tmp=0x49afae0, t=1467636107) at /usr/src/mysql-5.6.28/sql/tztime.cc:1079#2 0x00000000006e9ce0 in Time_zone::gmt_sec_to_TIME (this=0x180ee30 , tmp=0x49afae0, tv=...) at /usr/src/mysql-5.6.28/sql/tztime.h:60#3 0x00000000006e5e61 in MYSQL_TIME_cache::set_datetime (this=0x49afae0, tv=..., dec_arg=0 '\000', tz=0x180ee30 ) at /usr/src/mysql-5.6.28/sql/item_timefunc.cc:1747#4 0x00000000006e7bda in Item_func_now::fix_length_and_dec (this=0x49afa10) at /usr/src/mysql-5.6.28/sql/item_timefunc.cc:1866#5 0x000000000069e0e7 in Item_func::fix_fields (this=0x49afa10, thd=0x48c3db0, ref=0x49afb40) at /usr/src/mysql-5.6.28/sql/item_func.cc:231#6 0x000000000075c155 in setup_fields (thd=0x48c3db0, ref_pointer_array=..., fields=..., mark_used_columns=MARK_COLUMNS_READ, sum_func_list=0x49afe60, allow_sum_func=true) at /usr/src/mysql-5.6.28/sql/sql_base.cc:8400#7 0x00000000007f749d in JOIN::prepare (this=0x49afc18, tables_init=0x0, wild_num=0, conds_init=0x0, og_num=0, order_init=0x0, group_init=0x0, having_init=0x0, select_lex_arg=0x48c6348, unit_arg=0x48c5d00) at /usr/src/mysql-5.6.28/sql/sql_resolver.cc:168#8 0x00000000008080cd in mysql_prepare_select (thd=0x48c3db0, tables=0x0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, select_options=2147748608, result=0x49afbf0, unit=0x48c5d00, select_lex=0x48c6348, free_join=0x7ff85d1fce6b) at /usr/src/mysql-5.6.28/sql/sql_select.cc:1055#9 0x0000000000808222 in mysql_select (thd=0x48c3db0, tables=0x0, wild_num=0, fields=..., conds=0x0, order=0x48c6510, group=0x48c6448, having=0x0, select_options=2147748608, result=0x49afbf0, unit=0x48c5d00, select_lex=0x48c6348) at /usr/src/mysql-5.6.28/sql/sql_select.cc:1178#10 0x000000000080854d in handle_select (thd=0x48c3db0, result=0x49afbf0, setup_tables_done_option=0) at /usr/src/mysql-5.6.28/sql/sql_select.cc:110#11 0x00000000007cdc4e in execute_sqlcom_select (thd=0x48c3db0, all_tables=0x0) at /usr/src/mysql-5.6.28/sql/sql_parse.cc:5134#12 0x00000000007cf185 in mysql_execute_command (thd=0x48c3db0) at /usr/src/mysql-5.6.28/sql/sql_parse.cc:2656#13 0x00000000007d67c4 in mysql_parse (thd=0x48c3db0, rawbuf=0x49af980 "select now()", length=12, parser_state=0x7ff85d1fe910) at /usr/src/mysql-5.6.28/sql/sql_parse.cc:6386#14 0x00000000007d83f4 in dispatch_command (command=COM_QUERY, thd=0x48c3db0, packet=0x49a5751 "select now()", packet_length=12) at /usr/src/mysql-5.6.28/sql/sql_parse.cc:1340#15 0x00000000007d9c80 in do_command (thd=0x48c3db0) at /usr/src/mysql-5.6.28/sql/sql_parse.cc:1037#16 0x000000000078e3fb in do_handle_one_connection (thd_arg=0x48c3db0) at /usr/src/mysql-5.6.28/sql/sql_connect.cc:982#17 0x000000000078e4c1 in handle_one_connection (arg=0x48c3db0) at /usr/src/mysql-5.6.28/sql/sql_connect.cc:898#18 0x0000000000b11172 in pfs_spawn_thread (arg=0x4794e60) at /usr/src/mysql-5.6.28/storage/perfschema/pfs.cc:1860#19 0x00007ff8c27b883d in start_thread () from /lib64/libpthread.so.0#20 0x00007ff8c1c65fdd in clone () from /lib64/libc.so.6#21 0x0000000000000000 in ??()

(gdb) disas

Dump of assembler codeforfunction localtime_r:=> 0x00007ff8c1c1c1c0 : mov %rsi,%rdx0x00007ff8c1c1c1c3 : mov $0x1,%esi0x00007ff8c1c1c1c8 : jmpq 0x7ff8c1c1dab0 <__tz_convert>End of assembler dump.

(gdb) next

Single stepping until exitfromfunction localtime_r,

which has no line number information.0x00007ff8c1c1dab0 in __tz_convert () from /lib64/libc.so.6(gdb) diaas

Undefined command:"diaas". Try "help".

(gdb) disas

Dump of assembler codeforfunction __tz_convert:=> 0x00007ff8c1c1dab0 : push %r120x00007ff8c1c1dab2 : mov %esi,%r12d0x00007ff8c1c1dab5 : push %rbp0x00007ff8c1c1dab6 : mov %rdi,%rbp0x00007ff8c1c1dab9 : push %rbx0x00007ff8c1c1daba : mov %rdx,%rbx0x00007ff8c1c1dabd : sub $0x10,%rsp0x00007ff8c1c1dac1 : test %rdi,%rdi0x00007ff8c1c1dac4 : je 0x7ff8c1c1dc6e <__tz_convert>

0x00007ff8c1c1daca : mov $0x1,%esi0x00007ff8c1c1dacf : xor %eax,%eax0x00007ff8c1c1dad1 : cmpl $0x0,0x2cb458(%rip) # 0x7ff8c1ee8f30 <__libc_multiple_threads>

0x00007ff8c1c1dad8 : je 0x7ff8c1c1daea <__tz_convert>

0x00007ff8c1c1dada : lock cmpxchg %esi,0x2c8ab2(%rip) # 0x7ff8c1ee6594

0x00007ff8c1c1dae2 : jne 0x7ff8c1c1dd9a <_l_lock_1685>

0x00007ff8c1c1dae8 : jmp 0x7ff8c1c1daf7 <__tz_convert>

0x00007ff8c1c1daea : cmpxchg %esi,0x2c8aa3(%rip) # 0x7ff8c1ee6594

0x00007ff8c1c1daf1 : jne 0x7ff8c1c1dd9a <_l_lock_1685>

0x00007ff8c1c1daf7 : lea 0x2cb1c2(%rip),%rax # 0x7ff8c1ee8cc0 <_tmbuf>

0x00007ff8c1c1dafe : xor %edi,%edi0x00007ff8c1c1db00 : cmp %rax,%rdx0x00007ff8c1c1db03 : sete %dil0x00007ff8c1c1db07 : xor %esi,%esi0x00007ff8c1c1db09 : callq 0x7ff8c1c1d160

0x00007ff8c1c1db0e : mov 0x2cb1ec(%rip),%eax # 0x7ff8c1ee8d00 <__use_tzfile>

0x00007ff8c1c1db14 : test %eax,%eax0x00007ff8c1c1db16 : je 0x7ff8c1c1db94 <__tz_convert>

0x00007ff8c1c1db18 : mov 0x0(%rbp),%rdi0x00007ff8c1c1db1c : lea 0xc(%rsp),%rcx0x00007ff8c1c1db21 : mov %rsp,%rdx0x00007ff8c1c1db24 : mov %rbx,%r80x00007ff8c1c1db27 : mov %r12d,%esi0x00007ff8c1c1db2a : callq 0x7ff8c1c1de60 <__tzfile_compute>

0x00007ff8c1c1db2f : test %rbx,%rbx0x00007ff8c1c1db32 : je 0x7ff8c1c1db64 <__tz_convert>

0x00007ff8c1c1db34 : test %r12d,%r12d0x00007ff8c1c1db37 : je 0x7ff8c1c1dbc8 <__tz_convert>

0x00007ff8c1c1db3d : mov 0x2cb1bd(%rip),%eax # 0x7ff8c1ee8d00 <__use_tzfile>

0x00007ff8c1c1db43 : test %eax,%eax0x00007ff8c1c1db45 : je 0x7ff8c1c1dc13 <__tz_convert>

0x00007ff8c1c1db4b : mov 0x28(%rbx),%rsi0x00007ff8c1c1db4f : sub (%rsp),%rsi0x00007ff8c1c1db53 : mov %rbx,%rdx0x00007ff8c1c1db56 : mov %rbp,%rdi0x00007ff8c1c1db59 : callq 0x7ff8c1c1ba90 <__offtime>

0x00007ff8c1c1db5e : test %eax,%eax0x00007ff8c1c1db60 : jne 0x7ff8c1c1dbc0 <__tz_convert>

0x00007ff8c1c1db62 : xor %ebx,%ebx0x00007ff8c1c1db64 : cmpl $0x0,0x2cb3c5(%rip) # 0x7ff8c1ee8f30 <__libc_multiple_threads>

0x00007ff8c1c1db6b : je 0x7ff8c1c1db7c <__tz_convert>

0x00007ff8c1c1db6d : lock decl 0x2c8a20(%rip) # 0x7ff8c1ee6594

0x00007ff8c1c1db74 : jne 0x7ff8c1c1ddb9 <_l_unlock_1746>

0x00007ff8c1c1db7a : jmp 0x7ff8c1c1db88 <__tz_convert>

0x00007ff8c1c1db7c : decl 0x2c8a12(%rip) # 0x7ff8c1ee6594

0x00007ff8c1c1db82 : jne 0x7ff8c1c1ddb9 <_l_unlock_1746>

0x00007ff8c1c1db88 : add $0x10,%rsp0x00007ff8c1c1db8c : mov %rbx,%rax0x00007ff8c1c1db8f : pop %rbx0x00007ff8c1c1db90 : pop %rbp0x00007ff8c1c1db91 : pop %r120x00007ff8c1c1db93 : retq0x00007ff8c1c1db94 : xor %esi,%esi0x00007ff8c1c1db96 : mov %rbx,%rdx0x00007ff8c1c1db99 : mov %rbp,%rdi0x00007ff8c1c1db9c : callq 0x7ff8c1c1ba90 <__offtime>

0x00007ff8c1c1dba1 : test %eax,%eax0x00007ff8c1c1dba3 : jne 0x7ff8c1c1dbe7 <__tz_convert>

0x00007ff8c1c1dba5 : xor %ebx,%ebx0x00007ff8c1c1dba7 : movq $0x0,(%rsp)0x00007ff8c1c1dbaf : movl $0x0,0xc(%rsp)0x00007ff8c1c1dbb7 : jmpq 0x7ff8c1c1db2f <__tz_convert>

0x00007ff8c1c1dbbc : nopl 0x0(%rax)0x00007ff8c1c1dbc0 : mov 0xc(%rsp),%eax0x00007ff8c1c1dbc4 : add %eax,(%rbx)0x00007ff8c1c1dbc6 : jmp 0x7ff8c1c1db64 <__tz_convert>

0x00007ff8c1c1dbc8 : lea 0x951ae(%rip),%rax # 0x7ff8c1cb2d7d

0x00007ff8c1c1dbcf : movl $0x0,0x20(%rbx)0x00007ff8c1c1dbd6 : movq $0x0,0x28(%rbx)0x00007ff8c1c1dbde : mov %rax,0x30(%rbx)0x00007ff8c1c1dbe2 : jmpq 0x7ff8c1c1db4b <__tz_convert>

0x00007ff8c1c1dbe7 : mov 0x14(%rbx),%esi0x00007ff8c1c1dbea : lea 0x2c89af(%rip),%rdi # 0x7ff8c1ee65a0

0x00007ff8c1c1dbf1 : add $0x76c,%esi0x00007ff8c1c1dbf7 : callq 0x7ff8c1c1ce00

0x00007ff8c1c1dbfc : mov 0x14(%rbx),%esi0x00007ff8c1c1dbff : lea 0x2c89ca(%rip),%rdi # 0x7ff8c1ee65d0

0x00007ff8c1c1dc06 : add $0x76c,%esi0x00007ff8c1c1dc0c : callq 0x7ff8c1c1ce00

0x00007ff8c1c1dc11 : jmp 0x7ff8c1c1dba7 <__tz_convert>

0x00007ff8c1c1dc13 : mov 0x2c89a6(%rip),%rcx # 0x7ff8c1ee65c0

0x00007ff8c1c1dc1a : mov 0x2c89cf(%rip),%rdi # 0x7ff8c1ee65f0

0x00007ff8c1c1dc21 : cmp %rdi,%rcx0x00007ff8c1c1dc24 : jg 0x7ff8c1c1dc83 <__tz_convert>

0x00007ff8c1c1dc26 : mov 0x0(%rbp),%rsi0x00007ff8c1c1dc2a : xor %eax,%eax0x00007ff8c1c1dc2c : cmp %rsi,%rcx0x00007ff8c1c1dc2f : jg 0x7ff8c1c1dc39 <__tz_convert>

0x00007ff8c1c1dc31 : xor %eax,%eax0x00007ff8c1c1dc33 : cmp %rsi,%rdi0x00007ff8c1c1dc36 : setg %al0x00007ff8c1c1dc39 : movslq %eax,%rdx0x00007ff8c1c1dc3c : mov %eax,0x20(%rbx)0x00007ff8c1c1dc3f : mov 0x2c617a(%rip),%rax # 0x7ff8c1ee3dc0

0x00007ff8c1c1dc46 : mov (%rax,%rdx,8),%rax0x00007ff8c1c1dc4a : mov %rax,0x30(%rbx)0x00007ff8c1c1dc4e : lea (%rdx,%rdx,1),%rax0x00007ff8c1c1dc52 : add %rdx,%rax0x00007ff8c1c1dc55 : lea 0x2c894c(%rip),%rdx # 0x7ff8c1ee65a8

0x00007ff8c1c1dc5c : shl $0x4,%rax0x00007ff8c1c1dc60 : mov 0x10(%rax,%rdx,1),%rax0x00007ff8c1c1dc65 : mov %rax,0x28(%rbx)0x00007ff8c1c1dc69 : jmpq 0x7ff8c1c1db4b <__tz_convert>

0x00007ff8c1c1dc6e : mov 0x2c6333(%rip),%rax # 0x7ff8c1ee3fa8

0x00007ff8c1c1dc75 : xor %ebx,%ebx0x00007ff8c1c1dc77 : movl $0x16,%fs:(%rax)0x00007ff8c1c1dc7e : jmpq 0x7ff8c1c1db88 <__tz_convert>

0x00007ff8c1c1dc83 : mov 0x0(%rbp),%rdx0x00007ff8c1c1dc87 : mov $0x1,%eax0x00007ff8c1c1dc8c : cmp %rdx,%rdi0x00007ff8c1c1dc8f : jg 0x7ff8c1c1dc39 <__tz_convert>

0x00007ff8c1c1dc91 : xor %eax,%eax0x00007ff8c1c1dc93 : cmp %rdx,%rcx0x00007ff8c1c1dc96 : setle %al0x00007ff8c1c1dc99 : jmp 0x7ff8c1c1dc39 <__tz_convert>End of assembler dump.