CONTINUED FROM PART #1
While this happens, I was able to do a "mysqladmin processlist" command and here is
the result:
[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"
|
| 649824 | root | localhost | | Query | 8 | |
sho
w processlist
|
...... more and more
This is obviously VERY much too long, but I can't seem to figure out what is going on.
I am in dire need of help here!! I once thought that the kernel was the problem, but
I upgraded that and the problem returned. I upgraded MySQL and still the problem
returned. I upgraded the hard drive bandwidth (MB/sec) thinking that might improve
it, but nothing I have tried keeps the problem away for more than a day.
If you need any more information from me (including database table formats, queries,
etc) please let me know! I will be more than happy to give them to you!!
Thanks to anyone who helps me out!!!
Ryan Shrout
Owner - Amdmb.com
http://www.amdmb.com/
[EMAIL PROTECTED]
