Date: Tue, 28 Sep 2004 17:12:00 -0400 From: James Housley <jim@Thehousleys.net> To: freebsd-isp@freebsd.org Cc: "Erik @ Microcontroller.nl" <erik@microcontroller.nl> Subject: Re: mysql Message-ID: <4159D3A0.1000102@Thehousleys.net> In-Reply-To: <1096382924.31926.27.camel@tessa.mysmt.net> References: <1096380086.31926.9.camel@tessa.mysmt.net> <11ab01c4a567$30b2df60$8800000a@felfel> <1096382924.31926.27.camel@tessa.mysmt.net>
index | next in thread | previous in thread | raw e-mail
[-- Attachment #1 --] Erik @ Microcontroller.nl wrote: > 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? > Have you optimized the queries? Specifically read the section on optimizing in the documentation. Use "EXPLAIN" to make sure that these big queries are actually using the indexes you think they are. Jim -- /"\ ASCII Ribbon Campaign . \ / - NO HTML/RTF in e-mail . X - NO Word docs in e-mail . / \ ----------------------------------------------------------------- jeh@FreeBSD.org http://www.FreeBSD.org The Power to Serve jim@TheHousleys.Net http://www.TheHousleys.net --------------------------------------------------------------------- A Microsoft Certified Systems Engineer is to computing what a McDonalds Certified Food Specialist is to fine cuisine. -- Jack O'Neill [-- Attachment #2 --] 0 *H 01 0 + 0 *H #00U 0 *H 0b1 0 UZA1%0#U Thawte Consulting (Pty) Ltd.1,0*U#Thawte Personal Freemail Issuing CA0 040131191100Z 050130191100Z0^10UHousley10 U*James10U James Housley1"0 *H jim@thehousleys.net0"0 *H 0 %k7o_tg ?@<_P. Eh;_{)SӻNKH)'M(W_w%ވ,UnJ13{ ㎊t [lBg] ѢbkKZ 3OXmuq2$=d8ݨiܠc[)"(Vln嗛x RE%H%'zm6 ;!nij0$c` wӁX ᝐCs 00.0 U 0jim@thehousleys.net0 U 0 0 *H }Nrx4Ae+d)?O}ibqWSVَ Uր 0QjL*m$A "Vs̱8~`0e&q$5]%ړN00U 0 *H 0b1 0 UZA1%0#U Thawte Consulting (Pty) Ltd.1,0*U#Thawte Personal Freemail Issuing CA0 040131191100Z 050130191100Z0^10UHousley10 U*James10U James Housley1"0 *H jim@thehousleys.net0"0 *H 0 %k7o_tg ?@<_P. Eh;_{)SӻNKH)'M(W_w%ވ,UnJ13{ ㎊t [lBg] ѢbkKZ 3OXmuq2$=d8ݨiܠc[)"(Vln嗛x RE%H%'zm6 ;!nij0$c` wӁX ᝐCs 00.0 U 0jim@thehousleys.net0 U 0 0 *H }Nrx4Ae+d)?O}ibqWSVَ Uր 0QjL*m$A "Vs̱8~`0e&q$5]%ړN0?0 0 *H 01 0 UZA10U Western Cape10U Cape Town10U Thawte Consulting1(0&U Certification Services Division1$0"UThawte Personal Freemail CA1+0) *H personal-freemail@thawte.com0 030717000000Z 130716235959Z0b1 0 UZA1%0#U Thawte Consulting (Pty) Ltd.1,0*U#Thawte Personal Freemail Issuing CA00 *H 0 Ħ<UsUNʙZ hup [v :aQP 0cZ,p+Z?qV˯< 6$*+w=+>@dקe*TH<a@ dr` 00U 0 0CU <0:08642http://crl.thawte.com/ThawtePersonalFreemailCA.crl0 U 0)U "0 0 10UPrivateLabel2-1380 *H HP . fgCL!6 -6/ P p<ab:~ t%Pb'qW%ݩ9 Oe_N4[5MwV!x!5$ F]_eO1;070i0b1 0 UZA1%0#U Thawte Consulting (Pty) Ltd.1,0*U#Thawte Personal Freemail Issuing CA 0 + 0 *H 1 *H 0 *H 1 040928211201Z0# *H 1-w;2;b=Ix-)0R *H 1E0C0 *H 0*H 0 *H @0+0 *H (0x +71k0i0b1 0 UZA1%0#U Thawte Consulting (Pty) Ltd.1,0*U#Thawte Personal Freemail Issuing CA 0z *H 1ki0b1 0 UZA1%0#U Thawte Consulting (Pty) Ltd.1,0*U#Thawte Personal Freemail Issuing CA 0 *H mk dc G烕;bWI*b8 \kQ\ - : @2^߁oHt"!toB6[XH Ǔ3JTBT C? E|Kw(O iz$B,72$ S-Xy 0@9֪,4 boBOr|<Y<,excQ$!\3 BkɜCxc{f=fm:[oU>6`#ZRg]K9/4help
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4159D3A0.1000102>