Hallo
On Thu, Jun 22, 2006 at 01:54:07PM -0500, Dan Buettner wrote:
> Christian, I hope raising the open_files_limit helps (I think it
> should). I second Brent's suggestion to enable the thread_cache.
>
> Please do report back and let us know how you fare.
The effect that lots of tables are i
Christian, I hope raising the open_files_limit helps (I think it
should). I second Brent's suggestion to enable the thread_cache.
Please do report back and let us know how you fare.
Dan
Christian Hammers wrote:
Hello
On Thu, Jun 22, 2006 at 11:28:41AM -0500, Dan Buettner wrote:
Christian,
Christian, can you post the output of
SHOW VARIABLES;
and
SHOW STATUS;
please?
I see you're servicing 761 queries per second on average, which is
pretty good. However, it appears to me your server has performed over
120 million operations (Opens: 120224674) to open tables in 10 days of
uptime,
set global thread_cache_size=30
- Original Message -
From: "Christian Hammers" <[EMAIL PROTECTED]>
To: "Dan Buettner" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, June 22, 2006 1:02 PM
Subject: Re: Lots of threads in "opening tables" and "closing tables&
Hello
On Thu, Jun 22, 2006 at 11:28:41AM -0500, Dan Buettner wrote:
> Christian, can you post the output of
> SHOW VARIABLES;
> and
> SHOW STATUS;
> please?
Ok, is below. We're only using MyISAM although InnoDB is activated.
> I see you're servicing 761 queries per second on average, which is
> p
Hello
We have the problem that on one of our database server
(Quad-Dualcore-Hyperthreading Xeon system with 8GB RAM) the database
performance suddenly goes down and stays so for a while.
There is no significant memory or CPU activity but the Load goes up to
200 which indicates to me that there mu
