Re: Why linux memory management isn't clever, always hold large memroy?

2006-10-10 Thread T.J. Duchene
bowen wrote: > Previously, memory use looks good. And I use mysql> load data infile > 'file' into table to import a very large mysql data file. So the > memory used became large quickly and soon exhaust all the memory to > use swap space. After that the system became slow for cpu fully > waiting

Re: Why linux memory management isn't clever, always hold large memroy?

2006-10-08 Thread Dave Sherohman
On Sun, Oct 08, 2006 at 11:51:46AM +0800, bowen wrote: > (Why mysql or system do not automatic free some of > the loaded data from memory, Just use a little swap space to sawp out > a little memory). > shell# free > total used free sharedbuffers cached > Mem:

Re: Why linux memory management isn't clever, always hold large memroy?

2006-10-07 Thread Roberto C. Sanchez
On Sun, Oct 08, 2006 at 11:51:46AM +0800, bowen wrote: > Previously, memory use looks good. And I use mysql> load data infile > 'file' into table to import a very large mysql data file. So the > memory used became large quickly and soon exhaust all the memory to > use swap space. After that the s

Re: Why linux memory management isn't clever, always hold large memroy?

2006-10-07 Thread David E. Fox
On Sun, 8 Oct 2006 11:51:46 +0800 bowen <[EMAIL PROTECTED]> wrote: > a little memory). After a long time, the mysql load process complete > and I restart the mysqld daemon, but the memory does still hold large > memory. How much does mysqld take up now? From what you've said here it would seem th

Why linux memory management isn't clever, always hold large memroy?

2006-10-07 Thread bowen
Previously, memory use looks good. And I use mysql> load data infile 'file' into table to import a very large mysql data file. So the memory used became large quickly and soon exhaust all the memory to use swap space. After that the system became slow for cpu fully waiting IO status. (Why mysql