mysql

[Mustafa N. Deeb]

hi

you might be suffering from an I/O problem

if it takes a long time in big queries,

consider raid and using InnoDB


Cheers
----- Original Message ----- 
From: "Erik @ Microcontroller.nl" <erik at microcontroller.nl>
To: "Mustafa N. Deeb" <Mustafa at palnet.com>
Cc: <freebsd-isp at freebsd.org>
Sent: Tuesday, September 28, 2004 6:14 PM
Subject: Re: mysql


On Tue, 2004-09-28 at 17:01, Mustafa N. Deeb wrote:

> 
> i've meant our server configuration
>
> and are u doing big DBs?


ah o.k.,
freebsd 4.9 with mysql 4.018
there is one site with a big index, a big select query for every visit.
this generates the problem.
Should I increase the number of connections? I don't believe this is the
issue
Should I increase some kind of read buffer? but is this not dynamically
regulated by mysql already?

hmm,. I now switched to the my-large.cnf configuration in
/usr/local/share/mysql/
I copied it to /usr/local/share/mysql/my.cnf
and restarted mysql

let's see how that goes..

Greetings,
-Erik.


>
> Cheers
>
>         ----- Original Message ----- 
>         From: Erik @ Microcontroller.nl
>         To: Mustafa N. Deeb
>         Cc: freebsd-isp at freebsd.org
>         Sent: Tuesday, September 28, 2004 5:48 PM
>         Subject: Re: mysql
>
>         On Tue, 2004-09-28 at 16:26, Mustafa N. Deeb wrote:
>
>         > what is your configuration ?
>
>
>         I put:
>         [mysqld]
>         query_cache_type = ON
>         query_cache_size = 10M
>
>         in /usr/local/etc/my.cnf
>
>         I read that doing mysqld --help will give me all parameters,.
>         but how do we do that on a freebsd install where I use
>         mysqld_safe?
>
>
>
>
>         >
>         >
>         > ----- Original Message ----- 
>         > From: "Erik @ Microcontroller.nl" <erik at microcontroller.nl>
>         > To: <freebsd-isp at freebsd.org>
>         > Sent: Tuesday, September 28, 2004 5:01 PM
>         > Subject: mysql
>         >
>         >
>         > >
>         > > Hi all,.
>         > > Are you using any mysql tuning settings in my.cnf?
>         > > I'm having a bit of trouble with some have mysql sites with 
> big query's
>         > > resulting in a mysqld process at 80% continue.
>         > >
>         > > any tips are welcome.
>         > >
>         > > -Erik.
>         > >
>         > > _______________________________________________
>         > > freebsd-isp at freebsd.org mailing list
>         > > http://lists.freebsd.org/mailman/listinfo/freebsd-isp
>         > > To unsubscribe, send any mail to 
> "freebsd-isp-unsubscribe at freebsd.org"
>
>         -- 
>         Erik @ Microcontroller.nl <erik at microcontroller.nl>

-- 
Erik @ Microcontroller.nl <erik at microcontroller.nl>

_______________________________________________
freebsd-isp at freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-isp
To unsubscribe, send any mail to "freebsd-isp-unsubscribe at freebsd.org"