Server optimisation request
 

<div>Hello, I would greatly appreciate it if someone would look over my setup and offer some advice as to any improvements that could be made.

Thanks in advance!

1. Dedicated server

2.
Quote:
processor : 1
vendor_id : AuthenticAMD
cpu family : 15
model : 67
model name : Dual-Core AMD Opteron(tm) Processor 1212
stepping : 3
cpu MHz : 1000.000
cache size : 1024 KB
cpu cores : 2

Ram: 2GB DDR RAM
OS: Red Hat Enterprise Linux 5 - 64 bit
PHP Version 5.1.6
Apache version - 2.2.3
Hard drive: 250GB SATA
Raid: SATA RAID Controller (RAID 1)
MySql version: 5.0.45
3. vBulletin 3.8.1

4. N/A

5. C compiler: gcc (GCC) 4.1.2 20071124 (Red Hat 4.1.2-41)
>C++ compiler: g++ (GCC) 4.1.2 20071124 (Red Hat 4.1.2-41)

6. Quote:
top - 15:05:59 up 2:43, 1 user, load average: 1.88, 1.86, 1.66
Tasks: 126 total, 2 running, 124 sleeping, 0 stopped, 0 zombie
Cpu0 : 40.2%us, 3.7%sy, 0.0%ni, 56.1%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 73.2%us, 5.6%sy, 0.0%ni, 20.5%id, 0.0%wa, 0.3%hi, 0.3%si, 0.0%st
Mem: 2059748k total, 1817328k used, 242420k free, 46404k buffers
Swap: 2040244k total, 74616k used, 1965628k free, 1054500k cached


7. Quote:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
#old_passwords=1
skip-locking
key_buffer = 64M
max_allowed_packet = 16M
table_cache = 2048
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 16
thread_concurrency = 8
query_cache_size = 32M
tmp_table_size=64M
back_log = 100
max_connect_errors = 10000
join_buffer_size=1M
open-files = 20000
max_connections = 500
interactive_timeout = 600
wait_timeout = 600


#max_connections=200


# The following directives should be commented out
# but included as they are things that get added
# very frequently on tickets. These are more in a
# need-this-feature basis.

# The below 2 cannot be set on the fly. If the customer already has
# InnoDB tables and wants to change the size of the InnoDB tablespace
# and InnoDB logs, then:
# 1. Run a full backup with mysqldump
# 2. Stop MySQL
# 3. Move current ibdata and ib_logfiles out of /var/lib/mysql
# 4. Uncomment the below innodb_data_file_path and innodb_log_file_size
# 5. Start MySQL (it will recreate new InnoDB files)
# 6. Restore data from backup
#innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
#innodb_log_file_size = 100M

innodb_buffer_pool_size = 64M
innodb_additional_mem_pool_size = 8M


#log-slow-queries=/var/lib/mysqllogs/slow-log
#long_query_time=2
#log-queries-not-using-indexes

#log-bin=/var/lib/mysqllogs/bin-log
#log-slave-updates
#expire_logs_days = 14
server-id = 1

[mysql.server]
user=mysql
#basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
open_files_limit=65536
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 | 100 |
| basedir | /usr/ |
| bdb_cache_size | 8388600 |
| bdb_home | /var/lib/mysql/ |
| bdb_log_buffer_size | 1048576 |
| 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 | + ->