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
fr
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 wrote:
> In the last episode (May 29), Gerald L. Clark said:
>> Little, Timothy wrote:
>> > Also titled, I want this to run slow ALL the time...
>> >
>>
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 ne
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
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 "k
Hi evrerybody
I have recently joint this mailing list.I am a new user of Mysql, I am
having a problem with mysql 3.22.32 on sun sparc netra t1.we are running
an ISP and we have around 9000 to 1 users in our database.
The problem is this that if some one sends any large query to check
three fo
