Web Server + DB Server Optimization Request
 

<div>1. Is this on dedicated or shared virual server. If shared, how many sites share this server (ask web host if needed)

Dedicated - nonshared

2. your server specs.
cpu speed/type single or dual cpus):
dual p4 3ghz

how much memory installed:
2Gig ram

hard drive type/configuration:
200GB EIDE non raid

linux distributor or windows version:
Centos 5

apache/IIS version: apache 2
PHP version: php 5.2.5

3. what version of vB are you running ?
Version 3.8.2

4. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?
no

5. if possible how mysql was compiled/installed
no idea was isntalled via yum

6. your top stats. So log into your server via ssh telnet as root user and type the command in bold - top
Code:
top - 21:33:43 up 1 day, 11:10, 1 user, load average: 0.54, 0.50, 0.59
Tasks: 101 total, 2 running, 99 sleeping, 0 stopped, 0 zombie
Cpu(s): 31.0% us, 3.6% sy, 0.0% ni, 64.8% id, 0.1% wa, 0.0% hi, 0.4% si
Mem: 1260696k total, 314856k used, 945840k free, 55064k buffers
Swap: 0k total, 0k used, 0k free, 119220k cached
Now while top is running hit the number 1 on keyboard to show break down of cpu load over all cpu cores

Code:
top - 21:35:25 up 1 day, 11:11, 1 user, load average: 0.30, 0.44, 0.55
Tasks: 101 total, 1 running, 100 sleeping, 0 stopped, 0 zombie
Cpu0 : 7.7% us, 0.5% sy, 0.0% ni, 91.9% id, 0.0% wa, 0.0% hi, 0.0% si
Mem: 1260696k total, 300488k used, 960208k free, 55160k buffers
Swap: 0k total, 0k used, 0k free, 119396k cached
7. your mysql configuration variables located at /etc/my.cnf

Code:
# The following options will be passed to all MySQL clients
[client]
socket=/tmp/mysql.sock

# The MySQL server
[mysqld]
tmpdir=/tmp
socket=/tmp/mysql.sock
skip-locking
# skip-networking
skip-name-resolve
server-id=1
max_connections=500
key_buffer_size=512M
max_allowed_packet=16M
table_cache=256
sort_buffer_size=16M
read_buffer_size=16M
join_buffer_size=5M
# if you are performing GROUP BY or ORDER BY queries on tables that
# are much larger than your available memory, you should increase
# the value of read_rnd_buffer_size to speed up the reading of rows
# following sorting operations.
# but: change the session variable only from within those clients
# that need to run large queries
read_rnd_buffer_size=4M
max_heap_table_size=256M
tmp_table_size=256M
myisam_sort_buffer_size=64M
# increase until threads_created doesnt grow anymore
thread_cache=256
query_cache_type=1
query_cache_limit=1M
query_cache_size=32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=4

[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
8. MySQL stats from ssh telnet as root user type:
<div style="margin:20px; margin-top:5px"> Code:
+---------------------------------+------------------------------------------------------------+
| Variable_name | Value |
+---------------------------------+------------------------------------------------------------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| automatic_sp_privileges | ON |
| back_log | 50 |
| basedir | /usr/ |
| bdb_cache_size | 8388600 |
| bdb_home | /var/lib/mysql/ |
| bdb_log_buffer_size | 131072 |
| bdb_logdir | |
| bdb_max_lock | 10000 |
| bdb_shared_data | OFF |
| bdb_tmpdir | /tmp/ |
| 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 | + ->