Changes between Version 2 and Version 3 of HostingServerSetupRecommendations

Timestamp:

Aug 27, 2010, 6:34:21 AM (14 years ago)

Author:

AlexT

Comment:

--

HostingServerSetupRecommendations

@@ -5 +5 @@
 
 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.  
+
+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.
+
+'''Remember, making wrong changes can bring your server down !'''
 
 == MySQL ==
@@ -23 +27 @@
 
 To check this go to phpMysqlAdmin tool (in most cases it is in your whm panel -> SQL Services -> phpMyAdmin). Then click "Variables" tab.
-"query cache size" must be at lesat 16M, "query cache type" must be ON and "query cache limit" value should be around 1M:
+"query cache size" must be at lesat 16M, "query cache type" must be ON and "query cache limit" value should be around 1M.
+Example of good configuration:
 
  [[Image(hssr-mysql-1-query-cache.jpg)]]
+
+After you realized that you need to change these settings you need to edit "my.cnf" file on your server (in most cases it in in "/etc" folder) and add the foollowing lines in "[mysqld]" section of the file, if the same configuration options already exists it is better to comment out old ones (with hash # symbol ) and add new ones near them:
+
+{{{
+[mysqld]
+
+query_cache_limit = 1M
+query_cache_size = 32M
+}}}
+
+This most critical configuration options
+
+