前景：分析底层mysql sync的IO数据大小，用于条带化分析和优化
安装kernel debug info
yum install kernel-debuginfo kernel-debuginfo-common
- probe module("ext4").function("ext4_sync_file")
- {
- if( execname()=="mysqld") {
- printf("%s , %s, %d %u \n",pp(),tz_ctime(gettimeofday_s()),cpu(),gettimeofday_ns())
- printf("%s , %ld, %ld, %d \n",kernel_string($file->f_path->dentry->d_name->name),$start,$end,$datasync)
- }
- }
- probe kernel.function("filemap_write_and_wait_range")
- {
- if( execname()=="mysqld")
- printf(" %ld, %ld, %ld \n",$lstart, $lend, ($lend - $lstart))
- print_backtrace()
- }
sudo stap -v ext4_sync.stp
可以看到logfile都是按16k写出：
|
module("ext4").function("ext4_sync_file@fs/ext4/fsync.c:88") , Thu Mar 16 21:52:18 2017 CST, 13 1489672338942480490 ib_logfile1 , 0, 9223372036854775807, 0 0, 9223372036854775807, 9223372036854775807 0xffffffff811677c0 : filemap_write_and_wait_range+0x0/0x70 [kernel] 0xffffffffa032b7aa : ext4_sync_file+0xba/0x320 [ext4] 0xffffffff8120dee2 : vfs_fsync_range+0x42/0xb0 [kernel] 0xffffffff8120dfc0 : do_fsync+0x50/0x90 [kernel] 0xffffffff8120e2e0 : SyS_fsync+0x10/0x20 [kernel] 0xffffffff81641fc9 : system_call_fastpath+0x16/0x1b [kernel] 35439378432, 35439394815, 16383 0xffffffff811677c0 : filemap_write_and_wait_range+0x0/0x70 [kernel] 0xffffffff81168015 : generic_file_direct_write+0x95/0x190 [kernel] 0xffffffff8116842c : __generic_file_aio_write+0x31c/0x3e0 [kernel] 0xffffffffa032ad5c : ext4_file_write+0x2ac/0x460 [ext4] 0xffffffff811dbaed : do_sync_write+0x8d/0xd0 [kernel] 0xffffffff811dc30d : vfs_write+0xbd/0x1e0 [kernel] 0xffffffff811dcf62 : sys_pwrite64+0x92/0xc0 [kernel] 0xffffffff81641fc9 : system_call_fastpath+0x16/0x1b [kernel] 5346672640, 5346689023, 16383 0xffffffff811677c0 : filemap_write_and_wait_range+0x0/0x70 [kernel] 0xffffffff81168015 : generic_file_direct_write+0x95/0x190 [kernel] 0xffffffff8116842c : __generic_file_aio_write+0x31c/0x3e0 [kernel] 0xffffffffa032ad5c : ext4_file_write+0x2ac/0x460 [ext4] 0xffffffff811dbaed : do_sync_write+0x8d/0xd0 [kernel] 0xffffffff811dc30d : vfs_write+0xbd/0x1e0 [kernel] 0xffffffff811dcf62 : sys_pwrite64+0x92/0xc0 [kernel] 0xffffffff81641fc9 : system_call_fastpath+0x16/0x1b [kernel] 35553755136, 35553771519, 16383 0xffffffff811677c0 : filemap_write_and_wait_range+0x0/0x70 [kernel] 0xffffffff81168015 : generic_file_direct_write+0x95/0x190 [kernel] 0xffffffff8116842c : __generic_file_aio_write+0x31c/0x3e0 [kernel] 0xffffffffa032ad5c : ext4_file_write+0x2ac/0x460 [ext4] 0xffffffff811dbaed : do_sync_write+0x8d/0xd0 [kernel] 0xffffffff811dc30d : vfs_write+0xbd/0x1e0 [kernel] 0xffffffff811dcf62 : sys_pwrite64+0x92/0xc0 [kernel] 0xffffffff81641fc9 : system_call_fastpath+0x16/0x1b [kernel] 46601191424, 46601207807, 16383 0xffffffff811677c0 : filemap_write_and_wait_range+0x0/0x70 [kernel] 0xffffffff81168015 : generic_file_direct_write+0x95/0x190 [kernel] 0xffffffff8116842c : __generic_file_aio_write+0x31c/0x3e0 [kernel] 0xffffffffa032ad5c : ext4_file_write+0x2ac/0x460 [ext4] 0xffffffff811dbaed : do_sync_write+0x8d/0xd0 [kernel] 0xffffffff811dc30d : vfs_write+0xbd/0x1e0 [kernel] 0xffffffff811dcf62 : sys_pwrite64+0x92/0xc0 [kernel] 0xffffffff81641fc9 : system_call_fastpath+0x16/0x1b [kernel] 60283502592, 60283518975, 16383 0xffffffff811677c0 : filemap_write_and_wait_range+0x0/0x70 [kernel] 0xffffffff81168015 : generic_file_direct_write+0x95/0x190 [kernel] 0xffffffff8116842c : __generic_file_aio_write+0x31c/0x3e0 [kernel] 0xffffffffa032ad5c : ext4_file_write+0x2ac/0x460 [ext4] 0xffffffff811dbaed : do_sync_write+0x8d/0xd0 [kernel] 0xffffffff811dc30d : vfs_write+0xbd/0x1e0 [kernel] 0xffffffff811dcf62 : sys_pwrite64+0x92/0xc0 [kernel] 0xffffffff81641fc9 : system_call_fastpath+0x16/0x1b [kernel] 63991283712, 63991300095, 16383 0xffffffff811677c0 : filemap_write_and_wait_range+0x0/0x70 [kernel] 0xffffffff81168015 : generic_file_direct_write+0x95/0x190 [kernel] 0xffffffff8116842c : __generic_file_aio_write+0x31c/0x3e0 [kernel] 0xffffffffa032ad5c : ext4_file_write+0x2ac/0x460 [ext4] 0xffffffff811dbaed : do_sync_write+0x8d/0xd0 [kernel] 0xffffffff811dc30d : vfs_write+0xbd/0x1e0 [kernel] 0xffffffff811dcf62 : sys_pwrite64+0x92/0xc0 [kernel] 0xffffffff81641fc9 : system_call_fastpath+0x16/0x1b [kernel] 89684754432, 89684770815, 16383 0xffffffff811677c0 : filemap_write_and_wait_range+0x0/0x70 [kernel] 0xffffffff81168015 : generic_file_direct_write+0x95/0x190 [kernel] 0xffffffff8116842c : __generic_file_aio_write+0x31c/0x3e0 [kernel] 0xffffffffa032ad5c : ext4_file_write+0x2ac/0x460 [ext4] 0xffffffff811dbaed : do_sync_write+0x8d/0xd0 [kernel] 0xffffffff811dc30d : vfs_write+0xbd/0x1e0 [kernel] 0xffffffff811dcf62 : sys_pwrite64+0x92/0xc0 [kernel] 0xffffffff81641fc9 : system_call_fastpath+0x16/0x1b [kernel] 19488227328, 19488243711, 16383 0xffffffff811677c0 : filemap_write_and_wait_range+0x0/0x70 [kernel] 0xffffffff81168015 : generic_file_direct_write+0x95/0x190 [kernel] 0xffffffff8116842c : __generic_file_aio_write+0x31c/0x3e0 [kernel] 0xffffffffa032ad5c : ext4_file_write+0x2ac/0x460 [ext4] 0xffffffff811dbaed : do_sync_write+0x8d/0xd0 [kernel] 0xffffffff811dc30d : vfs_write+0xbd/0x1e0 [kernel] 0xffffffff811dcf62 : sys_pwrite64+0x92/0xc0 [kernel] 0xffffffff81641fc9 : system_call_fastpath+0x16/0x1b [kernel] 75220402176, 75220418559, 16383 0xffffffff811677c0 : filemap_write_and_wait_range+0x0/0x70 [kernel] 0xffffffff81168015 : generic_file_direct_write+0x95/0x190 [kernel] 0xffffffff8116842c : __generic_file_aio_write+0x31c/0x3e0 [kernel] 0xffffffffa032ad5c : ext4_file_write+0x2ac/0x460 [ext4] 0xffffffff811dbaed : do_sync_write+0x8d/0xd0 [kernel] 0xffffffff811dc30d : vfs_write+0xbd/0x1e0 [kernel] 0xffffffff811dcf62 : sys_pwrite64+0x92/0xc0 [kernel] 0xffffffff81641fc9 : system_call_fastpath+0x16/0x1b [kernel] |
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/30088583/viewspace-2136681/ ，如需转载，请注明出处，否则将追究法律责任。
