Changes between Version 4 and Version 5 of HostingServerSetupRecommendations
- Timestamp:
- Aug 27, 2010, 7:11:23 AM (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
HostingServerSetupRecommendations
v4 v5 9 9 10 10 '''Remember, making wrong changes can bring your server down !''' 11 12 == Before Start == 13 14 Always backup old data, so you can always return to original configuration. 15 16 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" nead 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. 11 17 12 18 == MySQL == … … 51 57 }}} 52 58 53 There is already a tool in phpMyAdmin which can help you with deciding what configuration values need to be changed. Go to phpMyAdmin and open "Status" tab, look through this page and pay attention to red values. There is a comment near each value you can use as a guide in changing particular MySQL option. Keep in mind that this is values are collected during some time, so if you change some value it is better to wait at least 1 day until new data is collected for analysis. After MySQL restarted this data is collected from the scratch.59 There is already a tool in phpMyAdmin which can help you with deciding what configuration values need to be changed. Go to phpMyAdmin and open "Status" tab, look through this page and pay attention to red values. There is a comment near each value you can use as a guide in changing particular MySQL option. During changing remember that memory is always limited, so you need to increase the values adequately your available RAM. Keep in mind that this is values are collected during some time, so if you change some value it is better to wait at least 1 day until new data is collected for analysis. After MySQL restarted this data is collected from the scratch. 54 60 55 61 This is an example on many queries becomes cached after introducing "query cache":