also try enabling the slow-log and track down any long queries.
just did that, so we'll go through that now, there are some in there...
Have you tuned any of the cache parameters for the large amount of
memory you have?
yes, we have done extensive tuning. Is there something I can provide to
Hi Jerry,
Someone has already answered why the load stays at 1.3 to 1.5.
Sounds like one query may be slowing down the others, mytop
(/usr/ports/databases/mytop) might help identify that query also try
enabling the slow-log and track down any long queries. Have you tuned
any of the cache
Jerry,
Thats a reasonably serious hardware platform, you should not encounter 30
second delays, did you compile mysql yourself or use a pre-compiled
binary...
Sid
-Original Message-
From: PR [SMTP:[EMAIL PROTECTED]]
Sent: Sunday, August 19, 2001 4:28 PM
To: [EMAIL PROTECTED]
I don't know, I would have to check with my progammer on that one to be
sure... does this help
mysql -V
Ver 11.15 Distrib 3.23.40, for unknown-freebsdelf4.2 (i386)
[EMAIL PROTECTED] writes:
Jerry,
Thats a reasonably serious hardware platform, you should not encounter 30
second delays, did