MySQL Forums
Forum List  »  Newbie

mysql 5.7.21 does not start on system reboot
Posted by: Gary Mills
Date: June 17, 2019 03:58PM

I am using MySQL 5.7.21 and it is working ok, my application accesses it just fine. normal operations as expected.
HOWEVER, on an OS reboot, mysql 5.7.21 does not start up after reboot.

The daemon service is added to the RC resource control of OS.

chkconfig --list | grep mysql.server
mysql.server 0:off 1:off 2:on 3:on 4:on 5:on 6:off

/etc/my.cnf
[mysqld]
local-infile=0
skip-external-locking
skip-name-resolve
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_connections=500
max_allowed_packet=256M
interactive_timeout=1000
wait_timeout=10000
connect_timeout=10000
thread_cache_size=128
key_buffer_size=16M
join_buffer_size=1M
max_allowed_packet=16M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
myisam_sort_buffer_size=64M
server-id=1

[client]
socket=/tmp/mysql.sock

[safe_mysqld]
err-log=/var/log/mysqld.log
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer_size=16M
write_buffer=16M

[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer_size=16M
write_buffer=16M

[mysqlhotcopy]
interactive-timeout

is there a known problem with mysql 5.7.21 not starting after OS system reboot?

Gary L Mills

Options: ReplyQuote


Subject
Written By
Posted
mysql 5.7.21 does not start on system reboot
June 17, 2019 03:58PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.