Re: mysql

From: James Housley (jim_at_Thehousleys.net)
Date: 09/28/04 

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

Relevant Pages