|
InnodbMutexContention2
Reduce mutex contention on log_sys->mutex and buffer_pool->mutex
DetailsInnoDB was changed to reduce mutex contention on the transaction log and buffer pool mutexes (log_sys->mutex, buffer_pool->mutex). It was also changed to reduce contention between them because on commit a session would lock log_sys->mutex and then lock buffer_pool->mutex. Now it locks log_sys->mutex and then locks buffer_pool->flush_list_mutex. Changes:
Query PerformanceChanges were made to reduce contention on log_sys->mutex and buffer_pool->mutex. At high levels of concurrency this improves performance by 20% on sysbench readwrite with a 16-core server.
The same data graphed Database reload performanceThis lists the time to reload a production database server with ~130GB of data for a real and complex schema into InnoDB.
|
Sign in to add a comment