Hi!

This is next release of ZTC (Zabbix Templates Collection) - collection of templates and UserParameter scrips for zabbix for server aviability and performance monitoring.

This version introduces new template for apache2 monitoring and also includes lots of bugfixes and enchancements to existing templates.

Hopefully, this would be useful for anyone. I'm waiting for reviews, bugreports, featire requests and patches. Do it via trac, comments to this post or via any other method you'll find.

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=""

1. Detailed review of Tokutek storage engine for MySQL
2. GZIP encoding = happier users?

Original: Iptables – производительность роутера (Russian)
Translation by Vladimir Rusinov

Incorrect iptables settings may cause poor router performance. I'll show you how can you improve iptables performance

Disable connection tracking

The first thing you need to do (if you are not using NAT) is to disable connection tracking in nat table, PREROUTING chain:

Hi!

Let me show you first release of ZTC (Zabbix Templates Collection) - collection of templates and UserParameter scrips for zabbix for server aviability and performance monitoring.

This version includes templates for generic Linux monitoing and PostgreSQL, PostgreSQL+Slony and nginx running under Linux monitoring.

Hopefully, this would be useful for anyone. I'm waiting for reviews, bugreports, featire requests and patches. Do it via trac, comments to this post or via any other method you'll find.

RHEL/CentOS is good server OS, but sometimes it's too Enterprise and needs some usability tuning. I wrote instruction for myself and apply it to all stand-alone servers I manage.

Here it is:

Whoami && whereami

# cpu:
cat /proc/cpuinfo
# disks:
df -h
sudo /sbin/fdisk -l
/usr/sbin/vgdisplay
/usr/sbin/lvdisplay
sudo /sbin/hdparm -tT /dev/sda
# devices:
sudo /sbin/lsusb
sudo /sbin/lspci
# memory
vmstat

Creating user

Do not use root account for many reasons.

Login as root:
 

[yyy@xxx ~]$ uptime
03:06:42 up 744 days, 10:27, 1 user, load average: 0.26, 0.25, 0.19

[yyy@xxx ~]$ sudo reboot && echo \;\( && exit
Password:

Broadcast message from root (pts/0) (Mon Apr 13 03:11:25 2009):

The system is going down for reboot NOW!
;(
logout

Connection to 1.2.3.4 closed

1. 10 Tips for Writing Efficient Bash Scripts
2. Nginx-patched - nginx with some additional patches included
3. Great device - torrent-client + video player.

ZTC - Zabbix Template Collection - collection of templates for server aviability and performance monitoring for zabbix monitoring system.

Latest stable version: 9.6

Trac: documentation, downloads, tickets

1. WWW SQL Designer - Simple visual database designer with web-interface
2. Book: Linux Performance and Tuning Guidelines
3. Offtopic: Interesting video about Moscow Metro