[cvs] [Wiki] changed: CentOS5InstallationNotes

[Wiki Guest]

guest [201.6.87.23]  Mon, 26 Jan 2009 19:52:29 -0500

Modified page: http://wiki.horde.org/CentOS5InstallationNotes
New Revision:  1.32
Change log:  Added mysql query cache hint

@@ -343,4 +343,19 @@
  <code>
  service httpd restart
  </code>

+++ Performance
+
+You could try to increase mysql performance by enabling query cache feature.
+
+Edit your /etc/my.cnf and add the following under [mysqld]:
+
+<code>
+query-cache-size=50M  (or whatever you think is enough)
+</code>
+
+Run the exact same queries and then, on mysql console, check on query  
cache status:
+
+<code>
+mysql> show status like '%qcache%';
+</code>