So far I've experienced it on one SMP box and one single CPU box. I
Silly question: what is SMP...?
Best regards,=20
Eivind :-)
sql, query
-
Before posting, please check:
SMP is System Multi Processor
Like a server with 2 or more CPUs ...
David
- Original Message -
From: webmaster [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, May 13, 2002 1:07 PM
Subject: Re: Re: mysql uses 99% cpu under freebsd 4.3
So far I've experienced it on one SMP box
, 2002 1:07 PM
Subject: Re: Re: mysql uses 99% cpu under freebsd 4.3
So far I've experienced it on one SMP box and one single CPU box. I
Silly question: what is SMP...?
Best regards,=20
Eivind :-)
sql, query
On Thu, May 09, 2002 at 11:18:35AM -0400, Ken Menzel wrote:
Gunnar, This sounds very interesting! I will have to try this and
see if I cannot aggravate the problem with large cache values.
Thank you for sharing this information. Jeremy I hope you will
share something if you can reproduce
On Wed, May 01, 2002 at 09:15:25PM +0200, Gunnar Helliesen wrote:
List,
Re:
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:sss:71261:200104:iidpojcdbmgdbajh
aobn#b
I have this exact problem on a single-CPU P-III 500 running FreeBSD
4.5-RELEASE, generic kernel. MySQL is 4.0.1-alpha. I have
List,
Re:
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:sss:71261:200104:iidpojcdbmgdbajh
aobn#b
I have this exact problem on a single-CPU P-III 500 running FreeBSD
4.5-RELEASE, generic kernel. MySQL is 4.0.1-alpha. I have tried both the
mysql.com-supplied binary package and rolling my own from
Jeremy Zawodny writes:
On Wed, Apr 11, 2001 at 04:58:49PM +0300, Sinisa Milivojevic wrote:
This seems to be a problem with threads on FreeBSD, although on
which side, yet remains to be seen.
It seems to appear that it is surfacing not just under heavy load,
but when there are many
Hi,
I have had some various similar things happen with other apps since
upgrading to Fbsd4.2stable
What I have learnt to do first before anything else is, reboot and load
a SINGLE CPU compiled kernel to determine at what/where the bug may be.
I had a/still occasionally get a constant waiting
Jeremy Zawodny writes:
On Tue, Apr 10, 2001 at 02:25:44PM +0300, Sinisa Milivojevic wrote:
Can anyone of you guys come with a repeatable test case that will
always lead to the situation as described. Then we could try to fix
it.
I produced one about 9 months ago and gave it to Tim
Hi Sinisa!
Good to hear from you. Not having this problem yet, I am however
interested in the details of what you did find and what may be the
potential cure. I am asking as I would like a little more detail than
what would normally go in a log entry. IE how did the problem get
reproduced.
Ken Menzel writes:
Hi Sinisa!
Good to hear from you. Not having this problem yet, I am however
interested in the details of what you did find and what may be the
potential cure. I am asking as I would like a little more detail than
what would normally go in a log entry. IE how did the
On Wed, 11 Apr 2001, Sinisa Milivojevic wrote:
Hi!
Hi Ken,
This seems to be a problem with threads on FreeBSD, although on which
side, yet remains to be seen.
It seems to appear that it is surfacing not just under heavy load, but
when there are many threads running. Many means more then
My 4.2 STABLE dosent get so many queries, according to mysqladmin (Queries
per second avg: 0.700) the last time it acted up. By the way, it is a dual
CPU machine. On another machine with only one CPU running exactly the same
code and relese of FreeBSD I havent seen this problem.
/Lars Andersson
On Wed, Apr 11, 2001 at 04:58:49PM +0300, Sinisa Milivojevic wrote:
This seems to be a problem with threads on FreeBSD, although on
which side, yet remains to be seen.
It seems to appear that it is surfacing not just under heavy load,
but when there are many threads running. Many means
FYI, people experiencing this problem should try to make the mysqld as
idle as possible (ie disconnect or idle the connections) and then run
truss -p NNN (where NNN is the pid of the mysqld process) and post
a typical chunk of the output.
That would give valuable info to the mysql developers.
I suspect the point is that many more threads simply makes the problem
appear more often and thus be reproducible and thus more easily fixed.
Tim.
On Wed, Apr 11, 2001 at 04:49:19PM +0200, Lars Andersson wrote:
My 4.2 STABLE dosent get so many queries, according to mysqladmin (Queries
per
On Wed, Apr 11, 2001 at 12:33:44PM -0400, Ken Menzel wrote:
The list reject my trace (it was too large), so here is a smaller
one! Stops after info from first top starts showing CPU usage of 99%
Ken
Hi Tim, I just had it happen. Overall average 14 queries per second
on this machine.
In the last episode (Apr 11), Ken Menzel said:
The list reject my trace (it was too large), so here is a smaller
one! Stops after info from first top starts showing CPU usage of 99%
Ken
Hi Tim, I just had it happen. Overall average 14 queries per second
on this machine. Single CPU
.. ?
Regards,
Johan Andersson
Consultant Qbranch
- Original Message -
From: "Lars Andersson" [EMAIL PROTECTED]
To: "Andrew Schmidt" [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Monday, April 09, 2001 11:26 PM
Subject: Re: mysql uses 99% cpu under f
Johan Andersson writes:
I've had the same problem on an Intel P-III 800 w 256M RAM running FreeBSD
4.1-RELEASE with
both the distribution from the ports tree and the source dist. from mysql.com.
I tried to solve the problem with analysing all the database traffic, but mysql were
taking all
Hi!
People are reporting performance problems also from the FreeBSD port of
Innobase. There seems to be a runaway thread which gets free sometimes
and eats up 100 % of the CPU. It was not fixed with the latest patches to
Innobase.
I will try setting thread priorities in 3.23.37. That might
On Tue, Apr 10, 2001 at 02:25:44PM +0300, Sinisa Milivojevic wrote:
Can anyone of you guys come with a repeatable test case that will
always lead to the situation as described. Then we could try to fix
it.
I produced one about 9 months ago and gave it to Tim Smith. Had to
send him a CD-ROM,
On Mon, 9 Apr 2001 [EMAIL PROTECTED] wrote:
I have the same problem under FreeBSD-4.2 STABLE
sometimes it work fin 1week, but sometimes 1 day.
Description:
mysql uses 99% cpu and becomes extremely unresponsive under high load
How-To-Repeat:
send about 300 simultaneous visitors to
Have you tried this under a 'stable' version of freebsd?
In FreeBSD 4.2 beta, mysql would crash with user locks. Not mysql's fault.
now, I understand RC's are generally stable; but I would still make sure
that this bug doesn't show up in a stable os.
regards,
-- Andrew
- Original
I have experienced the same problems on a dual processor machine running
4.2-STABLE and mysql 3.23.36 from the ports tree.
regards,
Lars Andersson
At 16:03 2001-04-09 -0400, Andrew Schmidt wrote:
Have you tried this under a 'stable' version of freebsd?
In FreeBSD 4.2 beta, mysql would crash
Similar problems on FreeBSD 4.2-RELEASE.
Dedicated Mysql server is pinning the CPU, under a load of 500+ queries
per second. Memory is not exausted, and Disk usage is 0.
Just the CPU is pinned.
[EMAIL PROTECTED] wrote:
Description:
mysql uses 99% cpu and becomes extremely
I've seen what's probably the same thing under 4.2-STABLE.
The poll() system call returns 1 but there's no corresponding
file handle marked in the data structures that were passed to poll().
(It could be a mysqld bug if they're asking to poll() for certain kinds
of events but then not checking
27 matches
Mail list logo