Make free calls and SMSs with Viber
I have just installed and tested Viber on my iPhone 3GS. Viber is an application for iPhone and Android phones that lets you make free phone calls a…
Moving Master or Slave nodes in MySQL
In this post I want to discuss with you a concept which simplifies failing-over or migration of a master or slave node in a MySQL replication setup w…
How Tables are arranged in JOINS
I often get asked how does an optimizer (being in Oracle or MySQL) decide which would be the outer table in a join. Consider the following three tabl…
Efficient Random Rows in MySQL
MySQL's official documentation dictates the use of the ORDER BY RAND() (coupled with LIMIT if you want) to select one or more random rows from a …
Choosing the ideal InnoDB log file size
I refer to an incredible post by Baron Schwartz where he wittingly explains a technique to choose the best InnoDB log file size. The idea is so mon…
