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
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.).
;)
Alexis
-Original Message-
From: Benjamin KRIEF [mailto:[EMAIL PROTECTED]
Sent: segunda-feira, 3 de Novembro de 2003 21:00
To: [EMAIL
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
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
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
10 matches
Mail list logo