28 Apr, 2016 -
By
Shameer C
As a programmer or system admin, taking database backup is an inevitable task that we have to do.
mysqldump is the de-facto tool for exporting data from MySQL server. It allows us to easily export databases or selected
tables very easily. For...
25 Jul, 2012 -
By
Shameer C
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...
10 Apr, 2012 -
By
Shameer C
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...
08 Mar, 2012 -
By
Shameer C
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...
05 Mar, 2011 -
By
Shameer C
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....
28 Nov, 2010 -
By
Shameer C
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...
07 Nov, 2010 -
By
Shameer C
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...