Diego Zabaleta writes:
>
> What I could observe is that the demons mysqld are consuming memory in
> incremental form (to see this I use the tool ' top' of RedHat Linux 6.2),
> each certain time consumes 4kb but, after the program finishes these demons
> they liberate the memory (top informs me that the demons mysqld are
> consuming less memory than before); to the I finish of one day they end up
> consuming but of 10 mbytes by heart (this depends on the quantity from calls
> to a routine that he/she obtains data of a chart).
>
> I use an only active connection, which closes at the end of the program; on
> this connection I carry out thousands of calls to obtain data, after
> obtaining every Sep of data I call to the routine ' mysql_free_result'. I
> think that each called n is increased the use by heart of mysqld. I have
> proven to make the calls every 10 seconds and mysqld it consumes enough but
> quick memory that making them each 2 or 3 minutes.
>
> Thank you,
> Diego. -
>
HI!
I am sorry, but you are mixing things. Client programs can not cause
memory leaking in the server.
The increase in mysqld memory image is due to table_cache. If you
would flush tables with mysqlgui or mysqladmin, the utilised memory
would decrease.
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:sinisa@stripped
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
