Hi,
My understanding is that the memory utilization of mysql can be calculated
roughly using the formula like:
(All global memory related server variables + max_connections * session
memory related server variables)
As I noticed that most global variables like key_buffer_size,
innodb_buffer_szie w
Which thread library is the mysqld linked against? Linuxthreads shows
each thread as a separate process in top or ps output. All threads
share the same memory. From your output, it is likely that you are
using linuxthreads(all pids having the same VSZ and RES memory).
Regards,
Ravi
Cabbar
On Tue, 2006-10-31 at 01:30 -0800, Cabbar Duzayak wrote:
> Hi,
>
> Could you please tell how I can tell how much memory does mysql server
> allocate on a linux box? I tried doing:
>
> top -b -n 1 | grep mysql
>
> But, it printed out bunch of processes for mysql. Are these all using
> shared memo
Hi,
Could you please tell how I can tell how much memory does mysql server
allocate on a linux box? I tried doing:
top -b -n 1 | grep mysql
But, it printed out bunch of processes for mysql. Are these all using
shared memory so each line gives you the total amount for mysql? How
can one interpre
set to? (ours is 4G) I'm betting
that needs to be changed.
-Sheeri
On 5/5/06, Anil <[EMAIL PROTECTED]> wrote:
Hi list,
We are facing memory problems for our application and to analyze memory
utilization by application we require below information on mysql memory
utilization.
h
Hi list,
We are facing memory problems for our application and to analyze memory
utilization by application we require below information on mysql memory
utilization.
how much of RAM mysql is utilizing and amount of memory allocated for
innodb buffer is utilizing ,how much of innodb buffer
TED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, January 12, 2005 5:20 AM
Subject: MySQL Memory Issue
--_=_NextPart_001_01C4F854.7050C7A0
Content-Type: text/plain
Windows 2000 Advance Server (latest service pack)
Physical Address Extension enabled
Dual 2.4Ghz Intel Pentium 4 Xeon
Windows 2000 Advance Server (latest service pack)
Physical Address Extension enabled
Dual 2.4Ghz Intel Pentium 4 Xeon
6gb of memory
This system is running as a dedicated MySQL 4.0.12-max-nt server.
Issue: The problem first exhibited itself as a connection issue. We
weren't able to obtain more t
First of all, thanks for the mailing list for giving details about myisamchk.we
used them but we got some errors which I have reported in 'myisamchk errors'
mail to mysql.
At present we are working in mysql 3.23.32 ,windows xp os.
Are there any system tables that store mysql related info.(like me
First of all, thanks for the mailing list for giving details about myisamchk.we
used them but we got some errors which I have reported in 'myisamchk errors'
mail to mysql.
At present we are working in mysql 3.23.32 ,windows xp os.
Are there any system tables that store mysql related info.(like
First of all, thanks for the mailing list for giving details about myisamchk.
At present we are working in mysql 3.23.32 ,windows xp os.
Are there any system tables that store mysql related info.(like memory related
issues etc).
Are there any other ways to find memory used and free memory av
> First, what version are you using? 4.0.20?
4.0.18 as provided by Suse with 9.1 Professional. 64 bit
4.0.20 64bit crashes 'out of the box' (segfault as I start it). I just
filed a bug report for that
> By key-cache, are you referring to the variable "key_buffer_size"? If
> so, keep in mind t
Our Opteron server should be arriving today, so I can't provide a whole
lot of insight.
First, what version are you using? 4.0.20? The 64-bit or 32-bit version?
Knowing the version might help. If this is not a production machine, you
might want to try using the version from the MySQL website
A
I just started setting up a dual opteron system with
Suse 9.1 (x86_64). At this point, I am sticking with the
Suse provided rpms.
I am having some odd mysql restarts (crashed with immediate
restart by safe_mysqld). Odd part about it: not a single line
in the error log. The connections just drop a
PROTECTED]>
Sent: Tuesday, April 27, 2004 1:37 PM
Subject: Re: MySQL Memory Structure
> Lou,
>
> use show variables; to display this info. You can also
> narrow it down by using show varibles like 'innodb%';
> to see only variables that start with "innodb&
I'm trying to get a handle on the entire memory structure used by MySQL. I'd like to
be able to see the total memory used by the entire MySQL instance, and then a
breakdown of what is going on within that aggregate allocation. For example, I'd like
to see how much memory is devoted to the quer
Sp.Raja wrote:
Thanks for your lightening response.
Even I thought of this idea
- Isolate pairs like
- my_malloc and my_free
- Innodb pair: ut_malloc and ut_free
But if pointers are passed between InnoDB and MySQL or MySQL and clients, then the memory consumer should free it using my wrap
D]>
> Cc: "Sp.Raja" <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> Date: Tue, Feb-17-2004 6:55 PM
> Subject: Re: MySQL Memory
>
> Chris Nolan wrote:
> > Hi!
> >
> > You'll want to look through the MySQL C API docs. There are specific
> > calls
.Raja
> > Original Message
> > From: Chris Nolan <[EMAIL PROTECTED]>
> > To: "Sp.Raja" <[EMAIL PROTECTED]>
> > Cc: [EMAIL PROTECTED]
> > Date: Tue, Feb-17-2004 6:53 PM
> > Subject: Re: MySQL Memory
> >
> > Server end? As in,
Chris Nolan wrote:
Hi!
You'll want to look through the MySQL C API docs. There are specific
calls for allocating certain structures that MySQL client software
should use (and routines for deallocating it as well).
Regards,
Chris
Sp.Raja wrote:
Hi List,
I want to use some other memory alloca
ssage
From: Chris Nolan <[EMAIL PROTECTED]>
To: "Sp.Raja" <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED]
Date: Tue, Feb-17-2004 6:29 PM
Subject: Re: MySQL Memory
Hi!
You'll want to look through the MySQL C API docs. There are specific
calls for allocating certain struc
ECTED]
> Date: Tue, Feb-17-2004 6:29 PM
> Subject: Re: MySQL Memory
>
> Hi!
>
> You'll want to look through the MySQL C API docs. There are specific
> calls for allocating certain structures that MySQL client software
> should use (and routines for deallocating it
Hi!
You'll want to look through the MySQL C API docs. There are specific
calls for allocating certain structures that MySQL client software
should use (and routines for deallocating it as well).
Regards,
Chris
Sp.Raja wrote:
Hi List,
I want to use some other memory allocator routine other t
Hi List,
I want to use some other memory allocator routine other than malloc in MySQL/InnoDB
4.0.15a.
Does MySQL call malloc directly? or thru wrappers? If it is through wrappers then my
job will be much simpler, If so please give me the list of wrappers.
Any Advice welcome
Regards,
Sp.Raja
In the last episode (Jan 27), Philip Mak said:
> > No, mysql is taking up 23MB. Linux creates separate processes for
> > each thread, which is why you see lots of mysqlds in top. They all
> > share the same address space, though. Are you sure you don't maybe
> > have a couple dozen apache proces
On Sat, Jan 24, 2004 at 01:56:53PM -0600, Dan Nelson wrote:
> You didn't say what OS you're using, but the below top output looks
> like Linux's procps top, which doesn't tell you your paging rate. Run
> "vmstat 1" and watch the si and so columns. Just because swap is being
> used doesn't mean yo
In the last episode (Jan 24), Philip Mak said:
> My machine appears to be swapping excessively, degrading performance.
> Note the high load average, combined with the mostly idle CPU and a
> lot of swap space being used.
You didn't say what OS you're using, but the below top output looks
like Linu
My machine appears to be swapping excessively, degrading performance.
Note the high load average, combined with the mostly idle CPU and a
lot of swap space being used.
3:11am up 47 days, 2:13, 12 users, load average: 6.06, 4.79, 3.19
482 processes: 480 sleeping, 1 running, 1 zombie, 0 stopped
On Wed, Nov 05, 2003 at 07:10:41PM -0600, Matt W wrote:
> Hi,
>
> In every instance I've seen, MySQL always allocates the amount you set
> for key_buffer at server startup even if it never comes close to being
> *used*. (It shouldn't be doing malloc()s or whatever for that on the
> fly. :-)) Same
eremy Zawodny [mailto:[EMAIL PROTECTED]
> Sent: terça-feira, 4 de Novembro de 2003 23:51
> To: Alexis Guia
> Cc: 'Benjamin KRIEF'; [EMAIL PROTECTED]
> Subject: Re: mysql memory usage
>
> On Tue, Nov 04, 2003 at 10:09:01AM -, Alexis Guia wrote:
> >
> >
o allocate it all at once. But if not.
Maybe I should ask on the Internals list sometime.
Matt
- Original Message -
From: "Alexis Guia"
Sent: Wednesday, November 05, 2003 5:30 AM
Subject: RE: mysql memory usage
Sorry, but I disagree :/
I always used 250MB of key buffer,
P.S.: you can test it easily, doing specific queries for each case.
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: terça-feira, 4 de Novembro de 2003 23:51
To: Alexis Guia
Cc: 'Benjamin KRIEF'; [EMAIL PROTECTED]
Subject: Re: mysql memory usage
On T
On Tue, Nov 04, 2003 at 10:09:01AM -, Alexis Guia wrote:
>
> Hi,
>
> I think that MyISAM uses the key buffer only if needed. The same happens
> with almost all the other buffers (read buffer, sort buffer, etc.).
True, but there's a subtle difference between "uses" and "allocates."
If you te
PROTECTED]
Subject: mysql memory usage
hi everyone.
i'd like to know if mysql always uses all the key_buffer size it has
been
given in my.cnf
especially, on my server with :
set-variable= thread_stack=128K
set-variable= key_buffer=200M
set-variable= max_allowed_packet=1M
set-var
hi everyone.
i'd like to know if mysql always uses all the key_buffer size it has been
given in my.cnf
especially, on my server with :
set-variable= thread_stack=128K
set-variable= key_buffer=200M
set-variable= max_allowed_packet=1M
set-variable= table_cache=128
set-variable=
On Thu, Sep 18, 2003 at 02:53:29PM -0400, Gabriel Ricard wrote:
> Is there any way to see what MySQL is storing in memory? Like, for
> instance, what is stored in the query cache, or at least what tables
> have data stored in the query cache, and how much they have stored?
Nothing other than wha
Is there any way to see what MySQL is storing in memory? Like, for
instance, what is stored in the query cache, or at least what tables
have data stored in the query cache, and how much they have stored?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Try putting the following before the mysqld call but before your ulimit calls -
export LDR_CNTRL='MAXDATA=0x8000'
Also try setting ulimit -m unlimited and ulimit -s unlimited.
Hopefully this helps.
Scott Pippin
[EMAIL PROTECTED]
Hi all,
Now I'm facing a big problem and see if anyone know how to solve it. I'm
using RS6000 AIX 4.3.2 CPU*2 1G RAM with HA. And DB is MySQL 4.0.12-max.
Here is the content of my.cnf.
[client]
#password = your_password
port= 3306
socket = /tmp/mysql.sock
# Here follo
On Wed, Jun 11, 2003 at 12:22:58PM +0800, Kaming wrote:
>
> Jeremy Zawodny wrote:
>
> > On Tue, Jun 10, 2003 at 07:37:19PM +0800, Kaming wrote:
> > >
> > > Then after the checking, the table seems being fixed and then I start
> > > the MySQL again. I can run query in that table after that. Then s
Hi Jeremy,
here is the value when I typed 'ulimit -a'.
core file size (blocks) unlimited
data seg size (kbytes) 524288
file size (blocks) unlimited
max locked memory (kbytes) unlimited
max memory size (kbytes)unlimited
open files 32768
pipe size (512 bytes)
On Tue, Jun 10, 2003 at 07:37:19PM +0800, Kaming wrote:
>
> Then after the checking, the table seems being fixed and then I start
> the MySQL again. I can run query in that table after that. Then suddenly
> I saw this error message keeps coming in the mysqld.log
>
> Error Message:
> Out of memory
Hi all,
I am facing a big problem and see if anyone know how to solve it. I am
using freebsd 4.4 with mysql-4.0.12. The database server has 2G RAM in
it. Here is the content of my.cnf.
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
port=3306
set-variable = thread_cache_size=550
Hmmm I would say other than upgrading your hardware try upgrading to mySQL 4.
and turn on query caching.
The difference it has made to our server is unbelivable!
We have found no problems with it so far.
John
-
Before posting,
At 15:36 7-3-03 +, John Wards wrote:
What OS are you using?
Linux 2.4.20.
> 'top' shows that mysqld is using 264M of memory. So I presume the rest is
> used for disk caching. How do I know for sure that mysql is using the rest
> of the memory, or how do I get mysql to use it all?
That seems f
On Friday 07 Mar 2003 3:28 pm, Rick Jansen wrote:
> On a P4-2.6Ghz, 1Gb mem server of ours, mysql keeps getting slower and
> slower because the database gets bigger and bigger.
> At the moment the database is 5.5Gb big, the biggest table being 1.1Gb.
What OS are you using?
> 'top' shows that mysq
Hello,
On a P4-2.6Ghz, 1Gb mem server of ours, mysql keeps getting slower and
slower because the database gets bigger and bigger.
At the moment the database is 5.5Gb big, the biggest table being 1.1Gb.
'top' shows that mysqld is using 264M of memory. So I presume the rest is
used for disk cachi
Hello,
On a P4-2.6Ghz, 1Gb mem server of ours, mysql keeps getting slower and
slower because the database gets bigger and bigger.
At the moment the database is 5.5Gb big, the biggest table being 1.1Gb.
'top' shows that mysqld is using 264M of memory. So I presume the rest is
used for disk cachi
ance as to whether this is normal or am I not configuring
> something properly.
What OS are you using?
Some versions of the Linux kernel had problems that caused it to
needlessly swap out MySQL memory when there was lots of memory still
available.
Here was some of my original discussion on the
I not configuring
> something properly.
What OS are you using?
Some versions of the Linux kernel had problems that caused it to
needlessly swap out MySQL memory when there was lots of memory still
available.
Here was some of my original discussion on the topic:
http://jeremy.zawodny
Hello,
I am setting up a mySQL box in my development environment and have noticed
that even under little usage mysql will consume a couple hundred MB's of
swap space even though I have almost 1GB of apparent "free" physical
memory. I am using the 'my-large.cnf' configuration file and otherwise
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
Hi Markus,
I just missed something in your original Mail,
I guess its not the mysql server growing to 1gig (check with ps -ely)
its simply the system memory showing no free mem.
If you have root access to the maschine its probably a good idea to
install the prtmem command (ftp://playground.sun.co
Lars,
the amount used increases until all free memory is used plus a fair amount of
swap. On a machine with 2GB memory this can well grow up to 1GB.
Any chance to get the current size of the malloc pool to check if this
causes the effect?
thx so far,
Markus
On Don, 21 Nov 2002, Lars Heidieker
Does the memory amount used increases any further if repeating the dump
import.
If so there is a leak if not you just got fooled by the standard malloc
of solaris which wont return memory free(d) to the system but instead
the memory will be kept in a pool for the next malloc.
Lars
On Donnerst
>Description:
Dump several big tables or entire databases with mysqldump, then
import to same or another database with mysql -f db How-To-Repeat:
Dump a database with around 250.000 to 3.000.000 records, record size
is around 200 bytes.
Import dump file and s
s may follow.
mailing.database.myodbc and mailing.database.mysql group has several repots
about -- have a look at them
( Google->groups search result on 'mysql++ memory leak' )
--
http://groups.google.com.ru/groups?q=mysql%2B%2B+memory+leak&hl=ru&lr=&ie=UTF-8&am
LLow -- exception: " << e.what() << endl;
throw;
}
}
int main(void)
{
connect();
int i=0;
while(true)
{
sql("SELECT * FROM a");
// comment out this line to eliminate memory leak
sql("UPDATE a SET i=i+1&
Jon,
> So how do I optimize memory usage? Where to start ?
If your server is compiled with debug=full, the command
mysqladmin proc stat
shows you total server memory use. Look in the manual at
How MySQL uses Memory
SHOW VARIABLES (for all vars that control server memory use)
Pe
: [EMAIL PROTECTED]
> Subject: Re: .Optimize mySQL memory usage ? 41MB threads ??
>
> In the last episode (Oct 07), Jon Shoberg said:
> > I have a small PHP website that gets a fair amount of traffic. It's
> > a simple layout with two tables. I average about 50 concurrently
In the last episode (Oct 07), Jon Shoberg said:
> From: Dan Nelson [mailto:[EMAIL PROTECTED]]
> > In the last episode (Oct 07), Jon Shoberg said:
> > > I have a small PHP website that gets a fair amount of traffic.
> > > It's a simple layout with two tables. I average about 50
> > > concurrently
Ok,
So how do I optimize memory usage? Where to start ?
-Jon
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 07, 2002 9:16 PM
To: Jon Shoberg
Cc: [EMAIL PROTECTED]
Subject: Re: .Optimize mySQL memory usage ? 41MB threads ??
In the last
In the last episode (Oct 07), Jon Shoberg said:
> I have a small PHP website that gets a fair amount of traffic. It's
> a simple layout with two tables. I average about 50 concurrently open
> apache sessions and 40 open mysql connections. I am calling for
> persistent connections from the mySQL/
I have a small PHP website that gets a fair amount of traffic. It's a
simple layout with two tables. I average about 50 concurrently open
apache sessions and 40 open mysql connections. I am calling for
persistent connections from the mySQL/PHP API.
But here is the kicker. Each mySQL thread ta
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
Hi guys,
I have a quad Xeon 550 server, 4gb RAM, with a RH Linux 6.2 + patches,
kernel 2.4.8 and mysql Ver 11.17 Distrib 3.23.49a.
After the start, mysql starts to grow memory usage. It grows until it
consumes all machine memory. After a restart it uses only 17Mb of memory, 18
hou
Hi guys,
I have a quad Xeon 550 server, 4gb RAM, with a RH Linux 6.2 + patches,
kernel 2.4.8 and mysql Ver 11.17 Distrib 3.23.49a.
After the start, mysql starts to grow memory usage. It grows until it
consumes all machine memory. After a restart it uses only 17Mb of memory, 18
hou
Hi.
Have a look at your my.cnf (and the according manual entries). There
you can specify how much memory MySQL is allowed to use.
MySQL doesn't release memory it's allowed to use for caching.
Bye,
Benjamin.
PS: There is nothing such as "linux 7.1". Linux (the kernel) exists in
versio
Dear all,
i used mysql on linux 7.1. And i discovered mysql not free the memory .
pls advise !1
1:24am up 1 day, 10:11, 2 users, load average: 1.13, 1.26, 1.31
65 processes: 63 sleeping, 2 running, 0 zombie, 0 stopped
CPU0 states: 4.2% user, 1.3% system, 0.0% nice, 93.3% idle
CPU1 stat
Hi!
> "Rock" == Rock VZ <[EMAIL PROTECTED]> writes:
Rock> Hi,
Rock> How much memory does mysql executable take in the ram?
Rock> What is its code memory foot print?
It depends on how you compile MySQL and how you set up the buffers.
MySQL can run with as little memory as 64K + code size Th
Hi,
How much memory does mysql executable take in the ram?
What is its code memory foot print?
regards
Rock
=
__
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger.
http://im.yahoo.com
--
Hi
I have a mysql server:
mysqld Ver 3.23.33 for pc-linux-gnu on i686
I use C API to communicate with database, a simple connection could look
like this:
-- test.c --
#include
#include
int main()
{
MYSQL *conn;
conn = mysql_init(NULL);
if (!m
vek Khera [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 6 February 2001 08:39
To: [EMAIL PROTECTED]
Subject: RE: MySQL Memory Requirements...
>>>>> "DK" == Daniel Kirk <[EMAIL PROTECTED]> writes:
DK> 30gb eide hdd
DK> Will the machine fall over because it doesn&
> "DK" == Daniel Kirk <[EMAIL PROTECTED]> writes:
DK> 30gb eide hdd
DK> Will the machine fall over because it doesn't have enough ram/CPU
DK> power (for about 20k users per week as below)? any ball park
DK> comments eg no worries, close call, not a chance?
Your bottleneck on a database is
---Reply to mail from Daniel Kirk about MySQL Memory Requirements...
> What it looks like i'm going for is the following setup
>
> 30gb eide hdd
> celeron 700Mhz processor
> 256MB RAM
> red hat linux
> mysql
> apache/tomcat
>
> I'm a bit worried because t
/CPU power (for
about 20k users per week as below)? any ball park comments eg no worries,
close call, not a chance?
thx
dan
-Original Message-
From: Daniel Kirk [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 6 February 2001 09:38
To: [EMAIL PROTECTED]
Subject: MySQL Memory Requirements...
Can
Can someone please give me a rough estimate of how much RAM MySQL would
require to run something like :
A connection pool of around 50 connections
20,000 users every week re-using these 50 connections
around 50 inserts per user (each row around 30 bytes)
around 20 queries per user
Installation on
78 matches
Mail list logo
