/Blog

NotORM for easy database interaction

In this article we will learn how to use NotORM, a simple PHP library for interacting with database. Its really simple and easy to learn. Continue reading...

Using EXPLAIN to Write Better MySQL Queries

When you issue a query, the MySQL Query Optimizer tries to devise an optimal plan for query execution. You can see information about the plan by prefixing the query with EXPLAIN. EXPLAIN is one of the most powerful tools at your disposal for...

Product Review – Jet Profiler for MySQL

It was few days back I came to know about Jet Profiler an excellent tool for profiling MySQL queries. Thanks Mr. Bjorn Melinder for offering me a professional version for free. Jet Profiler is a tool for monitoring and analyzing performance of MySQL...

Mysql Replication in Amazon EC2

In this article we will go through how to set up mysql replication in amazon EC2. Its a pretty basic introduction to replicaton, intended for beginners. We will go through how to start an Amzon instance, installing lamp and setting up replication....

MySql performance part-2 : Understanding the server

Server configuration and optimization is definitely not your job if you are not a DBA. You can’t just set the server parameters to some arbitrary values expecting a nice performance boost, because it depends on different factors. It needs good...

MySQL Performance Part-1 : Schema design guidelines

Few days back I started writing my article series on mysql performance optimization. Unfortunatly I was unable to continue the stream. This is my second attempt to do the same and will my try level best not to discontinue. I will be trying to keep...