|
|
Posted by Jerry Stuckle on 01/09/08 22:49
The Natural Philosopher wrote:
> Jerry Stuckle wrote:
>> NC wrote:
>>> On Jan 8, 8:12 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>>>> My point being that a network connection does not need to
>>>> be opened and close.
>>>
>>> Which network connection are we talking about -- the one between HTTP
>>> client and HTTP server or the one between MySQL client and MySQL
>>> server?
>>>
>>
>> My misstatement. What I meant to say was that no additional network
>> connections need to be opened or closed (between the client and the
>> server).
>>
>>>> And either way, if it's a commonly used image, the cache
>>>> (database or file system) can produce the image. In fact,
>>>> the database cache could be more efficient, as it doesn't
>>>> have to cache unrelated files, such as scripts.
>>>
>>> This is definitely true for content applications, where most recent
>>> items account for the lion's share of traffic, but it is generally
>>> false for social networking applications, where there are VERY few
>>> "commonly used" images, but rather, most of the content is used
>>> uncommonly -- my friends view my pictures, your friends view your
>>> pictures...
>>>
>>> Cheers,
>>> NC
>>>
>>
>> In that case either way they won't be in the cache and will need to be
>> retrieved. However, it's still more likely it will be in the database
>> cache than the file system cache. There's a lot more going on in the
>> file system.
>>
>>
> ..but its generally larger..in fact its probably true to say that all
> ram NOT being used for programs,is used for file system cache in most
> systems.
>
>
> Any machine that isn't using every last ounce of RAM to cache
> everything, is an overspecified machine IMHO ;-)
>
>
>
>
Not necessarily. I've seen some MySQL systems with huge caches. You
have direct control over the MySQL cache size. You don't have as much
control over the file system cache.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|