May 24, 2012

Post: SHOW INNODB STATUS walk through

… waited at ./../include/buf0buf.ic line 630 for 0.00 seconds the semaphore: Mutex at 0x2a957858b8 created file buf0buf.c line 517, lock… waited at ./../include/buf0buf.ic line 630 for 0.00 seconds the semaphore: Mutex at 0x2a957858b8 created file buf0buf.c line 517, lock… thread is not runniing inside innodb kernel status could be “waiting in InnoDB queue” or “sleeping before joining InnoDB queue”. Latest one is…

Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit

…-5.1.61) and a single test, innodb_plugin.innodb_bug53674. The test is chosen for no … reads and writes of mutex_t::waiters in mutex_get_waiters and mutex_set_waiters. Interestingly, there …#14 ==9090==    at 0x6B0CAF2: buf_refresh_io_stats (buf0buf.c:3529) ==9090==    by 0x6BC45D1: srv_error_monitor…

Comment: Returning to InnoDB scalability

buf0buf.c | 2230 | 0 | 0 | 0 | 0 | 0 | | &(buf_pool->mutex) | buf0buf.c | 2375090687 | 11868885 | 42507434 | 305779 | 307173 | 0 | | &(system->mutex

Comment: Returning to InnoDB scalability

…_sys->mutex) | log0log.c | 104098379 | 40757 | 402675 | 14433 | 18328 | 0 | | &(buf_pool->mutex) | buf0buf.c | 70739883283 | 4350334922 | 3239906212 | 2026290 | 562745 | 0 | | &(system->mutex) | fil0fil.c | 53893011 | 940 | 3139 | 7 | 15 | 0 | | &srv_innodb_monitor_mutex | srv0srv…

Comment: Returning to InnoDB scalability

mutex) | log0log.c | 773885913 | 466730 | 4249691 | 136192 | 180760 | 0 | | &(buf_pool->mutex) | buf0buf.c | 341813408575 | 5131618035 | 5198457973 | 6753293 | 3944667 | 0 | | &(system->mutex