June 18, 2013

Post: XtraDB: The Top 10 enhancements

… shard. This week I’m following up with the top 10 enhancements that XtraDB has over the built-in InnoDB included in MySQL 5.0… will prevent the rest of the information shown).  In addition to this, XtraDB diagnostics include the ability to see the contents of the buffer pool… along! My next post in this series will be on XtraDB: The Top 10 Configuration Parameters.

Post: Why you don't want to shard.

… sent to the server.  While the IO system can be improved with a RAID 10 controller w/battery backed write cache, the slave… will write about something that is going to be in the course – “XtraDB: The top 10 enhancements”, and in Part 3 “XtraDB: The top 10 parameters“.

Post: Tuning for heavy writing workloads

the contention problem. XtraDB can increase the rseg. innodb_extra_rsegments = 64 (affects to initialization of InnoDB) Recreated database files with the parameter. Then thetop