|
Friday 05 March 2004 5:27:01 am
Hi, a "small tip" which can speed up the system if you are using mysql 4.x. The "query cache" is turned off by default. Turning on the cache boost up the system!
To have a look, if your caching is turned on / off:
mysql> SHOW VARIABLES LIKE '%query_cache%';
+-------------------+---------+
| Variable_name | Value |
+-------------------+---------+
| have_query_cache | YES |
| query_cache_limit | 1048576 |
| query_cache_size | 0 |
| query_cache_type | ON |
+-------------------+---------+
4 rows in set (0.06 sec) If the "query_cache_size" is set to 0 -> the caching is disabled. Just put this in your my.ini / my.cnf configuration file:
query-cache-type = 1
query-cache-size = 32M
Kind regards,
Emil.
Best wishes,
Georg.
--
http://www.schicksal.com Horoskop website which uses eZ Publish since 2004
|