Re: mysql
From: James Housley (jim_at_Thehousleys.net)
Date: 09/28/04
- Previous message: Mustafa N. Deeb: "Re: mysql"
- In reply to: Erik _at_ Microcontroller.nl: "Re: mysql"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 28 Sep 2004 17:12:00 -0400 To: freebsd-isp@freebsd.org
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
- application/x-pkcs7-signature attachment: S/MIME Cryptographic Signature
- Previous message: Mustafa N. Deeb: "Re: mysql"
- In reply to: Erik _at_ Microcontroller.nl: "Re: mysql"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
