Sunday, 30 September 2007 20:10

I publish here some of my server settings in the hope that it will also help others...

Server Setup

AMD64 1 Gb RAM, Linux OSS 10.0, 7 Joomla instances (one being waltercedric.com with 250'000 unique visitors per months), 1 simple machine forums, 3 gallery2 install

All MySQL tables are myISAM (table locking instead of row loacking in innodb, myIsam make sense as ther is more read then insert)

# vi in /etc/my.cnf

Below the diff command between a standard MySQL install

# diff my.cnf my-beforeOptimizations.cnf
30c30
< key_buffer = 50M
---
> key_buffer = 16M
32,33c32,33
< table_cache = 1500
< sort_buffer_size = 4M
---
> table_cache = 64
> sort_buffer_size = 512K
35,46c35,37
< read_buffer_size = 4M
< read_rnd_buffer_size = 1024K
< myisam_sort_buffer_size = 64M
< join_buffer_size = 4M
< thread_cache_size = 128
< wait_timeout = 14400
< connect_timeout = 10
< max_connect_errors = 10
< query_cache_limit = 2M
< query_cache_size = 128M
< query_cache_type = 1
< thread_concurrency=4
---
> read_buffer_size = 256K
> read_rnd_buffer_size = 512K
> myisam_sort_buffer_size = 8M
163,166c154,157
< key_buffer = 64M
< sort_buffer = 64M
< read_buffer = 16M
< write_buffer = 16M
---
> key_buffer = 20M
> sort_buffer_size = 20M
> read_buffer = 2M
> write_buffer = 2M