Nik schrieb:
> [...]
>
> The server never uses all the Memory, at least 10% always free, and
> there's loads of free disk space. Just the CPU max's out, causing
> problems.
>
> I've posted below the output of STATUS and SHOW GLOBAL STATUS. Any
> and all comments would be much appreciated as to
Nik wrote:
I've posted below the output of STATUS and SHOW GLOBAL STATUS. Any
and all comments would be much appreciated as to how we can get
performance back on track.
Wow. . .200 logins? 511 open tables? 277+ million sort rows? On a
single PC host? And you're complaining about perform
We are using MySql as the backend to our Web (Apache) based Pool
website. Over the last 6-9 months the MySql process has become busier
and busier, to the point now where we see definative slowdowns to the
Application, as experienced by users - in terms of latency.
Using TOP, I can see that mysql p
