MySQL Correct Configuration
I would be pleased if anyone can help me if my configuration set properly. This dedicated server only dedicated to run board (discuz), i understand i need a better CPU since we are moving during april but i need a temporary solution which can maximise the current server performance.
CPU: P4 2.0 GHz , 1024 RAM, 80GB, Apache 2.0.46, MySQL 4.1.10
Code:
[mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock set-variable = max_user_connections=600 set-variable = max_connections=600 set-variable = bind-address=127.0.0.1 skip-locking skip-innodb skip-bdb key_buffer = 384M max_allowed_packet = 1M table_cache = 512 sort_buffer_size = 1M read_buffer_size = 1M sort_buffer = 2M record_buffer = 2M myisam_sort_buffer_size = 64M thread_cache = 8 query_cache_size= 16M thread_concurrency = 2 max_connect_errors = 200 wait_timeout = 25 connect_timeout = 25 interactive_timeout = 25 default-character-set = utf8 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [isamchk] key_buffer = 128M sort_buffer_size = 128M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 128M sort_buffer_size = 128M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout
Code:
ServerTokens OS ServerRoot "/etc/httpd" #ScoreBoardFile run/httpd.scoreboard PidFile run/httpd.pid Timeout 30 KeepAlive Off MaxKeepAliveRequests 100 KeepAliveTimeout 20 ExtendedStatus On StartServers 5 ServerLimit 850 MinSpareServers 10 MaxSpareServers 20 MaxClients 850 MaxRequestsPerChild 3000 RLimitMEM 50% RLimitCPU 50% Listen 80
