SEO

#1 (**permalink**) 02-28-2008, 10:32 AM

Sorry for the newbie question.

I am working with MySQL for the first time in a large table
environment. In MS SQL, there is a way to make the database logging
level "low" to increase your overall speed. Are there settings like
this in MySQL? Also, any other settings to improve performance would
be much appreciated. My first box is a Quad Xeon with 8GB ram and
8x150GB SAS drives.

Thank you,

CJ

#2 (**permalink**) 02-28-2008, 10:32 AM

On Wed, 30 Jan 2008 11:28:55 -0800 (PST), Curious Joe
<joebob.johnson@gmail.com> wrote:

>Sorry for the newbie question.
>
>I am working with MySQL for the first time in a large table
>environment. In MS SQL, there is a way to make the database logging
>level "low" to increase your overall speed. Are there settings like
>this in MySQL? Also, any other settings to improve performance would
>be much appreciated. My first box is a Quad Xeon with 8GB ram and
>8x150GB SAS drives.
>
>Thank you,
>
>CJ

There is a lot to tell about it. Luckily MySQL AB wrote it
all down in the fine manual. If you have more questions
after reading :
http://dev.mysql.com/doc/refman/5.0/...imization.html
be welcome to come back here.
--
( Kees
)
c[_] Lord, please make me the kind
of person my dog thinks I am. (#446)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Logging etc