Your mysql db is only using 496Mb of ram? i have a server with 1GB ram
where mysql uses more mem than yours does - you should probably tune
your server system variables a bit to utilize your memory better.
Christian Hammers wrote:
On Tue, Aug 22, 2006 at 10:20:47AM -0600, Michael Loftis wrote:
On Tue, Aug 22, 2006 at 10:20:47AM -0600, Michael Loftis wrote:
> One other quick ? -- Are you using a 64 bit (x86_64/EMT64) or 32-bit? If
> you're still in 32-bit mode the extra memory over 4Gb can actually slow the
> system down since it has to page between memory zones.
It was choosen to run
On Tue, Aug 22, 2006 at 10:04:06AM -0500, Dan Buettner wrote:
> You have a high number of connections, by my calculations about 15 per
> second. (connection / uptime, or 46944092/3052131 = 15.38) I would
> think that is introducing a fair bit of overhead for you - you might
> consider persistent
Hi Christian - thanks for posting that.
I see you are making excellent use of the query cache; also your
thread_cache is working well, seems that 30 is about the right number.
You have a high number of connections, by my calculations about 15 per second.
(connection / uptime, or 46944092/305213
Hallo
On Tue, Aug 22, 2006 at 09:25:09AM -0500, Dan Buettner wrote:
> Christian, can you post the output of
> SHOW STATUS
> and
> SHOW VARIABLES
> please?
>
> This will tell us how your server is configured, and how it has been
> running. It's possible you're not set up to best utilize your CPU
Christian, can you post the output of
SHOW STATUS
and
SHOW VARIABLES
please?
This will tell us how your server is configured, and how it has been
running. It's possible you're not set up to best utilize your CPU
power or memory.
Dan
On 8/22/06, Christian Hammers <[EMAIL PROTECTED]> wrote:
He
"Christian Hammers" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, August 22, 2006 6:47 AM
Subject: How to utilize 16 logical CPUs
Hello
I have a server with the following specs but fear that the currently
running MySQL-4.1 does not completely utilize it as the database feels
to slow f
Hello
I have a server with the following specs but fear that the currently
running MySQL-4.1 does not completely utilize it as the database feels
to slow for the webservers although the system load is always only at
about 10%:
CPU: Quad Dualcore Xeon with Hyperthreading (4*2*2=16 logical c
