Esse é para quando você estiver muito muito......
vi /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
port=3306
# bind-address = ip.ip.ip.ip
explicit_defaults_for_timestamp = TRUE
connect_timeout =1000000
net_write_timeout =1000000
wait_timeout =1000000
max_allowed_packet =1024M
interactive_timeout =1000000
net_buffer_length =200M
net_read_timeout =1000000
# add
key_buffer = 2048M
thread_stack = 256K
thread_cache_size = 16
max_connections = 5100
table_cache = 500
expire_logs_days = 10
max_binlog_size = 200M
# Temp tables
max_heap_table_size=16M
tmp_table_size=800M
# Query_cache
query_cache_limit=512K
query_cache_size=128M