Date: Tue, 28 Sep 2004 18:29:42 +0300 From: "Mustafa N. Deeb" <mustafa@palnet.com> To: "Erik @ Microcontroller.nl" <erik@microcontroller.nl> Cc: freebsd-isp@freebsd.org Subject: Re: mysql Message-ID: <127501c4a56f$fa327460$8800000a@felfel> References: <1096380086.31926.9.camel@tessa.mysmt.net> <11ab01c4a567$30b2df60$8800000a@felfel> <1096382924.31926.27.camel@tessa.mysmt.net> <122c01c4a56c$0fe603c0$8800000a@felfel> <1096384464.31926.41.camel@tessa.mysmt.net>
next in thread | previous in thread | raw e-mail | index | archive | help
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@microcontroller.nl> To: "Mustafa N. Deeb" <Mustafa@palnet.com> Cc: <freebsd-isp@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@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@microcontroller.nl> > > To: <freebsd-isp@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@freebsd.org mailing list > > > http://lists.freebsd.org/mailman/listinfo/freebsd-isp > > > To unsubscribe, send any mail to > "freebsd-isp-unsubscribe@freebsd.org" > > -- > Erik @ Microcontroller.nl <erik@microcontroller.nl> -- Erik @ Microcontroller.nl <erik@microcontroller.nl> _______________________________________________ freebsd-isp@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-isp To unsubscribe, send any mail to "freebsd-isp-unsubscribe@freebsd.org"
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?127501c4a56f$fa327460$8800000a>