I'm a bit confused about which settings to change in my my.conf file to optimise for my server (the mysql server keeps crashing due to our high traffic).
Here's the my.conf file:
[mysqld] local-infile = 0 max_connections = 300 key_buffer = 32M myisam_sort_buffer_size = 1G join_buffer_size = 10M read_buffer_size = 10M sort_buffer_size = 20M table_cache = 4000 thread_cache_size = 286 interactive_timeout = 25 wait_timeout = 7000 connect_timeout = 10 max_allowed_packet = 16M max_connect_errors = 10 query_cache_limit = 2M query_cache_size = 12M query_cache_type = 1 tmp_table_size = 16M skip-innodb [mysqld_safe] open_files_limit = 8192 [mysqldump] quick max_allowed_packet = 16M [myisamchk] key_buffer = 64M sort_buffer = 64M read_buffer = 16M write_buffer = 16M [mysqlhotcopy] interactive-timeout
And the server specs are:
CPU Cores 2 cores RAM (Memory) 1GB SSD (Disk Space) 20GB
Running Ubuntu 12.04 LTS
Here are my partitions:
NAME FSTYPE SIZE MOUNTPOINT LABEL vda 20G ├─vda1 ext4 476M /boot ├─vda2 swap 477M [SWAP] └─vda3 ext4 19.1G /
Any help would be much appreciated.