mysql

[Erik at Microcontroller.nl]

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>