|
|
![]() |
| Thread Tools | Search this Thread |
#1
| |||
| |||
Turn on MySQL query cache to speed up query performance I know there are different way to speed up performance of web based application, but i want some information on query cache of database to speed up web application. |
#2
| |||
| |||
Re: Turn on MySQL query cache to speed up query performance Query cache is great for certain applications, typically simple applications deployed on limited scale or applications dealing with small data sets. query_cache_size – This is the size of the cache in bytes. Setting this value to 0 will effectively disable caching. When using a standard MySQL binary, this value is always YES, even if query caching is disabled.The query cache is also controlled by the setting of the query_cache_type variable. |
#3
| |||
| |||
Re: Turn on MySQL query cache to speed up query performance To speed up query, enable the MySQL query cache, before that you need to set few variables in mysql configuration file (usually is my.cnf or my.ini). It can be seen worse if your query cache size is in GigabytesQuery caching can be enabled by setting the server variables query_cache_type, query_cache_size, and query_cache_limit. If any of these three variables is set to 0, query caching will be disabled. |
#4
| |||
| |||
Re: Turn on MySQL query cache to speed up query performance To enable mysql query cache write the following command in to cache.cnf file : Code: query_cache_size = 268435456 query_cache_type=1 query_cache_limit=1048576 |
![]() |
|
Tags: database, query cache, web application |
Thread Tools | Search this Thread |
|
![]() | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Query cache denied problem | Alibamu | Software Development | 6 | 19-06-2010 12:35 AM |
MySQL query in a query | Rail racer | Software Development | 3 | 21-07-2009 07:06 PM |
MySQL Query Cache | Ryder | Software Development | 3 | 16-04-2009 03:05 PM |
MySQL IF ELSE in Query | Ryder | Software Development | 3 | 27-03-2009 05:24 PM |
MySQL UPDATE Query | ANDERS | Software Development | 2 | 10-02-2009 11:57 AM |