dstat2graphs

This is a web application which draws graphs from a dstat CSV file. It accepts files output with the following options.

$ dstat -tfvn --output log.csv [delay]
$ dstat -tfvnrl --output log.csv [delay]

Sample

You can use the demo site below.

• dstat2graphs - dbstudy.info

Here is a sample output.

• k01sl6.local 2017/01/29 17:54:14 - dstat2graphs

When you use the demo site, please be aware of the following.

• A CSV file size that can be uploaded is limited to 4MBytes.
• Since there is no access control, please do not upload sensitive data.

Setup

This tool is intended to be used in Red Hat Enterprise Linux 6/7 and their clone distributions.

This tool requires Apache HTTP Server and PHP. Please install 'Web Server' and 'PHP Support' package groups.

# yum groupinstall 'Web Server' 'PHP Support'

Next, please install the following packages.

• perl-Archive-Zip
• perl-HTML-Parser
• rrdtool
• rrdtool-perl

# yum install perl-Archive-Zip perl-HTML-Parser rrdtool rrdtool-perl

This tool uses '/dev/shm' as a working directory. Please create the working directory and give write permission to user 'apache'. If you want to use this tool permanently, please add such procedures to '/etc/rc.local'.

# mkdir /dev/shm/dstat2graphs
# chown apache:apache /dev/shm/dstat2graphs

Please place the scripts under the document root of the Apache HTTP Server, create 'reports' directory and give write permission to user 'apache'.

# mkdir <document_root>/<script_dir>/reports
# chown apache:apache <document_root>/<script_dir>/reports

If the CSV file size is large, you should modify PHP settings to handle large files. Please adjust parameter 'upload_max_filesize' in '/etc/php.ini' to the value greater than the CSV file size. This parameter must meet the relationship 'memory_limit > post_max_size > upload_max_filesize'.

memory_limit = 128M
post_max_size = 8M
upload_max_filesize = 2M

Web UI

If you access http://<server_host>/<script_dir>/ in a web browser, the screen will be displayed. When you specify the CSV file and press the Upload button, the graphs will be drawn.

• dstat CSV File
  • dstat CSV File ... Specify the CSV file you want to upload.
• Graph Size
  • Width ... Specify the horizontal size of graphs, in pixel.
  • Height ... Specify the vertical size of graphs, in pixel.
• Graph Upper Limits
  • Disk I/O ... Specify the maximum value of the Y-axis for Disk I/O graphs. The unit is Bytes/second. It is automatically adjusted if you specify 0.
  • Disk IOPS ... Specify the maximum value of the Y-axis for Disk IOPS graphs. The unit is Times/second. It is automatically adjusted if you specify 0.
  • Network I/O ... Specify the maximum value of the Y-axis for Network I/O graphs. The unit is Bytes/second. It is automatically adjusted if you specify 0.
• Other Settings
  • X-axis ... Select whether to display elapsed time or actual time on the X-axis.
  • Offset ... Cut the specified time from the beginning of the CSV file. The unit is second.
  • Duration ... Draw only the specified time from the beginning or the offset position. The unit is second. It draws until the end of the CSV file if you specify 0.

Perl CUI

It is possible to draw graphs using Perl script 'dstat2graphs.pl'. Please give write permission of '/dev/shm/dstat2graphs' to the user which executes this script. Command line options are as follows. You must specify everything except the last two.

$ perl dstat2graph.pl csv_file report_dir width height disk_limit net_limit offset duration [io_limit] [is_actual]

• report_dir ... Specify the directory where you want to store graphs. It is automatically created if it does not exist.

Options other than 'report_dir' are the same as those that can be specified from Web UI.