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
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
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
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
21 matches
Mail list logo
