innodb_buffer_pool_pages_index performance
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
High
|
Unassigned |
Bug Description
Accerssing innodb_
it also can cause certain mutexes to be locked for long time causing server stall and potentially server crash (if locks are held more than allowed by Innodb watchdog)
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 4112, signal count 4016
--Thread 1235454272 has waited at buf/buf0lru.c line 2046 for 127.00 seconds the semaphore:
Mutex at 0xde2020 '&buf_pool_mutex', lock var 1
waiters flag 1
--Thread 1247275328 has waited at buf/buf0lru.c line 698 for 127.00 seconds the semaphore:
Mutex at 0xde2020 '&buf_pool_mutex', lock var 1
waiters flag 1
--Thread 1214474560 has waited at buf/buf0flu.c line 1077 for 127.00 seconds the semaphore:
Mutex at 0xde2020 '&buf_pool_mutex', lock var 1
waiters flag 1
--Thread 1245944128 has waited at row/row0purge.c line 543 for 122.00 seconds the semaphore:
Mutex at 0x6812220 '&dict_sys->mutex', lock var 1
waiters flag 1
Mutex spin waits 24624, rounds 144847, OS waits 3454
RW-shared spins 813, OS waits 483; RW-excl spins 48, OS waits 154
Spin rounds per wait: 5.88 mutex, 22.41 RW-shared, 104.08 RW-excl
Related branches
- Percona developers: Pending requested
-
Diff: 448 lines (+63/-94)10 files modifiedi_s_innodb_buffer_pool_pages.patch (+24/-67)
innodb_admin_command_base.patch (+1/-1)
innodb_extra_rseg.patch (+3/-3)
innodb_fix_misc.patch (+13/-0)
innodb_lru_dump_restore.patch (+2/-2)
innodb_show_sys_tables.patch (+2/-2)
innodb_split_buf_pool_mutex.patch (+2/-2)
innodb_stats.patch (+3/-3)
mysql-test.diff (+12/-13)
userstat.patch (+1/-1)
Changed in percona-server: | |
status: | New → Triaged |
importance: | Undecided → High |
assignee: | nobody → Yasufumi Kinoshita (yasufumi-kinoshita) |
milestone: | none → 5.1.46-rel10.1 |
Changed in percona-server: | |
milestone: | 5.1.46-rel11 → 11.0 |
Changed in percona-server: | |
milestone: | 11.0-old → 11.0 |
Changed in percona-server: | |
milestone: | 5.1-11.0 → 5.1-11.1 |
Changed in percona-server: | |
milestone: | 5.1-11.1 → 5.1-12.0 |
Changed in percona-server: | |
milestone: | 5.1.47-12.0 → 5.1-12.0 |
Changed in percona-server: | |
status: | Triaged → Fix Committed |
Changed in percona-server: | |
status: | Fix Committed → In Progress |
status: | In Progress → Fix Released |
Peter,
Which version do you use?
And, this information shows "who waits" only.
I 'd like to know is "who make them wait" rather than above.
So, I need stacktrace at the time.
I cannot analyze because information is shortage.