On Mon, Aug 13, 2001 at 05:54:35PM +0100, Tadej Guzej wrote:
> How do I benchmark 2 queries that return same results without having
> mysql read from cache?
The only certain way is to restart the server between the queries and
do what you can to flush the OS cache, too, if you're concerned about
it influencing the results.
> What is the max. size of the index file that fits into 512M memmory,
> so that mysql doesn't have to read the index file from disk?
It's probably rather close to 512MB, right?
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.29: up 60 days, processed 575,280,080 queries (109/sec. avg)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
