fsync mysql_mysql strace fsync,fdatasync

#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 ) 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 ??()

Thread16 (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 ) 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 ??()

Thread15 (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 ) 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 ??()

Thread14 (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 ) 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 ??()

Thread13 (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 ??()

Thread12 (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 ??()

Thread11 (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 ??()

Thread10 (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 ??()

Thread9 (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 ??()

Thread8 (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 ??()

Thread7 (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 ??()

Thread6 (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 ??()

Thread5 (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 ??()

Thread4 (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 ??()

Thread3 (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 ??()

Thread2 (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 , mp=0x17ea080 , 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 , mutex=0x17ea080 , 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 ??()

Thread1 (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