What database does Facebook use?
What database does Facebook use is one of the most common questions asked when folks start taking about what database is the most scalable for large scale web applications. …
Read moreMySQL – Innodb Slow Shutdown – Dirty Buffer Pages
If you have a MySQL server that reserves a large amount of memory for the Innodb buffer pool, you may have seen that it can often take a very long…
Read moreTop My.CNF Optimizations for Innodb
These are the four parameters which will have the most affect on the performance of MySQL 5.1x and Innodb. If you are suffering from poor performance, try changing the…
Read moreMySQL – Constraints on Hierarchical Data in a Self-Referential Table
I recently had a client who was using a table structure that utilized a self-referential structure using an ID field and Parent_ID fields. After upgrading to Innodb, his DBA was…
Read moreMySQL – ERROR 1005: Can’t create table (errno: 150) – INNODB
If you have seen this error, don’t worry, you are not alone. This error is often accompanied by a message that a table or file could not be created, and…
Read moreMySQL – Best way to speed up Slave replication
The number one thing that you can do to speed up Slave Replication is to set innodb_flush_log_at_trx_commit=0 in your my.cnf file. This will make the transactions less recoverable on your…
Read more