plainblack.com
Username Password
search
Bookmark and Share

    

mysql query caching

User mdawg
Date 8/12/2005 2:51 pm
Views 2873
Rating 35    Rate [
|
]
Previous · Next
User Message
mdawg
For those of you using mysql 4.0 or later, you can enable query caching which seems to have improved webgui performance at this installation...

matthew

Back to Top
Rate [
|
]
 
 
mdawg
For those of you using mysql 4.0 or later, you can enable query caching which seems to have improved webgui performance at this installation...

matthew

Back to Top
Rate [
|
]
 
 
pvanthony
Hi,

Thank you for the tip.

Please do us know how you activate query caching. I am using MySQL 4.1.

P.V.Anthony

Back to Top
Rate [
|
]
 
 
mdawg
see http://dev.mysql.com/doc/mysql/en/Query_Cache_Configuration.html

It's a setting in the my.cnf (my.ini in Windows).

By default, query_cache_size = 0

Change it to 1048576 for a typical server.

Also set query_cache_type = 1

Back to Top
Rate [
|
]
 
 
pvanthony
Hi,

Thank you very much.

P.V.Anthony


Back to Top
Rate [
|
]
 
 
    



© 2012 Plain Black Corporation | All Rights Reserved