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
- Original Message - From: "Heikki Tuuri"
<[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Friday, December 16, 2005 3:46 PM
Subject: Re: CPU 100% + crashes ...
Dilipan,
thank you.
I think there indeed is a slight unprotected access in:
> 0x8158a17 inn
fwrite(str, 1, len, f);
if (dyn_str)
{
my_free(dyn_str, MYF(0));
}
...
"
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Fri
p
MyISAM tables
http://www.innodb.com/order.php
- Original Message - From: "Dilipan Sebastiampillai"
<[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, December 15, 2005 2:04 PM
Subject: CPU 100% + crashes ...
Hi all,
We have a MySQL server used for
reign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up
MyISAM tables
http://www.innodb.com/order.php
- Original Message - From: "Dilipan Sebastiampillai"
<[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, December
Hello.
> server version: 4.0.18-log ( I know it's old but we can't update for
>the moment )
MySQL shouldn't die even under huge load, it is bad that you can't
update, and work with old version which has lots of bugs. Do you have
a stack trace in the error log? Please, resolve and send it
: "Dilipan Sebastiampillai" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, December 15, 2005 2:04 PM
Subject: CPU 100% + crashes ...
Hi all,
We have a MySQL server used for a queueing system. It worked fine so far
but now we are experiencing some load problems coup
Hi all,
We have a MySQL server used for a queueing system. It worked fine so far
but now we are experiencing some load problems couple with crashes.
The load ( around 5-7 ) is due, according to vmstat, to processes
waiting for the CPU. And it makes sense because the CPU is used 100%
most of
ECTED]
Subject: Re: CPU 100%
If you find an answer, I would really like to hear about it. I have
been working on this for months. No one seems to have a clear answer,
although several people have reported curing it by either adding your
server to c:\WINNT\system32\drivers\etc\hosts or settin
If you find an answer, I would really like to hear about it. I have
been working on this for months. No one seems to have a clear answer,
although several people have reported curing it by either adding your
server to c:\WINNT\system32\drivers\etc\hosts or setting the mysql
service up to run
Hello all,
We use MySQL 3.23.51 on a NT Server and a Win2000 Server.
On the Win2000 server all works fine. But wen we install MySQl on the NT
Server
CPU Usage goes through 100% for a while (20-30 seconds).
What could be the reason of this?
And how can we fix it?
Regards
Peter Zuidema
[EMAIL PR
13 matches
Mail list logo
