Category Archives: performance

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

MySQL Fabric – Part 1 – Installing

MySQL Fabric is a tool included on MySQL Utilities that helps you to manage your MySQL instances. It works by basically adding a new layer between your application and MySQL instances, which can provide an easy way to use sharding … Continue reading


Liked? Help and Share!
Posted in install, MySQL, performance, replication | 3 Comments

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

Why Does MySQL Replication Delays?

These days I’ve answer some questions about replication lag, and I realized that most of people does not correctly understand how this process works internally on MySQL, and why does delays happen: MySQL replication: most important config parameters for performance … Continue reading


Liked? Help and Share!
Posted in binlog, performance, replication | Leave a comment

Using the Mysql FullText Index Search

Today let’s talk about a resource very useful on MySQL, the FullText Index and Search This resource is very powerful, today on versions 5.5 is just available to MyISAM engine, but, like we can see on MySQL FullText documentation, it … Continue reading


Liked? Help and Share!
Posted in index, MySQL, performance | 29 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