the system starts swapping, there should be no problem with the growing
memory usage. At that point, performance will tank. The quick fix is to
decrease innodb_buffer_pool_size and/or key_buffer_size.
If you provide SHOW GLOBAL STATUS and SHOW VARIABLES, I can look for other
issues
19.04.2013 23:39, Ilya Kazakevich:
Try to use tuning-primer.sh: this scripts reads your variables and prints
memory size you need for that.
I tried that. The results are inconspicious:
MEMORY USAGE
Max Memory Ever Allocated : 5.27 G
Configured Max Per-thread Buffers : 1.92 G
Configured Max
Hi all.
In a specific MySQL installation of 5.6.10 using InnoDB tables, I
am observing unusual memory consumption patterns. The memory
usage is growing constantly - even beyond the physical memory
limits. The entire on-disk storage is 41 GB (uncompressed), yet
memory usage is happily growing
Hello,
Try to use tuning-primer.sh: this scripts reads your variables and prints
memory size you need for that.
Here is example of its output:
MEMORY USAGE
Max Memory Ever Allocated : 2.86 G
Configured Max Per-thread Buffers : 1.80 G
Configured Max Global Buffers : 2.10 G
Configured Max Memory
: RE: Troubleshoot excessive memory usage in InnoDB
Hello,
Try to use tuning-primer.sh: this scripts reads your variables and
prints memory size you need for that.
Here is example of its output:
MEMORY USAGE
Max Memory Ever Allocated : 2.86 G
Configured Max Per-thread Buffers : 1.80 G
How can I know how memory is being used by Mysql?
I have 32GB Ram, but I can't make mysql to use more than 12GB Ram , and even
that I have tables over 40GB...
Thanks! xD
!
[--] Up for: 17d 21h 53m 13s (39M q [25.329 qps], 132K conn, TX: 60B, RX: 19B)
[--] Reads / Writes: 67% / 33%
[--] Total buffers: 6.1G global + 1.2M per thread (500 max threads)
[OK] Maximum possible memory usage: 6.7G (66% of installed RAM)
[OK] Slow queries: 0% (13/39M)
[OK] Highest usage
-Original Message-
From: Andrés Tello [mailto:mr.crip...@gmail.com]
Sent: Monday, April 25, 2011 10:24 AM
To: Mailing-List mysql
Subject: Memory Usage.
How can I know how memory is being used by Mysql?
I have 32GB Ram, but I can't make mysql to use more than 12GB Ram , and even
that I
Hello,
How to query the memory usage for mysql server?
for example, how much memory mysqld has used? and how much memory
available for mysqld?
The OS is Linux.
Thanks.
Young.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
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
wanna bring the memory usage down?
WordPress blogs.
Why, because my VPS is very low-powered. I have PostgreSQL installed as
well and it uses less than 1.5% of memory when idle.
Sebastian
--
Emacs' AlsaPlayer - Music Without Jolts
Lightweight, full-featured and mindful of your idyllic
Quoth wult...@gmail.com:
Through your conf file(s) you have told MySQL how much memory it may
consume. As long as the server does not go beyond what it is told it
may consume it is not doing anything wrong.
Thanks. I'll have a look in the conf file. At the moment it's running
as it came out
So I assume you have a terabyte of RAM in the server, since you didn't
say... OMG, it's using 143GB of RAM when it's idle? Wow..
:-) You need to provide some more details here. I can't judge
whether there is any issue at all.
Baron
On Sun, Feb 1, 2009 at 8:35 AM, Sebastian Tennant
Quoth Baron Schwartz ba...@xaprb.com:
So I assume you have a terabyte of RAM in the server, since you didn't
say... OMG, it's using 143GB of RAM when it's idle? Wow..
:-) You need to provide some more details here. I can't judge
whether there is any issue at all.
Sorry. My VPS has 144 MB
Hi all,
I recently installed MySQL (version 5.0) on my Debian Lenny VPS and
mysqld uses 14.3% of memory when idle.
Is this a known issue?
I'm aware that version 5.0 is not the latest version but it's the one
currently shipped by Debian Lenny (testing) so I'm loathe to 'manually'
install a later
You could bring it down, but the real question is if you really want
to do that? Making the buffers and caches smaller will reduce the
memory used, but it also reduces performance.
Could you tell us what you are hoping to use MySQL for and why you
wanna bring the memory usage down?
Walter
Hi Joerg,
Thanks a lot for the info.
regards
anandkl
On 7/23/08, Joerg Bruehe [EMAIL PROTECTED] wrote:
Hi !
Ananda Kumar wrote:
Hi All,
I have setup slave db. The machine configuration details of this slave is
same as master.
OS=redhat
8 cpu
16GB RAM
key_buffer_size=3000M
Hi !
Ananda Kumar wrote:
Hi All,
I have setup slave db. The machine configuration details of this slave is
same as master.
OS=redhat
8 cpu
16GB RAM
key_buffer_size=3000M
innodb_buffer_pool_size=1M.
But when i do top, in the master db
Cpu(s): 0.5%us, 0.3%sy, 0.0%ni, 87.2%id,
Hi All,
I have setup slave db. The machine configuration details of this slave is
same as master.
OS=redhat
8 cpu
16GB RAM
key_buffer_size=3000M
innodb_buffer_pool_size=1M.
But when i do top, in the master db
Cpu(s): 0.5%us, 0.3%sy, 0.0%ni, 87.2%id, 11.9%wa, 0.0%hi, 0.1%si,
0.0%st
Hi..
Fairly new to mysql, in particular tuning.
I have a test mysql db, on a test server. I've got a test app that runs on
multiple servers, with each test app, firing/accessing data from the central
db server.
the central server is on a 2GHz, 1GMem, 100G system. MySQL is the basic app.
the
bruce a écrit :
Hi..
Fairly new to mysql, in particular tuning.
I have a test mysql db, on a test server. I've got a test app that runs on
multiple servers, with each test app, firing/accessing data from the central
db server.
the central server is on a 2GHz, 1GMem, 100G system. MySQL is the
.
the system has 1GB ram, and according to statistics most of it is
already in use. current value of max_connections for MySQL is 160.
are there any algorithms to calculate the average/maximum memory usage?
thanks in advance,
jonas
PS: i'm not subscribed to the list, please Cc me in your replies
as i can see you are running mysql on windows.
If i start my db server (5.0.45/innodb/win2k) the server uses about ~80K
handles (as seen in taskmgr) and memory usage increases around 1g.
Taskmgr.exe says that there is some swapping (the box has only 1gb ram).
The DB itself is small (~50mb
~80K
handles (as seen in taskmgr) and memory usage increases around 1g.
Taskmgr.exe says that there is some swapping (the box has only 1gb ram).
The DB itself is small (~50mb or so).
My Question is, did you have the same things on your box?
Did you have performace issues which resultes from
Hello all,
I am looking for a way to view the max values that have been used by all
threads or a signal thread for read_buffer, read_rnd_buffer,
sort_buffer, and net_buffer. I want to know these values so that I can
turn them appropriately.
Regards,
--Dave
David W. Juntgen
Medical
We very recently began replicating data from a master to a slave and
since doing that we've noticed that most of the RAM in the machine 2 GB
is being used with very little (relatively) free (12MB - 50MB). I've
looked at several forums and have done some web searches to see if there
was any
In the last episode (Sep 22), Blumenkrantz, Steve said:
We very recently began replicating data from a master to a slave and
since doing that we've noticed that most of the RAM in the machine 2
GB is being used with very little (relatively) free (12MB - 50MB).
I've looked at several forums
The following are from the InnoDB configuration page:
# Set buffer pool size to 50-80% of your computer's memory,
# but make sure on Linux x86 total memory usage is 2GB
*Warning:* On 32-bit GNU/Linux x86, you must be careful not to set
memory usage too high. |
glibc| may allow the process heap
process size is.
David
Mayuran Yogarajah wrote:
The following are from the InnoDB configuration page:
# Set buffer pool size to 50-80% of your computer's memory,
# but make sure on Linux x86 total memory usage is 2GB
*Warning:* On 32-bit GNU/Linux x86, you must be careful not to set
memory usage
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
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
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?
Tim:
Can you bring your libc to the latest patch level?
Not necessary. I resolved the problem:
binlog_cache_size was set to 32MB
I didn't realise that this would automatically be allocated to every
thread, even if there are no InnoDB or BDB tables in the entire
instance. This explains why
At 12:23 + 3/26/04, Tim Cutts wrote:
Tim:
Can you bring your libc to the latest patch level?
Not necessary. I resolved the problem:
binlog_cache_size was set to 32MB
I didn't realise that this would automatically be allocated to every
thread, even if there are no InnoDB or BDB tables in
On 25 Mar 2004, at 05:01, Sasha Pachev wrote:
Innodb to my knowledge does not allocate very much locally per thread,
and should not allocate anything at all if you are not doing any
queries.
That's what I thought.
Based on the test results you have reported, I would put your libc as
the
On 25 Mar 2004, at 06:31, Heikki Tuuri wrote:
you can use the command
SHOW INNODB STATUS;
to check how much memory InnoDB has allocated in total. Please report
what
it says at the time of the memory explosion.
Well, that was informative, but in a negative sort of way. SHOW INNODB
STATUS
On 25 Mar 2004, at 10:10, Tim Cutts wrote:
No, indeed. I'm going to try building mysql myself, on the machine on
which it's going to be running, and see whether that still has the
issue...
The version compiled natively on the machine does the same thing
(although it uses a little less memory
Tim Cutts wrote:
On 25 Mar 2004, at 10:10, Tim Cutts wrote:
No, indeed. I'm going to try building mysql myself, on the machine on
which it's going to be running, and see whether that still has the
issue...
The version compiled natively on the machine does the same thing
(although it uses a
On 22 Mar 2004, at 18:24, Tim Cutts wrote:
Some users' code is causing MySQL's memory use to explode. By the
time we reach about 200 simultaneous connections, the MySQL server is
using 8GB of virtual memory, and then falls over (the machine is an
AlphaServer ES45 with 8 GB of physical memory,
when setting these parameters. For example |sort_buffer_size|
is allocated only if MySQL nees to do a sort. Note: be careful not to
run out of memory.
/
I might start up mysql and watch the memory usage as you start dumb
clients on at a time - see what the step in memory usage is and match it
up
Tim Cutts wrote:
On 22 Mar 2004, at 18:24, Tim Cutts wrote:
Some users' code is causing MySQL's memory use to explode. By the
time we reach about 200 simultaneous connections, the MySQL server is
using 8GB of virtual memory, and then falls over (the machine is an
AlphaServer ES45 with 8 GB of
Tim,
- Original Message -
From: Sasha Pachev [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, March 25, 2004 7:04 AM
Subject: Re: Mystifying mysqld memory usage explosion
Tim Cutts wrote:
On 22 Mar 2004, at 18:24, Tim Cutts wrote:
Some users' code
Some users' code is causing MySQL's memory use to explode. By the time
we reach about 200 simultaneous connections, the MySQL server is using
8GB of virtual memory, and then falls over (the machine is an
AlphaServer ES45 with 8 GB of physical memory, and 16 GB of swap,
although processes are
In case anyone else encounters this particular symptom, it turns out the
problem was gcc using some orphaned headers for mysql 3.23.56 sitting in
/usr/include/mysql rather than the correct mysql 4.0.17 ones residing in
/usr/local/include/mysql, thus yielding all the strange behaviour.
M.
On Sat,
Hi,
I've been having problems with segfaults under mod_auth_mysql in Apache
1.3, which I think i've narrowed down to the MYSQL connection structure
getting corrupted on my particular mysql installation - specifically
manifesting itself with strange values of the free_me field, which results
in
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 Tue, Nov 04
. 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, and MySQL never allocates more than
: 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:
Hi,
I think that MyISAM uses the key buffer only if needed. The same
happens
with almost all
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 thing
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-variable
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 tell MySQL
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
Bringing this back up again, because the number of extra 'threads' mysql
is using seems to vary widely, from I've noticed sometimes, from 5 more
than the threads I'm using to more than 50!
My memory usage also seems to differ accordingly.
It seems to be because my thread cache is set to 40, so
In the last episode (Sep 27), Kevin said:
Bringing this back up again, because the number of extra 'threads'
mysql is using seems to vary widely, from I've noticed sometimes,
from 5 more than the threads I'm using to more than 50!
My memory usage also seems to differ accordingly.
It seems
' tries to report on threads (since mysql
technically supposedly has only 1 process). Is it doing something
wrong?
My main concern is for the reported memory usage. If ps is right, and
it IS using that memory, what is it doing?
1 31454 mysql23M 2.1M 108M 23M 34819 S mysqld
2 31456
process). Is it doing something
wrong?
No, you're all fine. No worries :)
My main concern is for the reported memory usage. If ps is right, and
it IS using that memory, what is it doing?
1 31454 mysql23M 2.1M 108M 23M 34819 S mysqld
2 31456 mysql23M 2.1M 108M 23M 34819 S
main concern is for the reported memory usage. If ps is right, and
it IS using that memory, what is it doing?
1 31454 mysql23M 2.1M 108M 23M 34819 S mysqld
2 31456 mysql23M 2.1M 108M 23M 34819 S mysqld
.. continue until ..
29 31639 mysql23M 2.1M 108M
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
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 what
Greetings List,
I'm running a dedicated MySQL server on a Dell PE 2550, dual proc. 4GB
RAM. Its using the Dell PERC 3/Di Scsi RAID controller with 18GB disks. I
running RH 7.3 with the latest updates(Kernel 2.4.20-19.7smp). The MySQL
version is the rpm currently being provided by the RH
On Mon, Aug 18, 2003 at 12:10:16PM -0400, Tom Mattison wrote:
: Greetings List,
:
: I'm running a dedicated MySQL server on a Dell PE 2550, dual proc. 4GB
: RAM. Its using the Dell PERC 3/Di Scsi RAID controller with 18GB disks. I
: running RH 7.3 with the latest updates(Kernel
]
Subject: Re: MySQL 3.23.56 Memory Usage Problem
On Mon, Aug 18, 2003 at 12:10:16PM -0400, Tom Mattison wrote:
: Greetings List,
:
: I'm running a dedicated MySQL server on a Dell PE 2550, dual proc. 4GB
: RAM. Its using the Dell PERC 3/Di Scsi RAID controller with
18GB disks. I
On Mon, Aug 18, 2003 at 12:10:16PM -0400, Tom Mattison wrote:
Greetings List,
I'm running a dedicated MySQL server on a Dell PE 2550, dual proc. 4GB
RAM. Its using the Dell PERC 3/Di Scsi RAID controller with 18GB disks. I
running RH 7.3 with the latest updates(Kernel 2.4.20-19.7smp).
Hi everyone, I was wondering if there's any way I can lower MySQL's memory
useage? It often uses more than 5kb which I consider to much.. I'm
guessing I should play with my.cnf or whatever it's called (located at C:/
and windows calls it cardnumber or something)...
Thanks in advance...
//
Hi, I have a question about the memory that mysql uses,
Here is the info that top command displays:
7:39pm up 55 days, 2:51, 1 user, load average: 0.18, 0.08, 0.02
54 processes: 53 sleeping, 1 running, 0 zombie, 0 stopped
CPU0 states: 0.1% user, 10.1% system, 0.0% nice, 89.3% idle
CPU1
On Mon, Jun 23, 2003 at 07:21:25PM -0500, Miguel Perez wrote:
Hi, I have a question about the memory that mysql uses,
Here is the info that top command displays:
7:39pm up 55 days, 2:51, 1 user, load average: 0.18, 0.08, 0.02
54 processes: 53 sleeping, 1 running, 0 zombie, 0 stopped
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
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
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 mysqld
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
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
Hello,
I am running MySQL-Max on RH8.0 on a Dell 1650, 2 proc with 512MB ram.
I am only using InnoDB for databases (40gb) other than the mysql.*.
I have the following relevant memory settings:
set-variable= sort_buffer=2M
set-variable= record_buffer=2M
## For redhat 8.0
set-variable
Apologies if this is off topic ... please let me know what a more
appropriate forum is if so.
Quick question: since there is normally a per-process limit of 4GB on
32-bit linux/intel platforms is there any point to installing more than
4gb in an sql server that is only running running 1 instance
You can expect that your operating system will use the remaining
memory as a file cache that will speed up your databases accesses.
We don't have that much memory our dedicated database server, it has
only 2 Gb. mysqld itself is using around 600Mb the rest is used
by the OS mainly for file
How do I set the cache limit? Any suggestions on optimizing mySQL?
At 07:05 PM 11/21/2002 +0100, Joseph Bueno wrote:
You can expect that your operating system will use the remaining
memory as a file cache that will speed up your databases accesses.
We don't have that much memory our dedicated
Hey folks,
I've looked around, but haven't seen anything similar to _quite_ the problem
I have. The symptoms are thus: memory usage for each mysqld process in top
creeps up to around 13%, 274MB, and stays there, no matter what I set my
config to.
79 processes: 76 sleeping, 3 running, 0 zombie
On Thu, Nov 14, 2002 at 09:02:59AM -0500, Nicholas Elliott wrote:
Hey folks,
I've looked around, but haven't seen anything similar to _quite_ the problem
I have. The symptoms are thus: memory usage for each mysqld process in top
creeps up to around 13%, 274MB, and stays there, no matter
I'm concerned about memory usage of mysql connections.
I've been reading the mailing list archives but I'm
still clueless.
I need to buy a new server for a mysql database that
will have at least 500 persistent connections from an Apache
server with mod_perl.
I'm checking the memory usage
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
takes about 41mb!! :( Can
anyone point me to resources on optimizing mySQL's memory usage under a
moderate/heavy load?
Thanks
Jon
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
API.
But here is the kicker. Each mySQL thread takes about 41mb!! :( Can
anyone point me to resources on optimizing mySQL's memory usage under
a moderate/heavy load?
Threads have no memory. You're getting misled by Linuxes threads
implementation, which displays each thread as if it were
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
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 takes about 41mb!! :(
Can anyone point me to resources on optimizing mySQL's memory
usage under a moderate/heavy load?
Threads
On Mon, 7 Oct 2002, Jon Shoberg wrote:
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
In the last episode (Jul 03), Dave said:
Hello all,
I have mysql running on a 2.4.18 kernel:
/usr/libexec/mysqld Ver 3.23.49 for redhat-linux-gnu on i386
and note that one started about 4 processes (threads?) began to
handle the various signal/table tasks and such. After several
Thanks for the confirmation Dan,
I will look a little closer but I could have sworn when I shutdown MySQL
about 300MB of memory got freed.
I had a suspicion the case was one process and ps/top could not
distinguish...I just needed to hear confirmation of it I guess.
-Dave
In the last
.
If you want to lower the number of sleeping thread, take a look at the
wait_timeout variable in your my.cnf file.
Regards,
Jocelyn
- Original Message -
From: Dave [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, July 04, 2002 8:39 AM
Subject: Re: Growing memory usage/processes
Hello all,
I have mysql running on a 2.4.18 kernel:
/usr/libexec/mysqld Ver 3.23.49 for redhat-linux-gnu on i386
and note that one started about 4 processes (threads?) began to handle the
various signal/table tasks and such. After several random queries the
process list grows accordingly.
On Thu, Jan 24, 2002 at 12:06:14PM +0100, Marcus Mueller wrote:
Hello,
in order to be able to use the replication features of MySQL we
recently gave version 4.0.1alpha a try, since these features are
reportedly more reliable in this version
Really? I haven't heard that about the
for the advantages: we experienced a very high server load
combined with higher memory-usage than usual, the average speed dropped
to a level the tested databases became almost unusable.
Let me explain our setup:
we're running a site-internal messaging system that handles approx.
110.000 messages per day
I am trying to understand how MySQL uses memory when executing a query on a
large table.
The server is running on RedHat 6.0 with pentium III 750 Mhz processor and 2
Gig of RAM.
I have my key_buffer_size set to 1600MB. My table cache is set at 512.
When I run top, I get the following out put:
Hello,
I was wondering, how can I lookup how much memory MySQL is currently allowed
to use, and how can I change this value?
Thanks in advance,
Leon Mergen
[EMAIL PROTECTED]
BlazeBox, Inc.
ICQ: 55677353
-
Before posting,
Just thought I'd share the results so far:
As I mentioned earlier, I went ahead and upgraded the kernel from 2.2.16
to 2.4.4. The server has been running for nearly 36 hours since then, and
has reached an RSS of 100M, well over what it ever reached before. And
things are still running very
On Mon, 7 May 2001 06:27:08 -0400 (EDT)
Jon Valvatne [EMAIL PROTECTED] wrote:
As you'd expect, the server gets bogged down rather quickly at this
point, serving new requests very slowly if at all. Restarting MySQL helps
right away, buying me another 24 hours of stable uptime.
If this is a
expect the server to be overworked, but the weird thing is how the
problem manifests itself:
When I start up MySQL and Apache, things seem to run fine for a while, and
they continue running fine for about 24 hours. Then, when MySQL memory
usage has grown to around 70-80 megs, things start to slow
That's the weird part; it doesn't seem to be swapping at all. When trying
different combinations in my.cnf, I had key_buffer as low as 64M without
any effect.
Jon
On Mon, 7 May 2001, Joseph Bueno wrote:
Hi,
Are you sure that you need 200Mb of key_buffer cache ?
Since your machine is
On Mon, 7 May 2001 07:40:26 -0400 (EDT)
[EMAIL PROTECTED] wrote:
Thanks for the quick reply.
I set max_connections so low because even at peaks I never need more, and
when the slowdowns happen, it seems to have an easier time recovering if
there are 15 slow connections hanging than if
On Mon, 7 May 2001, Rene Tegel wrote:
On Mon, 7 May 2001 07:40:26 -0400 (EDT)
[EMAIL PROTECTED] wrote:
Thanks for the quick reply.
I set max_connections so low because even at peaks I never need more, and
when the slowdowns happen, it seems to have an easier time recovering if
Hi,
From a system point of view, there are 3 main reasons for a slowdown:
- CPU : Your machine is slow because the CPUs are at 100% and can't
do anything more.
- I/O : Your processes are waiting for data from the disk.
- RAM : You don't have enough RAM so your machine is swapping and
"ryc" [EMAIL PROTECTED] wrote:
When performing a query that will return a large dataset (by large I mean
100k+ rows), is it more effecient (memory usage wise) to use the results
as
you fetch them or fetch all the results into an array, free the statement
handle, and the process
1 - 100 of 101 matches
Mail list logo