Happened to me on a fresh DO droplet.
Ubuntu 16.04.2 LTS mysql Ver 14.14 Distrib 5.7.17 (x86_64)
After two or three days of normal functioning. We had to start optimizing MyISAM. So the first thing we changed
log_slow_queries = /var/log/mysql/mysql-slow.log long_query_time = 3 log-queries-not-using-indexes
service mysql restart started failing from there.
Side note. We changed key_buffer_size to key_buffer_size = 768M
And restarted without problems the first day.
Happened to me on a fresh DO droplet.
Ubuntu 16.04.2 LTS
mysql Ver 14.14 Distrib 5.7.17 (x86_64)
After two or three days of normal functioning. We had to start optimizing MyISAM. So the first thing we changed
log_slow_queries = /var/log/ mysql/mysql- slow.log not-using- indexes
long_query_time = 3
log-queries-
service mysql restart started failing from there.
Side note. We changed key_buffer_size to
key_buffer_size = 768M
And restarted without problems the first day.