Index: [Article Count Order] [Thread]

Date:  Mon, 29 Dec 2008 15:55:02 -0700
From:  "Tony Loosle" <tony-bq (at mark)>
Subject:  [coba-e:14573] Re: MYSQL and Memory
To:  coba-e (at mark)
Message-Id:  <200812291555020025.056097F6 (at mark)>
In-Reply-To:  < (at mark)>
References:  <200812221837080169.5DA35607 (at mark)> < (at mark)>
X-Mail-Count: 14573


Thanks for the help.

I don't find a file:


*********** REPLY SEPARATOR  ***********

On 12/23/2008 at 6:07 PM Michael Stauber wrote:

>Hi Tony,
>> I have a server that has several database driven sites on it.  The cpu
>> at 50% alot of the time.
>> Is there a way to increase the memory for mysql to help it run better or
>> another setting?
>> Also, if I move the mysql to a seperate system, is the bluequartz faster
>> than mysql on a windows server?
>Lemons and Aardvarks aside, keep in mind that MySQL on CentOS typically
>with "default" settings, which aren't optimized in any way, shape or form. 
>There are quite a few things in /etc/ that you can tweak, like
>cache size, or memory limits. Additionally, optimized MySQL tables and 
>queries also go a long way performance wise. 
>I don't know all that much about MySQL optimization and usually my own 
>settings are based on what I gathered from trial and error. But someone
>might be able to give some pointers there.
>With best regards,
>Michael Stauber