TokuMX v1.2.1 introduces two simple new features to help you understand the performance characteristics of your database: lock diagnostics and index usage statistics. We’d like to take you through a few examples of what these features are and how to use them.
Since we introduced TokuMX, one of the most frequent complaints has been about “lock not granted” errors. These arise when a long-running operation takes document-level locks, and other clients timeout while waiting to acquire the same locks.
This is a new problem in TokuMX that doesn’t exist in MongoDB, because MongoDB doesn’t have document-level locks. It has a single lock per database, and if an operation takes a long time, it simply …[Read more]