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
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
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
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
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)
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
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/PHP
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:
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 open
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 open
apache sessions and 40 open mysql connections. I am calling
21 matches
Mail list logo
