New Server Configuration Request
 

<div>1. Dedicated

2. cpu speed/type single or dual cpus): Dual Quad Core Xeon 5520
how much memory installed: 12GB DDR3 RAM
hard drive type/configuration: 1 x 400GB 10K SAS
linux distributor or windows version: CENTOS 5.3
apache/IIS version: Apache v2.2.11
PHP version: php 5.2.8
MySQL version: mysql 5.0.81-community


3. 3.8.2

4. No

5. Default

6. Quote:
top - 11:28:49 up 8 days, 10:03, 1 user, load average: 2.65, 2.17, 2.12
Tasks: 600 total, 5 running, 594 sleeping, 0 stopped, 1 zombie
Cpu(s): 0.1%us, 0.2%sy, 0.6%ni, 98.2%id, 0.7%wa, 0.0%hi, 0.1%si, 0.0%st
Mem: 12290972k total, 11918904k used, 372068k free, 533288k buffers
Swap: 1052248k total, 228k used, 1052020k free, 6160288k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
5887 nobody 20 4 304m 71m 15m R 100.6 0.6 0:02.07 httpd
26234 mysql 21 6 530m 210m 4376 S 94.8 1.8 158:58.14 mysqld
9466 nobody 20 4 268m 36m 16m S 46.4 0.3 0:01.06 httpd
14636 nobody 19 4 265m 32m 13m S 31.0 0.3 0:00.38 httpd
32705 nobody 20 4 268m 37m 16m R 21.3 0.3 0:02.61 httpd
9362 nobody 20 4 268m 40m 17m R 17.4 0.3 0:01.82 httpd
12242 nobody 20 4 267m 34m 12m S 11.6 0.3 0:01.11 httpd
14647 nobody 20 4 266m 32m 13m R 9.7 0.3 0:00.49 httpd
16953 root 19 4 12996 1376 716 R 3.9 0.0 0:00.02 top
908 root 10 -5 0 0 0 S 1.9 0.0 0:11.24 ata/4
1616 root 21 4 9052 1440 868 S 1.9 0.0 0:03.18 sim
20824 root 21 4 9088 1500 868 S 1.9 0.0 0:02.63 sim
23789 root 21 4 9052 1432 868 S 1.9 0.0 0:01.00 sim
1 root 15 0 10344 640 544 S 0.0 0.0 0:03.34 init
2 root RT -5 0 0 0 S 0.0 0.0 0:21.76 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.06 ksoftirqd/0
4 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/0 top -
Quote:
11:29:32 up 8 days, 10:04, 1 user, load average: 2.54, 2.19, 2.13
Tasks: 583 total, 3 running, 579 sleeping, 0 stopped, 1 zombie
Cpu0 : 0.1%us, 0.4%sy, 0.6%ni, 98.5%id, 0.3%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 0.1%us, 0.5%sy, 0.9%ni, 97.2%id, 1.1%wa, 0.0%hi, 0.1%si, 0.0%st
Cpu2 : 0.2%us, 0.2%sy, 0.4%ni, 97.3%id, 1.9%wa, 0.0%hi, 0.1%si, 0.0%st
Cpu3 : 0.1%us, 0.2%sy, 0.6%ni, 97.3%id, 1.7%wa, 0.0%hi, 0.1%si, 0.0%st
Cpu4 : 0.2%us, 0.1%sy, 0.4%ni, 97.8%id, 1.4%wa, 0.0%hi, 0.1%si, 0.0%st
Cpu5 : 0.0%us, 0.2%sy, 0.5%ni, 98.7%id, 0.5%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu6 : 0.1%us, 0.1%sy, 0.4%ni, 98.9%id, 0.5%wa, 0.0%hi, 0.1%si, 0.0%st
Cpu7 : 0.0%us, 0.1%sy, 0.3%ni, 99.2%id, 0.4%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu8 : 0.1%us, 0.1%sy, 0.4%ni, 99.3%id, 0.2%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu9 : 0.0%us, 0.2%sy, 0.8%ni, 98.1%id, 0.8%wa, 0.0%hi, 0.1%si, 0.0%st
Cpu10 : 0.1%us, 0.4%sy, 0.5%ni, 98.1%id, 0.8%wa, 0.0%hi, 0.1%si, 0.0%st
Cpu11 : 0.1%us, 0.5%sy, 1.0%ni, 97.5%id, 0.9%wa, 0.0%hi, 0.1%si, 0.0%st
Cpu12 : 0.1%us, 0.2%sy, 0.6%ni, 98.6%id, 0.4%wa, 0.0%hi, 0.1%si, 0.0%st
Cpu13 : 0.0%us, 0.3%sy, 1.2%ni, 98.1%id, 0.3%wa, 0.0%hi, 0.1%si, 0.0%st
Cpu14 : 0.1%us, 0.2%sy, 0.6%ni, 99.0%id, 0.2%wa, 0.0%hi, 0.1%si, 0.0%st
Cpu15 : 0.0%us, 0.3%sy, 1.2%ni, 98.0%id, 0.3%wa, 0.0%hi, 0.3%si, 0.0%st
Mem: 12290972k total, 11582828k used, 708144k free, 533308k buffers
Swap: 1052248k total, 228k used, 1052020k free, 6163000k cached
7. Quote:
[mysqld]
skip-bdb
max_connections = 500
thread_concurrency = 8

key_buffer = 4M
key_buffer_size = 4M
myisam_sort_buffer_size = 32M
join_buffer_size = 16M
read_buffer_size = 16M
sort_buffer_size = 16M
record_buffer = 16M

max_allowed_packet = 16M

table_cache = 200
thread_cache_size = 128

wait_timeout = 60
connect_timeout = 60
interactive_timeout = 50
max_connect_errors = 20

query_cache_type = 1
query_cache_limit = 64M
query_cache_size = 64M

skip-locking
safe-show-database

#log-slow-queries = /var/log/mysqld.slow.log
long_query_time = 2


[mysqld_safe]
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 32M
read_buffer = 30M
write_buffer = 30M

8. <div style="margin:20px; margin-top:5px; "> Quote:
+---------------------------------+-------------------------------------+
| Variable_name | Value |
+---------------------------------+-------------------------------------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| automatic_sp_privileges | ON |
| back_log | 50 |
| basedir | / |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| completion_type | 0 |
| concurrent_insert | 1 |
| connect_timeout | 60 |
| datadir | /var/lib/mysql/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| div_precision_increment | 4 |
| keep_files_on_create | OFF |
| engine_condition_pushdown | OFF |
| expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + ->