[FockerFGAA]

Here are the queries that they said were running when our MySQL load goes to 100%. I can't really tell what is causing the issue because I don't have a clue what all that means, but it is something that isn't good im sure. Any help would be appreciated.

Its your database that is clogging the MySQL server. Here are the current queries:

| 981040 | fvsports_Focker | localhost | fvsports_forum | Query | 102 | Copying to tmp table | SELECT item.item_id, item.item_title, item.threadid, grp.group_title, item.item_status, item.item_cr |
| 981103 | fvsports_Focker | localhost | fvsports_forum | Query | 74 | Locked | UPDATE footballthread SET
lastpost = 1228164584,
lastposter = 'riker7',
| lastpostid = 1225055,
| 981105 | fvsports_Focker | localhost | fvsports_forum | Query | 74 | Locked | SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1227732584 AND open <> 10, 1, 0)) AS newthread
|
| 981106 | fvsports_Focker | localhost | fvsports_forum | Query | 73 | Locked | SELECT IF(visible = 2, 1, 0) AS isdeleted,


threadread.readtime AS threadread, forumread.read |
| 981113 | fvsports_Focker | localhost | fvsports_forum | Query | 67 | Locked | SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1227732590 AND open <> 10, 1, 0)) AS newthread
|
| 981116 | fvsports_Focker | localhost | fvsports_forum | Query | 67 | Locked | SELECT IF(visible = 2, 1, 0) AS isdeleted,


threadread.readtime AS threadread, forumread.read |
| 981121 | fvsports_Focker | localhost | fvsports_forum | Query | 64 | Locked | SELECT IF(visible = 2, 1, 0) AS isdeleted,


threadread.readtime AS threadread, forumread.read |
| 981125 | fvsports_Focker | localhost | fvsports_forum | Query | 62 | Locked | SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1227732596 AND open <> 10, 1, 0)) AS newthread
|
| 981127 | fvsports_Focker | localhost | fvsports_forum | Query | 59 | Locked | SELECT IF(visible = 2, 1, 0) AS isdeleted,


NOT ISNULL(subscribethread.subscribethreadid) AS |
| 981128 | fvsports_Focker | localhost | fvsports_forum | Query | 59 | Locked | SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1227732599 AND open <> 10, 1, 0)) AS newthread
|
| 981137 | fvsports_Focker | localhost | fvsports_forum | Query | 54 | Locked | SELECT IF(visible = 2, 1, 0) AS isdeleted,


threadread.readtime AS threadread, forumread.read |
| 981143 | fvsports_Focker | localhost | fvsports_forum | Query | 51 | Locked | SELECT IF(visible = 2, 1, 0) AS isdeleted,


threadread.readtime AS threadread, forumread.read |
| 981151 | fvsports_Focker | localhost | fvsports_forum | Query | 43 | Locked | SELECT IF(visible = 2, 1, 0) AS isdeleted,


NOT ISNULL(subscribethread.subscribethreadid) AS |
| 981152 | fvsports_Focker | localhost | fvsports_forum | Query | 42 | Locked | SELECT IF(visible = 2, 1, 0) AS isdeleted,



thread.*


FROM footballthread AS th |
| 981158 | fvsports_Focker | localhost | fvsports_forum | Query | 37 | Locked | SELECT
reputation.whoadded, reputation.postid, reputation.reputation, reputation.reason, reputati |
| 981167 | fvsports_Focker | localhost | fvsports_forum | Query | 33 | Locked | SELECT *, thread.title AS threadtitle
FROM footballrsslog AS rsslog
INNER JOIN footballrssfeed AS |
| 981178 | fvsports_Focker | localhost | fvsports_forum | Query | 30 | Locked | SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1227732628 AND open <> 10, 1, 0)) AS newthread
|
| 981185 | fvsports_Focker | localhost | fvsports_forum | Query | 25 | Locked | UPDATE footballuser
SET lastactivity = 1228164632
WHERE userid = 733 |
| 981208 | fvsports_Focker | localhost | fvsports_forum | Query | 13 | Locked | SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user. |
| 981231 | fvsports_Focker | localhost | fvsports_forum | Query | 3 | Locked | SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user. |
| 981234 | fvsports_Focker | localhost | fvsports_forum | Query | 1 | Locked | SELECT
user.username, (user.options & 512) AS invisible, user.usergroupid,