Our site has 3,000+ concurrent users when we open our registration on our website. The site was too slow and get the server down sometime, even sub accounts websites are down. Free memory was 400MB.
We upgraded our server to 8Gb for us to have a larger allocated memory. After upgrading our site still encountering server down/ slow site. What should be the best setting for our my.cnf so that our MySql Server would not give up?
This is currently our setting:
[mysqld] default-storage-engine=MyISAM performance-schema=0 max_allowed_packet=512M thread_cache_size=256K tmp_table_size=1G max_heap_table_size=1G open_files_limit=1000 max_connections=3000 interactive_timeout=180 wait_timeout=180 key_buffer_size=400M slow_query_log = ON
Any suggestion is highly appreciated.