Benchmarking

[Tadej Guzej]

How do I benchmark 2 queries that return same results
without having mysql read from cache?

Example:
if i run the first query it will take 2 seconds, when I run the query
again, it takes 0.05 seconds.


And

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?
Can someone explain the settings of that.


Thanks,
Tadej