Mysql server not stable?

Question

linux

There is a weak link on the server - this is mysql, which regularly causes such simple messages as mysql server has gone away - for phpmyadmin, error establishing a database connection - wp, Query execution was interrupted - pdo. The Mysql daemon is like a sissy that shouldn't be heavily loaded.
As a result of my "fine" settings, such a "thick" config appeared:

[client]
port            = 3306
socket          = /tmp/mysql.sock
[mysqld]
skip-host-cache
skip-name-resolve
port            = 3306
socket          = /tmp/mysql.sock
key_buffer_size = 64M
max_allowed_packet = 512M
table_open_cache = 512
sort_buffer_size = 64M
read_buffer_size = 64M
read_rnd_buffer_size = 64M
net_buffer_length = 64M
thread_stack = 64M
thread_cache_size = 64
query_cache_size = 64M
default-storage-engine=myisam
tmp_table_size=64M
max_heap_table_size=64M
low-priority-updates
wait_timeout=360
interactive_timeout=360
max-connections = 100
myisam_sort_buffer_size = 64M
character-set-server = utf8
collation-server = utf8_general_ci
bulk_insert_buffer_size = 64M

server-id       = 1
[mysqldump]
quick
max_allowed_packet = 512M

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size = 64M
sort_buffer_size = 64M

[mysqlhotcopy]
interactive-timeout

The server is not powerful, but there were always enough resources. Something like this in top Mysqld
Mem: 527M Active, 1024M Inact, 241M Free
itself crashed very rarely, no more than once every half a year.
How to turn my mysql server into a locomotive that will work properly to the fullest?

Answer 1

mysqltuner optimization