Tag: perl

This article explain a way to get a mail as soon as the disk usage reaches to its critical level to avoid issues later. To set a simple monitor on Linux / Unix, I have two simple scripts: DSAlert.sh : Shell script for retrieving disk space percentages and put in to a cron job. DiskSpace_Alert.pl : Perl script for sending an […]

The perl script is mainly created to avoid manual Mysql Server Maintenance. The script uses Perl module DBI. You need to provide access credentials and database name(optional). Regarding Analyse, Optimize and Repair you may ofcourse refer dev.mysql.com. OPTIMIZE TABLE should be used if you have deleted a large part of a table or if you […]