mysql> show create table y;
+-------+------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+------------------------------------------------------------------------------------+
| y | CREATE TABLE `y` (
`a` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+-------+------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
insert into y select 2;
[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 4043
COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME
mysqld 4043 mysql cwd DIR 8,2 4096 3900075 /data
mysqld 4043 mysql rtd DIR 8,2 4096 2 /
mysqld 4043 mysql txt REG 8,2 99818078 1315410 /usr/local/mysql56/bin/mysqld
mysqld 4043 mysql mem REG 8,2 5328 1296493 /usr/lib64/libaio.so.1.0.1
mysqld 4043 mysql mem REG 8,2 58400 2982207 /lib64/libgcc_s-4.1.2-20080825.so.1
mysqld 4043 mysql mem REG 8,2 976312 1286514 /usr/lib64/libstdc++.so.6.0.8
mysqld 4043 mysql mem REG 8,2 53880 2982189 /lib64/libnss_files-2.5.so
mysqld 4043 mysql mem REG 8,2 1720712 2981897 /lib64/libc-2.5.so
mysqld 4043 mysql mem REG 8,2 611736 2982186 /lib64/libm-2.5.so
mysqld 4043 mysql mem REG 8,2 20424 2982185 /lib64/libdl-2.5.so
mysqld 4043 mysql mem REG 8,2 45728 2981901 /lib64/libcrypt-2.5.so
mysqld 4043 mysql mem REG 8,2 50288 2982192 /lib64/librt-2.5.so
mysqld 4043 mysql mem REG 8,2 146840 2981921 /lib64/libpthread-2.5.so
mysqld 4043 mysql mem REG 8,2 142488 4098550 /lib64/ld-2.5.so
mysqld 4043 mysql 0u CHR 136,1 4 /dev/pts/1 (deleted)
mysqld 4043 mysql 1u CHR 136,1 4 /dev/pts/1 (deleted)
mysqld 4043 mysql 2u CHR 136,1 4 /dev/pts/1 (deleted)
mysqld 4043 mysql 3u REG 8,2 407 754743 /data/1.index
mysqld 4043 mysql 4uW REG 8,2 79691776 3899547 /data/ibdata1
mysqld 4043 mysql 5u REG 8,2 0 2457607 /tmp/ibfdLTdG (deleted)
mysqld 4043 mysql 6u REG 8,2 0 2457608 /tmp/ibv1eHOO (deleted)
mysqld 4043 mysql 7u REG 8,2 0 2457609 /tmp/ibdPkvpX (deleted)
mysqld 4043 mysql 8u REG 8,2 0 2457610 /tmp/ibbu44op (deleted)
mysqld 4043 mysql 9uW REG 8,2 50331648 3899548 /data/ib_logfile0
mysqld 4043 mysql 10uW REG 8,2 50331648 3899549 /data/ib_logfile1
mysqld 4043 mysql 11uW REG 8,2 98304 820502 /data/test/rank_status_no.ibd
mysqld 4043 mysql 12uW REG 8,2 98304 3900109 /data/mysql/innodb_table_stats.ibd
mysqld 4043 mysql 13uW REG 8,2 98304 820496 /data/test/rank_status_yes.ibd
mysqld 4043 mysql 14uW REG 8,2 98304 3900111 /data/mysql/innodb_index_stats.ibd
mysqld 4043 mysql 15u REG 8,2 0 2457611 /tmp/ibJe2XXK (deleted)
mysqld 4043 mysql 16u unix 0xffff880022561480 13971 /tmp/mysql.sock
mysqld 4043 mysql 17u IPv6 8841 TCP *:mysql (LISTEN)
mysqld 4043 mysql 18u unix 0xffff88000b9d8e80 8842 /tmp/mysql.sock
mysqld 4043 mysql 19uW REG 8,2 98304 820503 /data/test/tbl_a.ibd
mysqld 4043 mysql 20uW REG 8,2 98304 820505 /data/test/y.ibd
mysqld 4043 mysql 21u REG 8,2 2048 820499 /data/test/t.MYI
mysqld 4043 mysql 22u REG 8,2 7 820506 /data/test/t.MYD
mysqld 4043 mysql 33uW REG 8,2 98304 3900115 /data/mysql/slave_master_info.ibd
mysqld 4043 mysql 34uW REG 8,2 98304 3900117 /data/mysql/slave_worker_info.ibd
mysqld 4043 mysql 35uW REG 8,2 98304 3900113 /data/mysql/slave_relay_log_info.ibd
mysqld 4043 mysql 36w REG 8,2 7409 754742 /data/1.000037
(gdb) thread apply all bt
Thread 23 (Thread 0x7fc1603be940 (LWP 4044)):
#0 0x00000030738005b4 in ?? () from /usr/lib64/libaio.so.1
#1 0x0000000000ba441d in os_aio_linux_collect (array=0x1988ee0, segment=0, seg_size=256) at /usr/src/mysql-5.6.28/storage/innobase/os/os0file.cc:4975
#2 0x0000000000ba4be2 in os_aio_linux_handle (global_seg=0, message1=0x7fc1603be0e0, message2=0x7fc1603be0d8, type=0x7fc1603be0d0) at /usr/src/mysql-5.6.28/storage/innobase/os/os0file.cc:5119
#3 0x0000000000d4deca in fil_aio_wait (segment=0) at /usr/src/mysql-5.6.28/storage/innobase/fil/fil0fil.cc:5796
#4 0x0000000000c6e122 in io_handler_thread (arg=0x1829c20 <n>) at /usr/src/mysql-5.6.28/storage/innobase/srv/srv0start.cc:492
#5 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.0
#6 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.6
#7 0x0000000000000000 in ?? ()
Thread 22 (Thread 0x7fc15fbbd940 (LWP 4045)):
#0 0x00000030738005b4 in ?? () from /usr/lib64/libaio.so.1
#1 0x0000000000ba441d in os_aio_linux_collect (array=0x197bc40, segment=0, seg_size=256) at /usr/src/mysql-5.6.28/storage/innobase/os/os0file.cc:4975
#2 0x0000000000ba4be2 in os_aio_linux_handle (global_seg=1, message1=0x7fc15fbbd0e0, message2=0x7fc15fbbd0d8, type=0x7fc15fbbd0d0) at /usr/src/mysql-5.6.28/storage/innobase/os/os0file.cc:5119
#3 0x0000000000d4deca in fil_aio_wait (segment=1) at /usr/src/mysql-5.6.28/storage/innobase/fil/fil0fil.cc:5796
#4 0x0000000000c6e122 in io_handler_thread (arg=0x1829c28 <n+8>) at /usr/src/mysql-5.6.28/storage/innobase/srv/srv0start.cc:492
#5 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.0
#6 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.6
#7 0x0000000000000000 in ?? ()
Thread 21 (Thread 0x7fc15f3bc940 (LWP 4046)):
#0 0x00000030738005b4 in ?? () from /usr/lib64/libaio.so.1
#1 0x0000000000ba441d in os_aio_linux_collect (array=0x1973980, segment=0, seg_size=256) at /usr/src/mysql-5.6.28/storage/innobase/os/os0file.cc:4975
#2 0x0000000000ba4be2 in os_aio_linux_handle (global_seg=2, message1=0x7fc15f3bc0e0, message2=0x7fc15f3bc0d8, type=0x7fc15f3bc0d0) at /usr/src/mysql-5.6.28/storage/innobase/os/os0file.cc:5119
#3 0x0000000000d4deca in fil_aio_wait (segment=2) at /usr/src/mysql-5.6.28/storage/innobase/fil/fil0fil.cc:5796
#4 0x0000000000c6e122 in io_handler_thread (arg=0x1829c30 <n+16>) at /usr/src/mysql-5.6.28/storage/innobase/srv/srv0start.cc:492
#5 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.0
#6 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.6
#7 0x0000000000000000 in ?? ()
Thread 20 (Thread 0x7fc15ebbb940 (LWP 4047)):
#0 0x00000030738005b4 in ?? () from /usr/lib64/libaio.so.1
#1 0x0000000000ba441d in os_aio_linux_collect (array=0x1973980, segment=1, seg_size=256) at /usr/src/mysql-5.6.28/storage/innobase/os/os0file.cc:4975
#2 0x0000000000ba4be2 in os_aio_linux_handle (global_seg=3, message1=0x7fc15ebbb0e0, message2=0x7fc15ebbb0d8, type=0x7fc15ebbb0d0) at /usr/src/mysql-5.6.28/storage/innobase/os/os0file.cc:5119
#3 0x0000000000d4deca in fil_aio_wait (segment=3) at /usr/src/mysql-5.6.28/storage/innobase/fil/fil0fil.cc:5796
#4 0x0000000000c6e122 in io_handler_thread (arg=0x1829c38 <n+24>) at /usr/src/mysql-5.6.28/storage/innobase/srv/srv0start.cc:492
#5 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.0
#6 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.6
#7 0x0000000000000000 in ?? ()
Thread 19 (Thread 0x7fc15e3ba940 (LWP 4048)):
#0 0x00000030738005b4 in ?? () from /usr/lib64/libaio.so.1
#1 0x0000000000ba441d in os_aio_linux_collect (array=0x1973980, segment=2, seg_size=256) at /usr/src/mysql-5.6.28/storage/innobase/os/os0file.cc:4975
#2 0x0000000000ba4be2 in os_aio_linux_handle (global_seg=4, message1=0x7fc15e3ba0e0, message2=0x7fc15e3ba0d8, type=0x7fc15e3ba0d0) at /usr/src/mysql-5.6.28/storage/innobase/os/os0file.cc:5119
#3 0x0000000000d4deca in fil_aio_wait (segment=4) at /usr/src/mysql-5.6.28/storage/innobase/fil/fil0fil.cc:5796
#4 0x0000000000c6e122 in io_handler_thread (arg=0x1829c40 <n+32>) at /usr/src/mysql-5.6.28/storage/innobase/srv/srv0start.cc:492
#5 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.0
#6 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.6
#7 0x0000000000000000 in ?? ()
Thread 18 (Thread 0x7fc15dbb9940 (LWP 4049)):
#0 0x00000030738005b4 in ?? () from /usr/lib64/libaio.so.1
#1 0x0000000000ba441d in os_aio_linux_collect (array=0x1973980, segment=3, seg_size=256) at /usr/src/mysql-5.6.28/storage/innobase/os/os0file.cc:4975
#2 0x0000000000ba4be2 in os_aio_linux_handle (global_seg=5, message1=0x7fc15dbb90e0, message2=0x7fc15dbb90d8, type=0x7fc15dbb90d0) at /usr/src/mysql-5.6.28/storage/innobase/os/os0file.cc:5119
#3 0x0000000000d4deca in fil_aio_wait (segment=5) at /usr/src/mysql-5.6.28/storage/innobase/fil/fil0fil.cc:5796
#4 0x0000000000c6e122 in io_handler_thread (arg=0x1829c48 <n+40>) at /usr/src/mysql-5.6.28/storage/innobase/srv/srv0start.cc:492
#5 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.0
#6 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.6
#7 0x0000000000000000 in ?? ()
Thread 17 (Thread 0x7fc15d3b8940 (LWP 4050)): y.ibd innodb_table_stats.ibd innodb_index_stats.ibd
#0 0x00000030738005b4 in ?? () from /usr/lib64/libaio.so.1
#1 0x0000000000ba441d in os_aio_linux_collect (array=0x19961a0, segment=0, seg_size=256) at /usr/src/mysql-5.6.28/storage/innobase/os/os0file.cc:4975
#2 0x0000000000ba4be2 in os_aio_linux_handle (global_seg=6, message1=0x7fc15d3b80e0, message2=0x7fc15d3b80d8, type=0x7fc15d3b80d0) at /usr/src/mysql-5.6.28/storage/innobase/os/os0file.cc:5119
#3 0x0000000000d4deca in fil_aio_wait (segment=6) at /usr/src/mysql-5.6.28/storage/innobase/fil/fil0fil.cc:5796
#4 0x0000000000c6e122 in io_handler_thread (arg=0x1829c50 <n+48>) at /usr/src/mysql-5.6.28/storage/innobase/srv/srv0start.cc:492
#5 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.0
#6 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.6
#7 0x0000000000000000 in ?? ()
Thread 16 (Thread 0x7fc15cbb7940 (LWP 4051)):
#0 0x00000030738005b4 in ?? () from /usr/lib64/libaio.so.1
#1 0x0000000000ba441d in os_aio_linux_collect (array=0x19961a0, segment=1, seg_size=256) at /usr/src/mysql-5.6.28/storage/innobase/os/os0file.cc:4975
#2 0x0000000000ba4be2 in os_aio_linux_handle (global_seg=7, message1=0x7fc15cbb70e0, message2=0x7fc15cbb70d8, type=0x7fc15cbb70d0) at /usr/src/mysql-5.6.28/storage/innobase/os/os0file.cc:5119
#3 0x0000000000d4deca in fil_aio_wait (segment=7) at /usr/src/mysql-5.6.28/storage/innobase/fil/fil0fil.cc:5796
#4 0x0000000000c6e122 in io_handler_thread (arg=0x1829c58 <n+56>) at /usr/src/mysql-5.6.28/storage/innobase/srv/srv0start.cc:492
#5 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.0
#6 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.6
#7 0x0000000000000000 in ?? ()
Thread 15 (Thread 0x7fc15c3b6940 (LWP 4052)):
#0 0x00000030738005b4 in ?? () from /usr/lib64/libaio.so.1
#1 0x0000000000ba441d in os_aio_linux_collect (array=0x19961a0, segment=2, seg_size=256) at /usr/src/mysql-5.6.28/storage/innobase/os/os0file.cc:4975
#2 0x0000000000ba4be2 in os_aio_linux_handle (global_seg=8, message1=0x7fc15c3b60e0, message2=0x7fc15c3b60d8, type=0x7fc15c3b60d0) at /usr/src/mysql-5.6.28/storage/innobase/os/os0file.cc:5119
#3 0x0000000000d4deca in fil_aio_wait (segment=8) at /usr/src/mysql-5.6.28/storage/innobase/fil/fil0fil.cc:5796
#4 0x0000000000c6e122 in io_handler_thread (arg=0x1829c60 <n+64>) at /usr/src/mysql-5.6.28/storage/innobase/srv/srv0start.cc:492
#5 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.0
#6 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.6
#7 0x0000000000000000 in ?? ()
Thread 14 (Thread 0x7fc15bbb5940 (LWP 4053)):
#0 0x00000030738005b4 in ?? () from /usr/lib64/libaio.so.1
#1 0x0000000000ba441d in os_aio_linux_collect (array=0x19961a0, segment=3, seg_size=256) at /usr/src/mysql-5.6.28/storage/innobase/os/os0file.cc:4975
#2 0x0000000000ba4be2 in os_aio_linux_handle (global_seg=9, message1=0x7fc15bbb50e0, message2=0x7fc15bbb50d8, type=0x7fc15bbb50d0) at /usr/src/mysql-5.6.28/storage/innobase/os/os0file.cc:5119
#3 0x0000000000d4deca in fil_aio_wait (segment=9) at /usr/src/mysql-5.6.28/storage/innobase/fil/fil0fil.cc:5796
#4 0x0000000000c6e122 in io_handler_thread (arg=0x1829c68 <n+72>) at /usr/src/mysql-5.6.28/storage/innobase/srv/srv0start.cc:492
#5 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.0
#6 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.6
#7 0x0000000000000000 in ?? ()
Thread 13 (Thread 0x7fc15b3b4940 (LWP 4056)):
#0 0x00007fc1bf7c4280 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1 0x0000000000baa77b in os_cond_wait_timed (cond=0x4768390, fast_mutex=0x4768350, abstime=0x7fc15b3b40c0) at /usr/src/mysql-5.6.28/storage/innobase/os/os0sync.cc:177
#2 0x0000000000baa9b0 in os_event_wait_time_low (event=0x4768350, time_in_usec=1000000, reset_sig_count=1) at /usr/src/mysql-5.6.28/storage/innobase/os/os0sync.cc:705
#3 0x0000000000b88945 in lock_wait_timeout_thread (arg=0x0) at /usr/src/mysql-5.6.28/storage/innobase/lock/lock0wait.cc:503
#4 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.0
#5 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.6
#6 0x0000000000000000 in ?? ()
Thread 12 (Thread 0x7fc15abb3940 (LWP 4057)):
#0 0x00007fc1bf7c4280 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1 0x0000000000baa77b in os_cond_wait_timed (cond=0x194ebc0, fast_mutex=0x194eb80, abstime=0x7fc15abb3080) at /usr/src/mysql-5.6.28/storage/innobase/os/os0sync.cc:177
#2 0x0000000000baa9b0 in os_event_wait_time_low (event=0x194eb80, time_in_usec=1000000, reset_sig_count=1) at /usr/src/mysql-5.6.28/storage/innobase/os/os0sync.cc:705
#3 0x0000000000c65ce8 in srv_error_monitor_thread (arg=0x0) at /usr/src/mysql-5.6.28/storage/innobase/srv/srv0srv.cc:1769
#4 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.0
#5 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.6
#6 0x0000000000000000 in ?? ()
Thread 11 (Thread 0x7fc159ecc940 (LWP 4058)):
#0 0x00007fc1bf7c4280 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1 0x0000000000baa77b in os_cond_wait_timed (cond=0x194ec50, fast_mutex=0x194ec10, abstime=0x7fc159ecc090) at /usr/src/mysql-5.6.28/storage/innobase/os/os0sync.cc:177
#2 0x0000000000baa9b0 in os_event_wait_time_low (event=0x194ec10, time_in_usec=5000000, reset_sig_count=1) at /usr/src/mysql-5.6.28/storage/innobase/os/os0sync.cc:705
#3 0x0000000000c66e58 in srv_monitor_thread (arg=0x0) at /usr/src/mysql-5.6.28/storage/innobase/srv/srv0srv.cc:1538
#4 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.0
#5 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.6
#6 0x0000000000000000 in ?? ()
Thread 10 (Thread 0x7fc159290940 (LWP 4059)):
#0 0x00007fc1bec66172 in select () from /lib64/libc.so.6
#1 0x0000000000bab334 in os_thread_sleep (tm=1000000) at /usr/src/mysql-5.6.28/storage/innobase/os/os0thread.cc:261
#2 0x0000000000c64c96 in srv_master_sleep () at /usr/src/mysql-5.6.28/storage/innobase/srv/srv0srv.cc:2300
#3 0x0000000000c65853 in srv_master_thread (arg=0x0) at /usr/src/mysql-5.6.28/storage/innobase/srv/srv0srv.cc:2344
#4 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.0
#5 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.6
#6 0x0000000000000000 in ?? ()
Thread 9 (Thread 0x7fc158a8f940 (LWP 4060)):
#0 0x00007fc1bf7c4019 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1 0x0000000000baaa63 in os_cond_wait (cond=0x194eb30, fast_mutex=0x194eaf0) at /usr/src/mysql-5.6.28/storage/innobase/os/os0sync.cc:214
#2 0x0000000000baaadf in os_event_wait_low (event=0x194eaf0, reset_sig_count=26) at /usr/src/mysql-5.6.28/storage/innobase/os/os0sync.cc:592
#3 0x0000000000c64129 in srv_purge_coordinator_suspend (slot=0x194ea20, rseg_history_len=412) at /usr/src/mysql-5.6.28/storage/innobase/srv/srv0srv.cc:2634
#4 0x0000000000c64639 in srv_purge_coordinator_thread (arg=0x0) at /usr/src/mysql-5.6.28/storage/innobase/srv/srv0srv.cc:2753
#5 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.0
#6 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.6
#7 0x0000000000000000 in ?? ()
Thread 8 (Thread 0x7fc15828e940 (LWP 4061)):
#0 0x00007fc1bec66172 in select () from /lib64/libc.so.6
#1 0x0000000000bab334 in os_thread_sleep (tm=1000000) at /usr/src/mysql-5.6.28/storage/innobase/os/os0thread.cc:261
#2 0x0000000000cf9215 in page_cleaner_sleep_if_needed (next_loop_time=1467477197439) at /usr/src/mysql-5.6.28/storage/innobase/buf/buf0flu.cc:2375
#3 0x0000000000cfd758 in buf_flush_page_cleaner_thread (arg=0x0) at /usr/src/mysql-5.6.28/storage/innobase/buf/buf0flu.cc:2416
#4 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.0
#5 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.6
#6 0x0000000000000000 in ?? ()
Thread 7 (Thread 0x7fc157a8d940 (LWP 4062)):
#0 0x00007fc1bf7c4019 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1 0x0000000000baaa63 in os_cond_wait (cond=0x194ece0, fast_mutex=0x194eca0) at /usr/src/mysql-5.6.28/storage/innobase/os/os0sync.cc:214
#2 0x0000000000baaadf in os_event_wait_low (event=0x194eca0, reset_sig_count=1) at /usr/src/mysql-5.6.28/storage/innobase/os/os0sync.cc:592
#3 0x0000000000cf6f1d in buf_dump_thread (arg=0x0) at /usr/src/mysql-5.6.28/storage/innobase/buf/buf0dump.cc:594
#4 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.0
#5 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.6
#6 0x0000000000000000 in ?? ()
Thread 6 (Thread 0x7fc15728c940 (LWP 4063)): log
#0 0x00007fc1bf7c4280 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1 0x0000000000baa77b in os_cond_wait_timed (cond=0x476cde0, fast_mutex=0x476cda0, abstime=0x7fc15728c0e0) at /usr/src/mysql-5.6.28/storage/innobase/os/os0sync.cc:177
#2 0x0000000000baa9b0 in os_event_wait_time_low (event=0x476cda0, time_in_usec=10000000, reset_sig_count=11) at /usr/src/mysql-5.6.28/storage/innobase/os/os0sync.cc:705
#3 0x0000000000d44dd2 in dict_stats_thread (arg=0x0) at /usr/src/mysql-5.6.28/storage/innobase/dict/dict0stats_bg.cc:348
#4 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.0
#5 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.6
#6 0x0000000000000000 in ?? ()
Thread 5 (Thread 0x7fc156a8b940 (LWP 4064)):
#0 0x00007fc1bf7c4280 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1 0x0000000000baa77b in os_cond_wait_timed (cond=0x47a30b0, fast_mutex=0x47a3070, abstime=0x7fc156a8b020) at /usr/src/mysql-5.6.28/storage/innobase/os/os0sync.cc:177
#2 0x0000000000baa9b0 in os_event_wait_time_low (event=0x47a3070, time_in_usec=5000000, reset_sig_count=1) at /usr/src/mysql-5.6.28/storage/innobase/os/os0sync.cc:705
#3 0x0000000000ca6df8 in ib_wqueue_timedwait (wq=0x47bb888, wait_in_usecs=5000000) at /usr/src/mysql-5.6.28/storage/innobase/ut/ut0wqueue.cc:154
#4 0x0000000000d8173e in fts_optimize_thread (arg=0x47bb888) at /usr/src/mysql-5.6.28/storage/innobase/fts/fts0opt.cc:3000
#5 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.0
#6 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.6
#7 0x0000000000000000 in ?? ()
Thread 4 (Thread 0x7fc15a3b2940 (LWP 4065)):
#0 0x00007fc1bf7c79c8 in do_sigwait () from /lib64/libpthread.so.0
#1 0x00007fc1bf7c7a6d in sigwait () from /lib64/libpthread.so.0
#2 0x0000000000603688 in signal_hand (arg=0x0) at /usr/src/mysql-5.6.28/sql/mysqld.cc:3190
#3 0x0000000000b11172 in pfs_spawn_thread (arg=0x7fc15000b9b0) at /usr/src/mysql-5.6.28/storage/perfschema/pfs.cc:1860
#4 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.0
#5 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.6
#6 0x0000000000000000 in ?? ()
Thread 3 (Thread 0x7fc15a371940 (LWP 7089)): log
#0 0x00007fc1bec640b6 in poll () from /lib64/libc.so.6
#1 0x0000000000e7da67 in vio_io_wait (vio=0x7fc150020b00, event=VIO_IO_EVENT_READ, timeout=28800000) at /usr/src/mysql-5.6.28/vio/viosocket.c:771
#2 0x0000000000e7c350 in vio_socket_io_wait (vio=0x7fc150020b00, event=VIO_IO_EVENT_READ) at /usr/src/mysql-5.6.28/vio/viosocket.c:68
#3 0x0000000000e7c42b in vio_read (vio=0x7fc150020b00, buf=0x7fc150062f40 "\001", size=4) at /usr/src/mysql-5.6.28/vio/viosocket.c:123
#4 0x0000000000709e3e in net_read_raw_loop (net=0x7fc15013e488, count=4) at /usr/src/mysql-5.6.28/sql/net_serv.cc:669
#5 0x0000000000709ff7 in net_read_packet_header (net=0x7fc15013e488) at /usr/src/mysql-5.6.28/sql/net_serv.cc:751
#6 0x000000000070ade5 in net_read_packet (net=0x7fc15013e488, complen=0x7fc15a370f88) at /usr/src/mysql-5.6.28/sql/net_serv.cc:816
#7 0x000000000070af62 in my_net_read (net=0x7fc15013e488) at /usr/src/mysql-5.6.28/sql/net_serv.cc:894
#8 0x00000000007d9a30 in do_command (thd=0x7fc15013e230) at /usr/src/mysql-5.6.28/sql/sql_parse.cc:970
#9 0x000000000078e3fb in do_handle_one_connection (thd_arg=0x7fc15013e230) at /usr/src/mysql-5.6.28/sql/sql_connect.cc:982
#10 0x000000000078e4c1 in handle_one_connection (arg=0x7fc15013e230) at /usr/src/mysql-5.6.28/sql/sql_connect.cc:898
#11 0x0000000000b11172 in pfs_spawn_thread (arg=0x7fc15007d990) at /usr/src/mysql-5.6.28/storage/perfschema/pfs.cc:1860
#12 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.0
#13 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.6
#14 0x0000000000000000 in ?? ()
Thread 2 (Thread 0x7fc15a330940 (LWP 8703)):
#0 0x00007fc1bf7c4019 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1 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=1162) at /usr/src/mysql-5.6.28/mysys/thr_mutex.c:240
#2 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=2687) at /usr/src/mysql-5.6.28/include/mysql/psi/mysql_thread.h:1162
#3 0x000000000060bced in block_until_new_connection () at /usr/src/mysql-5.6.28/sql/mysqld.cc:2687
#4 0x000000000060bfc2 in one_thread_per_connection_end (thd=0x7fc1500baf10, block_pthread=true) at /usr/src/mysql-5.6.28/sql/mysqld.cc:2775
#5 0x000000000078e45e in do_handle_one_connection (thd_arg=0x7fc1500baf10) at /usr/src/mysql-5.6.28/sql/sql_connect.cc:989
#6 0x000000000078e4c1 in handle_one_connection (arg=0x7fc1500baf10) at /usr/src/mysql-5.6.28/sql/sql_connect.cc:898
#7 0x0000000000b11172 in pfs_spawn_thread (arg=0x7fc1500a1960) at /usr/src/mysql-5.6.28/storage/perfschema/pfs.cc:1860
#8 0x00007fc1bf7bf83d in start_thread () from /lib64/libpthread.so.0
#9 0x00007fc1bec6cfdd in clone () from /lib64/libc.so.6
#10 0x0000000000000000 in ?? ()
Thread 1 (Thread 0x7fc1bfbd76f0 (LWP 4043)):
#0 0x00007fc1bec640b6 in poll () from /lib64/libc.so.6
#1 0x00000000006047fd in handle_connections_sockets () at /usr/src/mysql-5.6.28/sql/mysqld.cc:6254
#2 0x000000000060b103 in mysqld_main (argc=9, argv=0x1841d80) at /usr/src/mysql-5.6.28/sql/mysqld.cc:5673
#3 0x00000000005fa9c3 in main (argc=5, argv=0x7fff1208e778) at /usr/src/mysql-5.6.28/sql/main.cc:25
本文章为转载内容，我们尊重原作者对文章享有的著作权。如有内容错误或侵权问题，欢迎原作者联系我们进行内容更正或删除文章。
