mysql not freeing memory

2001-03-29 Thread Shaun Tritton
Hello All, I have to memory problems with mysql. 1: When a client makes a "SELECT * FROM mytable1" request to the server , mysqld allocates memory to handle it and on subsequent queries to the same table no more memory is allocated.However, if a subsequent query such as

Re: mysql not freeing memory

2001-03-30 Thread Shaun Tritton
At 18:52 29/03/01 +0200, you wrote: Hello again! >Sorry but didn't see your other comments on first reading. I thought that the key cache meant that mysqld would only hold key/indexes in memory and that the data the indexs point to would still be read/written from disk. It's just that it seems