Need assistance with random mysql db problem

محروم.كوم · #1 07-21-2009, 09:50 AM

Hello Everyone -

Looking for some assistance with a random DB problem Im having. I opened a support ticket but they suggested I open a thread here.

Every few days, my site goes unresponsive, and can be tracked back to all queries in the mysql process list showing as locked. Ive included the mysql processlist output from the most recent outage below. Ive noticed over the last 6 or 7 instances a commonality in that all Queries go into Locked state, except for a single Query that is still "Sending". The query in question is "SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247835044 AND open 10, 1, 0)) AS newthread\n". The bold numbers are not always identical, but its this query that continues to run while everything else is humped.

example of processes during instance.
Quote:
SERVER# cat processes7-17-2009.txt
Id User Host db Command Time State Info
15663 username 10.10.10.10:54075 dbname Query 338 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15666 username 10.10.10.10:54120 dbname Query 339 Sending data SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247835044 AND open 10, 1, 0)) AS newthread\n
15672 username 10.10.10.10:54201 dbname Sleep 352 NULL
15677 username 10.10.10.10:54213 dbname Sleep 339 NULL
15678 username 10.10.10.10:54220 dbname Query 339 Locked UPDATE thread SET firstpostid = 7120165, lastpostid = 7120165 WHERE threadid = 627910
15683 username 10.10.10.10:54286 dbname Sleep 341 NULL
15684 username 10.10.10.10:54287 dbname Query 336 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15686 username 10.10.10.10:54333 dbname Query 333 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15687 username 10.10.10.10:54351 dbname Sleep 362 NULL
15688 username 10.10.10.10:54354 dbname Query 337 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15691 username 10.10.10.10:54378 dbname Sleep 365 NULL
15692 username 10.10.10.10:54398 dbname Query 338 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247809098 AND open 10, 1, 0)) AS newthread\n
15694 username 10.10.10.10:54403 dbname Sleep 344 NULL
15695 username 10.10.10.10:54404 dbname Query 338 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15696 username 10.10.10.10:54411 dbname Query 333 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\t\n\t\t\tthread.*\n\t\t \t\n\t\t\tFROM thread AS thread\n\t\t\t\n\t\t\t
15700 username 10.10.10.10:54490 dbname Sleep 341 NULL
15708 username 10.10.10.10:54581 dbname Sleep 338 NULL
15709 username 10.10.10.10:54584 dbname Query 336 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15711 username 10.10.10.10:54630 dbname Sleep 340 NULL
15712 username 10.10.10.10:54631 dbname Query 339 Locked SELECT thread.threadid, lastpost, open\n\t\t\tFROM thread AS thread\n\t\t\tWHERE forumid = 18\n\t\t\t\tAND sticky
15716 username 10.10.10.10:54648 dbname Query 335 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247811280 AND open 10, 1, 0)) AS newthread\n
15718 username 10.10.10.10:54655 dbname Sleep 338 NULL
15719 username 10.10.10.10:54658 dbname Sleep 354 NULL
15722 username 10.10.10.10:54697 dbname Query 338 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247869663 AND open 10, 1, 0)) AS newthread\n
15723 username 10.10.10.10:54705 dbname Sleep 347 NULL
15724 username 10.10.10.10:54719 dbname Sleep 335 NULL
15728 username 10.10.10.10:54806 dbname Query 338 Locked SELECT threadid AS itemid, forumid, visible AS thread_visible, postuserid,\n\t\t\tIF(postuserid = 3337,
15730 username 10.10.10.10:54888 dbname Query 339 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15733 username 10.10.10.10:54917 dbname Sleep 339 NULL
15734 username 10.10.10.10:54922 dbname Sleep 363 NULL
15735 username 10.10.10.10:54923 dbname Query 337 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15737 username 10.10.10.10:55006 dbname Query 336 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15738 username 10.10.10.10:55034 dbname Sleep 361 NULL
15739 username 10.10.10.10:55041 dbname Query 334 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15740 username 10.10.10.10:55043 dbname Sleep 339 NULL
15741 username 10.10.10.10:55045 dbname Query 339 Locked SELECT thread.threadid, lastpost, open\n\t\t\tFROM thread AS thread\n\t\t\tWHERE forumid = 11\n\t\t\t\tAND sticky
15742 username 10.10.10.10:55053 dbname Query 338 Locked SELECT thread.threadid\n\t\t\tFROM thread AS thread\n\t\t\t\n\t\t\tWHERE thread.forumid IN(1, 2, 19, 4, 5, 10, 6
15743 username 10.10.10.10:55070 dbname Sleep 357 NULL
15744 username 10.10.10.10:55185 dbname Query 337 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15745 username 10.10.10.10:55215 dbname Query 336 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15746 username 10.10.10.10:55217 dbname Query 336 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15747 username 10.10.10.10:55221 dbname Sleep 335 NULL
15748 username 10.10.10.10:55223 dbname Query 335 Locked SELECT\n\t\t\t\t\t\tthread.threadid, thread.forumid, post.userid\n\t\t\t\t\t\tFROM thread AS thread \n\t\t\t\t\t\tINNER J
15749 username 10.10.10.10:55225 dbname Query 327 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247869663 AND open 10, 1, 0)) AS newthread\n
15750 username 10.10.10.10:55228 dbname Query 331 Locked SELECT thread.threadid\n\t\t\tFROM thread AS thread\n\t\t\t\n\t\t\tWHERE thread.forumid IN(1, 2, 19, 4, 5, 10, 6
15751 username 10.10.10.10:55230 dbname Query 334 Locked SELECT thread.threadid\n\t\t\tFROM thread AS thread\n\t\t\t\n\t\t\tWHERE thread.forumid IN(1, 2, 19, 4, 5, 10, 6
15752 username 10.10.10.10:55231 dbname Query 334 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247869146 AND open 10, 1, 0)) AS newthread\n
15753 username 10.10.10.10:55232 dbname Sleep 334 NULL
15754 username 10.10.10.10:55233 dbname Query 330 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15755 username 10.10.10.10:55236 dbname Sleep 334 NULL
15756 username 10.10.10.10:55237 dbname Query 334 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15757 username 10.10.10.10:55240 dbname Query 334 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247867093 AND open 10, 1, 0)) AS newthread\n
15758 username 10.10.10.10:55241 dbname Query 334 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247867980 AND open 10, 1, 0)) AS newthread\n
15759 username 10.10.10.10:55244 dbname Query 327 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247869146 AND open 10, 1, 0)) AS newthread\n
15760 username 10.10.10.10:55248 dbname Sleep 334 NULL
15761 username 10.10.10.10:55249 dbname Query 334 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15762 username 10.10.10.10:55252 dbname Sleep 334 NULL
15763 username 10.10.10.10:55253 dbname Query 334 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15764 username 10.10.10.10:55255 dbname Query 334 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247869663 AND open 10, 1, 0)) AS newthread\n
15765 username 10.10.10.10:55258 dbname Sleep 333 NULL
15766 username 10.10.10.10:55259 dbname Query 331 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15767 username 10.10.10.10:55260 dbname Query 331 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15768 username 10.10.10.10:55261 dbname Query 333 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15769 username 10.10.10.10:55265 dbname Query 333 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247870731 AND open 10, 1, 0)) AS newthread\n
15770 username 10.10.10.10:55267 dbname Query 332 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15771 username 10.10.10.10:55274 dbname Query 333 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15772 username 10.10.10.10:55279 dbname Query 333 Locked SELECT thread.*\n\t\tFROM thread AS thread\n\t\tWHERE thread.pollid = 5859\n\t\t\tAND open 10
15773 username 10.10.10.10:55282 dbname Query 332 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15774 username 10.10.10.10:55284 dbname Query 327 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15775 username 10.10.10.10:55288 dbname Query 326 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15776 username 10.10.10.10:55290 dbname Query 331 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15777 username 10.10.10.10:55292 dbname Sleep 331 NULL
15778 username 10.10.10.10:55296 dbname Query 328 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247866424 AND open 10, 1, 0)) AS newthread\n
15779 username 10.10.10.10:55298 dbname Query 331 Locked SELECT threadid AS itemid, forumid, visible AS thread_visible, postuserid,\n\t\t\tIF(postuserid = 3337,
15780 username 10.10.10.10:55314 dbname Query 329 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247869097 AND open 10, 1, 0)) AS newthread\n
15781 username 10.10.10.10:55317 dbname Query 329 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15782 username 10.10.10.10:55319 dbname Sleep 329 NULL
15783 username 10.10.10.10:55322 dbname Query 329 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15784 username 10.10.10.10:55324 dbname Query 328 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15785 username 10.10.10.10:55326 dbname Sleep 328 NULL
15786 username 10.10.10.10:55329 dbname Query 328 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15787 username 10.10.10.10:55331 dbname Query 328 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15788 username 10.10.10.10:55333 dbname Sleep 327 NULL
15789 username 10.10.10.10:55335 dbname Query 327 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15790 username 10.10.10.10:55338 dbname Sleep 327 NULL
15791 username 10.10.10.10:55340 dbname Query 327 Locked SELECT thread.threadid\n\t\t\tFROM thread AS thread\n\t\t\t\n\t\t\tWHERE thread.forumid IN(1, 2, 19, 4, 5, 10, 6
15792 username 10.10.10.10:55343 dbname Query 327 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15793 username 10.10.10.10:55346 dbname Sleep 326 NULL
15794 username 10.10.10.10:55347 dbname Query 324 Locked SELECT threadid AS itemid, forumid, visible AS thread_visible, postuserid,\n\t\t\tIF(postuserid = 23859,
15795 username 10.10.10.10:55349 dbname Sleep 326 NULL
15796 username 10.10.10.10:55350 dbname Query 326 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247872453 AND open 10, 1, 0)) AS newthread\n
15797 username 10.10.10.10:55352 dbname Query 326 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15798 username 10.10.10.10:55354 dbname Query 326 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15799 username 10.10.10.10:55356 dbname Query 326 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15800 username 10.10.10.10:55358 dbname Sleep 325 NULL
15801 username 10.10.10.10:55359 dbname Sleep 325 NULL
15802 username 10.10.10.10:55360 dbname Query 325 Locked select t.forumid, t.threadid, t.title, t.replycount, t.lastposter, lastpostid, lastpost, visible\nfro
15803 username 10.10.10.10:55362 dbname Query 325 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247858847 AND open 10, 1, 0)) AS newthread\n
15804 username 10.10.10.10:55364 dbname Query 325 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247866587 AND open 10, 1, 0)) AS newthread\n
15805 username 10.10.10.10:55366 dbname Query 322 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15806 username 10.10.10.10:55368 dbname Query 325 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15807 username 10.10.10.10:55370 dbname Query 325 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15808 username 10.10.10.10:55372 dbname Sleep 325 NULL
15809 username 10.10.10.10:55373 dbname Query 321 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15810 username 10.10.10.10:55376 dbname Sleep 324 NULL
15811 username 10.10.10.10:55377 dbname Query 324 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247867093 AND open 10, 1, 0)) AS newthread\n
15812 username 10.10.10.10:55379 dbname Query 321 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15813 username 10.10.10.10:55382 dbname Query 322 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247862982 AND open 10, 1, 0)) AS newthread\n
15814 username 10.10.10.10:55384 dbname Query 324 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15815 username 10.10.10.10:55386 dbname Query 323 Locked SELECT thread.threadid\n\t\t\tFROM thread AS thread\n\t\t\t\n\t\t\tWHERE thread.forumid IN(1, 2, 19, 4, 5, 10, 6
15816 username 10.10.10.10:55388 dbname Query 322 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15817 username 10.10.10.10:55390 dbname Query 323 Locked SELECT COUNT(*) AS total, folderid\n\t\t FROM subscribethread AS subscribethread\n\t\t LEFT
15818 username 10.10.10.10:55393 dbname Query 321 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15819 username 10.10.10.10:55395 dbname Query 320 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247809098 AND open 10, 1, 0)) AS newthread\n
15820 username 10.10.10.10:55397 dbname Sleep 323 NULL
15821 username 10.10.10.10:55398 dbname Query 323 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247866541 AND open 10, 1, 0)) AS newthread\n
15822 username 10.10.10.10:55400 dbname Query 323 Locked SELECT thread.threadid\n\t\t\tFROM thread AS thread\n\t\t\t\n\t\t\tWHERE thread.forumid IN(1, 2, 19, 4, 5, 10, 6
15823 username 10.10.10.10:55402 dbname Query 321 Locked SELECT thread.threadid, thread.forumid, thread.postuserid, subscribethread.subscribethreadid\n\t\t\n\t\tFR
15824 username 10.10.10.10:55409 dbname Query 322 Locked SELECT threadid AS itemid, forumid, visible AS thread_visible, postuserid,\n\t\t\tIF(postuserid = 6053,
15825 username 10.10.10.10:55411 dbname Query 322 Locked SELECT threadid AS itemid, forumid, visible AS thread_visible, postuserid,\n\t\t\tIF(postuserid = 2348,
15826 username 10.10.10.10:55414 dbname Query 322 Locked SELECT threadid AS itemid, forumid, visible AS thread_visible, postuserid,\n\t\t\tIF(postuserid = 2348,
15827 username 10.10.10.10:55416 dbname Sleep 322 NULL
15828 username 10.10.10.10:55419 dbname Query 322 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15829 username 10.10.10.10:55426 dbname Sleep 321 NULL
15830 username 10.10.10.10:55427 dbname Query 321 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247868666 AND open 10, 1, 0)) AS newthread\n
15831 username 10.10.10.10:55429 dbname Sleep 320 NULL
15832 username 10.10.10.10:55431 dbname Sleep 320 NULL
15833 username 10.10.10.10:55432 dbname Query 320 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15834 username 10.10.10.10:55434 dbname Query 320 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247794868 AND open 10, 1, 0)) AS newthread\n
15835 username 10.10.10.10:55437 dbname Query 312 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247875832 AND open 10, 1, 0)) AS newthread\n
15836 username 10.10.10.10:55438 dbname Query 318 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15837 username 10.10.10.10:55439 dbname Query 319 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15838 username 10.10.10.10:55440 dbname Query 319 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15839 username 10.10.10.10:55446 dbname Sleep 318 NULL
15840 username 10.10.10.10:55447 dbname Query 318 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15841 username 10.10.10.10:55448 dbname Sleep 318 NULL
15842 username 10.10.10.10:55449 dbname Query 318 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15843 username 10.10.10.10:55450 dbname Query 318 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15844 username 10.10.10.10:55451 dbname Sleep 312 NULL
15845 username 10.10.10.10:55452 dbname Sleep 318 NULL
15846 username 10.10.10.10:55454 dbname Query 318 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15847 username 10.10.10.10:55458 dbname Query 318 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247865969 AND open 10, 1, 0)) AS newthread\n
15848 username 10.10.10.10:55459 dbname Query 318 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247862053 AND open 10, 1, 0)) AS newthread\n
15849 username 10.10.10.10:55462 dbname Query 318 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247859324 AND open 10, 1, 0)) AS newthread\n
15850 username 10.10.10.10:55464 dbname Query 312 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247860301 AND open 10, 1, 0)) AS newthread\n
15851 username 10.10.10.10:55466 dbname Sleep 317 NULL
15852 username 10.10.10.10:55467 dbname Query 316 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15853 username 10.10.10.10:55468 dbname Sleep 317 NULL
15854 username 10.10.10.10:55469 dbname Query 317 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15855 username 10.10.10.10:55470 dbname Sleep 317 NULL
15856 username 10.10.10.10:55472 dbname Query 313 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247869295 AND open 10, 1, 0)) AS newthread\n
15857 username 10.10.10.10:55473 dbname Query 317 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15858 username 10.10.10.10:55474 dbname Query 317 Locked SELECT thread.threadid\n\t\t\tFROM thread AS thread\n\t\t\t\n\t\t\tWHERE thread.forumid IN(1, 2, 19, 4, 5, 10, 6
15859 username 10.10.10.10:55479 dbname Query 317 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15860 username 10.10.10.10:55480 dbname Query 309 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15861 username 10.10.10.10:55481 dbname Query 317 Locked SELECT thread.threadid\n\t\t\tFROM thread AS thread\n\t\t\t\n\t\t\tWHERE thread.forumid IN(1, 2, 19, 4, 5, 10, 6
15862 username 10.10.10.10:55485 dbname Query 316 Locked SELECT threadid AS itemid, forumid, visible AS thread_visible, postuserid,\n\t\t\tIF(postuserid = 13523,
15863 username 10.10.10.10:55486 dbname Query 317 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247853225 AND open 10, 1, 0)) AS newthread\n
15864 username 10.10.10.10:55490 dbname Query 317 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247867261 AND open 10, 1, 0)) AS newthread\n
15865 username 10.10.10.10:55491 dbname Query 317 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247869146 AND open 10, 1, 0)) AS newthread\n
15866 username 10.10.10.10:55494 dbname Sleep 317 NULL
15867 username 10.10.10.10:55495 dbname Query 317 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247864714 AND open 10, 1, 0)) AS newthread\n
15868 username 10.10.10.10:55497 dbname Query 316 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247867093 AND open 10, 1, 0)) AS newthread\n
15869 username 10.10.10.10:55499 dbname Query 317 Locked SELECT thread.threadid, thread.forumid, thread.postuserid, subscribethread.subscribethreadid\n\t\t\n\t\tFR
15870 username 10.10.10.10:55500 dbname Sleep 317 NULL
15871 username 10.10.10.10:55502 dbname Query 317 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247866587 AND open 10, 1, 0)) AS newthread\n
15872 username 10.10.10.10:55506 dbname Sleep 316 NULL
15873 username 10.10.10.10:55509 dbname Sleep 316 NULL
15875 username 10.10.10.10:55512 dbname Query 312 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15876 username 10.10.10.10:55514 dbname Sleep 316 NULL
15877 username 10.10.10.10:55515 dbname Query 316 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247872453 AND open 10, 1, 0)) AS newthread\n
15878 username 10.10.10.10:55517 dbname Query 316 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15879 username 10.10.10.10:55520 dbname Query 315 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15880 username 10.10.10.10:55522 dbname Query 311 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15881 username 10.10.10.10:55524 dbname Query 312 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15882 username 10.10.10.10:55526 dbname Sleep 315 NULL
15883 username 10.10.10.10:55527 dbname Query 315 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247861721 AND open 10, 1, 0)) AS newthread\n
15884 username 10.10.10.10:55529 dbname Query 314 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15885 username 10.10.10.10:55531 dbname Sleep 314 NULL
15886 username 10.10.10.10:55533 dbname Sleep 314 NULL
15887 username 10.10.10.10:55534 dbname Query 314 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247866495 AND open 10, 1, 0)) AS newthread\n
15888 username 10.10.10.10:55536 dbname Query 314 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247847800 AND open 10, 1, 0)) AS newthread\n
15889 username 10.10.10.10:55538 dbname Query 314 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15890 username 10.10.10.10:55540 dbname Query 314 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15891 username 10.10.10.10:55542 dbname Sleep 313 NULL
15892 username 10.10.10.10:55545 dbname Query 313 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15893 username 10.10.10.10:55547 dbname Query 313 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15894 username 10.10.10.10:55549 dbname Sleep 312 NULL
15895 username 10.10.10.10:55553 dbname Query 310 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15896 username 10.10.10.10:55558 dbname Query 311 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15897 username 10.10.10.10:55560 dbname Query 306 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15898 username 10.10.10.10:55562 dbname Sleep 312 NULL
15899 username 10.10.10.10:55563 dbname Query 312 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247866424 AND open 10, 1, 0)) AS newthread\n
15900 username 10.10.10.10:55565 dbname Query 312 Locked SELECT thread.threadid, thread.forumid, thread.postuserid, subscribethread.subscribethreadid\n\t\t\n\t\tFR

15901 username 10.10.10.10:55567 dbname Query 311 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15902 username 10.10.10.10:55569 dbname Query 311 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15903 username 10.10.10.10:55573 dbname Query 310 Locked SELECT\n\t\t\t\t\t\tthread.threadid, thread.forumid, post.userid\n\t\t\t\t\t\tFROM thread AS thread \n\t\t\t\t\t\tINNER J
15904 username 10.10.10.10:55575 dbname Sleep 309 NULL
15905 username 10.10.10.10:55577 dbname Sleep 310 NULL
15906 username 10.10.10.10:55578 dbname Query 310 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247846597 AND open 10, 1, 0)) AS newthread\n
15907 username 10.10.10.10:55580 dbname Query 310 Locked SELECT thread.threadid, thread.forumid, thread.postuserid, subscribethread.subscribethreadid\n\t\t\n\t\tFR
15908 username 10.10.10.10:55582 dbname Query 310 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15909 username 10.10.10.10:55585 dbname Query 309 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15910 username 10.10.10.10:55588 dbname Query 309 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247841124 AND open 10, 1, 0)) AS newthread\n
15911 username 10.10.10.10:55590 dbname Sleep 309 NULL
15912 username 10.10.10.10:55591 dbname Query 309 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247863552 AND open 10, 1, 0)) AS newthread\n
15913 username 10.10.10.10:55593 dbname Query 309 Locked SELECT thread.threadid\n\t\t\tFROM thread AS thread\n\t\t\t\n\t\t\tWHERE thread.forumid IN(1, 2, 19, 4, 5, 10, 6
15914 username 10.10.10.10:55595 dbname Sleep 308 NULL
15915 username 10.10.10.10:55596 dbname Query 308 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247865874 AND open 10, 1, 0)) AS newthread\n
15916 username 10.10.10.10:55603 dbname Sleep 307 NULL
15917 username 10.10.10.10:55604 dbname Query 307 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15918 username 10.10.10.10:55605 dbname Query 307 Locked SELECT thread.threadid\n\t\t\tFROM thread AS thread\n\t\t\t\n\t\t\tWHERE thread.forumid IN(1, 2, 19, 4, 5, 10, 6
15919 username 10.10.10.10:55606 dbname Query 307 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15920 username 10.10.10.10:55609 dbname Query 307 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247869340 AND open 10, 1, 0)) AS newthread\n
15921 username 10.10.10.10:55613 dbname Sleep 306 NULL
15922 username 10.10.10.10:55614 dbname Sleep 306 NULL
15923 username 10.10.10.10:55615 dbname Query 306 Locked SELECT thread.threadid\n\t\t\tFROM thread AS thread\n\t\t\t\n\t\t\tWHERE thread.forumid IN(1, 2, 19, 4, 5, 10, 6
15924 username 10.10.10.10:55616 dbname Sleep 306 NULL
15925 username 10.10.10.10:55617 dbname Query 306 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15926 username 10.10.10.10:55618 dbname Query 306 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15927 username 10.10.10.10:55620 dbname Query 306 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\t\n\t\t\tthread.*\n\t\t \t\n\t\t\tFROM thread AS thread\n\t\t\t\n\t\t\t
15928 username 10.10.10.10:55621 dbname Query 306 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247864536 AND open 10, 1, 0)) AS newthread\n
15929 username 10.10.10.10:55626 dbname Query 306 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247869146 AND open 10, 1, 0)) AS newthread\n
15930 username 10.10.10.10:55627 dbname Query 306 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247865383 AND open 10, 1, 0)) AS newthread\n
15931 username 10.10.10.10:55630 dbname Sleep 306 NULL
15932 username 10.10.10.10:55631 dbname Query 306 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247864728 AND open 10, 1, 0)) AS newthread\n
15933 username 10.10.10.10:55633 dbname Sleep 305 NULL
15934 username 10.10.10.10:55634 dbname Sleep 305 NULL
15935 username 10.10.10.10:55635 dbname Sleep 305 NULL
15936 username 10.10.10.10:55636 dbname Query 305 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS

15937 username 10.10.10.10:55638 dbname Query 305 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15938 username 10.10.10.10:55639 dbname Query 305 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15939 username 10.10.10.10:55640 dbname Query 305 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15940 username 10.10.10.10:55641 dbname Query 305 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15941 username 10.10.10.10:55642 dbname Query 305 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15942 username 10.10.10.10:55643 dbname Query 300 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247871348 AND open 10, 1, 0)) AS newthread\n
15943 username 10.10.10.10:55647 dbname Query 305 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247866587 AND open 10, 1, 0)) AS newthread\n
15944 username 10.10.10.10:55652 dbname Query 305 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247862982 AND open 10, 1, 0)) AS newthread\n
15945 username 10.10.10.10:55653 dbname Query 305 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247861721 AND open 10, 1, 0)) AS newthread\n
15946 username 10.10.10.10:55656 dbname Query 305 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15947 username 10.10.10.10:55658 dbname Query 304 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247871139 AND open 10, 1, 0)) AS newthread\n
15948 username 10.10.10.10:55660 dbname Query 305 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15949 username 10.10.10.10:55662 dbname Sleep 304 NULL
15950 username 10.10.10.10:55663 dbname Query 305 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15951 username 10.10.10.10:55665 dbname Sleep 305 NULL
15952 username 10.10.10.10:55666 dbname Query 305 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247872741 AND open 10, 1, 0)) AS newthread\n
15953 username 10.10.10.10:55668 dbname Query 304 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247872453 AND open 10, 1, 0)) AS newthread\n
15954 username 10.10.10.10:55670 dbname Sleep 304 NULL
15955 username 10.10.10.10:55672 dbname Query 304 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15956 username 10.10.10.10:55674 dbname Query 300 Locked SELECT thread.threadid\n\t\t\tFROM thread AS thread\n\t\t\t\n\t\t\tWHERE thread.forumid IN(1, 2, 19, 4, 5, 10, 6
15957 username 10.10.10.10:55676 dbname Query 304 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15958 username 10.10.10.10:55678 dbname Query 300 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15959 username 10.10.10.10:55680 dbname Query 303 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15960 username 10.10.10.10:55682 dbname Query 303 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15961 username 10.10.10.10:55685 dbname Query 303 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15962 username 10.10.10.10:55687 dbname Query 303 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15963 username 10.10.10.10:55689 dbname Query 302 Locked INSERT INTO thread^M\n\t(postusername, postuserid, title, iconid, visible, forumid, dateline, open, att
15964 username 10.10.10.10:55691 dbname Query 303 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15965 username 10.10.10.10:55693 dbname Sleep 303 NULL
15966 username 10.10.10.10:55694 dbname Query 303 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247854907 AND open 10, 1, 0)) AS newthread\n
15967 username 10.10.10.10:55698 dbname Query 302 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15968 username 10.10.10.10:55701 dbname Query 302 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15969 username 10.10.10.10:55703 dbname Query 302 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15970 username 10.10.10.10:55705 dbname Sleep 302 NULL
15971 username 10.10.10.10:55706 dbname Query 302 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15972 username 10.10.10.10:55708 dbname Query 302 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15973 username 10.10.10.10:55710 dbname Query 302 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247865969 AND open 10, 1, 0)) AS newthread\n
15974 username 10.10.10.10:55712 dbname Query 301 Locked SELECT threadid AS itemid, forumid, visible AS thread_visible, postuserid,\n\t\t\tIF(postuserid = 6053,
15975 username 10.10.10.10:55714 dbname Sleep 301 NULL
15976 username 10.10.10.10:55715 dbname Query 301 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247869295 AND open 10, 1, 0)) AS newthread\n
15977 username 10.10.10.10:55718 dbname Query 300 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15978 username 10.10.10.10:55720 dbname Query 300 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15979 username 10.10.10.10:55722 dbname Query 301 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15980 username 10.10.10.10:55724 dbname Query 301 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15981 username 10.10.10.10:55725 dbname Query 301 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\t\n\t\t\tthread.*\n\t\t \t\n\t\t\tFROM thread AS thread\n\t\t\t\n\t\t\t
15982 username 10.10.10.10:55728 dbname Sleep 301 NULL
15983 username 10.10.10.10:55729 dbname Query 300 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15984 username 10.10.10.10:55731 dbname Query 301 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247870549 AND open 10, 1, 0)) AS newthread\n
15985 username 10.10.10.10:55735 dbname Sleep 300 NULL
15986 username 10.10.10.10:55737 dbname Query 300 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15987 username 10.10.10.10:55739 dbname Query 300 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15988 username 10.10.10.10:55741 dbname Sleep 300 NULL
15989 username 10.10.10.10:55743 dbname Sleep 300 NULL
15990 username 10.10.10.10:55744 dbname Query 300 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247865751 AND open 10, 1, 0)) AS newthread\n
15991 username 10.10.10.10:55746 dbname Sleep 300 NULL
15992 username 10.10.10.10:55747 dbname Query 300 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247866424 AND open 10, 1, 0)) AS newthread\n
15993 username 10.10.10.10:55753 dbname Query 299 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15994 username 10.10.10.10:55755 dbname Query 299 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15995 username 10.10.10.10:55757 dbname Sleep 298 NULL
15996 username 10.10.10.10:55758 dbname Query 298 Locked SELECT thread.threadid, thread.forumid, thread.postuserid, subscribethread.subscribethreadid\n\t\t\n\t\tFR
15997 username 10.10.10.10:55759 dbname Query 298 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
15998 username 10.10.10.10:55762 dbname Query 298 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247835044 AND open 10, 1, 0)) AS newthread\n
15999 username 10.10.10.10:55764 dbname Query 298 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
16000 username 10.10.10.10:55766 dbname Sleep 297 NULL
16001 username 10.10.10.10:55767 dbname Sleep 297 NULL
16002 username 10.10.10.10:55768 dbname Query 297 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
16003 username 10.10.10.10:55769 dbname Query 297 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\t\n\t\t\tthread.*\n\t\t \t\n\t\t\tFROM thread AS thread\n\t\t\t\n\t\t\t
16004 username 10.10.10.10:55772 dbname Query 295 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
16005 username 10.10.10.10:55774 dbname Sleep 297 NULL
16006 username 10.10.10.10:55775 dbname Sleep 297 NULL
16007 username 10.10.10.10:55776 dbname Query 296 Locked SELECT thread.threadid, thread.forumid, thread.postuserid, subscribethread.subscribethreadid\n\t\t\n\t\tFR
16008 username 10.10.10.10:55777 dbname Sleep 297 NULL
16009 username 10.10.10.10:55779 dbname Query 297 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247866587 AND open 10, 1, 0)) AS newthread\n
16010 username 10.10.10.10:55780 dbname Query 297 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247854907 AND open 10, 1, 0)) AS newthread\n
16011 username 10.10.10.10:55783 dbname Query 297 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247835360 AND open 10, 1, 0)) AS newthread\n
16012 username 10.10.10.10:55785 dbname Query 297 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247864714 AND open 10, 1, 0)) AS newthread\n
16013 username 10.10.10.10:55791 dbname Sleep 296 NULL
16014 username 10.10.10.10:55792 dbname Sleep 296 NULL
16015 username 10.10.10.10:55793 dbname Sleep 296 NULL
16016 username 10.10.10.10:55794 dbname Sleep 296 NULL
16017 username 10.10.10.10:55795 dbname Query 296 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
16018 username 10.10.10.10:55796 dbname Query 296 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
16019 username 10.10.10.10:55797 dbname Query 296 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247872453 AND open 10, 1, 0)) AS newthread\n
16020 username 10.10.10.10:55800 dbname Query 296 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247866587 AND open 10, 1, 0)) AS newthread\n
16021 username 10.10.10.10:55802 dbname Query 296 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247870811 AND open 10, 1, 0)) AS newthread\n
16022 username 10.10.10.10:55803 dbname Query 296 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247866587 AND open 10, 1, 0)) AS newthread\n
16023 username 10.10.10.10:55807 dbname Query 293 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247866091 AND open 10, 1, 0)) AS newthread\n
16024 username 10.10.10.10:55809 dbname Sleep 296 NULL
16025 username 10.10.10.10:55810 dbname Query 295 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247869146 AND open 10, 1, 0)) AS newthread\n
16026 username 10.10.10.10:55812 dbname Query 295 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
16027 username 10.10.10.10:55814 dbname Query 295 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
16028 username 10.10.10.10:55817 dbname Query 291 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
16029 username 10.10.10.10:55819 dbname Query 292 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247866587 AND open 10, 1, 0)) AS newthread\n
16030 username 10.10.10.10:55821 dbname Query 295 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
16031 username 10.10.10.10:55823 dbname Sleep 295 NULL
16032 username 10.10.10.10:55824 dbname Query 294 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247862982 AND open 10, 1, 0)) AS newthread\n
16033 username 10.10.10.10:55826 dbname Sleep 294 NULL
16034 username 10.10.10.10:55827 dbname Query 294 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247533342 AND open 10, 1, 0)) AS newthread\n
16035 username 10.10.10.10:55829 dbname Query 294 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
16036 username 10.10.10.10:55831 dbname Query 294 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
16037 username 10.10.10.10:55833 dbname Sleep 294 NULL
16038 username 10.10.10.10:55835 dbname Query 294 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247866603 AND open 10, 1, 0)) AS newthread\n
16039 username 10.10.10.10:55837 dbname Sleep 294 NULL
16040 username 10.10.10.10:55838 dbname Query 294 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247862954 AND open 10, 1, 0)) AS newthread\n
16041 username 10.10.10.10:55840 dbname Query 294 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
16042 username 10.10.10.10:55842 dbname Sleep 293 NULL
16043 username 10.10.10.10:55843 dbname Query 293 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247798102 AND open 10, 1, 0)) AS newthread\n
16044 username 10.10.10.10:55845 dbname Query 290 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
16045 username 10.10.10.10:55847 dbname Query 292 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
16046 username 10.10.10.10:55850 dbname Query 293 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
16047 username 10.10.10.10:55852 dbname Sleep 293 NULL
16048 username 10.10.10.10:55853 dbname Query 293 Locked SELECT thread.threadid, thread.forumid, thread.postuserid, subscribethread.subscribethreadid\n\t\t\n\t\tFR
16049 username 10.10.10.10:55856 dbname Sleep 293 NULL
16050 username 10.10.10.10:55857 dbname Query 293 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247864536 AND open 10, 1, 0)) AS newthread\n
16051 username 10.10.10.10:55859 dbname Query 293 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
16052 username 10.10.10.10:55861 dbname Sleep 293 NULL
16053 username 10.10.10.10:55863 dbname Query 292 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
16054 username 10.10.10.10:55865 dbname Sleep 292 NULL
16055 username 10.10.10.10:55866 dbname Query 292 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247869430 AND open 10, 1, 0)) AS newthread\n
16056 username 10.10.10.10:55868 dbname Sleep 292 NULL
16057 username 10.10.10.10:55869 dbname Query 292 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247866587 AND open 10, 1, 0)) AS newthread\n
16058 username 10.10.10.10:55872 dbname Query 291 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
16059 username 10.10.10.10:55874 dbname Query 291 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
16060 username 10.10.10.10:55877 dbname Query 290 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247798102 AND open 10, 1, 0)) AS newthread\n
16061 username 10.10.10.10:55879 dbname Query 286 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247870811 AND open 10, 1, 0)) AS newthread\n
16062 username 10.10.10.10:55881 dbname Sleep 290 NULL
16063 username 10.10.10.10:55882 dbname Query 290 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247871703 AND open 10, 1, 0)) AS newthread\n
16064 username 10.10.10.10:55885 dbname Sleep 290 NULL
16065 username 10.10.10.10:55888 dbname Sleep 290 NULL
16066 username 10.10.10.10:55889 dbname Query 290 Locked SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247866495 AND open 10, 1, 0)) AS newthread\n
16067 username 10.10.10.10:55893 dbname Query 287 Locked SELECT IF(visible = 2, 1, 0) AS isdeleted,\n\t\t\t\n\n\t\t\tNOT ISNULL(subscribethread.subscribethreadid) AS
16068 username 10.10.10.10:55895 dbname Sleep 287 NULL
16071 root localhost NULL Query 0 NULL show processlist
review of 8 text files with process output showing commonality:
SERVER# cat *.txt | grep Sending
15666 username 10.10.10.10:54120 dbname Query 339 Sending data SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1247835044 AND open 10, 1, 0)) AS newthread\n
46636 username 10.10.10.10:50865 dbname Query 362 Sending data SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1233373622 AND open 10, 1, 0)) AS newthread\n\t\t\n\t\tFROM thread AS thread\n\t\t\n\t\t\n\t\tWHERE forumid = 11\n\t\t\tAND sticky = 0\n\t\t\t AND visible = 1 \n\t\t\tAND postuserid NOT IN (8773,20136,810,13679,1783,9313,4585,6251,2351,326 ,3891,1730,130,31,632,1560,2901,1150,373,2267,362)
46636 username 10.10.10.10:50865 dbname Query 497 Sending data SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1233373622 AND open 10, 1, 0)) AS newthread\n\t\t\n\t\tFROM thread AS thread\n\t\t\n\t\t\n\t\tWHERE forumid = 11\n\t\t\tAND sticky = 0\n\t\t\t AND visible = 1 \n\t\t\tAND postuserid NOT IN (8773,20136,810,13679,1783,9313,4585,6251,2351,326 ,3891,1730,130,31,632,1560,2901,1150,373,2267,362)
64143 username 10.10.10.10:65202 dbname Query 494 Sending data SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1233583078 AND open 10, 1, 0)) AS newthread\n\t\t\n\t\tFROM thread AS thread\n\t\t\n\t\t\n\t\tWHERE forumid = 18\n\t\t\tAND sticky = 0\n\t\t\t AND visible = 1 \n\t\t\tAND postuserid NOT IN (8773,20136,810,13679,1783,9313,4585,6251,2351,326 ,3891,1730,130,31,632,1560,2901,1150,373,2267,362)
64143 username 10.10.10.10:65202 dbname Query 521 Sending data SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1233583078 AND open 10, 1, 0)) AS newthread\n\t\t\n\t\tFROM thread AS thread\n\t\t\n\t\t\n\t\tWHERE forumid = 18\n\t\t\tAND sticky = 0\n\t\t\t AND visible = 1 \n\t\t\tAND postuserid NOT IN (8773,20136,810,13679,1783,9313,4585,6251,2351,326 ,3891,1730,130,31,632,1560,2901,1150,373,2267,362)
323003 username 10.10.10.10:52468 dbname Query 584 Sending data SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1234432916 AND open 10, 1, 0)) AS newthread\n\t\t\n\t\tFROM thread AS thread\n\t\t\n\t\t\n\t\tWHERE forumid = 38\n\t\t\tAND sticky = 0\n\t\t\t AND visible = 1 \n\t\t\tAND postuserid NOT IN (8773,20136,810,13679,1783,9313,4585,6251,2351,326 ,3891,1730,130,31,632,1560,2901,1150,373,2267,362)
132037 username 10.10.10.10:57760 dbname Query 281 Sending data SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1234826600 AND open 10, 1, 0)) AS newthread\n\t\t\n\t\tFROM thread AS thread\n\t\t\n\t\t\n\t\tWHERE forumid = 18\n\t\t\tAND sticky = 0\n\t\t\t AND visible = 1 \n\t\t\tAND postuserid NOT IN (8773,20136,810,13679,1783,9313,4585,6251,2351,326 ,3891,1730,130,31,632,1560,2901,1150,373,2267,362)
79102 username 10.10.10.10:52363 dbname Query 311 Sending data SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1235094675 AND open 10, 1, 0)) AS newthread\n\t\t\n\t\tFROM thread AS thread\n\t\t\n\t\t\n\t\tWHERE forumid = 11\n\t\t\tAND sticky = 0\n\t\t\t AND visible = 1 \n\t\t\tAND postuserid NOT IN (8773,20136,810,13679,1783,9313,4585,6251,2351,326 ,3891,1730,130,31,632,1560,2901,1150,373,2267,362)

Ill add the required info from Steves thread to assist in troubleshooting the issue.

Thx in advance everyone! __DEFINE_LIKE_SHARE__

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	مشاركات	آخر مشاركة
just move server -Random Forbidden 403 + 404 & random Attachment problem	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	08-11-2009 01:20 PM
problem with MySQL/vbulletin	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	07-19-2009 07:50 PM
mysql problem	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	06-04-2009 12:00 AM
tag system mysql problem	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-21-2009 03:50 PM
MySql and yahoo??? PROBLEM	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-06-2009 04:30 AM