Changes between Version 9 and Version 10 of HostingServerSetupRecommendations


Ignore:
Timestamp:
Aug 27, 2010, 7:22:15 AM (14 years ago)
Author:
AlexT
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • HostingServerSetupRecommendations

    v9 v10  
    5858}}} 
    5959 
    60 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.  
     60There 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 to your available RAM. Keep in mind that these 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.  
    6161 
    62 This is an example on many queries becomes cached after introducing "query cache": 
     62This is an example on how many queries becomes cached after introducing "query cache": 
    6363 
    6464[[Image(hssr-mysql-2-queries-day.png)]] 
    6565 
    66 1 day is showed on the graph, in the beginning cache was disabled then cache was enabled - pink zpne shows SELECT queries which are taken from cache. So, benefits are obvious ! 
     661 day is showed on the graph, in the beginning cache was disabled, then cache was enabled - pink zone shows SELECT queries which are taken from cache. So, benefits are obvious ! 
    6767 
    6868 
 
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