Category Archives: InnoDB

Forcing deadlock rollback victim transaction

If you use a storage engine that supports transactions, you probably have faced or heard of deadlock’s. From MySQL Documentation: “Always be prepared to re-issue a transaction if it fails due to deadlock. Deadlocks are not dangerous. Just try again.” … Continue reading




Liked? Help and Share!
Posted in InnoDB, MySQL | 4 Comments

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