Clear query cache without restarting server : MySQL
Clear Memory Cache on Linux centos RESET QUERY CACHE will clear out the query cache, but needs RELOAD privileges. RESET
Read more
mysql
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 Restore MySQL database from binary log
To learn more about what is binary log and how to setup Click here MySQL binary log : mysqlbinlog utility
Read more MySQL binary log : mysqlbinlog utility
Mysql binary log is a special kind of logging facility provided by MySql by which we can record the log
Read more Kill slow mysql queries
A Shell script for killing slow MySQL queries: #!/bin/sh # Credentials for a MySQL user with PROCESS, SUPER permissions USERNAME=
Read more