Server Optimization Request
 

I hope I have all the required information below. Pleases advise if you need anything else. I really appreciate any help I can get as I have been having odd issues and I just want to make sure I have a good configuration moving forward on this new server.

THANK YOU in advance!



1.)
Dedicated.


2.)
Intel(R) Core(TM)2 Quad CPU Q9400 @ 2.66GHz
4GB of DDR2 RAM
1 x 250 GB SATA II
Linux CentOS 5.3 (Final) (32bit)
2.6.18-128.2.1.el5PAE i686 Kernel
Apache 2.2.3


PHP 5.1.6 (cli) (built: Apr 7 2009 08:00:04)
Copyright (c) 1997-2006 The PHP Group
Zend Engine v2.1.0, Copyright (c) 1998-2006 Zend Technologies
with XCache v1.2.2, Copyright (c) 2005-2007, by mOo
with the ionCube PHP Loader v3.1.16, Copyright (c) 2002-2006, by ionCube Ltd.

MySQL 5.0.45-7.el5

Plesk 9.2.1


3.) vBulletin 3.8.3, with latest vbSEO install, also using xCache file store system in config.php

4.) I have to keep innodb enabled for Plesk to work - I suppose. When I skip-innodb mysqld can restart just fine, but plesk gives errors.


5.) Unsure on how mySQL was compiled

6.) top

top - 22:07:16 up 23:19, 1 user, load average: 0.24, 0.14, 0.13
Tasks: 183 total, 1 running, 175 sleeping, 6 stopped, 1 zombie
Cpu0 : 4.4%us, 0.9%sy, 0.0%ni, 94.6%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 0.6%us, 0.0%sy, 0.0%ni, 99.4%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu2 : 0.6%us, 0.3%sy, 0.0%ni, 99.1%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu3 : 18.7%us, 1.9%sy, 0.0%ni, 77.8%id, 1.6%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 4148560k total, 3460592k used, 687968k free, 423056k buffers
Swap: 2096472k total, 0k used, 2096472k free, 1938852k cached




7.) nano my.cnf

[mysqld]
set-variable=local-infile=0
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


safe-show-database
back_log = 50
max_connections = 500
key_buffer_size = 128M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 4000
thread_cache_size = 384
wait_timeout = 60
connect_timeout = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
net_buffer_length = 16384
max_connect_errors = 100000
thread_concurrency = 8
concurrent_insert = 2
table_lock_wait_timeout = 30
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 4M
query_cache_size = 96M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM
max_write_lock_count = 8

[mysqldump]
quick
max_allowed_packet = 64M


[myisamchk]
key_buffer = 64M
sort_buffer = 16M
read_buffer = 16M
write_buffer = 16M

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
nice = -5
open_files_limit = 8192




8.)


+---------------------------------

+---------------------------------------------------------+
| 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 | 2048000

|
| 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 | 2

|
| 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 | OFF

|
| expire_logs_days | 0

|
| flush | OFF

|
| flush_time | 0

|
| ft_boolean_syntax | + ->br /;; For windows users, replace xcache.so with php_xcache.dllbr /zend_extension_ts = c:/php/extensions/php_xcache.dllbr /;; or install as extension, make sure your extension_dir setting is correctbr /; extension = xcache.sobr /;; or win32:br /; extension = php_xcache.dllbr /br /br /[xcache]br /; ini only settings, all the values here is default unless explainedbr /br /; select low level shm/allocator scheme implemenationbr /xcache.shm_scheme = "mmap"br /; to disable: xcache.size=0br /; to enable : xcache.size=64M etc (any size > 0) and your system mmap allows
xcache.size = 164M
; set to cpu count (cat /proc/cpuinfo |grep -c processor)
xcache.count = 4
; just a hash hints, you can always store count(items) > slots
xcache.slots = 2K
; ttl of the cache item, 0=forever
xcache.ttl = 0
; interval of gc scanning expired items, 0=no scan, other values is in seconds
xcache.gc_interval = 0

; same as aboves but for variable cache
xcache.var_size = 2M
xcache.var_count = 4
xcache.var_slots = 2K
; default ttl
xcache.var_ttl = 0
xcache.var_maxttl = 0
xcache.var_gc_interval = 300

xcache.test = Off
; N/A for /dev/zero
xcache.readonly_protection = Off
; for *nix, xcache.mmap_path is a file path, not directory.
; Use something like "/tmp/xcache" if you want to turn on ReadonlyProtection
; 2 group of php won't share the same /tmp/xcache
; for win32, xcache.mmap_path=anonymous map name, not file path
xcache.mmap_path = "/dev/zero"


; leave it blank(disabled) or "/tmp/phpcore/"
; make sure it's writable by php (without checking open_basedir)
xcache.coredump_directory = ""

; per request settings
xcache.cacher = On
xcache.stat = On
xcache.optimizer = On

[xcache.coverager]
; per request settings
; enable coverage data collecting for xcache.coveragedump_directory and xcache_coverager_start/stop/get/clean() functions (will hurt executing performance)
xcache.coverager = Off

; ini only settings
; make sure it's readable (care open_basedir) by coverage viewer script
; requires xcache.coverager=On
xcache.coveragedump_directory = ""