I installed via apt-get mysql 5.5 and created following custom config that i placed in /etc/mysql/conf.d/custom.cnf
[mysqld] #bind-address = 0.0.0.0 innodb_buffer_pool_size = 10G query_cache_limit = 80M query_cache_size = 64M tmp_table_size = 256M max_heap_table_size = 256M table_open_cache = 2000 join_buffer_size = 64M max_allowed_packet=512M log_slow_queries = /var/log/mysql/mysql-slow.log long_query_time = 2 #log-queries-not-using-indexes max_connections = 250
An apache web server in the same network is connecting to this server (roughly 70 max connections) and a couple of times the database would become unresponsive.
Now my fear is that there is something not okay with my config above.
The server has a SSD, 32GB of ram and 4 cores. All tables are InnoDB
Any input would be greatly appreciated.
Thanks in advance!