okie..got u
On 9/17/08, Bard Aase <[EMAIL PROTECTED]> wrote:
>
> On Wed, Sep 17, 2008 at 12:42 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> >>query_cache_limit is the maximum size of a single resultset in the
> >> cache. If your query results in a bigger resultset it will never get
> >> into the
On Wed, Sep 17, 2008 at 12:42 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
>>query_cache_limit is the maximum size of a single resultset in the
>> cache. If your query results in a bigger resultset it will never get
>> into the cache even if its room for it in the cache itself.
>
>
>
> Even if there
>query_cache_limit is the maximum size of a single resultset in the
> cache. If your query results in a bigger resultset it will never get
> into the cache even if its room for it in the cache itself.
Even if there is room why will it not fit into the cache.
On 9/17/08, Bard Aase <[EMAIL PRO
On Wed, Sep 17, 2008 at 11:54 AM, Uwe Kiewel <[EMAIL PROTECTED]> wrote:
> Bard Aase schrieb:
>> On Wed, Sep 17, 2008 at 11:37 AM, Uwe Kiewel <[EMAIL PROTECTED]> wrote:
>>> Hi,
>>>
>>> I have two questions regarding the query cache:
>>>
>>> 1. What is the difference between query_cache_limit and que
Bard Aase schrieb:
> On Wed, Sep 17, 2008 at 11:37 AM, Uwe Kiewel <[EMAIL PROTECTED]> wrote:
>> Hi,
>>
>> I have two questions regarding the query cache:
>>
>> 1. What is the difference between query_cache_limit and query_cache_size?
>
> query_cache_limit is the maximum size of a single resultset
On Wed, Sep 17, 2008 at 11:37 AM, Uwe Kiewel <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have two questions regarding the query cache:
>
> 1. What is the difference between query_cache_limit and query_cache_size?
query_cache_limit is the maximum size of a single resultset in the
cache. If your query re
Hi,
I have two questions regarding the query cache:
1. What is the difference between query_cache_limit and query_cache_size?
mysql> show variables like '%query_cache%';
have_query_cache | YES |
query_cache_limit| 1048576 |
query_cache_min_res_unit | 4096 |
Hello,
I just upgraded to MySQL 4.0.18. I have a question about the new
query-cache. The documentation says:
"The FLUSH TABLES statement also flushes the query cache."
What does that mean exactly? Does it mean FLUSH TABLES, in effect, is equal
to RESET QUERY CACHE, in that it purges the cache? O