MySQL : Cheking MySQL replication status
Once replication has been started it should execute without requiring much regular administration. Depending on your replication environment, you will
Read more
Author: eduguru
Apachetop – Web server Real time Traffic Monitor
Apachetop is very simple command line utility that you can use to monitor traffic real-time. It accomplishes this by parsing the
Read more
MySQL Range Optimization – Where Clause
In this post we will see how can we optimize where clause. Where clause restrict the result set to a
Read more How MySQL Optimizes WHERE Clauses
Some of the optimizations performed by MySQL on where clauses as follow: Removal of unnecessary parentheses: ((a AND b) AND
Read more Optimizing MySQL SELECT statements
The core logic of a database application is performed through SQL statements, whether issued directly through an interpreter or submitted
Read more MySQL Optimization Part 1
Database performance depends on several factors at the database level, such as tables, queries, and configuration settings. These software constructs
Read more Recovering Corrupt Tables : MyISAM Table Crash Recovery
If you have to restore MyISAM tables that have become corrupt, try to recover them using REPAIR TABLE or myisamchk
Read more MySQL Server Logs : Error log and General Query Log
MySQL Server has several logs that can help you find out what activity is taking place. By Default , No
Read more
The While loop in C
It is often the case in programming that you want to do something a fixed number of times. Perhaps you
Read more
Enable setup command in CentOS minimal install
Generally setup command is not used to install in centos minimal installation: Here is the step to install setup
Read more