Re: High Memory Usage

2004-08-11 Thread Sashi Ramaswamy
On Tuesday 10 August 2004 05:25 pm, Jeremy Zawodny wrote:
 On Thu, Aug 05, 2004 at 10:27:54AM -0500, Sashi Ramaswamy wrote:
  Hi,
 
  All of a sudden the memory used by mysql threads has gone up. Each thread
  is consuming about 20 M of RAM.  My databases are really small and usage
  is not very intense. Tables in the database are of type INNODB. MySQL
  server version is 4.0.14-standard.

 I suspect most of that is shared memory, not private.

I am not sure I understand. Could you please elaborate?

How do I get MySQL to release this memory?

Thanks for your help.
Sashi


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: High Memory Usage

2004-08-10 Thread Jeremy Zawodny
On Thu, Aug 05, 2004 at 10:27:54AM -0500, Sashi Ramaswamy wrote:
 
 Hi,
 
 All of a sudden the memory used by mysql threads has gone up. Each thread is 
 consuming about 20 M of RAM.  My databases are really small and usage is not 
 very intense. Tables in the database are of type INNODB. MySQL server version 
 is 4.0.14-standard.

I suspect most of that is shared memory, not private.
-- 
Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED]  |  http://jeremy.zawodny.com/

[book] High Performance MySQL -- http://highperformancemysql.com/

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



High Memory Usage

2004-08-05 Thread Sashi Ramaswamy

Hi,

All of a sudden the memory used by mysql threads has gone up. Each thread is 
consuming about 20 M of RAM.  My databases are really small and usage is not 
very intense. Tables in the database are of type INNODB. MySQL server version 
is 4.0.14-standard.
Any ideas on how to fix this problem? I tried flushing logs, query cache, etc 
but nothing seems to help.

Thanks for you help.
Sashi

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]