This just happened a second time today... that is the most frequent yet.
Please, you have got to help me on this!
Ryan Shrout
Owner - Amdmb.com
http://www.amdmb.com/
[EMAIL PROTECTED]
----- Original Message -----
From: "Ryan Shrout" <[EMAIL PROTECTED]>
To: "Tonu Samuel" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, August 14, 2001 11:21 AM
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
|
> 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
>
---------------------------------------------------------------------
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
