We have a dedicated server through fasthosts and are running 1 wordpress set up and a multi-store magento set up.
Our Magento sites are running at a slow speed back and front-end compared to the wordpress site.
Has anyone had experience of optimising a dedicated server for Magento?
I've posted our server spec below along with our configurations for php and my.cnf. We've followed some advice on tweaking the settings but things don't seem to be running any better.
As you can see we're not on a small server set up so we believe we should be getting better performance from it.
Can anyone see anything that we are doing wrong with the set up?
Server config
2x 2.1GHz AMD Opteron™ 12 Core processors
32GB RAM
2x 300GB SAS hard disk drives (RAID 1*)
2x 500GB SATA hard disk drives (RAID 1*)
Remote server control - keyboard, mouse & video control
Bandwidth & network
Unlimited bandwidth 100Mbps
99.99% network uptime guarantee
2 IP addresses - Additional IPs available
Create private LANs for your server - Option
Multiple UK internet connections
Flexible remote backup space - Option
Linux server operating system
CentOS 5.5
Ubuntu 10.04
Red Hat Enterprise Server v5.3
Apache web server
Courier mail server
Postfix mail transport agent
PureFTP FTP server
MySQL database management
Preconfigured IP Tables port security
Bind 9 DNS
my.cnf Settings:
[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
# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0
key_buffer = 512M
max_allowed_packet = 64M
table_cache = 1024
sort_buffer_size = 256M
read_buffer_size = 16M
read_rnd_buffer_size = 16M
myisam_sort_buffer_size = 64M
tmp_table_size = 128M
thread_cache_size = 64
query_cache_type = 1
query_cache_size = 64M
query_cache_limit = 2M
max_connections = 500
wait_timeout = 300
thread_concurrency = 96
max_heap_table_size = 64M
innodb_buffer_pool_size = 12800M
innodb_additional_mem_pool_size = 20M
innodb_thread_concurrency = 50
innodb_autoextend_increment = 8M
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
php.ini settings
max_execution_time = 28000;
max_input_time = 60;
memory_limit = 9216M;