InnoDB performance drop in 5.7 because of the lru_manager
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Expired
|
Undecided
|
Unassigned |
Bug Description
Hi,
I'm investigating a performance regression in InnoDB between 5.6 & 5.7.
I noticed a lot of time is spent in os_thread_sleep called from buf_lru_
Is there any way to avoid this (my configuration is using innodb_
Poor's man profiler result :
89 pthread_
24 nanosleep,
23 pthread_
23 pthread_
1 test_quick_
1 ??,sigwaitinfo,
[...]
Thanks!
Jocelyn
Why not using an event wait which would trigger a thread wakeup once the bufpool free list reaches some defined threshold - and perhaps auto adjust this threshold - instead of currently auto adjusting the lru_sleep_time in buf_lru_ manager_ adapt_sleep_ time()?