Thanks for the quick reply.
I need some further inputs from you.
Is there any other way (except query cache) using which the database can
be made memory resident.
Actually I want a database which is to be used by a lookup
server(something like a dns server). The database lookup delay can
become a bottleneck in the performance of the server.
Do you know of any techniques used to speedup frequent database lookups
for databases which are mostly static in nature.
thanks and regards,
From: Jeremy Zawodny [mailto:jzawodn@stripped]
Sent: Tuesday, January 22, 2002 12:41 PM
To: Chetan Lavti
Subject: Re: regarding the MySQL's server Chaching feature
On Tue, Jan 22, 2002 at 12:30:56PM +0530, Chetan Lavti wrote:
> I am using (open source) MySQL-3.23.47, I wanted to know, is the
> feature of caching of the data in RAM is available in this version
> ?If yes , then what is the limit of that in terms of size. What I
> have Understood is that this feature will be available with the
> version 4.0 and if so, how this is implemented in the version 4.0
> ?how to configure this ?
It sounds like you're referring to the new Query Cache. If so, no.
That's in verison 4.0 only.
Jeremy D. Zawodny, <jzawodn@stripped>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 19 days, processed 440,853,176 queries (264/sec.