I had heard of that trick but never looked it up. 'man proc' tells me
/proc/sys/vm/drop_caches (since Linux 2.6.16)
Writing to this file causes the kernel to drop clean caches,
dentries and inodes from memory, causing that memory to become
Also titled, I want this to run slow ALL the time...
I have a group of dreadful queries that I have to optimize.
Some take 20-30 seconds each -- the first time that I run them. But
then they never seem to take that long after the first time (taking less
than a second then). If I change the
Little, Timothy wrote:
Also titled, I want this to run slow ALL the time...
I have a group of dreadful queries that I have to optimize.
Some take 20-30 seconds each -- the first time that I run them. But
then they never seem to take that long after the first time (taking less
than a second
In the last episode (May 29), Gerald L. Clark said:
Little, Timothy wrote:
Also titled, I want this to run slow ALL the time...
I have a group of dreadful queries that I have to optimize.
Some take 20-30 seconds each -- the first time that I run them. But
then they never seem to
You can also flush the cache with echo 1 /proc/sys/vm/drop_caches if
you have a new enough kernel.
On Fri, May 29, 2009 at 2:16 PM, Dan Nelson dnel...@allantgroup.com wrote:
In the last episode (May 29), Gerald L. Clark said:
Little, Timothy wrote:
Also titled, I want this to run slow ALL