no more than
50M. (The link explains.)
Until 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 V
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
is Jedig'; mysql@lists.mysql.com
> Subject: 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:
> MEM
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
Conf
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
>-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 u
usage can easily be some
hundret GB!
[--] 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:
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
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 w
Quoth Baron Schwartz :
> 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 of RAM so
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
wrote:
> H
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 ou
gt; 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 idy
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 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
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_
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, 11.9%wa,
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
Mem
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 b
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 remo
sed memory.
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 C
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 or
~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 the
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 Informati
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
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 mention
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
memo
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 proc
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
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. MyS
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?
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 th
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 --
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 li
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
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 produ
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 primary
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
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
lable
resource 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 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,
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 c
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 the
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=
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 usa
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 ca
't interact directly with clients. Are
you using InnoDB? It adds a few more.
> 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 m
report on threads (since mysql
> technically supposedly has only 1 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 314
amiliar with how 'ps' 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 3
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
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)
son
> Cc: [EMAIL PROTECTED]
> 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
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)
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 updat
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...
// DvD
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 stopp
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 states
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
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
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 d
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 caching
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
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%, 2
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
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
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
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
h 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 takes about 41mb!! :(
> > > Can anyone po
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
ns 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 have no memory. You're getting misled by Linuxes threads
implementati
hread 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 manua
.
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
S
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 episo
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 severa
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.
Aft
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 repli
p 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 messag
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, plea
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 smo
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 al
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 r
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 tha
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 o
mount involved, I know I should
> 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
> us
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 there are hundreds.
I'll try the thread concurrency thing, thanks. I was u
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 i
1 - 100 of 104 matches
Mail list logo
