mysql

[James Housley]

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 at FreeBSD.org      http://www.FreeBSD.org     The Power to Serve
jim at 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3228 bytes
Desc: S/MIME Cryptographic Signature
Url : http://lists.freebsd.org/pipermail/freebsd-isp/attachments/20040928/ade08d65/smime.bin