Index: [Article Count Order] [Thread]

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

Michael

Thanks for the help.

I don't find a file:
/etc/my.cf 

tony


*********** 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
>sits
>> 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
>runs 
>with "default" settings, which aren't optimized in any way, shape or form. 
>
>There are quite a few things in /etc/my.cf that you can tweak, like
>increasing 
>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
>else 
>might be able to give some pointers there.
>
>-- 
>With best regards,
>
>Michael Stauber