Re: MySQL 4.1.13-debian + large HEAP table

Hi!

On Aug 08, gaga moo wrote:
> Miguel,
> 
> MySQL in my case is the backbone of a fairly complex
> web application, so far things have been stable but
> very recently mysql started acting up.  This is
> probably due to changes in the site.

Do you mean it was not due to MySQL upgrade ?
 
> But in order to make a reproducable test case and
> submit a bug (if indeed it's a bug in mysql) I would
> need to know how to pinpoint the issue and find out
> for myself and you how to reproduce this.
> 
> Please give me some pointers on how to see exactly how
> mysql is using all that memory when it starts eating
> all my system memory up ...

"exactly" is problematic :(
but some hints are still available:
 
> I will leave a script running in the background that
> once in every few minutes checks mysql's memory usage
> and will execute any set of queries and log them for
> me whenever this happens again (as well as
> automatically restart mysqld for me, after the queries
> have been executed).

Try usual commands SHOW VARIABLES; SHOW STATUS;
SHOW INNODB STATUS, if you use InnoDB.
And also 'mysqladmin debug'.

Ah, by the way, if you have debug build of mysqld (with safemalloc),
then 'mysqladmin debug' will list ALL the memory allocations - looks
like "exactly" what you were asking for :)

Regards,
Sergei

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <[email protected]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Senior Software Developer
/_/  /_/\_, /___/\___\_\___/  Kerpen, Germany
       <___/  www.mysql.com

-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]