MySQL (my.cnf)
Tunning MySQL para servidor de 2.9 GB de memória RAM. Ajustar os parâmetros do arquivo de configuração do MySQL my.cnf para alta performance.
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 [mysqld] back_log = 75 #skip-innodb max_connections = 512 myisam_sort_buffer_size = 64M join_buffer_size = 1M read_buffer_size = 1M sort_buffer_size = 2M table_cache = 1800 thread_cache_size = 384 wait_timeout = 7200 connect_timeout = 120 tmp_table_size = 64M max_heap_table_size = 64M max_allowed_packet = 64M max_connect_errors = 1000 read_rnd_buffer_size = 524288 bulk_insert_buffer_size = 8M query_cache_limit = 5M query_cache_size = 1M query_cache_type = 1 query_prealloc_size = 65536 query_alloc_block_size = 131072 #Slow query long_query_time = 1 slow_query_log = 8 slow_query_log_file = /var/log/mysql/slowquery.log log_queries_not_using_indexes = 1 general_log = on general_log_file=/var/log/mysql/general.log [mysqld_safe] log_error=/var/log/mysqld.log pid_file=/var/run/mysqld/mysqld.pid bind address = 127.0.0.1 nice = -5 open_files_limit = 8192 [mysqldump] quick max_allowed_packet = 16M [myisamchk] key_buffer = 128M sort_buffer = 64M read_buffer = 16M write_buffer = 16M # Split Tables #innodb_file_per_table = 1 key_buffer_size = 32M table_open_cache = 200 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M
O que eu deveria alterar caso o server tivesse mais memória e processador ? Seria interessante você apontar isso... que ai ajudaria mto mais por exemplo eu tenho um server com 4 processadores e 8 GB de ram o que devo alterar ?