Help needed to Optimized my managed VPS for xenForo

[wickedstangs]

OK, first thing to do, use EasyApache and update PHP to either 5.3 or 5.4 (5.4.12 is the latest, I'm using that and works great), and Apache to 2.2.24

You also have no real InnoDB config in your MySQL setup. What version of MySQL are you using?

Ok, here is the update..


---
root@host [~]# cat /etc/my.cnf
[mysqld]
innodb_lock_wait_timeout=100
query_cache_size=128M
max_allowed_packet=16M
thread_cache_size=16
max_tmp_tables=1
max_heap_table_size=64M
open_files_limit=65535
max_connections=80
query_cache_type=1
local-infile=0
tmp_table_size=32M
table_open_cache=768
table_definition_cache=768
# safe-show-database
table_cache=256
interactive_timeout=120
wait_timeout=120
query_cache_limit=8M
innodb_file_per_table=1
default-storage-engine=MyISAM

root@host [~]# php -v
PHP 5.4.12 (cli) (built: Mar 8 2013 11:30:54)
Copyright (c) 1997-2013 The PHP Group
Zend Engine v2.4.0, Copyright (c) 1998-2013 Zend Technologies
with the ionCube PHP Loader v4.2.2, Copyright (c) 2002-2012, by ionCube Ltd.

root@host [~]# httpd -v
Server version: Apache/2.2.24 (Unix)
Server built: Mar 8 2013 11:26:59
Cpanel::Easy::Apache v3.18.6 rev9999
---

I am also pasting the MySQL version.

---
root@host [~]# mysql --version
mysql Ver 14.14 Distrib 5.5.30, for Linux (i686) using readline 5.1
---

 

[MattW]

Sent you a PC

 

[hellreturn]

how do I install this? Tried using PuTTy and did something, what next?

Did u followed what tutorial said? U need to run the script as shown in tutorial. With that you can actually see if your MySQL tunning is good or bad.

 

[wickedstangs]

Did u followed what tutorial said? U need to run the script as shown in tutorial. With that you can actually see if your MySQL tunning is good or bad.

I downloaded it, how do you run it?

 

[MattW]

chmod +x mysqltuner.pl
./mysqltuner.pl

 

[Deleted member 2163]

chmod +x mysqltuner.pl
./mysqltuner.pl

Just want to note that you should not blindly follow mysqltuner.pl's recommendations, especially if the server has been recently started/restarted or hasn't been running for at least (the more the better!) a week or two with consistent use.

It is a good tool if used properly, but it should not be run early or often to tweak settings. There are plenty of resources online that provide recommendations for various mysql settings for cache sizes, etc, based on what kind of resources you have for your VPS.

Here are a couple good ones:

General tuning:
http://petermoulding.com/tune_mysql_and_mariadb_through_their_.ini_configuration_file

InnoDB thread concurrency explained
http://www.mysqlperformanceblog.com/2006/06/05/innodb-thread-concurrency/