From: Jerry Schwartz (jschwartzthe-infoshop.com)
Date: Thu Jun 12 2008 - 16:15:58 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

>From: Rory McKinley [mailto:rorymckinleylistsgmail.com]
>Sent: Thursday, June 12, 2008 4:57 PM
>To: Jerry Schwartz; mysql
>Subject: Re: Fulltext index -first query slow, subsequent queries fast
>
>Jerry Schwartz wrote:
>> File system, or disk caching, uses some kind of algorithm to hold
>chunks of
>> files in system RAM. That way a program can get to it more quickly
>than if
>> it had to go out to the disk. The algorithms vary, depending upon the
>smarts
>> of the program and the smarts of the file system. The system might
>keep the
>> most recently used stuff, the most frequently used stuff, even the
>stuff it
>> thinks you will need based upon the pattern of use.
>>
>> Regards,
><snip>
>
>Hi Jerry
>
>Thanks for the explanation.
>
>So, in short, I am most likely hitting a wall with the fulltext index,
>and I am just getting lucky cos of the disk caching, but I am not going
>to be able to get away from that initial slow load...rats.
[JS] I can't agree or disagree. I used to be a performance consultant, but
that was in another life and I don't know anything about MySQL's own caching
algorithms.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]