debian init script times out at server start when innodb_blocking_buffer_pool_restore=1
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
New
|
Medium
|
Ignacio Nin |
Bug Description
The debian init script times out after a fixed interval of 15 seconds, with a check based on mysql_ping. This approach can fail with buffer pools as small as 6GB when innodb_
Setting up percona-
* Stopping MySQL (Percona Server) mysqld [ OK ]
* Starting MySQL (Percona Server) database server mysqld [fail]
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing percona-
subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of percona-
percona-
Package percona-
dpkg: error processing percona-
dependency problems - leaving unconfigured
Percona options sample:
# More Tuning
skip-name-resolve
back_log=500
tmpdir=/dev/shm
log_slow_
long_query_time=0
innodb_
innodb_
innodb_
innodb_
expand_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
query_cache_
query_response_
query_response_
log_slow_
log_slow_
log_slow_
log_slow_
log_slow_
slow_query_
slow_query_
slow_query_
thread_statistics=1
userstat
innodb_
innodb_
innodb_
Duplicate of bug #1072538?