Server Optimisation Request
 

<div>1. Is this on dedicated or shared virual server.

Dedicated.

2. your server specs.

cpu speed/type single or dual cpus): Dual AMD 2376
how much memory installed: 16GB RAM
hard drive type/configuration: 2 x 250GB SATA (RAID1)
linux distributor or windows version: CentOS 4.5
apache/IIS version: Apache/2.0.53
PHP version: PHP 5.2.9
MySQL version: MySQL 5.1.34

3. what version of vB are you running ?

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 ?

Using MySQL 5.1.34, but using a couple of innodb tables because we were experiencing a lot of table locking problems.
Tables converted to innodb are: vb_thread vb_user

5. if possible how mysql was compiled/installed

Not known.

6. your top stats. So log into your server via ssh telnet as root user and type the command in bold - top

Code:
top - 18:10:49 up 12 days, 20:18, 1 user, load average: 2.47, 2.17, 1.70
Tasks: 164 total, 1 running, 163 sleeping, 0 stopped, 0 zombie
Cpu0 : 31.2% us, 3.0% sy, 0.0% ni, 65.4% id, 0.3% wa, 0.0% hi, 0.0% si
Cpu1 : 6.3% us, 1.0% sy, 0.0% ni, 28.1% id, 64.6% wa, 0.0% hi, 0.0% si
Cpu2 : 0.3% us, 0.0% sy, 0.0% ni, 99.3% id, 0.3% wa, 0.0% hi, 0.0% si
Cpu3 : 1.3% us, 0.3% sy, 0.0% ni, 74.0% id, 24.3% wa, 0.0% hi, 0.0% si
Cpu4 : 2.3% us, 0.3% sy, 0.0% ni, 97.0% id, 0.3% wa, 0.0% hi, 0.0% si
Cpu5 : 3.3% us, 0.3% sy, 0.0% ni, 96.0% id, 0.3% wa, 0.0% hi, 0.0% si
Cpu6 : 0.0% us, 0.0% sy, 0.0% ni, 100.0% id, 0.0% wa, 0.0% hi, 0.0% si
Cpu7 : 0.0% us, 0.0% sy, 0.0% ni, 100.0% id, 0.0% wa, 0.0% hi, 0.0% si
Mem: 16634544k total, 9720656k used, 6913888k free, 53108k buffers
Swap: 2040244k total, 0k used, 2040244k free, 9220312k cached
7. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf or my.ini so post the contents inside of my.cnf (minus any passwords of course).

Code:
[mysqld]
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

# To allow mysqld to connect to a MySQL Cluster management daemon, uncomment
# these lines and adjust the connectstring as needed.
#ndbcluster
#ndb-connectstring="nodeid=4;host=localhost:1186"

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[ndbd]
# If you are running a MySQL Cluster storage daemon (ndbd) on this machine,
# adjust its connection to the management daemon here.
# Note: ndbd init script requires this to include nodeid!
connect-string="nodeid=2;host=localhost:1186"

[ndb_mgm]
# connection string for MySQL Cluster management tool
connect-string="host=localhost:1186"
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 |
| autocommit | ON |
| automatic_sp_privileges | ON |
| back_log | 50 |
| basedir | /usr/ |
| big_tables | OFF |
| binlog_cache_size | 32768 |
| binlog_format | STATEMENT |
| 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 | 10 |
| 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 | ON |
| error_count | 0 |
| event_scheduler | OFF |
| expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| foreign_key_checks | ON |
| ft_boolean_syntax | + ->