Welcome to the MySQL Knowledge Base and Tutorial
Client Programming Security Guidelines - MySQL
Applications that access MySQL should not trust any data entered by users, who can try to trick your code byRead More »
General Security Guidelines - MySQL Security
This article describes general security issues to be aware of and what you can do to make your MySQL installation moreRead More »
Security Issues With LOAD DATA LOCAL - MySQL Security
The LOAD DATA statement can load a file that is located on the server host, or it can load aRead More »
Asterisk : Select Multiple column from MySQL
Here is an example to select multiple column of a table from select statement in asterisk. exten => h,1,MYSQL(Connect connRead More »
MySQL : Cheking MySQL replication status
Once replication has been started it should execute without requiring much regular administration. Depending on your replication environment, you willRead More »
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. RESETRead 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 aRead 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) ANDRead More »
Optimizing MySQL SELECT statements
The core logic of a database application is performed through SQL statements, whether issued directly through an interpreter or submittedRead More »
MySQL Optimization Part 1
Database performance depends on several factors at the database level, such as tables, queries, and configuration settings. These software constructsRead 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 myisamchkRead 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 , NoRead 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 utilityRead 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 logRead 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 »