creating cache in mysql - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

wordgeist · 07-26-2010, 12:28 PM

Any of you knows how to create of increase the cache in mysql?

HyperGoblin · 07-31-2010, 09:42 PM

Why exactly would you wanna do that?

manzar · 08-02-2010, 05:30 AM

Edit your my.cnf and set query_cache_type equal to 1, and set the query_cache_size to some value (here we have set it to 25mb)

query_cache_type = 1
query_cache_size = 26214400

kinah · 08-14-2010, 04:59 AM

you can do it.

wordgeist · 08-14-2010, 11:58 PM

Quote:

Originally Posted by manzar

Edit your my.cnf and set query_cache_type equal to 1, and set the query_cache_size to some value (here we have set it to 25mb)

query_cache_type = 1
query_cache_size = 26214400

Do you restart mysql after modify my.cnf ?

goodbloggers · 08-15-2010, 10:06 PM

Quote:

Originally Posted by manzar

Edit your my.cnf and set query_cache_type equal to 1, and set the query_cache_size to some value (here we have set it to 25mb)

query_cache_type = 1
query_cache_size = 26214400

I will try this thx

asbharmal · 09-16-2010, 11:56 PM

you have be effective enough to have an effective cache done for the google and other search engines

giteshtrivedi · 10-05-2010, 07:53 AM

There is bug also coming with query_cache_type parameter. Please refer mysql document for same.

softwaretailor · 10-10-2010, 10:39 PM

thanks for share