Changes between Initial Version and Version 1 of HostingServerSetupRecommendations


Ignore:
Timestamp:
Aug 27, 2010, 6:17:17 AM (14 years ago)
Author:
AlexT
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • HostingServerSetupRecommendations

    v1 v1  
     1 
     2= Hosting Server Setup Recommendations = 
     3 
     4It was noticed that many server's default setup is very inefficient. It lead to poor script performance and in some hosting can terminate your account due to heavy load. This document covers very basic recommendations on how to improve your site performance by slightly changing your server configuration.    
     5 
     6This recommendations are for dedicated or VPS server owners, however if you are on shared hosting and notice that your server configuration is inefficient you can ask your hosting support do change this settings on the server, so whole server will run faster.   
     7 
     8== MySQL == 
     9 
     10[mysqld] 
     11 
     12query_cache_limit = 1M 
     13query_cache_size = 32M 
     14 
     15key_buffer_size = 64M 
     16 
     17max_heap_table_size = 256M 
     18tmp_table_size = 256M 
     19 
     20thread_cache = 128 
     21 
     22First you need to check if query_cache is enabled on your server. It was noticed that 80% of all SELECT queries are taken from query_cache when it is enabled, so if it is disabled on your server - mysql performance is '''5''' times slower !  
     23 
     24To check this go to phpMysqlAdmin tool (in most cases it is in your whm panel -> SQL Services -> phpMyAdmin). Then click "Variables" tab. 
     25"query cache size" must be at lesat 16M, "query cache type" must be ON and "query cache limit" value should be around 1M: 
     26 
     27  
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.
Fork me on GitHub