Changes between Version 8 and Version 9 of HostingServerSetupRecommendations
- Timestamp:
- Aug 27, 2010, 7:20:12 AM (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
HostingServerSetupRecommendations
v8 v9 2 2 = Hosting Server Setup Recommendations = 3 3 4 It was noticed that many server's default setup is very inefficient. It lead to poor script performance and in somehosting 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.4 It was noticed that many server's default setup is very inefficient. It leads to poor script performance and in some cases 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 5 6 This 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.6 This 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 to change this settings on the server, so whole server will run faster. 7 7 8 8 You need root access to the server and have some skills on how to connect to the server using SSH terminal and know some basic command line tools, like navigating through directories and editing files. … … 15 15 16 16 17 Before starting optimization It is better to monitor your server performance before starting optimization and afterto see how things are changing, if it becomes better or worth. I suggest to install "[http://munin-monitoring.org/ Munin]" server monitor, it is available as WHM plugin, you can install it from WHM panel -> cPanel -> Manage Plugins -> click "Install and Keep Updated" near Munin logo and press "Save" button at the bottom of the page. After installing link to Munin appears in "Plugins" section of WHM panel, please allow up to 10 minutes until it generates pages with graphs for you.17 Before starting optimization it is better to monitor your server performance before starting optimization and after, to see how things are changing, if it becomes better or worth. I suggest to install "[http://munin-monitoring.org/ Munin]" server monitor, it is available as WHM plugin, you can install it from WHM panel -> cPanel -> Manage Plugins -> click "Install and Keep Updated" near Munin logo and press "Save" button at the bottom of the page. After installing link to Munin appears in "Plugins" section of WHM panel, please allow up to 10 minutes until it generates pages with graphs for you. 18 18 19 19 == MySQL == 20 20 21 First 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_cachewhen it is enabled, so if it is disabled on your server - mysql performance is '''5''' times slower !21 First 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 ! 22 22 23 To check this go to phpMysqlAdmin tool (in most cases it is in your whmpanel -> SQL Services -> phpMyAdmin). Then click "Variables" tab.23 To check this go to phpMysqlAdmin tool (in most cases it is in your WHM panel -> SQL Services -> phpMyAdmin). Then click "Variables" tab. 24 24 "query cache size" must be at lesat 16M, "query cache type" must be ON and "query cache limit" value should be around 1M. 25 25 Example of good configuration: … … 35 35 }}} 36 36 37 You need to restart mysql server to apply the changes, you can do it from whmpanel or from command line, most common command line for linux servers is:37 You need to restart MySQL server to apply the changes, you can do it from WHM panel or from command line, most common command line for linux servers is: 38 38 39 39 {{{ … … 41 41 }}} 42 42 43 This most critical configuration options. Other useful options must be enabled too - "key buffer size", "max heap table size", "tmp table size", "thread_cache" are some of them. But exact values varies from server from server, for example for dedicated or VPS server with 1Gb RAM and one dolphin site, these values maybe like this:43 This most critical configuration options. Other useful options should be enabled too - "key buffer size", "max heap table size", "tmp table size", "thread cache" are some of them. But exact values varies from server from server, for example for dedicated or VPS server with 1Gb RAM and one dolphin site, these values maybe like this: 44 44 45 45 {{{