I was looking into the init.d script for more details, and I think this part is the problem.
case "${1:-''}" in
'start') sanity_checks;
# Start daemon log_daemon_msg "Starting MySQL (Percona Server) database server" "mysqld"
if mysqld_status check_alive nowarn; then log_progress_msg "already running" log_end_msg 0
else "${PERCONA_PREFIX}"/bin/mysqld_safe > /dev/null 2>&1 &
# 6s was reported in #352070 to be too few when using ndbcluster
for i in 1 2 3 4 5 6 7 8 9 10 11 12 13 14; do sleep 1
if mysqld_status check_alive nowarn ; then break; fi log_progress_msg "."
done
if mysqld_status check_alive warn; then log_end_msg 0
# Now start mysqlcheck or whatever the admin wants. output=$(/etc/mysql/debian-start)
[ -n "$output" ] && log_action_msg "$output"
else log_end_msg 1 log_failure_msg "Please take a look at the syslog"
fi
fi
;;
Because mysqld_status check_alive is not able to connect the DB the whole time (it took 15mins to load the LRU), so it throw error at that last else statement.
I was looking into the init.d script for more details, and I think this part is the problem.
case "${1:-''}" in
sanity_ checks;
log_daemon_ msg "Starting MySQL (Percona Server) database server" "mysqld"
log_ progress_ msg "already running"
log_ end_msg 0
"$ {PERCONA_ PREFIX} "/bin/mysqld_ safe > /dev/null 2>&1 &
sleep 1
log_progress_ msg "."
log_end_ msg 0
output= $(/etc/ mysql/debian- start)
log_end_ msg 1
log_failure_ msg "Please take a look at the syslog"
'start')
# Start daemon
if mysqld_status check_alive nowarn; then
else
# 6s was reported in #352070 to be too few when using ndbcluster
for i in 1 2 3 4 5 6 7 8 9 10 11 12 13 14; do
if mysqld_status check_alive nowarn ; then break; fi
done
if mysqld_status check_alive warn; then
# Now start mysqlcheck or whatever the admin wants.
[ -n "$output" ] && log_action_msg "$output"
else
fi
fi
;;
Because mysqld_status check_alive is not able to connect the DB the whole time (it took 15mins to load the LRU), so it throw error at that last else statement.
Is it possible to fix this false alert problem?