VPS Help Needed - Slow posting but sites fast

[Slavik]

service mysqld start or /etc/init.d/mysqld start

 

[Michael]

Neither work, is this not due to removing mysql with the commands?

 

[Slavik]

Neither work, is this not due to removing mysql with the commands?

Whats the error it gives?

 

[Michael]

I have PM'd you the whole log from putty just there

 

[Michael]

I would just like to say a big thank you to Slavik here, he has helped with getting Percona server working and running well and the sites posting speed has really improved, its not just a small difference but a huge difference. Thank you for the great support! Percona server is something I think I will be sticking with from now on. Anyone experiencing a fast loading XF but slow on posting replies should try this.

 

[Slavik]

I would just like to say a big thank you to Slavik here, he has helped with getting Percona server working and running well and the sites posting speed has really improved, its not just a small difference but a huge difference. Thank you for the great support! Percona server is something I think I will be sticking with from now on. Anyone experiencing a fast loading XF but slow on posting replies should try this.

No problem.

For those wondering, there were some lib dependency errors (the server was running WHM and cpanel) which needed to be removed as they were conflicting with the percona libs. Once done percona needed to be started up (with inno DB (error logs had to be removed)) and some configuration, and finally rebuild litespeed and php.

Glad it's made such an impact.

Can you just post your updated my.cnf here? I forgot to make a copy, just to show people what it had in it.

 

[MattW]

Nice work Slavik, that's what I had to go through on mine, as I also run cpanel/WHM. Has yum.conf also been updated to stop it excluding MySQL from updating now it's no longer being looked after by WHM?

 

[Michael]

No problem.

For those wondering, there were some lib dependency errors (the server was running WHM and cpanel) which needed to be removed as they were conflicting with the percona libs. Once done percona needed to be started up (with inno DB (error logs had to be removed)) and some configuration, and finally rebuild litespeed and php.

Glad it's made such an impact.

Can you just post your updated my.cnf here? I forgot to make a copy, just to show people what it had in it.

Here it is:

# Generated by Percona Configuration Wizard (http://tools.percona.com/) version REL5-20120208
# Configuration name server-9 generated for xxxxxxxxx@xxxxxxxxxxx.com at 2013-01-03 16:32:09
 
[mysqld]
 
default-storage-engine = innodb
 
# MyISAM #
key_buffer_size                = 32M
 
# SAFETY #
max_allowed_packet            = 16M
 
# CACHES AND LIMITS #
tmp_table_size                = 32M
max_heap_table_size            = 32M
query_cache_type              = 1
query_cache_size              = 32M
max_connections                = 500
thread_cache_size              = 50
open_files_limit              = 65535
table_definition_cache        = 1024
table_open_cache              = 2048
 
# INNODB #
innodb_flush_method            = O_DIRECT
innodb_log_files_in_group      = 2
innodb_log_file_size          = 128M
innodb_flush_log_at_trx_commit = 2
innodb_file_per_table          = 1
innodb_buffer_pool_size        = 1456M
 
# LOGGING #
log_error                      = /var/lib/mysql/mysql-error.log
log_queries_not_using_indexes  = 1
slow_query_log                = 1
slow_query_log_file            = /var/lib/mysql/mysql-slow.log

 

[Slavik]

Nice work Slavik, that's what I had to go through on mine, as I also run cpanel/WHM. Has yum.conf also been updated to stop it excluding MySQL from updating now it's no longer being looked after by WHM?

Disabled the mysql updates in WHM.

 

[Slavik]

Here it is:

Thats the one, cut out some bits and peices for your server and changed a few bits, but I think that should handle everything fine for the near future, at least until you update to a 64 bit system