Category: Database

Some tweaks for MySQL InnoDB performance

In most recent mysql-based applications today, InnoDB is used as the database engine due to its great supported features such as transaction, foreign key, etc. But if the DB server …

Some notes on MySQL index query

Some rules we should remember when doing MySQL index query: Index uses B-TREE, so be sure we understand how B-Tree works. Index is left-most, so if there is (c1, c2, c3) …

MySQL Query Optimization using UNION

Every developers might also understand how important index is when performing query but not of all do really care about how MySQL Query Optimization works. In the most cases, developers …

Install Percona in CentOS

This tutorial helps you install percona server in CentOS as a replacement for MySQL server. According to Percona, Their “MySQL service clients and open source software users achieve breakthrough results …

Reset MySQL Root Password in CentOS

In your development work, there are sometimes you forgot the mysql root password so you cannot make any system-level change to the mysql server. This quick tutorial tells you how …