[VPS] Need optimization

[Big Dan]

Howdy Folks,

I'm running a medium sized XF board (37k threads, 465k posts) on a VPS with 1280MB RAM. It's a standard LAMP server running cPanel minus Apache; I'm running Litespeed. I do have memcache installed but not activated with XF; I'd read on the boards that performance increase was negligible on a single server. I've had the server techs tweak mySQL and it helped for a little while but it's feeling sluggish again.

The biggest problem I'm seeing is database commits. Posting threads, replies, conversations, etc. intermittently hangs for quite a bit and sometimes triggers the dreaded Server did not respond in time error. RAM is only at ~70% utilization at any given time so I doubt it's a lack of memory problem. Page loads are generally pretty fast.

Within the next couple of months I'll be moving the board to a fully dedicated box but in the mean time it'd be nice if the site would hum along in the mean time. There are a couple of small Wordpress installs running on this server but they can be moved if certain tweaks wouldn't play well with WP.

What files do you guys need to see?

Thanks in advance,
Dan

Edit:

I forgot to add I'm running Extended Search from XF too, if that tidbid helps.

 

[Luke F]

my.cnf and http://mysqltuner.pl/mysqltuner.pl

 

[Slavik]

Can you post up your current my.cnf

 

[Big Dan]

my.cnf and http://mysqltuner.pl/mysqltuner.pl

Do you want me to run that perl script as root?

my.cnf from /etc/my.cnf (I assume this is the only one?)

[mysqld]
skip-bdb
local-infile=0
datadir=/var/lib/mysql
skip-locking
safe-show-database
long_query_time=2
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_user_connections=30
max_connections=200
thread_cache_size=128
table_cache=2048
key_buffer=64M
max_connect_errors=20
max_allowed_packet=16M
join_buffer=1M
record_buffer=1M
sort_buffer_size=1M
read_buffer_size=1M
read_rnd_buffer_size=1M
thread_concurrency=4
myisam_sort_buffer_size=16M
open_files_limit=8192
concurrent_insert=2
local-infile=0

 

[Luke F]

[mysqld]
skip-bdb
local-infile=0
datadir=/var/lib/mysql
skip-locking
safe-show-database
long_query_time=2
query_cache_limit=16M
query_cache_size=200M
query_cache_type=1
max_user_connections=30
max_connections=200
thread_cache_size=128
table_cache=2048
key_buffer=32M
max_connect_errors=20
max_allowed_packet=16M
join_buffer=2M
record_buffer=1M
sort_buffer_size=16M
read_buffer_size=2M
read_rnd_buffer_size=2M
thread_concurrency=4
myisam_sort_buffer_size=16M
open_files_limit=8192
concurrent_insert=2
local-infile=0
 
innodb_buffer_pool_size = 400M
innodb_thread_concurrency = 8
innodb_flush_log_at_trx_commit = 0

And yes, but there may be no need, see how that performs

If you run out of RAM reduce innodb_buffer_pool_size

 

[Big Dan]

Thank you Dark! Just updated the config and restarted mySQL. The site seems faster. I'll see how it preforms during our busy days.