mysql> show create table y;
+-------+------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+------------------------------------------------------------------------------------+
| y | CREATE TABLE `y` (
`a` int() DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+-------+------------------------------------------------------------------------------------+
row in set (0.00 sec)
[root@localhost test]# strace -f -F -e trace=fdatasync,fsync -p 4043
Process 8703 attached with 23 threads - interrupt to quit
[pid 7089] fsync(9) = 0
[pid 4063] fsync(9) = 0
[pid 4063] fsync(9) = 0
[pid 4061] fsync(4) = 0
[pid 4050] fsync(4) = 0
[pid 4050] fsync(20) = 0
[pid 4061] fsync(4) = 0
[pid 4050] fsync(12) = 0
[pid 4061] fsync(4) = 0
[pid 4050] fsync(14) = 0
[pid 4061] fsync(4) = 0
[pid 4050] fsync(4) = 0
[pid 4061] fsync(4) = 0
[pid 4052] fsync(4) = 0
[pid 4061] fsync(4) = 0
[pid 4053] fsync(4) = 0
[pid 4045] fsync(9) = 0
[root@localhost test]# strace -f -F -c -p 4043
% time seconds usecs/call calls errors syscall
------ ----------- ----------- --------- --------- ----------------
60.99 0.154980 1084 143 io_getevents
23.66 0.060119 911 66 16 futex
10.23 0.025997 1625 16 select
2.36 0.006000 1200 5 4 restart_syscall
1.97 0.005000 625 8 fsync
0.39 0.001000 40 25 clock_gettime
0.39 0.000999 250 4 pwrite
0.00 0.000000 0 1 write
0.00 0.000000 0 4 sched_yield
0.00 0.000000 0 1 sendto
0.00 0.000000 0 3 1 recvfrom
0.00 0.000000 0 4 io_submit
------ ----------- ----------- --------- --------- ----------------
100.00 0.254095 280 21 total
[root@localhost test]# lsof -p
COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME
mysqld mysql cwd DIR , /data
mysqld mysql rtd DIR , /
mysqld mysql txt REG , /usr/local/mysql56/bin/mysqld
mysqld mysql mem REG , /usr/lib64/libaio.so.1.0.
mysqld mysql mem REG , /lib64/libgcc_s-4.1.-.so.
mysqld mysql mem REG , /usr/lib64/libstdc++.so.6.0.
mysqld mysql mem REG , /lib64/libnss_files-2.5.so
mysqld mysql mem REG , /lib64/libc-2.5.so
mysqld mysql mem REG , /lib64/libm-2.5.so
mysqld mysql mem REG , /lib64/libdl-2.5.so
mysqld mysql mem REG , /lib64/libcrypt-2.5.so
mysqld mysql mem REG , /lib64/librt-2.5.so
mysqld mysql mem REG , /lib64/libpthread-2.5.so
mysqld mysql mem REG , /lib64/ld-2.5.so
mysqld mysql 0u CHR , /dev/pts/ (deleted)
mysqld mysql 1u CHR , /dev/pts/ (deleted)
mysqld mysql 2u CHR , /dev/pts/ (deleted)
mysqld mysql 3u REG , /data/.index
mysqld 4043 mysql 4uW REG 8,2 79691776 3899547 /data/ibdata1
mysqld mysql 5u REG , /tmp/ibfdLTdG (deleted)
mysqld mysql 6u REG , /tmp/ibv1eHOO (deleted)
mysqld mysql 7u REG , /tmp/ibdPkvpX (deleted)
mysqld mysql 8u REG , /tmp/ibbu44op (deleted)
mysqld 4043 mysql 9uW REG 8,2 50331648 3899548 /data/ib_logfile0
mysqld mysql 10uW REG , /data/ib_logfile1
mysqld mysql 11uW REG , /data/test/rank_status_no.ibd
mysqld 4043 mysql 12uW REG 8,2 98304 3900109 /data/mysql/innodb_table_stats.ibd
mysqld mysql 13uW REG , /data/test/rank_status_yes.ibd
mysqld 4043 mysql 14uW REG 8,2 98304 3900111 /data/mysql/innodb_index_stats.ibd
mysqld mysql 15u REG , /tmp/ibJe2XXK (deleted)
mysqld mysql 16u unix 0xffff880022561480 /tmp/mysql.sock
mysqld mysql 17u IPv6 TCP *:mysql (LISTEN)
mysqld mysql 18u unix 0xffff88000b9d8e80 /tmp/mysql.sock
mysqld mysql 19uW REG , /data/test/tbl_a.ibd
mysqld 4043 mysql 20uW REG 8,2 98304 820505 /data/test/y.ibd
mysqld mysql 21u REG , /data/test/t.MYI
mysqld mysql 22u REG , /data/test/t.MYD
mysqld mysql 33uW REG , /data/mysql/slave_master_info.ibd
mysqld mysql 34uW REG , /data/mysql/slave_worker_info.ibd
mysqld mysql 35uW REG , /data/mysql/slave_relay_log_info.ibd
mysqld mysql 36w REG , /data/1.000037
(gdb) thread apply all bt
Thread (Thread 0x7fc1603be940 (LWP )):
# 0x00000030738005b4 in ?? () from /usr/lib64/libaio.so.
# 0x0000000000ba441d in os_aio_linux_collect (array=0x1988ee0, segment=, seg_size=) at /usr/src/mysql-5.6./storage/innobase/os/os0file.cc:
# 0x0000000000ba4be2 in os_aio_linux_handle (global_seg=, message1=0x7fc1603be0e0, message2=0x7fc1603be0d8, type=0x7fc1603be0d0) at /usr/src/mysql-5.6./storage/innobase/os/os0file.cc:
# 0x0000000000d4deca in fil_aio_wait (segment=) at /usr/src/mysql-5.6./storage/innobase/fil/fil0fil.cc:
# 0x0000000000c6e122 in io_handler_thread (arg=0x1829c20 <n>) at /usr/src/mysql-5.6./storage/innobase/srv/srv0start.cc:
# 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.
# 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.
# 0x0000000000000000 in ?? ()
Thread (Thread 0x7fc15fbbd940 (LWP )):
# 0x00000030738005b4 in ?? () from /usr/lib64/libaio.so.
# 0x0000000000ba441d in os_aio_linux_collect (array=0x197bc40, segment=, seg_size=) at /usr/src/mysql-5.6./storage/innobase/os/os0file.cc:
# 0x0000000000ba4be2 in os_aio_linux_handle (global_seg=, message1=0x7fc15fbbd0e0, message2=0x7fc15fbbd0d8, type=0x7fc15fbbd0d0) at /usr/src/mysql-5.6./storage/innobase/os/os0file.cc:
# 0x0000000000d4deca in fil_aio_wait (segment=) at /usr/src/mysql-5.6./storage/innobase/fil/fil0fil.cc:
# 0x0000000000c6e122 in io_handler_thread (arg=0x1829c28 <n+>) at /usr/src/mysql-5.6./storage/innobase/srv/srv0start.cc:
# 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.
# 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.
# 0x0000000000000000 in ?? ()
Thread (Thread 0x7fc15f3bc940 (LWP )):
# 0x00000030738005b4 in ?? () from /usr/lib64/libaio.so.
# 0x0000000000ba441d in os_aio_linux_collect (array=0x1973980, segment=, seg_size=) at /usr/src/mysql-5.6./storage/innobase/os/os0file.cc:
# 0x0000000000ba4be2 in os_aio_linux_handle (global_seg=, message1=0x7fc15f3bc0e0, message2=0x7fc15f3bc0d8, type=0x7fc15f3bc0d0) at /usr/src/mysql-5.6./storage/innobase/os/os0file.cc:
# 0x0000000000d4deca in fil_aio_wait (segment=) at /usr/src/mysql-5.6./storage/innobase/fil/fil0fil.cc:
# 0x0000000000c6e122 in io_handler_thread (arg=0x1829c30 <n+>) at /usr/src/mysql-5.6./storage/innobase/srv/srv0start.cc:
# 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.
# 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.
# 0x0000000000000000 in ?? ()
Thread (Thread 0x7fc15ebbb940 (LWP )):
# 0x00000030738005b4 in ?? () from /usr/lib64/libaio.so.
# 0x0000000000ba441d in os_aio_linux_collect (array=0x1973980, segment=, seg_size=) at /usr/src/mysql-5.6./storage/innobase/os/os0file.cc:
# 0x0000000000ba4be2 in os_aio_linux_handle (global_seg=, message1=0x7fc15ebbb0e0, message2=0x7fc15ebbb0d8, type=0x7fc15ebbb0d0) at /usr/src/mysql-5.6./storage/innobase/os/os0file.cc:
# 0x0000000000d4deca in fil_aio_wait (segment=) at /usr/src/mysql-5.6./storage/innobase/fil/fil0fil.cc:
# 0x0000000000c6e122 in io_handler_thread (arg=0x1829c38 <n+>) at /usr/src/mysql-5.6./storage/innobase/srv/srv0start.cc:
# 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.
# 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.
# 0x0000000000000000 in ?? ()
Thread (Thread 0x7fc15e3ba940 (LWP )):
# 0x00000030738005b4 in ?? () from /usr/lib64/libaio.so.
# 0x0000000000ba441d in os_aio_linux_collect (array=0x1973980, segment=, seg_size=) at /usr/src/mysql-5.6./storage/innobase/os/os0file.cc:
# 0x0000000000ba4be2 in os_aio_linux_handle (global_seg=, message1=0x7fc15e3ba0e0, message2=0x7fc15e3ba0d8, type=0x7fc15e3ba0d0) at /usr/src/mysql-5.6./storage/innobase/os/os0file.cc:
# 0x0000000000d4deca in fil_aio_wait (segment=) at /usr/src/mysql-5.6./storage/innobase/fil/fil0fil.cc:
# 0x0000000000c6e122 in io_handler_thread (arg=0x1829c40 <n+>) at /usr/src/mysql-5.6./storage/innobase/srv/srv0start.cc:
# 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.
# 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.
# 0x0000000000000000 in ?? ()
Thread (Thread 0x7fc15dbb9940 (LWP )):
# 0x00000030738005b4 in ?? () from /usr/lib64/libaio.so.
# 0x0000000000ba441d in os_aio_linux_collect (array=0x1973980, segment=, seg_size=) at /usr/src/mysql-5.6./storage/innobase/os/os0file.cc:
# 0x0000000000ba4be2 in os_aio_linux_handle (global_seg=, message1=0x7fc15dbb90e0, message2=0x7fc15dbb90d8, type=0x7fc15dbb90d0) at /usr/src/mysql-5.6./storage/innobase/os/os0file.cc:
# 0x0000000000d4deca in fil_aio_wait (segment=) at /usr/src/mysql-5.6./storage/innobase/fil/fil0fil.cc:
# 0x0000000000c6e122 in io_handler_thread (arg=0x1829c48 <n+>) at /usr/src/mysql-5.6./storage/innobase/srv/srv0start.cc:
# 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.
# 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.
# 0x0000000000000000 in ?? ()
Thread 17 (Thread 0x7fc15d3b8940 (LWP 4050)): y.ibd innodb_table_stats.ibd innodb_index_stats.ibd
# 0x00000030738005b4 in ?? () from /usr/lib64/libaio.so.
# 0x0000000000ba441d in os_aio_linux_collect (array=0x19961a0, segment=, seg_size=) at /usr/src/mysql-5.6./storage/innobase/os/os0file.cc:
# 0x0000000000ba4be2 in os_aio_linux_handle (global_seg=, message1=0x7fc15d3b80e0, message2=0x7fc15d3b80d8, type=0x7fc15d3b80d0) at /usr/src/mysql-5.6./storage/innobase/os/os0file.cc:
# 0x0000000000d4deca in fil_aio_wait (segment=) at /usr/src/mysql-5.6./storage/innobase/fil/fil0fil.cc:
# 0x0000000000c6e122 in io_handler_thread (arg=0x1829c50 <n+>) at /usr/src/mysql-5.6./storage/innobase/srv/srv0start.cc:
# 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.
# 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.
# 0x0000000000000000 in ?? ()
Thread (Thread 0x7fc15cbb7940 (LWP )):
# 0x00000030738005b4 in ?? () from /usr/lib64/libaio.so.
# 0x0000000000ba441d in os_aio_linux_collect (array=0x19961a0, segment=, seg_size=) at /usr/src/mysql-5.6./storage/innobase/os/os0file.cc:
# 0x0000000000ba4be2 in os_aio_linux_handle (global_seg=, message1=0x7fc15cbb70e0, message2=0x7fc15cbb70d8, type=0x7fc15cbb70d0) at /usr/src/mysql-5.6./storage/innobase/os/os0file.cc:
# 0x0000000000d4deca in fil_aio_wait (segment=) at /usr/src/mysql-5.6./storage/innobase/fil/fil0fil.cc:
# 0x0000000000c6e122 in io_handler_thread (arg=0x1829c58 <n+>) at /usr/src/mysql-5.6./storage/innobase/srv/srv0start.cc:
# 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.
# 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.
# 0x0000000000000000 in ?? ()
Thread (Thread 0x7fc15c3b6940 (LWP )):
# 0x00000030738005b4 in ?? () from /usr/lib64/libaio.so.
# 0x0000000000ba441d in os_aio_linux_collect (array=0x19961a0, segment=, seg_size=) at /usr/src/mysql-5.6./storage/innobase/os/os0file.cc:
# 0x0000000000ba4be2 in os_aio_linux_handle (global_seg=, message1=0x7fc15c3b60e0, message2=0x7fc15c3b60d8, type=0x7fc15c3b60d0) at /usr/src/mysql-5.6./storage/innobase/os/os0file.cc:
# 0x0000000000d4deca in fil_aio_wait (segment=) at /usr/src/mysql-5.6./storage/innobase/fil/fil0fil.cc:
# 0x0000000000c6e122 in io_handler_thread (arg=0x1829c60 <n+>) at /usr/src/mysql-5.6./storage/innobase/srv/srv0start.cc:
# 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.
# 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.
# 0x0000000000000000 in ?? ()
Thread (Thread 0x7fc15bbb5940 (LWP )):
# 0x00000030738005b4 in ?? () from /usr/lib64/libaio.so.
# 0x0000000000ba441d in os_aio_linux_collect (array=0x19961a0, segment=, seg_size=) at /usr/src/mysql-5.6./storage/innobase/os/os0file.cc:
# 0x0000000000ba4be2 in os_aio_linux_handle (global_seg=, message1=0x7fc15bbb50e0, message2=0x7fc15bbb50d8, type=0x7fc15bbb50d0) at /usr/src/mysql-5.6./storage/innobase/os/os0file.cc:
# 0x0000000000d4deca in fil_aio_wait (segment=) at /usr/src/mysql-5.6./storage/innobase/fil/fil0fil.cc:
# 0x0000000000c6e122 in io_handler_thread (arg=0x1829c68 <n+>) at /usr/src/mysql-5.6./storage/innobase/srv/srv0start.cc:
# 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.
# 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.
# 0x0000000000000000 in ?? ()
Thread (Thread 0x7fc15b3b4940 (LWP )):
# 0x00007fc1bf7c4280 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.
# 0x0000000000baa77b in os_cond_wait_timed (cond=0x4768390, fast_mutex=0x4768350, abstime=0x7fc15b3b40c0) at /usr/src/mysql-5.6./storage/innobase/os/os0sync.cc:
# 0x0000000000baa9b0 in os_event_wait_time_low (event=0x4768350, time_in_usec=, reset_sig_count=) at /usr/src/mysql-5.6./storage/innobase/os/os0sync.cc:
# 0x0000000000b88945 in lock_wait_timeout_thread (arg=0x0) at /usr/src/mysql-5.6./storage/innobase/lock/lock0wait.cc:
# 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.
# 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.
# 0x0000000000000000 in ?? ()
Thread (Thread 0x7fc15abb3940 (LWP )):
# 0x00007fc1bf7c4280 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.
# 0x0000000000baa77b in os_cond_wait_timed (cond=0x194ebc0, fast_mutex=0x194eb80, abstime=0x7fc15abb3080) at /usr/src/mysql-5.6./storage/innobase/os/os0sync.cc:
# 0x0000000000baa9b0 in os_event_wait_time_low (event=0x194eb80, time_in_usec=, reset_sig_count=) at /usr/src/mysql-5.6./storage/innobase/os/os0sync.cc:
# 0x0000000000c65ce8 in srv_error_monitor_thread (arg=0x0) at /usr/src/mysql-5.6./storage/innobase/srv/srv0srv.cc:
# 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.
# 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.
# 0x0000000000000000 in ?? ()
Thread (Thread 0x7fc159ecc940 (LWP )):
# 0x00007fc1bf7c4280 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.
# 0x0000000000baa77b in os_cond_wait_timed (cond=0x194ec50, fast_mutex=0x194ec10, abstime=0x7fc159ecc090) at /usr/src/mysql-5.6./storage/innobase/os/os0sync.cc:
# 0x0000000000baa9b0 in os_event_wait_time_low (event=0x194ec10, time_in_usec=, reset_sig_count=) at /usr/src/mysql-5.6./storage/innobase/os/os0sync.cc:
# 0x0000000000c66e58 in srv_monitor_thread (arg=0x0) at /usr/src/mysql-5.6./storage/innobase/srv/srv0srv.cc:
# 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.
# 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.
# 0x0000000000000000 in ?? ()
Thread (Thread 0x7fc159290940 (LWP )):
# 0x00007fc1bec66172 in select () from /lib64/libc.so.
# 0x0000000000bab334 in os_thread_sleep (tm=) at /usr/src/mysql-5.6./storage/innobase/os/os0thread.cc:
# 0x0000000000c64c96 in srv_master_sleep () at /usr/src/mysql-5.6./storage/innobase/srv/srv0srv.cc:
# 0x0000000000c65853 in srv_master_thread (arg=0x0) at /usr/src/mysql-5.6./storage/innobase/srv/srv0srv.cc:
# 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.
# 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.
# 0x0000000000000000 in ?? ()
Thread (Thread 0x7fc158a8f940 (LWP )):
# 0x00007fc1bf7c4019 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.
# 0x0000000000baaa63 in os_cond_wait (cond=0x194eb30, fast_mutex=0x194eaf0) at /usr/src/mysql-5.6./storage/innobase/os/os0sync.cc:
# 0x0000000000baaadf in os_event_wait_low (event=0x194eaf0, reset_sig_count=) at /usr/src/mysql-5.6./storage/innobase/os/os0sync.cc:
# 0x0000000000c64129 in srv_purge_coordinator_suspend (slot=0x194ea20, rseg_history_len=) at /usr/src/mysql-5.6./storage/innobase/srv/srv0srv.cc:
# 0x0000000000c64639 in srv_purge_coordinator_thread (arg=0x0) at /usr/src/mysql-5.6./storage/innobase/srv/srv0srv.cc:
# 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.
# 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.
# 0x0000000000000000 in ?? ()
Thread (Thread 0x7fc15828e940 (LWP )):
# 0x00007fc1bec66172 in select () from /lib64/libc.so.
# 0x0000000000bab334 in os_thread_sleep (tm=) at /usr/src/mysql-5.6./storage/innobase/os/os0thread.cc:
# 0x0000000000cf9215 in page_cleaner_sleep_if_needed (next_loop_time=) at /usr/src/mysql-5.6./storage/innobase/buf/buf0flu.cc:
# 0x0000000000cfd758 in buf_flush_page_cleaner_thread (arg=0x0) at /usr/src/mysql-5.6./storage/innobase/buf/buf0flu.cc:
# 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.
# 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.
# 0x0000000000000000 in ?? ()
Thread (Thread 0x7fc157a8d940 (LWP )):
# 0x00007fc1bf7c4019 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.
# 0x0000000000baaa63 in os_cond_wait (cond=0x194ece0, fast_mutex=0x194eca0) at /usr/src/mysql-5.6./storage/innobase/os/os0sync.cc:
# 0x0000000000baaadf in os_event_wait_low (event=0x194eca0, reset_sig_count=) at /usr/src/mysql-5.6./storage/innobase/os/os0sync.cc:
# 0x0000000000cf6f1d in buf_dump_thread (arg=0x0) at /usr/src/mysql-5.6./storage/innobase/buf/buf0dump.cc:
# 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.
# 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.
# 0x0000000000000000 in ?? ()
Thread 6 (Thread 0x7fc15728c940 (LWP 4063)): log
# 0x00007fc1bf7c4280 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.
# 0x0000000000baa77b in os_cond_wait_timed (cond=0x476cde0, fast_mutex=0x476cda0, abstime=0x7fc15728c0e0) at /usr/src/mysql-5.6./storage/innobase/os/os0sync.cc:
# 0x0000000000baa9b0 in os_event_wait_time_low (event=0x476cda0, time_in_usec=, reset_sig_count=) at /usr/src/mysql-5.6./storage/innobase/os/os0sync.cc:
# 0x0000000000d44dd2 in dict_stats_thread (arg=0x0) at /usr/src/mysql-5.6./storage/innobase/dict/dict0stats_bg.cc:
# 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.
# 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.
# 0x0000000000000000 in ?? ()
Thread (Thread 0x7fc156a8b940 (LWP )):
# 0x00007fc1bf7c4280 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.
# 0x0000000000baa77b in os_cond_wait_timed (cond=0x47a30b0, fast_mutex=0x47a3070, abstime=0x7fc156a8b020) at /usr/src/mysql-5.6./storage/innobase/os/os0sync.cc:
# 0x0000000000baa9b0 in os_event_wait_time_low (event=0x47a3070, time_in_usec=, reset_sig_count=) at /usr/src/mysql-5.6./storage/innobase/os/os0sync.cc:
# 0x0000000000ca6df8 in ib_wqueue_timedwait (wq=0x47bb888, wait_in_usecs=) at /usr/src/mysql-5.6./storage/innobase/ut/ut0wqueue.cc:
# 0x0000000000d8173e in fts_optimize_thread (arg=0x47bb888) at /usr/src/mysql-5.6./storage/innobase/fts/fts0opt.cc:
# 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.
# 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.
# 0x0000000000000000 in ?? ()
Thread (Thread 0x7fc15a3b2940 (LWP )):
# 0x00007fc1bf7c79c8 in do_sigwait () from /lib64/libpthread.so.
# 0x00007fc1bf7c7a6d in sigwait () from /lib64/libpthread.so.
# 0x0000000000603688 in signal_hand (arg=0x0) at /usr/src/mysql-5.6./sql/mysqld.cc:
# 0x0000000000b11172 in pfs_spawn_thread (arg=0x7fc15000b9b0) at /usr/src/mysql-5.6./storage/perfschema/pfs.cc:
# 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.
# 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.
# 0x0000000000000000 in ?? ()
Thread 3 (Thread 0x7fc15a371940 (LWP 7089)): log
# 0x00007fc1bec640b6 in poll () from /lib64/libc.so.
# 0x0000000000e7da67 in vio_io_wait (vio=0x7fc150020b00, event=VIO_IO_EVENT_READ, timeout=) at /usr/src/mysql-5.6./vio/viosocket.c:
# 0x0000000000e7c350 in vio_socket_io_wait (vio=0x7fc150020b00, event=VIO_IO_EVENT_READ) at /usr/src/mysql-5.6./vio/viosocket.c:
# 0x0000000000e7c42b in vio_read (vio=0x7fc150020b00, buf=0x7fc150062f40 "\001", size=) at /usr/src/mysql-5.6./vio/viosocket.c:
# 0x0000000000709e3e in net_read_raw_loop (net=0x7fc15013e488, count=) at /usr/src/mysql-5.6./sql/net_serv.cc:
# 0x0000000000709ff7 in net_read_packet_header (net=0x7fc15013e488) at /usr/src/mysql-5.6./sql/net_serv.cc:
# 0x000000000070ade5 in net_read_packet (net=0x7fc15013e488, complen=0x7fc15a370f88) at /usr/src/mysql-5.6./sql/net_serv.cc:
# 0x000000000070af62 in my_net_read (net=0x7fc15013e488) at /usr/src/mysql-5.6./sql/net_serv.cc:
# 0x00000000007d9a30 in do_command (thd=0x7fc15013e230) at /usr/src/mysql-5.6./sql/sql_parse.cc:
# 0x000000000078e3fb in do_handle_one_connection (thd_arg=0x7fc15013e230) at /usr/src/mysql-5.6./sql/sql_connect.cc:
# 0x000000000078e4c1 in handle_one_connection (arg=0x7fc15013e230) at /usr/src/mysql-5.6./sql/sql_connect.cc:
# 0x0000000000b11172 in pfs_spawn_thread (arg=0x7fc15007d990) at /usr/src/mysql-5.6./storage/perfschema/pfs.cc:
# 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.
# 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.
# 0x0000000000000000 in ?? ()
Thread (Thread 0x7fc15a330940 (LWP )):
# 0x00007fc1bf7c4019 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.
# 0x0000000000abdfb0 in safe_cond_wait (cond=0x17ecc60 <COND_thread_cache>, mp=0x17ea080 <LOCK_thread_count>, file=0xee0078 "/usr/src/mysql-5.6.28/include/mysql/psi/mysql_thread.h", line=) at /usr/src/mysql-5.6./mysys/thr_mutex.c:
# 0x0000000000600361 in inline_mysql_cond_wait (that=0x17ecc60 <COND_thread_cache>, mutex=0x17ea080 <LOCK_thread_count>, src_file=0xedef70 "/usr/src/mysql-5.6.28/sql/mysqld.cc", src_line=) at /usr/src/mysql-5.6./include/mysql/psi/mysql_thread.h:
# 0x000000000060bced in block_until_new_connection () at /usr/src/mysql-5.6./sql/mysqld.cc:
# 0x000000000060bfc2 in one_thread_per_connection_end (thd=0x7fc1500baf10, block_pthread=true) at /usr/src/mysql-5.6./sql/mysqld.cc:
# 0x000000000078e45e in do_handle_one_connection (thd_arg=0x7fc1500baf10) at /usr/src/mysql-5.6./sql/sql_connect.cc:
# 0x000000000078e4c1 in handle_one_connection (arg=0x7fc1500baf10) at /usr/src/mysql-5.6./sql/sql_connect.cc:
# 0x0000000000b11172 in pfs_spawn_thread (arg=0x7fc1500a1960) at /usr/src/mysql-5.6./storage/perfschema/pfs.cc:
# 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.
# 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.
# 0x0000000000000000 in ?? ()
Thread (Thread 0x7fc1bfbd76f0 (LWP )):
# 0x00007fc1bec640b6 in poll () from /lib64/libc.so.
# 0x00000000006047fd in handle_connections_sockets () at /usr/src/mysql-5.6./sql/mysqld.cc:
# 0x000000000060b103 in mysqld_main (argc=, argv=0x1841d80) at /usr/src/mysql-5.6./sql/mysqld.cc:
# 0x00000000005fa9c3 in main (argc=, argv=0x7fff1208e778) at /usr/src/mysql-5.6./sql/main.cc: