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 ‘ ‘ ‘_’`; done Change case of multiple file names: for files in *; do mv $files `echo $files | tr ‘[:upper:]’ ‘[:lower:]’`; done Find files having […]
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 huge .ibdataX No transation, Foreign key ACID Transactions, Foreign key, Rollback Low disk and memory utilisation Relatively high storage requirements (Almost 3 times disk space) […]
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 quotes of Oscar Wilde: A cynic is a man who knows the price of everything but the value of nothing. A dreamer is one who […]
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 ones, I jotted down a few lines and that’s my first attempt. I call it (my) Life At Rest. insomniac for your sleep, you’re awesome […]
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 of consideration for MyISAM – MySQL storage engine: Tables are really fast for select-heavy loads Table level locks limit their scalability for write intensive multi-user […]
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 […]
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 your MySQL installation and the areas where it can be improved. Downloading MySQLTuner: wget http://mysqltuner.com/mysqltuner.pl chmod +x mysqltuner.pl Using MySQLTuner Script for Lampp systems: Just […]
Change Is Inevitable