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? 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).
3: mysqld will not deallocate memory after a "mysqladmin -u root -p
shutdown" command s issued.
i'm using:-
mysql version 3.23.33
Linux Box - kernel 2.4 (swap disabled)
Can anyone help?
many thanks
Shaun.
---------------------------------------------------------------------
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
