Category Archives: optimize

MySQL & NoSQL – Memcached Plugin

Many of you have already heard about NoSQL databases and one of the the most used tool is Memcached, where you add a cache layer between the application and database. Since MySQL version 5.6, a new plugin is available to … Continue reading


Liked? Help and Share!
Posted in InnoDB, install, MySQL, optimize, performance | Leave a comment

Warm-up InnoDB Buffer Pool

As we know, one of the most important config for InnoDB is the innodb_buffer_pool_size, it basically store the innodb data and indexes in memory, when MySQL receives a query and the InnoDB pages involved on that query are stored in … Continue reading


Liked? Help and Share!
Posted in InnoDB, MySQL, optimize, performance | 6 Comments

MySQL query optimize with query cache

Today let’s talk about a very cool tool of MySQL, the query cache. The query cache saved the SELECT results, that’s already executed their raw data have not changed thus making the response time of query much more optimized, because … Continue reading


Liked? Help and Share!
Posted in MySQL, optimize, performance, query cache | 5 Comments