mysql

 

ZTC 11.03 is out

ZTC 11.03 is out today.

ZTC (Zabbix Templates Collection) is a collection of templates for monitoring servers availability and performance.

New in version 11.03:

  • Apache template: apache.ping instead of apache.alive
  • Mysql template: ping now in seconds
  • Apache request processing time: ability to return min and max times
  • Apache request processing time script: ability to write slow logs
  • new template: Terracotta
  • PgSQL: bloat script have ability to print bloatest tables (use 'list' as 1st argument)

ZTC 11.02: zabbix templates for Linux servers monitoring

ZTC (Zabbix Templates Collection) is a collection of templates for monitoring servers availability and performance.

New in version 11.02:

  • NEW: very basic apache avtivemq template
  • NEW: very basic NFS filesystem template
  • IMPROVEMENT: mysql supports unix_socket config parameter

ZTC 10.11: zabbix templates for Linux, PostgreSQL, MySQL, Apache and nginx monitoring

ZTC (Zabbix Templates Collection) is a collection of templates for monitoring servers availability and performance.

New in version 10.11:

  • Template_app_nginx: nginx.ping param
  • Template_app_PostgreSQL: pgsql_autovac_freeze.py: listing databases with % how close they are to freeze (use /opt/ztc/bin/pgsql_autovac_freeze.py list)
  • new template: 3ware raid status monitoring
  • Template_Linux: ntp jitter monitoring

MySQL check & repair script

Recommended to run after every forced shutdown and periodically. Especially useful for large number of databases with MyISAM tables.

Requires: Python 2.x and MySQLdb (mysql python module)

#!/usr/bin/env python
 
#########################################
# Check all tables in all mysql databases
#
# Written by Vladimir Rusinov <vladimir@greenmice.info>, http://greenmice.info/
#
# Reqirements:
#   Python 2.x (tested with 2.4)
#   MySQLdb
 
#########################################
# Settings:
 
host="localhost"
username="root"
password=""

ZTC 10.10: zabbix templates for Linux, PostgreSQL, MySQL, Apache and nginx monitoring

ZTC (Zabbix Templates Collection) is a collection of templates for monitoring servers availability and performance.

ZTC 10.10 includes following templates

  • Linux_Generic - Linux OS monitoring: CPU, memory, disks
  • Apache - monitoring of apache httpd 2.0+ web server
  • nginx - monitoring of nginx web server
  • MySQL - monitoring of MySQL 5.0+
  • PostgreSQL - monitoring of PostgreSQL 8.3+
  • and some others

User login

Syndicate

Syndicate content