Select Page

Optimizing MySQL settings for Joomla

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

About The Author

I worked with various Insurances companies across Switzerland on online applications handling billion premium volumes. I love to continuously spark my creativity in many different and challenging open-source projects fueled by my great passion for innovation and blockchain technology.In my technical role as a senior software engineer and Blockchain consultant, I help to define and implement innovative solutions in the scope of both blockchain and traditional products, solutions, and services. I can support the full spectrum of software development activities, starting from analyzing ideas and business cases and up to the production deployment of the solutions.I'm the Founder and CEO of Disruptr GmbH.

Categories