eAccelerator Optimized Settings

php.ini location for cPanel

/usr/local/lib/php.ini

eAccelerator caching in SHM only. SHM size = All scripts total sizes.

eaccelerator.cache_dir="/tmp/eaccelerator"
eaccelerator.check_mtime="1"
eaccelerator.compress="1"
eaccelerator.compress_level="9"
eaccelerator.debug="0"
eaccelerator.enable="1"
eaccelerator.filter=""
eaccelerator.optimizer="1"
eaccelerator.shm_max="0"
eaccelerator.shm_only="1"
eaccelerator.shm_prune_period="0"
eaccelerator.shm_size="128"
eaccelerator.shm_ttl="0"

MySQL Optimization

[mysqld]
low_priority_updates=1
max_connections = 100
key_buffer = 192M
tmpdir=/home/tmp
safe-show-database
skip-locking
max_allowed_packet = 16M
table_cache = 4096
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 2M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_type = 1
query_cache_size= 128M
query_cache_limit = 1M
thread_concurrency = 8
wait_timeout = 30
innodb_file_per_table
innodb_log_file_size = 10485760
open_files_limit = 8192
tmp_table_size = 256M
max_heap_table_size = 256M
join_buffer_size = 32M
key_buffer_size = 1024M
innodb_buffer_pool_size = 64M

table_definition_cache=1024

log-slow-queries=/var/lib/mysql/slow.log

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

local-infile=0