Hi there,
We know that normally Mysql is good at controlling memory usage but the
problem we are seeing is a bit suspicious. I want to ask for help to see
whether somebody can help on debugging the issue. Feel free to let me know
if there are more details needed.
The databases we have are all
id, I am using the thread aware libraries of mysql and
> mysqlpp.
>
> Here are a couple of stack traces I get on application shutdown from a
> memory leak detector (using VLD 1.0 on VS 9.0):
>
> Connect related:
>
> Call Stack:
> f:\dd\vctools\crt_bld\self_x86\crt\src\dbg
orker (when a connection
becomes available)
That all being said, I am using the thread aware libraries of mysql and
mysqlpp.
Here are a couple of stack traces I get on application shutdown from a
memory leak detector (using VLD 1.0 on VS 9.0):
Connect related:
Call Stack:
f:\dd\vctools\crt
Hello there guys,
Latelly our database server is going into a very big problem, our current
configuration (is in an attachment file), is having huge load of leak memory
and a variable *innodb_log_file_size *is off cause when i up it the mysqld
doesn't start, our server is having this status(averag
Hi.
There are 1 store procedures in my database,and prepared statement was
used within procedure's definition.
But when our concurrency is higher,mysqld's memory grows very fast.
PS:I have explicitly used drop prepare .. statement in procedure's
definition.
Anybody can tell me why this happen
I'm using mysql 4.1.14 rpm's on Fedora Core 4.
I've setup max_heap_table_size to allow for 500M heap tables. Currently I
use roughly 435M in heap by about 16 different tables. Some use btree,
other's use default hash.
The problem is, over time mysql looks like this in top:
PID USER PR NI VIRT RES
Geoffrey,
- Original Message -
From: "Geoffrey" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, February 07, 2004 10:11 PM
Subject: Re: Memory Leak using InnoDB ?
> Dan, Heikki,
>
>
Dan, Heikki,
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 07, 2004 11:39 AM
Subject: Re: Memory Leak using InnoDB ?
> Geoffrey, Dan,
>
> - Original Message -
> From: "Dan N
Geoffrey, Dan,
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Saturday, February 07, 2004 5:27 AM
Subject: Re: Memory Leak using InnoDB ?
> In the last episode (Feb 07), Geoffrey said:
> > I'm runnin
Geoffrey wrote:
Hi,
I'm running MySQL 4.0.17 with RH Linux 8 on Xeon 3.0/1GB RAM.
One application has to access the database (1 connection to the DB is open
on startup and left open). However this application performs a lot of
queries on the DB.
Main InnoDB table : 50.000 Rows
Other InnoDB table
In the last episode (Feb 07), Geoffrey said:
> I'm running MySQL 4.0.17 with RH Linux 8 on Xeon 3.0/1GB RAM.
>
> One application has to access the database (1 connection to the DB is
> open on startup and left open). However this application performs a
> lot of queries on the DB.
>
> Thanks to "
Hi,
I'm running MySQL 4.0.17 with RH Linux 8 on Xeon 3.0/1GB RAM.
One application has to access the database (1 connection to the DB is open
on startup and left open). However this application performs a lot of
queries on the DB.
Main InnoDB table : 50.000 Rows
Other InnoDB tables (about 8) : Fr
--- Original Message -
From: "Jon Drukman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 23, 2003 1:26 PM
Subject: MyODBC 3.51 + Windows Server 2000 = Memory Leak
> We have a very high traffic mysql app running in ASP on Windows 2000.
> It con
We have a very high traffic mysql app running in ASP on Windows 2000.
It connects to a Linux mysql server (4.0.12) via ADODB and MyODBC. It's
leaking memory like crazy. We've implemented connection pooling and
long timeouts on connections so as to minimize the number of connects &
closes, but
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Jeff Kilbride" <[EMAIL PROTECTED]>
Cc: "Lopez David E-r9374c" <[EMAIL PROTECTED]>; "'DeepBlue'"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
S
On Fri, Mar 28, 2003 at 10:46:52AM -0800, Jeff Kilbride wrote:
> I've heard some bad things about turning off swap on Linux. I think it was
> on Jeremy Z.'s Blogger page. If he sees this maybe he can comment.
It really depends on the kernel too. Newer (2.4.19+) kernel are much
better than those a
;'DeepBlue'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, March 28, 2003 7:38 AM
Subject: RE: Memory Leak
DeepBlue
For 1000 simultaneous connections, your key_buffer seems way low.
Should be in the 100's of megabytes. You may have to increase your
RA
ssage---
From: Egor Egorov
Date: sexta-feira, 28 de março de 2003 10:13:25
To: [EMAIL PROTECTED]
Subject: re: Memory Leak
On Friday 28 March 2003 11:23, DeepBlue wrote:> I'm experiencing a memory leak problem on a server with runs Mysql 3.23.55> with 1000 simultaneous users.>> It&#x
On Friday 28 March 2003 11:23, DeepBlue wrote:
> I'm experiencing a memory leak problem on a server with runs Mysql 3.23.55
> with 1000 simultaneous users.
>
> It's an athlon XP 1800 with 512 Mb ram.
>
> Befor starting Mysql, webmin shows 350 Mb free memory, but afte
Hi, all
I'm experiencing a memory leak problem on a server with runs Mysql 3.23.55
with 1000 simultaneous users.
It's an athlon XP 1800 with 512 Mb ram.
Befor starting Mysql, webmin shows 350 Mb free memory, but after starting
mysql server it goes down, down, down and the server hang
Linux Redhat 7.3
MySQL 4.0.9-gamma
I tried to import a 900M file with mysqlimport command. Everything works fine.
All the data has been insert into the DB.
However, all the memory has been used up. Before the mysqlimport, I have 800M
free memory, after that, 13M free memory left.
Is there any w
Lars,
uhm, installed that package and it confirms your suspicion:
Total memory: 612 Megabytes
Kernel Memory: 60 Megabytes
Application: 89 Megabytes
Executable & libs: 32 Megabytes
File Cache: 419 Megabytes
Free, file cache: 6 M
ith around 250.000 to 3.000.000 records, record
size
is around 200 bytes.
Import dump file and see memory eaten up.
Fix:
unknown
Submitter-Id:
Originator: Markus Warg
Organization:
no organization
MySQL support: none
Synopsis: memory leak
Severity: non-critical
Priority: low
Category: m
> >> Fix:
> > unknown
> >
> >> Submitter-Id:
> >> Originator:Markus Warg
> >> Organization:
> > no organization
> >> MySQL support: none
> >> Synopsis: memory leak
> >> Severity: non-critical
> >>
200 bytes.
Import dump file and see memory eaten up.
Fix:
unknown
Submitter-Id:
Originator: Markus Warg
Organization:
no organization
MySQL support: none
Synopsis: memory leak
Severity: non-critical
Priority: low
Category: mysql
Class: sw-bug
Release: mysql-3.23.40 (Source distribution
and see memory eaten up.
>Fix:
unknown
>Submitter-Id:
>Originator:Markus Warg
>Organization:
no organization
>MySQL support: none
>Synopsis: memory leak
>Severity: non-critical
>Priority: low
>Category: mysql
>Class: sw-
the $30.
Mike
SQL QUERY MYSQL
> -Original Message-
> From: Jon Finanger [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 19, 2002 3:56 AM
> To: Dyego Souza do Carmo; [EMAIL PROTECTED]
> Subject: memory leak
>
>
> FYI:
> I experience a memoryleak with winm
Sent: Tuesday, November 19, 2002 3:56 AM
> To: Dyego Souza do Carmo; [EMAIL PROTECTED]
> Subject: memory leak
>
>
> FYI:
> I experience a memoryleak with winmysqladmin.exe on win2000
> with the latest updates.
> Sometimes i shutdown the server through the trayicon - afte
; [EMAIL PROTECTED]
Subject: memory leak
FYI:
I experience a memoryleak with winmysqladmin.exe on win2000 with the latest
updates.
Sometimes i shutdown the server through the trayicon - after short time the
system runs out of memory. Killing the winmysqladmin.exe
process makes things work as
FYI:
I experience a memoryleak with winmysqladmin.exe on win2000 with the latest updates.
Sometimes i shutdown the server through the trayicon - after short time the system
runs out of memory. Killing the winmysqladmin.exe
process makes things work as normal again
i use mysql 3.23.53-max-nt
-Jon
Background:
MySQL++ ( libsqlplus ) is a pretty nice official C++ styled mysql client
library wrapper of libmysqlclient. It offers STL-style C++ interface and is
designed with an effort of generic programming style. It should be a really
excellent choise if only it had not a MEMORY LEAK problem
>Description:
I use a little subset of mysql++ capabilities
- Connection
- Query ( only Query::store )
- Result
Memory leak I discovered is located somewhere in Result::operator= and is
available only after update;
Proof of concept code is supplied.
It leaks 1 Mb
ompiled with -lmysqlclient, allocating memory
using a routine (mysql_init) from that included library, and then unloading
the library cause a memory leak if the included (mysqlclient) library
doesn't free certain other memory that's only initialized once mysql_init is
called? IE does mysq
I've compiled debugging into the library .. now I figured the library was
getting loaded/unloaded, but it didn't really come to mind until I ran it
with debugging. My atomic tests (A standalone program that init's and
closes) does NOT do this.. So, I'm wondering if the leak is somehow being
incur
ut the amount of RAM was growing by ~ 1K per 5
> min.
Not 1K but ~1M !!! Just forgot that the units are Kb themselves.
> Now it is up for about 16 hours:
> virt: 281928K
> RAM: 143920K
Again, 5 min later
virt:281928K
RAM: 145152K
Anyway (145152K-23160K)/16hours =~ 7 additional MB p
e amount of RAM was growing by ~ 1K per 5
min.
Now it is up for about 16 hours:
virt: 281928K
RAM: 143920K
See, something wrong happens, it's back 50% in RAM. It's a memory leak,
isn't it?
Thanks, any input is much appreciated
--
=
On Thu, Apr 11, 2002 at 12:05:45PM -0700, Steven Deaton wrote:
>
> I am having a problem with a mysql server that I have that starts up
> with about 10-15 processes at 12MB each.and then JUMPS to a
> couple hundred processes at 100MB each. in just a couple minutes
> time.
Can you get a pr
I am having a problem with a mysql server that I
have that starts up with about 10-15 processes at 12MB
each.and then JUMPS to a couple hundred processes
at 100MB each. in just a couple minutes time.
What can cause this, other than just some loop in a script?
Any ideas anyone?
This is on
I have noticed some odd behavior in my mysql server (running build 41 on
Win2k).
I have a large table (4 million rows, 118 columns, about 1.7Gb on disk). As
its primary key, this table has an auto increment int field called 'runid'.
The machine it runs on has 733Mhz cpu/1.25Gb RAM and a 60Gb ide
39 matches
Mail list logo
