-
Daily Popular
- Calculate Mysql Memory Usage – Quick Stored Proc
- 10 Steps: MySQL Monitoring through Nagios: Install & Configure
- Collection for insulting – one liners
- MyDumpSplitter-Extract tables from Mysql dump-shell script
- How to echo colored text in linux shell script
- Audit-Checking login history-to know WHO DID THAT on Redhat Linux
- MySQL Stored procedure – Split Delimited string into Rows
- MySQL Function to Convert Date To Words
- MySQL Memory Usage Limits on 32 bit Linux
- Load Delimited Data (csv, excel) into MySQL Server
-
Latest Headlines
-
Simple Shell Script to Monitoring Disk Space on a Linux Machine
Posted on January 11, 2009 | 4 CommentsMore...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 /... -
Linux Shell Commands – quick how-tos
Posted on January 10, 2009 | No CommentsMore...Following are linux commands, tricks for doing regular tasks. Rename files: replace space by _ in linux: for files in *; do mv "$files" `echo $files | tr ' '... -
Difference MyISAM and InnoDB Storage Engines Mysql
Posted on January 4, 2009 | No CommentsMore... MyISAM InnoDB Default since version 3.23 Relatively newer Files storage: FRM: table definition, MYD: Actual Data MYI: Index File FRM: table definition .ibd file (concept of table space) or... -
Selected Oscar Wilde Quotes
Posted on January 4, 2009 | No CommentsMore...Oscar Fingal O’Flahertie Wills Wilde!! Oscar Wilde is well known for his biting wit. And he has an extraordinary way of representing the things. Here are some collection of famous... -
life at rest – my first poem
Posted on January 4, 2009 | No CommentsMore...insomniac for ur sleep, ur awesome when its deep, pale skin, nighty hair, mighty life and ur so near… warm breath, and ur charm, makes me wait, till u wake,... -
Choosing between MyISAM and INNODB – MySQL Storage Engines
Posted on January 1, 2009 | No CommentsMore...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
Posted on January 1, 2009 | 1 CommentMore...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
Posted on January 1, 2009 | 2 CommentsMore...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...