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 in
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
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
pretty
You should also up your thread cache, currently it's set to 0. MySQL won't reuse threads if this is set to 0. MySQL has created
13781740 new threads so far.
You can change the value while the server is running (example below), but may
want to also add it to your conf file.
set global
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,
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: