This is happening to me also!
I have a Dual P-III, 550, 896MB RAM.
Suddenly mysql says it has <insert max_connections here> connections busy
most of them "LOCKED", and then suddenly they start working on all of them
at the same time. This creates a load average similar to <max_connections>.
Is this a problem related to Linux, or is it a MySQL "feature" ?
//Johan
----- Original Message -----
From: "Johan Wahlström" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 14, 2001 5:48 PM
Subject: Re: Mysql causing severe load problems on Dual-Athlon server?
>
> ----- Original Message -----
> From: "Ryan Shrout" <[EMAIL PROTECTED]>
> To: "Tonu Samuel" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Tuesday, August 14, 2001 5:21 PM
> Subject: Re: Mysql causing severe load problems on Dual-Athlon server?
>
>
> > Update -- The problem I described happened again, and this time I was
able
> > to get the "mysqladmin processlist" done. Here are the results from
that.
> > Can you help me find my problem based on this information?
> >
> > Thank you!!
> >
> > Here is the "top" header: 11:09am up 4 days, 20:15, 1 user, load
> > average: 101.55, 49.58, 20.18
> >
> > [root@dagger /root]# mysqladmin processlist -p
> > Enter password:
> > mysqladmin: connect to server at 'localhost' failed
> > error: 'Access denied for user: 'root@localhost' (Using password: YES)'
> > [root@dagger /root]# mysqladmin processlist -p
> > Enter password:
> >
>
+--------+-------+-----------+-----------+---------+------+----------------+
> > ----
>
> --------------------------------------------------------------------------
> --
> > ----
> > ------------------+
> > | Id | User | Host | db | Command | Time | State
> |
> > Inf
> > o
> > |
> >
>
+--------+-------+-----------+-----------+---------+------+----------------+
> > ----
> > ------------------------------------------------------------------------
--
> --
> > ----
> > ------------------+
> > | 649586 | amdmb | localhost | forum | Quit | 48 |
> |
> >
> > |
> > | 649594 | amdmb | localhost | dotbanner | Query | 4 | Locked
> |
> > upd
> > ate advertisers set Shown="6613775" where UserName="TCComputers"
> > |
> > | 649597 | amdmb | localhost | forum | Query | 36 | cleaning up
> |
> > SEL
> > ECT * FROM thread WHERE forumid <> 15 ORDER BY lastpost DESC LIMIT 10
> > |
> > | 649598 | amdmb | localhost | dotbanner | Query | 8 | Locked
> |
> > sel
> > ect * from advertisers where UserName="Iwill"
> > |
> > | 649601 | amdmb | localhost | forum | Sleep | 36 |
> |
> >
> > |
> > | 649609 | amdmb | localhost | Amdmb | Init DB | 1 | cleaning up
> |
> >
> > |
> > | 649614 | amdmb | localhost | forum | Query | 0 | Opening
tables
> |
> > SEL
> > ECT forumid,canview,canpostnew FROM forumpermission WHERE
usergroupid='1'
> > |
> > | 649629 | amdmb | localhost | forum | Query | 4 |
> |
> >
> > |
> > | 649630 | amdmb | localhost | dotbanner | Query | 4 | Locked
> |
> > sel
> > ect * from advertisers where UserName="DualAthloncom"
> > |
> > | 649642 | amdmb | localhost | forum | Query | 36 | cleaning up
> |
> > OR Display_Zone = |
> > | 649694 | amdmb | localhost | dotbanner | Query | 45 | cleaning up
> |
> > sel
> > ect UserName, Weight from advertisers where (Display_Zone like
> > "%VantecHome%" OR
> > Display_Zone = " |
> > | 649695 | amdmb | localhost | forum | Quit | 4 |
> |
> >> > set-variable = table_cache=128
> > > set-variable = record_buffer=2M
> > > set-variable = net_buffer=2M
> > > [myisamchk]
> > > set-variable = key_buffer_size=32M
> > > set-variable = sort_buffer_size=128M
> > > tmpdir=/mnt/mysql/tmp
> > > [tonu@x153 tonu]$
> > >
> > > I am sure that this is not your problem currently but this is
neccessary
> > > anyway.
> > >
> > > To solve your problem, please run "mysqladmin processlist" while this
> > > bad things is going on and post output of it here together with table
> > > structures which you can get with "mysqldump --no-data dbname"
> > >
> > > And one thing what I suggest to try - get really latest linux-ac
kernel.
> > There is a some possibility that you problem is solved
> > > in 2.4.7-pre8 or latest. There were some important bugs related to IO
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
