mysql strace fsync,fdatasync

最新推荐文章于 2024-11-11 23:47:19 发布
最新推荐文章于 2024-11-11 23:47:19 发布
阅读量131 收藏
点赞数
文章标签： 数据库 网络
原文链接：http://www.cnblogs.com/zengkefu/p/5636367.html
版权 
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

 

转载于:https://www.cnblogs.com/zengkefu/p/5636367.html

weixin_30952535
关注
strace工具使用手册
Huangxiang6的博客
07-31 5429
strace工具使用手册 一、说明 ​ Strace是Linux中一个调试和跟踪工具。它可以接管被跟踪进程执行的系统调用和收到的信号。然后把每一个执行的系统调用的名字，参数和返回值打印出来。可以通过strace找到问题出现在user层还是kernel层。strace 显示这些调用的参数并返回符号形式的值。strace 从内核接收信息，而且不需要以任何特殊的方式来构建内核。 ...
MySQL innodb_flush_method/innodb_use_fdatasync
xiewen99的专栏
04-19 386
结论 8.0.26+ 配置 innodb_flush_method=O_DIRECT，innodb_use_fdatasync=ON 8.0.26- 配置 innodb_flush_method=O_DIRECT 环境 host1 Percona Server 8.0.26-16 host2 Percona Server 8.0.25-15 host3 sysbench 1.0.20 EL 7.6 4.14.35 ssd & ext4 sysbench: --tables=30 --table_
fsync mysql_mysql strace fsync,fdatasync
weixin_33624741的博客
01-19 98
#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/os0fil...
mysql 查看函数fsync_sync/fsync/fdatasync的简单比较
weixin_29188997的博客
12-24 246
此文主要转载自官网上有关于MySQL的flush method的设置参数说明，但可能很多人不太明白。下文就详细说明此问题。首先官网的说明如下：http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_flush_methodinnodb_flush_methodCommand-Line Format--i...
sync、fsync与fdatasync函数详解
formydream的博客
01-28 1650
在研究mysql配置文件中sync_binlog=N参数之中，发现该参数的含义是在N个SQL之后，调用了fdatasync()函数刷新binlog到磁盘，所以就好好研究了下sync、fsync和fdatasync这三个函数，也记录下来分享一波。 名词解释： 脏页：当进程修改了缓存中的数据时，该页就被标记为脏页 内存映射：一个文件到一块内存的映射 延迟写（delayed write）: 传统
MySQL 8.0 引入 innodb_flush_method 等新参数的系统调用分析
ActionTech的博客
01-30 1332
首先，让我们定义该参数的作用。它规定了 InnoDB 如何管理数据刷新到磁盘的行为。文章不会详细说明每个有效值的作用，更多详细介绍请查看参数值文档。fsyncO_DSYNClittlesyncnosyncO_DIRECT如前所述，我们将重点关注 O_DIRECT。作为最佳实践的一部分，我们建议选择 O_DIRECT 避免双缓冲，绕过操作系统缓存，从而提高写入数据时的性能。下面是从官方文档中摘录的 InnoDB 架构：在支持。
mysql pstack进程号,使用strace跟踪mysql的运行
weixin_28756427的博客
03-17 715
Strace简介官网：https://strace.io/strace是个功能强大的Linux调试分析诊断工具，可用于跟踪程序执行时进程系统调用(system call)和所接收的信号，尤其是针对源码不可读或源码无法再编译的程序。使用strace的正确姿势：• strace -T -tt -o /tmp/strace.log CMD• strace -T -tt CMD 2>&1 |...
免安装strace strace.zip
07-20
免安装strace [root@vmtca-2003 strace-5.1]# ldd strace linux-vdso.so.1 (0x00007ffc14ffb000) librt.so.1 => /lib64/librt.so.1 (0x00007fe620539000) libc.so.6 => /lib64/libc.so.6 (0x00007fe620174000) ...
strace-5.15 arm和arm64架构,Android可用
01-04
《strace-5.15在Android上的应用与解析》 在信息技术领域，尤其是在系统调试和性能分析中，strace是一个不可或缺的工具。它能够帮助我们跟踪和记录Linux系统调用，以及进程间的信号传递，从而揭示程序在操作系统...
strace命令 跟踪系统调用
01-09
strace命令是一个集诊断、调试、统计与一体的工具，我们可以使用strace对应用的系统调用和信号传递的跟踪结果来对应用进行分析，以达到解决问题或者是了解应用工作过程的目的。 strace常用来跟踪进程执行时的系统...
strace_pstack-master.zip_pstack_strace
09-21
在Linux系统中，`strace`和`pstack`是两个非常重要的系统调用跟踪工具，它们对于理解和调试进程的行为有着不可替代的作用。本压缩包`strace_pstack-master.zip`包含了与这两个工具相关的脚本，旨在帮助用户深入学习...
分布式存储系统——《MySQL海量数据存储与优化》_分布式海量数据的研发与调优
2401_84254279的博客
04-19 1012
数据库的事务隔离级别越高，并发问题就越小，但是并发处理能力越差（代价）。InnoDB自适应哈希索引是为了提升查询效率，InnoDB存储引擎会监控表上各个索引页的查询，当InnoDB注意到某些索引值访问非常频繁时，会在内存中基于B+Tree索引再创建一个哈希索引，使得内存中的 B+Tree 索引具备哈希索引的功能，即能够快速定值访问频繁访问的索引页。MySQL 默认采用异步复制方式，这样从节点不用一直访问主服务器来更新自己的数据，从节点可以复制主数据库中的所有数据库，或者特定的数据库，或者特定的表。
怎么处理MySQL延迟问题和数据刷盘？
weixin_62421895的博客
08-17 553
1、在类unix操作系统中，文件的打开方式为O_DIRECT会最小化缓冲对io的影响，该文件的io是直接在用户空间的buffer上操作的，并且io操作是同步的，因此不管是read()系统调用还是write()系统调用，数据都保证是从磁盘上读取的；默认datasync模式，整体表现较好，因为充分利用了操作系统buffer和innodb_buffer_pool的处理性能，但带来的负面效果是free内存降低过快，最后导致页交换频繁，磁盘IO压力大，这会严重影响大并发量数据写入的稳定性。...
sync/fsync/fdatasync的简单比较
I'm lovin' it
09-07 6292
之前在研究MySQL的一个参数innodb_flush_method时，就涉及到了fsync/fdatasync这些系统调用[system call]（什么是系统调用？它与库函数的区别在哪？参见这里）。接下来就简单的分析一下sync/fsync/fdatasync的区别。         sync()：int sync( void )这就是它的原型，A call to this function
ext4的fsync性能和nodelalloc参数的分析
╰☆╮EvilCode的专栏╭☆╯
11-24 1万+
原文：http://blog.thinksrc.com/?p=189001 感叹归感叹，发泄完了还得继续过。 前几天忙的不可开交，周报上面竟然能列出11项，想想以前在T公司时候的清闲，现在的老板的真幸运了。 好了，言归正传。 我们的系统是使用ext4作为文件系统的，ext4怎么好呢？ 主要是我对它感觉比较好，呵呵，开玩笑的。还记得第一次使用一个全新的ext4作为文件系统（不
针对innodb_flush_method参数的理解和对比测试（mycat+mysql）
Data & Analysis
03-15 350
mysql的innodb_flush_method这个参数控制着innodb数据文件及redo log的打开、刷写模式，对于这个参数，文档上是这样描述的： 有三个值：fdatasync(默认)，O_DSYNC，O_DIRECT 默认是fdatasync，调用fsync()去刷数据文件与redo log的buffer 为O_DSYNC时，innodb会使用O_SYNC方式打开和刷写redo l...
2020-10-15：mysql的双1设置是什么？
福大大架构师每日一题
10-15 6372
福哥答案2020-10-15：#福大大架构师每日一题# 答案来自知乎： 其实就是innodb_flush_log_at_trx_commit和sync_binlog两个参数设置，都设置为1就是双1设置。MySQL 默认配置就是双1配置。 innodb_flush_log_at_trx_commit 是 innodb 引擎的配置，sync_binlog 是 MySQL 引擎上层的配置，都是控制磁盘写入策略。 MySQL innoDB引擎在事务 commit 之后： 1.binlog 写内存。 2.redo l
函数sync、fsync与fdatasync总结整理
热门推荐
Yancygao的专栏
07-13 1万+
脏页:linux内核中的概念，因为硬盘的读写速度远赶不上内存的速度，系统就把读写比较频繁的数据事 先放到内存中，以提高读写速度，这就叫高速缓存，linux是以页作为高速缓存的单位，当进程修改了高速缓存里 的数据时，该页就被内核标记为脏页，内核将会在合适的时间把脏页的数据写到磁盘中去，以保持高速缓存中的 数据和磁盘中的数据是一致的。       内存映射：内存映射文件，是由一个文件到一块内存
redhat 7.6 oracle 19c 单机离线安装（文末附安装的虚拟机，可以直接运行）
最新发布
hf191850699的专栏
11-11 718
Oracle 19c离线单机的安装，包括补丁，后期的配置和维护等常用命令记录，文末有实验的虚拟机，下载就可以打开。
利用strace进行故障注入
"strace作为故障注入工具" "strace" 是一个在Linux系统中广泛使用的诊断、调试和教学用户空间工具。它允许用户监控进程与Linux内核之间的交互，包括系统调用、信号传递和进程状态变化。由于其命令行界面（CLI）和...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值