Web Performance, Branding, and Social Media
In: GrabPERF
13 Mar 2009Over the last seven days, GrabPERF has been running in a very unstable state. This appears to be directly related to the use of InnoDB as the DB engine on a few of the larger tables in the database. [InnoDB changeover discussed here]
Today, the system was offline for several hours before I noticed that the [...]
In: GrabPERF| Technology| The Web| Web Performance| WebPerformance.Org
3 Mar 2009On the weekend, I upgraded the database engine for GrabPERF to Mysql 5.1 and switched the main data table from MyISAM to InnoDB.
The switch to InnoDB was done because of the locking issues that were occurring during long queries, especially when doing ad-hoc analysis. The row-level (versus table-level) locking of InnoDB has removed most of [...]