|
Need assistance with random mysql db problem 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! |
| الساعة الآن 10:08 AM |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.5.2 TranZ By
Almuhajir