life at rest – my first poem
You’d never forget the those beautiful moments when you feel loved and feel blessed with the presence of the one of your life. Looking at above capture of my dear…
Choosing between MyISAM and INNODB – MySQL Storage Engines
After reading at a lot of places for the the single repeatative question, “What engine shall I choose – MyISAM or Innodb?”, this is what I’ve got. Following are points…
Perl Script for Analyze – Optimize – Repair Mysql Databases
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…
Using MySQLTuner – MySQL Optimization Tool
MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability. Within seconds, it will display statistics about…