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