slowlog

slowlog

type:: plugin
plugin:: slowlog
author:: the_cacti_group
description:: Simple plugin to allow you to analyze your MySQL Slow Query Logs
version:: 1.3
pia:: 2.x
cacti:: 0.8.7e,0.8.7g
date:: 2011-10-05
license:: GPL v2
plugins:: analysis,; performance,; slow,; logs,; audit,; database,; mysql

Download

Latest: slowlog-v1.3-1.tgz

Archive: slowlog-v1.1-1.tgz

Purpose

Allows Cacti Administrators to optimize performance of their Cacti systems by taking the hard work our of analyzing their MySQL Slow Query logs.

Features

Easy import feature Analysis by Query Type Analysis by Table Name Detailed View of Queries by Table

Prerequisites

PIA 2.x is required.

You must turn on MySQL Slow Query Logs and have a threshold that is reasonable.

You must also make sure your Web server can upload files of whatever size are being produced by your query logs

There are two PHP.INI variables that control the size of you file uploads. They are 'upload_max_filesize', and 'post_max_size'. Both of these variables must be set, and the Apache server restarted to upload large files.