Chinaunix首页 | 论坛 | 博客

王恒-Henryhengwang.blog.chinaunix.net

首页　| 　博文目录　| 　关于我

king_wangheng

  • 博客访问： 1734134
  • 博文数量： 107
  • 博客积分： 1715
  • 博客等级： 上尉
  • 技术积分： 3168
  • 用 户 组： 普通用户
  • 注册时间： 2012-04-18 18:42
个人简介

阿里巴巴DBA，原去哪儿网DBA。专注于MySQL源码研究、DBA运维、CGroup虚拟化及Linux Kernel源码研究等。 github:https://github.com/HengWang/ Email：king_wangheng@163.com 微博 ：@王恒-Henry QQ ：506437736

文章分类

全部博文（107）

文章存档

2014年（2）

2013年（38）

2012年（67）

我的朋友
最近访客
推荐博文
相关博文
sysbench scripts（4）

分类： Mysql/postgreSQL

2012-05-11 15:17:42

4、analyze文件夹
1）analyze_global_innodb_dirty_page_ratio.sh脚本

点击(此处)折叠或打开

  1. #! /bin/sh

  3. ###########################################################
  4. # Copyright (c) 2012, Heng.Wang. All rights reserved.
  5. #
  6. # This program is used to analyze the dirty pages ratio.
  7. ###########################################################

  9. # set -x

  11. # Get the key value of input arguments format like '--args=value'.
  12. get_key_value()
  13. {
  14.     echo "$1" | sed 's/^--[a-zA-Z_-]*=//'
  15. }

  17. # Usage will be helpful when you need to input the valid arguments.
  18. usage()
  19. {
  20. cat <<EOF
  21. Usage: $0 [configure-options]
  22.   -?, --help Show this help message.
  23.   --input=<> Set the input file path.
  24.   --outputdir=<> Set the output directory.

  26. Note: this script is intended for internal use by developers.

  28. EOF
  29. }

  31. # Print the default value of the arguments of the script.
  32. print_default()
  33. {
  34. cat <<EOF
  35.   The default value of the variables:
  36.   input $INPUT
  37.   outputdir $OUTPUTDIR

  39. EOF
  40. }

  42. # Parse the input arguments and get the value of the input argument.
  43. parse_options()
  44. {
  45.   while test $# -gt 0
  46.   do
  47.     case "$1" in
  48.     --input=*)
  49.       INPUT=`get_key_value "$1"`;;
  50.     --outputdir=*)
  51.       OUTPUTDIR=`get_key_value "$1"`;;
  52.     -? | --help)
  53.       usage
  54.       print_default
  55.       exit 0;;
  56.     *)
  57.       echo "Unknown option '$1'"
  58.       exit 1;;
  59.     esac
  60.     shift
  61.   done
  62. }



  66. #################################################################
  67. INPUT=""
  68. OUTPUTDIR=/opt/result

  70. parse_options "$@"

  72. if [ -z $INPUT ]
  73. then
  74.   echo "Please give the input file address!"
  75.   exit -1
  76. fi

  78. if [ -f $INPUT ]
  79. then
  80.   [[ -d $OUTPUTDIR ]] || mkdir -p $OUTPUTDIR
  81.   
  82.   dir1=`dirname $INPUT`
  83.   dir2=`dirname $dir1`
  84.   
  85.   cat $INPUT | awk ' BEGIN { dt=-1;dr=-1;df=-1 } /Innodb_buffer_pool_pages_data/ \
  86.   { if (dt==-1) { dt=$4} else { dt+=$4 } } /Innodb_buffer_pool_pages_dirty/ \
  87.   { if (dr==-1) { dr=$4} else { dr+=$4 } } /Innodb_buffer_pool_pages_free/ \
  88.   { if (df==-1) { df=$4} else { df+=$4 } ; print (100*dr)/(1+dt+df) } ' \
  89.   >$OUTPUTDIR/dirty_page_ratio_${dir2##*/}_${dir1##*/}.result
  90.   exit 0
  91. else
  92.   echo "The input file is not exist!"
  93.   echo "Please be double check the input file!"
  94.   exit -1
  95. fi
2、analyze_global_innodb_page_flushed.sh脚本

点击(此处)折叠或打开

  1. #! /bin/sh

  3. ###########################################################
  4. # Copyright (c) 2012, Heng.Wang. All rights reserved.
  5. #
  6. # This program is used to analyze the dirty pages ratio.
  7. ###########################################################

  9. # set -x

  11. # Get the key value of input arguments format like '--args=value'.
  12. get_key_value()
  13. {
  14.     echo "$1" | sed 's/^--[a-zA-Z_-]*=//'
  15. }

  17. # Usage will be helpful when you need to input the valid arguments.
  18. usage()
  19. {
  20. cat <<EOF
  21. Usage: $0 [configure-options]
  22.   -?, --help Show this help message.
  23.   --input=<> Set the input file path.
  24.   --outputdir=<> Set the output directory.

  26. Note: this script is intended for internal use by developers.

  28. EOF
  29. }

  31. # Print the default value of the arguments of the script.
  32. print_default()
  33. {
  34. cat <<EOF
  35.   The default value of the variables:
  36.   input $INPUT
  37.   outputdir $OUTPUTDIR

  39. EOF
  40. }

  42. # Parse the input arguments and get the value of the input argument.
  43. parse_options()
  44. {
  45.   while test $# -gt 0
  46.   do
  47.     case "$1" in
  48.     --input=*)
  49.       INPUT=`get_key_value "$1"`;;
  50.     --outputdir=*)
  51.       OUTPUTDIR=`get_key_value "$1"`;;
  52.     -? | --help)
  53.       usage
  54.       print_default
  55.       exit 0;;
  56.     *)
  57.       echo "Unknown option '$1'"
  58.       exit 1;;
  59.     esac
  60.     shift
  61.   done
  62. }



  66. #################################################################
  67. INPUT=""
  68. OUTPUTDIR=/opt/result

  70. parse_options "$@"

  72. if [ -z $INPUT ]
  73. then
  74.   echo "Please give the input file address!"
  75.   exit -1
  76. fi

  78. if [ -f $INPUT ]
  79. then
  80.   [[ -d $OUTPUTDIR ]] || mkdir -p $OUTPUTDIR
  81.   
  82.   dir1=`dirname $INPUT`
  83.   dir2=`dirname $dir1`
  84.   
  85.   cat $INPUT | awk ' BEGIN { df=0 ; dl=0; } /Innodb_buffer_pool_pages_flushed[\s]/ \
  86.   { df=$4 } /Innodb_buffer_pool_pages_LRU_flushed/ { dl=$4; print df,dl } ' \
  87.   >$OUTPUTDIR/flushed_pages_${dir2##*/}_${dir1##*/}.result
  88. else
  89.   echo "The input file is not exist!"
  90.   echo "Please be double check the input file!"
  91.   exit -1
  92. fi
3）analyze_innodb_checkpoint.sh脚本

点击(此处)折叠或打开

  1. #! /bin/sh

  3. ###########################################################
  4. # Copyright (c) 2012, Heng.Wang. All rights reserved.
  5. #
  6. # This program is used to analyze the checkpoint.
  7. ###########################################################

  9. # set -x

  11. # Get the key value of input arguments format like '--args=value'.
  12. get_key_value()
  13. {
  14.     echo "$1" | sed 's/^--[a-zA-Z_-]*=//'
  15. }

  17. # Usage will be helpful when you need to input the valid arguments.
  18. usage()
  19. {
  20. cat <<EOF
  21. Usage: $0 [configure-options]
  22.   -?, --help Show this help message.
  23.   --input=<> Set the input file path.
  24.   --outputdir=<> Set the output directory.

  26. Note: this script is intended for internal use by developers.

  28. EOF
  29. }

  31. # Print the default value of the arguments of the script.
  32. print_default()
  33. {
  34. cat <<EOF
  35.   The default value of the variables:
  36.   input $INPUT
  37.   outputdir $OUTPUTDIR

  39. EOF
  40. }

  42. # Parse the input arguments and get the value of the input argument.
  43. parse_options()
  44. {
  45.   while test $# -gt 0
  46.   do
  47.     case "$1" in
  48.     --input=*)
  49.       INPUT=`get_key_value "$1"`;;
  50.     --outputdir=*)
  51.       OUTPUTDIR=`get_key_value "$1"`;;
  52.     -? | --help)
  53.       usage
  54.       print_default
  55.       exit 0;;
  56.     *)
  57.       echo "Unknown option '$1'"
  58.       exit 1;;
  59.     esac
  60.     shift
  61.   done
  62. }



  66. #################################################################
  67. INPUT=""
  68. OUTPUTDIR=/opt/result

  70. parse_options "$@"

  72. if [ -z $INPUT ]
  73. then
  74.   echo "Please give the input file address!"
  75.   exit -1
  76. fi

  78. if [ -f $INPUT ]
  79. then
  80.   [[ -d $OUTPUTDIR ]] || mkdir -p $OUTPUTDIR
  81.   
  82.   dir1=`dirname $INPUT`
  83.   dir2=`dirname $dir1`

  85.   cat $INPUT | awk ' BEGIN { } /Log sequence number/ {st=$4 } /Last checkpoint at/ \
  86.   { ed=$4; print (st-ed)/1024/1024 } '>$OUTPUTDIR/checkpoint_${dir2##*/}_${dir1##*/}.result
  87.   exit 0
  88. else
  89.   echo "The input file is not exist!"
  90.   echo "Please be double check the input file!"
  91.   exit -1
  92. fi

4）analyze_innodb_log_flushed_fallbehind.sh脚本

点击(此处)折叠或打开

  1. #! /bin/sh

  3. ###########################################################
  4. # Copyright (c) 2012, Heng.Wang. All rights reserved.
  5. #
  6. # This program is used to analyze the dirty pages ratio.
  7. ###########################################################

  9. # set -x

  11. # Get the key value of input arguments format like '--args=value'.
  12. get_key_value()
  13. {
  14.     echo "$1" | sed 's/^--[a-zA-Z_-]*=//'
  15. }

  17. # Usage will be helpful when you need to input the valid arguments.
  18. usage()
  19. {
  20. cat <<EOF
  21. Usage: $0 [configure-options]
  22.   -?, --help Show this help message.
  23.   --input=<> Set the input file path.
  24.   --outputdir=<> Set the output directory.

  26. Note: this script is intended for internal use by developers.

  28. EOF
  29. }

  31. # Print the default value of the arguments of the script.
  32. print_default()
  33. {
  34. cat <<EOF
  35.   The default value of the variables:
  36.   input $INPUT
  37.   outputdir $OUTPUTDIR

  39. EOF
  40. }

  42. # Parse the input arguments and get the value of the input argument.
  43. parse_options()
  44. {
  45.   while test $# -gt 0
  46.   do
  47.     case "$1" in
  48.     --input=*)
  49.       INPUT=`get_key_value "$1"`;;
  50.     --outputdir=*)
  51.       OUTPUTDIR=`get_key_value "$1"`;;
  52.     -? | --help)
  53.       usage
  54.       print_default
  55.       exit 0;;
  56.     *)
  57.       echo "Unknown option '$1'"
  58.       exit 1;;
  59.     esac
  60.     shift
  61.   done
  62. }



  66. #################################################################
  67. INPUT=""
  68. OUTPUTDIR=/opt/result

  70. parse_options "$@"

  72. if [ -z $INPUT ]
  73. then
  74.   echo "Please give the input file address!"
  75.   exit -1
  76. fi

  78. if [ -f $INPUT ]
  79. then
  80.   [[ -d $OUTPUTDIR ]] || mkdir -p $OUTPUTDIR
  81.   
  82.   dir1=`dirname $INPUT`
  83.   dir2=`dirname $dir1`
  84.   
  85.   cat $INPUT | awk ' BEGIN { } /Log sequence number/ {st=$4 } /Log flushed up to/ \
  86.   { ed=$5; print (st-ed) } ' > $OUTPUTDIR/log_flushed_fallbehind_${dir2##*/}_${dir1##*/}.result
  87. else
  88.   echo "The input file is not exist!"
  89.   echo "Please be double check the input file!"
  90.   exit -1
  91. fi
5）analyze_sysbench_performance_args.sh脚本

点击(此处)折叠或打开

  1. #! /bin/sh

  3. ###########################################################
  4. # Copyright (c) 2012, Heng.Wang. All rights reserved.
  5. #
  6. # This program is used to analyze the sysbench test report
  7. # and get the performance value of per second (transactions,
  8. # deadlocks, read/write requests and other operations).
  9. ###########################################################

  11. # set -x

  13. # Get the key value of input arguments format like '--args=value'.
  14. get_key_value()
  15. {
  16.     echo "$1" | sed 's/^--[a-zA-Z_-]*=//'
  17. }

  19. # Usage will be helpful when you need to input the valid arguments.
  20. usage()
  21. {
  22. cat <<EOF
  23. Usage: $0 [configure-options]
  24.   -?, --help Show this help message.
  25.   --input=<> Set the input file path.
  26.   --outputdir=<> Set the output directory.

  28. Note: this script is intended for internal use by developers.

  30. EOF
  31. }

  33. # Print the default value of the arguments of the script.
  34. print_default()
  35. {
  36. cat <<EOF
  37.   The default value of the variables:
  38.   input $INPUT
  39.   outputdir $OUTPUTDIR

  41. EOF
  42. }

  44. # Parse the input arguments and get the value of the input argument.
  45. parse_options()
  46. {
  47.   while test $# -gt 0
  48.   do
  49.     case "$1" in
  50.     --input=*)
  51.       INPUT=`get_key_value "$1"`;;
  52.     --outputdir=*)
  53.       OUTPUTDIR=`get_key_value "$1"`;;
  54.     -? | --help)
  55.       usage
  56.       print_default
  57.       exit 0;;
  58.     *)
  59.       echo "Unknown option '$1'"
  60.       exit 1;;
  61.     esac
  62.     shift
  63.   done
  64. }



  68. #################################################################
  69. INPUT=""
  70. OUTPUTDIR=/opt/result

  72. parse_options "$@"

  74. if [ -z $INPUT ]
  75. then
  76.   echo "Please give the input file address!"
  77.   exit -1
  78. fi

  80. if [ -f $INPUT ]
  81. then
  82.   [[ -d $OUTPUTDIR ]] || mkdir -p $OUTPUTDIR
  83.   
  84.   dir1=`dirname $INPUT`
  85.   dir2=`dirname $dir1`
  86.       
  87.   cat $INPUT | awk ' BEGIN { ts=0 ; dl=0; rwq=0; oo=0; } /transactions/ \
  88.   { ts=$3 } /deadlocks/ { dl=$3 } /read\/write requests/ { rwq=$4 } /other operations/ \
  89.   { oo=$4; print substr(ts,2),substr(dl,2),substr(rwq,2),substr(oo,2) }' \
  90.   >> $OUTPUTDIR/sysbench_perform_per_second_${dir2##*/}.result
  91. else
  92.   echo "The input file is not exist!"
  93.   echo "Please be double check the input file!"
  94.   exit -1
  95. fi

6）analyze_sysbench_report脚本

点击(此处)折叠或打开

  1. #! /bin/sh

  3. ###########################################################
  4. # Copyright (c) 2012, Heng.Wang. All rights reserved.
  5. #
  6. # This program is used to analyze the sysbench test report.
  7. ###########################################################

  9. # set -x

  11. # Get the key value of input arguments format like '--args=value'.
  12. get_key_value()
  13. {
  14.     echo "$1" | sed 's/^--[a-zA-Z_-]*=//'
  15. }

  17. # Usage will be helpful when you need to input the valid arguments.
  18. usage()
  19. {
  20. cat <<EOF
  21. Usage: $0 [configure-options]
  22.   -?, --help Show this help message.
  23.   --input=<> Set the input file path.
  24.   --outputdir=<> Set the output directory.

  26. Note: this script is intended for internal use by developers.

  28. EOF
  29. }

  31. # Print the default value of the arguments of the script.
  32. print_default()
  33. {
  34. cat <<EOF
  35.   The default value of the variables:
  36.   input $INPUT
  37.   outputdir $OUTPUTDIR

  39. EOF
  40. }

  42. # Parse the input arguments and get the value of the input argument.
  43. parse_options()
  44. {
  45.   while test $# -gt 0
  46.   do
  47.     case "$1" in
  48.     --input=*)
  49.       INPUT=`get_key_value "$1"`;;
  50.     --outputdir=*)
  51.       OUTPUTDIR=`get_key_value "$1"`;;
  52.     -? | --help)
  53.       usage
  54.       print_default
  55.       exit 0;;
  56.     *)
  57.       echo "Unknown option '$1'"
  58.       exit 1;;
  59.     esac
  60.     shift
  61.   done
  62. }



  66. #################################################################
  67. INPUT=""
  68. OUTPUTDIR=/opt/result

  70. parse_options "$@"

  72. if [ -z $INPUT ]
  73. then
  74.   echo "Please give the input file address!"
  75.   exit -1
  76. fi

  78. if [ -f $INPUT ]
  79. then
  80.   [[ -d $OUTPUTDIR ]] || mkdir -p $OUTPUTDIR
  81.   
  82.   dir1=`dirname $INPUT`
  83.   dir2=`dirname $dir1`
  84.   
  85.   sed -n '/OLTP test statistics/,+30p' $INPUT > $OUTPUTDIR/sysbench_report_${dir2##*/}_${dir1##*/}.result
  86. else
  87.   echo "The input file is not exist!"
  88.   echo "Please be double check the input file!"
  89.   exit -1
  90. fi




阅读(2686) | 评论(0) | 转发(0) |
0

上一篇：sysbench scripts（2）

下一篇：Sysbench scripts源码分析

给主人留下些什么吧！~~
关于我们 | 关于IT168 | 联系方式 | 广告合作 | 法律声明 | 免费注册

Copyright 2001-2010 ChinaUnix.net All Rights Reserved 北京皓辰网域网络信息技术有限公司. 版权所有

感谢所有关心和支持过ChinaUnix的朋友们

16024965号-6