This is my current setup:
[mysqld] default-storage-engine=MyISAM local-infile=0 symbolic-links=0 max_connections = 500 max_user_connections = 25 key_buffer = 64M myisam_sort_buffer_size = 32M join_buffer_size = 2M read_buffer_size = 2M sort_buffer_size = 2M read_rnd_buffer_size = 2M table_cache = 1024 thread_cache_size = 16K wait_timeout = 20 connect_timeout = 10 tmp_table_size = 128M max_heap_table_size = 128M max_allowed_packet = 160M max_connect_errors = 10 query_cache_limit = 1M query_cache_size = 16M query_cache_type = 1 low_priority_updates=1 concurrent_insert=ALWAYS [mysqld_safe] open_files_limit = 8192 [mysqldump] max_allowed_packet = 16M [myisamchk] key_buffer = 64M sort_buffer = 64M read_buffer = 16M write_buffer = 16M
I've been noticing a lot more I/O lately and was wondering if there was something I could tune to increase performance?
I have an 8GB of RAM. Should I increase the values?