On Thu, Mar 25, 2004 at 07:21:04PM -, Matt Chatterley wrote:
Hmm.
Taking a stab in the dark here, but..
If it's purely a 'hit counter' type affair, and you're updating a single
row, perhaps performance could be gained by instead inserting into a table
(presumably this can be done with single-
arch 2004 03:17
To: [EMAIL PROTECTED]
Subject: Re: Speeding up MySQL server
On Wed, Mar 24, 2004 at 08:21:15PM -0600, Paul DuBois wrote:
>At 17:55 -0800 3/24/04, Jim Richardson wrote:
>>I have a rather heavily loaded server, which I would like to tweak a
>>little more performance out
Is the table you 're talking about critical ?
If not, you could use type=HEAP for it, so every access will be done in
memory.
Marc.
-Message d'origine-
De : Jim Richardson [mailto:[EMAIL PROTECTED]
Envoye : jeudi 25 mars 2004 04:17
A : [EMAIL PROTECTED]
Objet : Re: Speedin
On Wed, Mar 24, 2004 at 08:21:15PM -0600, Paul DuBois wrote:
At 17:55 -0800 3/24/04, Jim Richardson wrote:
I have a rather heavily loaded server, which I would like to tweak a
little more performance out of. It currently is binlogging although
there is no slave yet. Does the process of bin logging
At 17:55 -0800 3/24/04, Jim Richardson wrote:
I have a rather heavily loaded server, which I would like to tweak a
little more performance out of. It currently is binlogging although
there is no slave yet. Does the process of bin logging take significant
resources? It's putting out about 1GB log pe