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 |
UPD
ATE LOW_PRIORITY thread SET views=views+1 WHERE threadid='53042'
|
| 649644 | amdmb | localhost | forum | Query | 68 | cleaning up |
SEL
ECT COUNT(*) AS threads FROM thread WHERE thread.forumid='19' AND
thread.visible
=1 AND lastpost > |
| 649649 | amdmb | localhost | dotbanner | Query | 80 | cleaning up |
upd
ate advertisers set Shown="6613772" where UserName="TCComputers"
|
| 649658 | amdmb | localhost | dotbanner | Query | 8 | Locked |
upd
ate advertisers set Shown="6613774" where UserName="TCComputers"
|
| 649663 | amdmb | localhost | forum | Query | 36 | cleaning up |
UPD
ATE LOW_PRIORITY thread SET views=views+1 WHERE threadid='51192'
|
| 649664 | amdmb | localhost | dotbanner | Quit | 72 | |
|
| 649666 | amdmb | localhost | forum | Query | 67 | |
|
| 649667 | amdmb | localhost | forum | Query | 68 | |
|
| 649673 | amdmb | localhost | dotbanner | Query | 0 | Locked |
sel
ect * from advertisers where UserName="DualAthloncom"
|
| 649678 | amdmb | localhost | Amdmb | Quit | 53 | cleaning up |
|
| 649685 | amdmb | localhost | forum | Quit | 28 | |
|
| 649690 | amdmb | localhost | dotbanner | Query | 8 | Locked |
sel
ect UserName, Weight from advertisers where (Display_Zone like
"%left_125_125%"
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 | |
|
| 649706 | amdmb | localhost | dotbanner | Query | 4 | Locked |
sel
ect UserName, Weight from advertisers where (Display_Zone like
"%VantecHome%" OR
Display_Zone = " |
| 649709 | amdmb | localhost | forum | Query | 0 | Opening tables |
SEL
ECT * FROM usergroup WHERE usergroupid=1
|
| 649711 | amdmb | localhost | dotbanner | Query | 0 | Locked |
sel
ect * from advertisers where UserName="TCComputers"
|
| 649712 | amdmb | localhost | forum | Quit | 28 | |
|
| 649713 | amdmb | localhost | dotbanner | Query | 55 | cleaning up |
sel
ect * from advertisers where UserName="Iwill"
|
| 649715 | amdmb | localhost | dotbanner | Query | 3 | cleaning up |
sel
ect UserName, Weight from advertisers where (Display_Zone like
"%left_125_125%"
OR Display_Zone = |
| 649716 | amdmb | localhost | dotbanner | Query | 8 | Locked |
upd
ate advertisers set Shown="1722353" where UserName="Vantec"
|
| 649719 | amdmb | localhost | dotbanner | Query | 55 | |
|
| 649720 | amdmb | localhost | Amdmb | Query | 48 | |
|
| 649721 | amdmb | localhost | dotbanner | Query | 55 | cleaning up |
sel
ect * from advertisers where UserName="Iwill"
|
| 649722 | amdmb | localhost | forum | Query | 4 | Sorting result |
SEL
ECT * FROM thread WHERE forumid <> 15 ORDER BY lastpost DESC LIMIT 10
|
| 649723 | amdmb | localhost | dotbanner | Query | 8 | Locked |
sel
ect UserName, Weight from advertisers where (Display_Zone like
"%left_125_125%"
OR Display_Zone = |
| 649728 | amdmb | localhost | dotbanner | Query | 0 | Locked |
upd
ate advertisers set Shown="571682" where UserName="DualAthloncom"
|
| 649730 | amdmb | localhost | dotbanner | Query | 4 | Locked |
sel
ect * from advertisers where UserName="Vantec"
|
| 649732 | amdmb | localhost | dotbanner | Query | 4 | Locked |
sel
ect * from advertisers where UserName="Iwill"
|
| 649733 | amdmb | localhost | dotbanner | Init DB | 81 | cleaning up |
|
| 649734 | amdmb | localhost | dotbanner | Query | 0 | Locked |
sel
ect * from advertisers where UserName="Webconnect"
|
| 649735 | amdmb | localhost | Amdmb | Query | 70 | cleaning up |
SEL
ECT News.NewsID, News.Title, News.Date, News.Author, News.Source, News.Link,
New
s.Information, Ne |
| 649736 | amdmb | localhost | dotbanner | Query | 28 | cleaning up |
upd
ate advertisers set Shown="12026001" where UserName="Webconnect"
|
| 649738 | amdmb | localhost | dotbanner | Query | 28 | cleaning up |
upd
ate advertisers set Shown="979013" where UserName="Netshelter"
|
| 649739 | amdmb | localhost | dotbanner | Query | 4 | Locked |
sel
ect UserName, Weight from advertisers where (Display_Zone like "%crucial%"
OR Di
splay_Zone = "*") |
| 649740 | amdmb | localhost | dotbanner | Sleep | 0 | |
|
| 649743 | amdmb | localhost | dotbanner | Query | 4 | Locked |
sel
ect * from advertisers where UserName="Vantec"
|
| 649745 | amdmb | localhost | dotbanner | Query | 4 | Locked |
upd
ate advertisers set Shown="1722353" where UserName="Vantec"
|
| 649746 | amdmb | localhost | dotbanner | Query | 4 | Locked |
sel
ect * from advertisers where UserName="ADKy"
|
| 649747 | amdmb | localhost | dotbanner | Query | 5 | cleaning up |
sel
ect UserName, Weight from advertisers where (Display_Zone like
"%left_125_125%"
OR Display_Zone = |
| 649748 | amdmb | localhost | forum | Quit | 71 | |
|
| 649749 | amdmb | localhost | dotbanner | Query | 4 | Locked |
sel
ect * from advertisers where UserName="Vantec"
|
| 649750 | amdmb | localhost | dotbanner | Query | 59 | cleaning up |
sel
ect UserName, Weight from advertisers where (Display_Zone like
"%Vantec_125%" OR
Display_Zone = " |
| 649751 | amdmb | localhost | dotbanner | Query | 59 | cleaning up |
sel
ect UserName, Weight from advertisers where (Display_Zone like "%crucial%"
OR Di
splay_Zone = "*") |
| 649752 | amdmb | localhost | dotbanner | Query | 4 | Locked |
sel
ect * from advertisers where UserName="Webconnect"
|
| 649753 | amdmb | localhost | dotbanner | Query | 22 | cleaning up |
sel
ect * from advertisers where UserName="Vantec"
|
| 649754 | amdmb | localhost | dotbanner | Query | 4 | Locked |
upd
ate advertisers set Shown="12026002" where UserName="Webconnect"
|
| 649755 | amdmb | localhost | forum | Init DB | 4 | cleaning up |
|
| 649756 | amdmb | localhost | dotbanner | Query | 59 | cleaning up |
upd
ate advertisers set Shown="11613610" where UserName="Fastclick"
|
| 649757 | amdmb | localhost | Amdmb | Init DB | 8 | cleaning up |
|
| 649758 | amdmb | localhost | dotbanner | Query | 4 | Locked |
upd
ate advertisers set Shown="6613775" where UserName="TCComputers"
|
| 649759 | amdmb | localhost | dotbanner | Query | 59 | cleaning up |
sel
ect UserName, Weight from advertisers where (Display_Zone like "%Top_468%"
OR Di
splay_Zone = "*") |
| 649760 | amdmb | localhost | dotbanner | Query | 4 | Locked |
upd
ate advertisers set Shown="12026002" where UserName="Webconnect"
|
| 649761 | amdmb | localhost | dotbanner | Query | 32 | cleaning up |
upd
ate advertisers set Shown="11613611" where UserName="Fastclick"
|
| 649762 | amdmb | localhost | forum | Query | 4 | Sorting result |
SEL
ECT * FROM thread WHERE forumid <> 15 ORDER BY lastpost DESC LIMIT 10
|
| 649763 | amdmb | localhost | dotbanner | Query | 59 | cleaning up |
sel
ect UserName, Weight from advertisers where (Display_Zone like "%Top_468%"
OR Di
splay_Zone = "*") |
| 649764 | amdmb | localhost | dotbanner | Query | 4 | Locked |
upd
ate advertisers set Shown="979011" where UserName="Netshelter"
|
| 649766 | amdmb | localhost | dotbanner | Query | 4 | Locked |
sel
ect * from advertisers where UserName="Netshelter"
|
| 649767 | amdmb | localhost | dotbanner | Query | 4 | Locked |
sel
ect * from advertisers where UserName="Fastclick"
|
| 649768 | amdmb | localhost | dotbanner | Init DB | 31 | cleaning up |
|
| 649769 | amdmb | localhost | dotbanner | Query | 49 | cleaning up |
upd
ate advertisers set Shown="979012" where UserName="Netshelter"
|
| 649770 | amdmb | localhost | dotbanner | Query | 45 | cleaning up |
sel
ect UserName, Weight from advertisers where (Display_Zone like "%Top_468%"
OR Di
splay_Zone = "*") |
| 649771 | amdmb | localhost | dotbanner | Query | 4 | Locked |
sel
ect * from advertisers where UserName="Fastclick"
|
| 649772 | amdmb | localhost | dotbanner | Query | 22 | cleaning up |
upd
ate advertisers set Shown="979012" where UserName="Netshelter"
|
| 649773 | amdmb | localhost | dotbanner | Query | 4 | Locked |
upd
ate advertisers set Shown="979013" where UserName="Netshelter"
|
| 649774 | amdmb | localhost | dotbanner | Query | 60 | cleaning up |
upd
ate advertisers set Shown="11613608" where UserName="Fastclick"
|
| 649775 | amdmb | localhost | dotbanner | Query | 4 | Locked |
sel
ect * from advertisers where UserName="Netshelter"
|
| 649776 | amdmb | localhost | dotbanner | Query | 4 | Locked |
upd
ate advertisers set Shown="11613611" where UserName="Fastclick"
|
| 649777 | amdmb | localhost | dotbanner | Query | 8 | Locked |
sel
ect UserName, Weight from advertisers where (Display_Zone like "%crucial%"
OR Di
splay_Zone = "*") |
| 649778 | amdmb | localhost | forum | Query | 0 | Opening tables |
SEL
ECT forum.forumid,styleid,styleoverride FROM forum,thread WHERE
forum.forumid=th
read.forumid AND |
| 649779 | amdmb | localhost | forum | Query | 69 | cleaning up |
SELECT DISTINCT post.userid, IF(votenum>=2,votenum,0) AS votenum,
IF(votenum>=2 AN |
| 649780 | amdmb | localhost | dotbanner | Query | 22 | cleaning up |
sel
ect UserName, Weight from advertisers where (Display_Zone like "%Top_468%"
OR Di
splay_Zone = "*") |
| 649781 | amdmb | localhost | dotbanner | Query | 0 | Locked |
sel
ect * from advertisers where UserName="ADKy"
|
| 649782 | amdmb | localhost | dotbanner | Query | 0 | Locked |
sel
ect * from advertisers where UserName="Webconnect"
|
| 649783 | amdmb | localhost | dotbanner | Query | 59 | cleaning up |
sel
ect UserName, Weight from advertisers where (Display_Zone like "%Top_468%"
OR Di
splay_Zone = "*") |
| 649784 | amdmb | localhost | dotbanner | Query | 69 | cleaning up |
sel
ect UserName, Weight from advertisers where (Display_Zone like "%Top_468%"
OR Di
splay_Zone = "*") |
| 649785 | amdmb | localhost | dotbanner | Query | 4 | Locked |
sel
ect * from advertisers where UserName="Netshelter"
|
| 649786 | amdmb | localhost | dotbanner | Query | 4 | Locked |
sel
ect * from advertisers where UserName="Webconnect"
|
| 649787 | amdmb | localhost | Amdmb | Query | 0 | Sorting result |
SEL
ECT News.NewsID, News.Title, News.Date, News.Author, News.Source, News.Link,
New
s.Information, Ne |
| 649788 | amdmb | localhost | forum | Query | 13 | cleaning up |
SEL
ECT sessionhash,userid,host,useragent,styleid FROM session WHERE
sessionhash='0f
23ebaec1609ae94e2 |
| 649789 | amdmb | localhost | dotbanner | Query | 4 | Locked |
sel
ect * from advertisers where UserName="Webconnect"
|
| 649790 | amdmb | localhost | Amdmb | Init DB | 48 | |
|
| 649791 | amdmb | localhost | dotbanner | Query | 0 | cleaning up |
upd
ate advertisers set Shown="11613611" where UserName="Fastclick"
|
| 649792 | amdmb | localhost | dotbanner | Query | 4 | Locked |
sel
ect UserName, Weight from advertisers where (Display_Zone like "%Top_468%"
OR Di
splay_Zone = "*") |
| 649793 | amdmb | localhost | Amdmb | Query | 67 | |
|
| 649794 | amdmb | localhost | dotbanner | Query | 22 | cleaning up |
sel
ect * from advertisers where UserName="Fastclick"
|
| 649795 | amdmb | localhost | Amdmb | Query | 68 | |
|
| 649796 | amdmb | localhost | | Init DB | 61 | |
|
| 649797 | amdmb | localhost | dotbanner | Query | 0 | Locked |
sel
ect * from advertisers where UserName="Fastclick"
|
| 649798 | amdmb | localhost | dotbanner | Query | 0 | Locked |
sel
ect * from advertisers where UserName="Fastclick"
|
| 649799 | amdmb | localhost | dotbanner | Query | 4 | Locked |
sel
ect * from advertisers where UserName="Netshelter"
|
| 649800 | amdmb | localhost | forum | Query | 36 | cleaning up |
SEL
ECT * FROM thread WHERE forumid <> 15 ORDER BY lastpost DESC LIMIT 10
|
| 649801 | amdmb | localhost | dotbanner | Query | 4 | Locked |
sel
ect * from advertisers where UserName="Fastclick"
|
| 649802 | amdmb | localhost | dotbanner | Query | 22 | cleaning up |
sel
ect * from advertisers where UserName="Fastclick"
|
| 649803 | amdmb | localhost | dotbanner | Query | 0 | Locked |
sel
ect * from advertisers where UserName="Netshelter"
|
| 649805 | amdmb | localhost | forum | Query | 18 | cleaning up |
SEL
ECT sessionhash,userid,host,useragent,styleid FROM session WHERE
sessionhash='86
9ed04d891f9d57215 |
| 649806 | amdmb | localhost | Amdmb | Query | 28 | |
|
| 649807 | amdmb | localhost | Amdmb | Query | 0 | Writing to net |
SEL
ECT News.NewsID, News.Title, News.Date, News.Author, News.Source, News.Link,
New
s.Information, Ne |
| 649808 | amdmb | localhost | | Init DB | 28 | |
|
| 649809 | amdmb | localhost | dotbanner | Sleep | 0 | |
|
| 649810 | amdmb | localhost | dotbanner | Query | 8 | Locked |
sel
ect UserName, Weight from advertisers where (Display_Zone like "%Top_468%"
OR Di
splay_Zone = "*") |
| 649811 | amdmb | localhost | dotbanner | Query | 4 | Locked |
sel
ect * from advertisers where UserName="Netshelter"
|
| 649812 | amdmb | localhost | dotbanner | Query | 22 | cleaning up |
sel
ect * from advertisers where UserName="Fastclick"
|
| 649813 | amdmb | localhost | forum | Query | 4 | |
|
| 649814 | amdmb | localhost | forum | Init DB | 0 | Writing to net |
|
| 649815 | amdmb | localhost | dotbanner | Query | 4 | Locked |
upd
ate advertisers set Shown="11613612" where UserName="Fastclick"
|
| 649816 | amdmb | localhost | dotbanner | Query | 4 | Locked |
sel
ect * from advertisers where UserName="Netshelter"
|
| 649817 | amdmb | localhost | dotbanner | Query | 4 | Locked |
sel
ect * from advertisers where UserName="Webconnect"
|
| 649818 | amdmb | localhost | | Connect | | login |
|
| 649819 | amdmb | localhost | Amdmb | Query | 28 | |
|
| 649820 | amdmb | localhost | forum | Query | 0 | closing tables |
SEL
ECT template FROM template WHERE title='options'
|
| 649821 | amdmb | localhost | | Connect | | login |
|
| 649822 | amdmb | localhost | | Init DB | 22 | |
|
| 649823 | amdmb | localhost | | Connect | | login |
|
| 649824 | root | localhost | | Query | 8 | |
sho
w processlist
|
| 649825 | amdmb | localhost | dotbanner | Query | 4 | Locked |
sel
ect UserName, Weight from advertisers where (Display_Zone like "%Top_468%"
OR Di
splay_Zone = "*") |
| 649826 | amdmb | localhost | Amdmb | Init DB | 5 | cleaning up |
|
| 649827 | amdmb | localhost | Amdmb | Sleep | 0 | |
|
| 649828 | amdmb | localhost | | Init DB | 8 | |
|
| 649829 | amdmb | localhost | | Init DB | 40 | |
|
| 649830 | amdmb | localhost | dotbanner | Query | 4 | Locked |
sel
ect UserName, Weight from advertisers where (Display_Zone like "%Top_468%"
OR Di
splay_Zone = "*") |
| 649831 | amdmb | localhost | dotbanner | Query | 4 | Locked |
sel
ect UserName, Weight from advertisers where (Display_Zone like "%Top_468%"
OR Di
splay_Zone = "*") |
| 649832 | amdmb | localhost | | Connect | | login |
|
| 649833 | amdmb | localhost | | Connect | | login |
|
| 649834 | amdmb | localhost | | Connect | | login |
|
| 649835 | amdmb | localhost | | Init DB | 1 | |
|
| 649836 | amdmb | localhost | | Init DB | 1 | |
|
| 649837 | amdmb | localhost | | Init DB | 0 | |
|
| 649838 | amdmb | localhost | | Connect | | login |
|
| 649839 | amdmb | localhost | | Connect | | login |
|
| 649840 | amdmb | localhost | | Connect | | login |
|
| 649841 | amdmb | localhost | | Connect | | login |
|
| 649842 | amdmb | localhost | | Init DB | 27 | |
|
| 649843 | amdmb | localhost | Amdmb | Query | 0 | cleaning up |
SEL
ECT Articles.ArticleID, Articles.AuthorID, Articles.Date,
Articles.SubjectID, Ar
ticles.Pages, Art |
| 649844 | amdmb | localhost | Amdmb | Query | 27 | |
|
| 649845 | amdmb | localhost | forum | Sleep | 1 | |
|
| 649846 | amdmb | localhost | dotbanner | Query | 4 | Locked |
sel
ect UserName, Weight from advertisers where (Display_Zone like "%Top_468%"
OR Di
splay_Zone = "*") |
| 649847 | amdmb | localhost | | Connect | | login |
|
| 649848 | amdmb | localhost | | Init DB | 22 | |
|
| 649849 | amdmb | localhost | | Connect | | login |
|
| 649850 | amdmb | localhost | | Connect | | login |
|
| 649851 | amdmb | localhost | | Connect | | login |
|
| 649852 | amdmb | localhost | | Init DB | 8 | |
|
| 649853 | amdmb | localhost | Amdmb | Init DB | 5 | cleaning up |
|
| 649854 | amdmb | localhost | | Connect | | login |
|
| 649855 | amdmb | localhost | | Connect | | login |
|
| 649856 | amdmb | localhost | Amdmb | Query | 1 | cleaning up |
SEL
ECT News.NewsID, News.Title, News.Date, News.Author, News.Source, News.Link,
New
s.Information, Ne |
| 649857 | amdmb | localhost | Amdmb | Init DB | 5 | cleaning up |
|
| 649858 | amdmb | localhost | | Init DB | 8 | |
|
| 649859 | amdmb | localhost | | Connect | | login |
|
| 649860 | amdmb | localhost | | Connect | | login |
|
| 649861 | amdmb | localhost | | Connect | | login |
|
| 649862 | amdmb | localhost | | Connect | | login |
|
| 649863 | amdmb | localhost | | Connect | | login |
|
| 649864 | amdmb | localhost | Amdmb | Query | 0 | System lock |
SEL
ECT Pages.PageID, Articles.ArticleID, Pages.PageTitle, Pages.Text
FROM Pages, Articles
WHERE Ar |
+--------+-------+-----------+-----------+---------+------+----------------+
----
----------------------------------------------------------------------------
----
------------------+
[root@dagger /root]#
Ryan Shrout
Owner - Amdmb.com
http://www.amdmb.com/
[EMAIL PROTECTED]
----- Original Message -----
From: "Tonu Samuel" <[EMAIL PROTECTED]>
To: "Ryan Shrout" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, August 11, 2001 3:12 AM
Subject: Re: Mysql causing severe load problems on Dual-Athlon server?
> On 11 Aug 2001 02:08:41 -0400, Ryan Shrout wrote:
> > Below, I have included a copy of the "top" status during one of the
afore mentioned problem times:
> >
> > 3:17pm up 23 min, 1 user, load average: 87.18, 54.78, 24.56
> > 282 processes: 203 sleeping, 79 running, 0 zombie, 0 stopped
> > CPU0 states: 96.14% user, 3.0% system, 0.0% nice, 0.0% idle
> > CPU1 states: 95.5% user, 4.9% system, 0.0% nice, 0.0% idle
> > Mem: 1026964K av, 757988K used, 268976K free, 56K shrd, 8116K
buff
> > Swap: 2048248K av, 0K used, 2048248K free 312316K
cached
> >
> > PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
> > 4784 mysql 18 0 28472 27M 2236 R 15.5 2.7 0:02 mysqld
> > 4944 mysql 18 0 26316 25M 2236 R 7.6 2.5 0:00 mysqld
> > 4940 mysql 19 0 26316 25M 2236 S 7.2 2.5 0:00 mysqld
> > 4942 mysql 17 0 26316 25M 2236 S 7.2 2.5 0:00 mysqld
> > 5049 mysql 19 0 24948 24M 2236 R 3.9 2.4 0:00 mysqld
> > 4810 mysql 20 0 26316 25M 2236 R 3.1 2.5 0:01 mysqld
> > 4808 mysql 20 0 26316 25M 2236 R 3.0 2.5 0:01 mysqld
> > 4806 mysql 17 0 26316 25M 2236 R 2.8 2.5 0:01 mysqld
> > 4727 mysql 20 0 28472 27M 2236 R 2.7 2.7 0:02 mysqld
>
> This is really weird.
>
> 1. You have memory free even while running machine overloaded for 20+
> minutes. This means that MySQL does not run tight on memory. Even more,
> memory is just wasted.
>
> 2. MySQL-s are in status "R" not "D" which also means that they do
> something related to CPU, not IO
>
> 3. Actually you have to allow MySQL allocate more memory like this:
>
> [tonu@x153 tonu]$ cat /etc/my.cnf
> [mysqld]
> set-variable = key_buffer=32M
> set-variable = sort_buffer=1M
> 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 and
some Athlon-VIA chipsets.
>
> --
> For technical support contracts, goto https://order.mysql.com/
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Tonu Samuel <[EMAIL PROTECTED]>
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator
> /_/ /_/\_, /___/\___\_\___/ Hong Kong, China
> <___/ www.mysql.com
>
>
> ---------------------------------------------------------------------
> 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
