Linux Shell Commands – quick how-tos
Kedar
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
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 single…
Selected Oscar Wilde Quotes
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
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…