Server Optimization - Server about to explode
 

<div>1. Dedicated
2. CPU: Quad Core 6600
HD: 250 gig
OS: Centos 5.x
Apache: 2
PHP: 5.2.x
MYSQL: 5.0.45
3. 3.8.2
4. MyISAM only
5. ServerOs
6. Quote:
top - 23:41:00 up 6 days, 9:44, 1 user, load average: 1.64, 1.91, 1.68
Tasks: 190 total, 3 running, 185 sleeping, 2 stopped, 0 zombie
Cpu(s): 5.2%us, 1.4%sy, 0.0%ni, 93.2%id, 0.1%wa, 0.0%hi, 0.1%si, 0.0%st
Mem: 3366748k total, 2020660k used, 1346088k free, 136680k buffers
Swap: 4192956k total, 140k used, 4192816k free, 1673056k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
6247 nobody 23 0 32868 17m 3052 S 4.3 0.5 0:00.13 httpd
6246 nobody 17 0 33156 17m 3132 S 3.7 0.5 0:00.11 httpd
6249 mysql 16 0 95688 26m 3312 R 0.7 0.8 0:00.02 mysqld
6248 mysql 16 0 95688 26m 3312 R 0.3 0.8 0:00.01 mysqld
6647 mysql 15 0 95688 26m 3312 S 0.3 0.8 0:45.62 mysqld
1 root 15 0 2064 592 512 S 0.0 0.0 0:01.40 init
2 root RT -5 0 0 0 S 0.0 0.0 0:01.07 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.07 ksoftirqd/0
4 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/0
5 root RT -5 0 0 0 S 0.0 0.0 0:00.20 migration/1
6 root 34 19 0 0 0 S 0.0 0.0 0:00.21 ksoftirqd/1
7 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/1
8 root RT -5 0 0 0 S 0.0 0.0 0:02.61 migration/2
9 root 34 19 0 0 0 S 0.0 0.0 0:00.09 ksoftirqd/2
10 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/2
11 root RT -5 0 0 0 S 0.0 0.0 0:00.22 migration/3
12 root 34 19 0 0 0 S 0.0 0.0 0:00.15 ksoftirqd/3
7. Quote:
[mysqld]
set-variable = max_connections=300
set-variable = max_connect_errors=150
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 | 5 |
| 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 |
| engine_condition_pushdown | OFF |
| expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + ->