InnoDB with shared buffer pool takes long to shutdown
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
High
|
Unassigned |
Bug Description
I noticed that on server with big amount of memory ( 120GB buffer pool)
when I use buffer_pool_shared memory it takes very long to shutdown.
There is some process after InnoDB finished flushing, it is CPU bound process.
stack trace:
(gdb) thread app all bt
Thread 2 (Thread 0x599e2940 (LWP 17830)):
#0 buf_pool_free () at ./include/
#1 0x0000000000798a3a in innobase_
#2 0x000000000072c78f in innobase_end (hton=<value optimized out>, type=<value optimized out>) at handler/
#3 0x000000000068f6ab in ha_finalize_
#4 0x000000000070cbc6 in plugin_deinitialize (plugin=0x5725db8, ref_check=true) at sql_plugin.cc:828
#5 0x000000000070d6fe in reap_plugins () at sql_plugin.cc:916
#6 0x000000000070db8d in plugin_shutdown () at sql_plugin.cc:1551
#7 0x00000000005b01bc in clean_up (print_
#8 0x00000000005b061e in unireg_end () at mysqld.cc:1289
#9 0x00000000005b430d in kill_server (arg=<value optimized out>) at mysqld.cc:1224
#10 kill_server_thread (arg=<value optimized out>) at mysqld.cc:1252
#11 0x0000003d2760673d in start_thread () from /lib64/
#12 0x0000003d26ed3d1d in clone () from /lib64/libc.so.6
Thread 1 (Thread 0x2ab90c584fb0 (LWP 17698)):
#0 0x0000003d2760aee9 in pthread_
#1 0x00000000005b52f5 in main (argc=<value optimized out>, argv=<value optimized out>) at mysqld.cc:4765
Related branches
- Vadim Tkachenko: Approve
-
Diff: 131 lines (+17/-13)1 file modifiedinnodb_buffer_pool_shm.patch (+17/-13)
- Vadim Tkachenko: Approve
- Fred Linhoss (community): Approve (documentation)
-
Diff: 291 lines (+77/-39)1 file modifiedinnodb_buffer_pool_shm.patch (+77/-39)
Changed in percona-server: | |
status: | New → Confirmed |
importance: | Undecided → High |
assignee: | nobody → Yasufumi Kinoshita (yasufumi-kinoshita) |
milestone: | none → 5.1-13.0 |
Changed in percona-server: | |
status: | Confirmed → Fix Committed |
Changed in percona-server: | |
status: | Fix Committed → Fix Released |
The same happens when InnoDB starts and attaches to existing shared buffer pool.
A lot of time is spent in ut0rnd. ic:171 ut0rnd. ic: No such file or directory.
0x00000000007d8b73 in ut_fold_ulint_pair (chunk=0x913e1d8, mem_size=<value optimized out>) at ./include/
171 ./include/
in ./include/ut0rnd.ic