mysql夏令時_mysql時區，夏令時，冬令時
(gdb) bt
#0 0x00007ff8c1c1c1c0 in localtime_r () from /lib64/libc.so.6#1 0x00000000008a40ef in
Time_zone_system::gmt_c_to_TIME (this=0x180ee30 , tmp=0x49afae0, t=1467636107) at /usr/src/mysql-
5.6.28/:1079#2 0x00000000006e9ce0 in Time_zone::gmt_c_to_TIME (this=0x180ee30 , tmp=0x49afae0, tv=...) at /usr/src/mysql-5.6.28/sql/tztime.h:60#3 0x00000000006e5e61 in MYSQL_TIME_cache::t_datetime
(this=0x49afae0, tv=..., dec_arg=0 '\000', tz=0x180ee30 ) at /usr/src/mysql-5.6.28/sql/:1747#4
0x00000000006e7bda in Item_func_now::fix_length_and_dec (this=0x49afa10) at /usr/src/mysql-
5.6.28/sql/:1866#5 0x000000000069e0e7 in Item_func::fix_fields (this=0x49afa10, thd=0x48c3db0,
ref=0x49afb40) at /usr/src/mysql-5.6.28/sql/:231#6 0x000000000075c155 in tup_fields
(thd=0x48c3db0, ref_pointer_array=..., fields=..., mark_ud_columns=MARK_COLUMNS_READ, sum_func_list=0x49afe60, allow_sum_func=true) at /usr/src/mysql-5.6.28/sql/: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, lect_lex_arg=0x48c6348, unit_arg=0x48c5d00) at /usr/src/mysql-5.6.28/sql/:168#8
0x00000000008080cd in mysql_prepare_lect (thd=0x48c3db0, tables=0x0, wild_num=0, fields=..., conds=0x0,
og_num=0, order=0x0, group=0x0, having=0x0, lect_options=2147748608, result=0x49afbf0, unit=0x48c5d00,
lect_lex=0x48c6348, free_join=0x7ff85d1fce6b) at /usr/src/mysql-5.6.28/sql/:1055#9
0x0000000000808222 in mysql_lect (thd=0x48c3db0, tables=0x0, wild_num=0, fields=..., conds=0x0,
order=0x48c6510, group=0x48c6448, having=0x0, lect_options=2147748608, result=0x49afbf0, unit=0x48c5d00, lect_lex=0x48c6348) at /usr/src/mysql-5.6.28/sql/:1178#10 0x000000000080854d in handle_lect (thd=0x48c3db0, result=0x49afbf0, tup_tables_done_option=0) at /usr/src/mysql-5.6.28/sql/:110#11
0x00000000007cdc4e in execute_sqlcom_lect (thd=0x48c3db0, all_tables=0x0) at /usr/src/mysql-
5.6.28/sql/:5134#12 0x00000000007cf185 in mysql_execute_command (thd=0x48c3db0) at
/usr/src/mysql-5.6.28/sql/:2656#13 0x00000000007d67c4 in mysql_par (thd=0x48c3db0,
rawbuf=0x49af980 "lect now()", length=12, parr_state=0x7ff85d1fe910) at /usr/src/mysql-
5.6.28/sql/:6386#14 0x00000000007d83f4 in dispatch_command (command=COM_QUERY,
thd=0x48c3db0, packet=0x49a5751 "lect now()", packet_length=12) at /usr/src/mysql-
5.6.28/sql/:1340#15 0x00000000007d9c80 in do_command (thd=0x48c3db0) at /usr/src/mysql-
5.6.28/sql/:1037#16 0x000000000078e3fb in do_handle_one_connection (thd_arg=0x48c3db0) at
/usr/src/mysql-5.6.28/sql/:982#17 0x000000000078e4c1 in handle_one_connection (arg=0x48c3db0) at /usr/src/mysql-5.6.28/sql/:898#18 0x0000000000b11172 in pfs_spawn_thread (arg=0x4794e60) at
/usr/src/mysql-5.6.28/storage/: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 asmbler codeforfunction localtime_r:=> 0x00007ff8c1c1c1c0 : mov %rsi,%rdx0x00007ff8c1c1c1c3 : mov
$0x1,%esi0x00007ff8c1c1c1c8 : jmpq 0x7ff8c1c1dab0 <__tz_convert>End of asmbler 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 asmbler 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 : te
%dil0x00007ff8c1c1db07 : xor %esi,%esi0x00007ff8c1c1db09 : callq 0x7ff8c1c1d160
0x00007ff8c1c1db0e : mov 0x2cb1ec(%rip),%eax # 0x7ff8c1ee8d00 <__u_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 <__u_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 : tg
%al0x00007ff8c1c1dc39 : movslq %eax,%rdx0x00007ff8c1c1dc3c : mov %eax,0x20(%rbx)0x00007ff8c1c1dc3f : mov 0x2c617a(%rip),%rax # 0x7ff8c1ee3dc0
0x00007ff8c1c1dc46 : mov (%rax,%rdx,8),%rax0x00007ff8c1c1dc4a : mov %rax,0x30(%rbx)0x0000
7ff8c1c1dc4e : 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 : tle
%al0x00007ff8c1c1dc99 : jmp 0x7ff8c1c1dc39 <__tz_convert>End of asmbler dump.
