Hi.
On Thu, Mar 29, 2001 at 04:43:53PM +0100, [EMAIL PROTECTED] wrote:
> 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 "SELECT * FROM mytable2" is issued, mysqld allocates additional memory
>
> even though the first client has closed it's connection.Is this supposed
> to happen this way?
Yes. MySQL has a key cache (and some other caches) which are used to
optimize speed. You can specify the size of the caches on start-up.
> My problem is that i'm running out of memory.
> 2: Update times for HEAP tables is slower than updates on MyISAM
> tables(using identical data).
This is too general to give an specific answer. HEAP tables are known
to be slower with some stuff (e.g. operating on ranges of values), and
maybe you just hit one.
> 3: mysqld will not deallocate memory after a "mysqladmin -u root -p
> shutdown" command s issued.
Huh? shutdown will make mysqld quit, so how even if MySQL wouldn't
deallocate memory, Linux would do it.
Does mysqld quit? And how did you measure memory consumption?
> i'm using:-
> mysql version 3.23.33
> Linux Box - kernel 2.4 (swap disabled)
Bye,
Benjamin.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
