joelle Posted July 27, 2007 Posted July 27, 2007 I already asked the IPB.Board support team but they couldn't help me. Since I switched from vbulletin to Invision Power Board I am getting a lot of server crashes. I am definately sure that the error comes from either from IPB.Board, IPB.Blog or from IP.Gallery.That is part of the error log:[client 74.6.22.226] PHP Warning: Invalid argument supplied for foreach() in /var/www/vhosts/joelle.de/httpdocs/modules/blog/lib/lib_cblocks.php on line 658 [client 66.249.72.239] PHP Warning: array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [Thu Jul 26 00:12:43 2007] [error] [client 88.73.43.162] File does not exist: /var/www/vhosts/joelle.de/httpdocs/robots.txt [client 66.249.72.239] PHP Warning: array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: array_keys(): The first argument should be an array in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 [client 66.249.72.239] PHP Warning: in_array(): Wrong datatype for second argument in /var/www/vhosts/joelle.de/httpdocs/cache/skin_cache/cacheid_3/skin_profile.php on line 1173 The slow query log says: # Time: 070727 12:58:50 # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 28 Lock_time: 13 Rows_sent: 1 Rows_examined: 0 SELECT * FROM ibf_topics WHERE tid=18985; # Time: 070727 12:58:52 # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 188 Lock_time: 172 Rows_sent: 1 Rows_examined: 238 SELECT count(*) as count FROM ibf_topics WHERE approved=1 AND state != 'link' AND forum_id IN(23,138,116,376,48,50,486,636,646,37,80,57,621,403,653,648,637,657,661,685,68 ,698,689,703,695,406,617,117,103,670,633,710,658,58,59,60,62,96,402,65,66,68,69, 5,656,132,543,462,131,639,133,134,135,105,674,109,110,111,623,475,75,474,97,556, 59,557,558,140,405,665,463,476,544,545,693,83,84,85,86,87,614,627,622,625,626,62 ,630,651,694,638,652,641,640,642,643,644,649,697,654,616,662,31,32,33,702,81,141 672,676,677,673,666,416,17,18,700,671,88,78,645,635,38,679,43,386,680,681,24,11, 5,130,686,701,688,690,696,699,704,16,15,14,13,12,28,29,10,54,34,36,678,51,64,106 71,20,684,21,632,325,22,668,705,667,669,326,613,624,628,711) AND last_post > '1185414679'; # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 26 Lock_time: 9 Rows_sent: 1 Rows_examined: 0 SELECT * FROM ibf_topics WHERE tid=14018; # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 80 Lock_time: 63 Rows_sent: 1 Rows_examined: 97 SELECT count(*) as count FROM ibf_topics WHERE approved=1 AND state != 'link' AND forum_id IN(23,138,116,376,48,50,486,636,646,37,80,57,621,403,653,648,637,657,661,685,68 ,698,689,703,695,406,617,117,103,670,633,710,58,59,60,62,96,402,65,66,68,69,95,6 6,132,543,462,131,639,133,134,135,105,674,109,110,111,623,475,75,474,97,556,559, 57,558,140,405,665,463,476,544,545,693,83,84,85,86,87,614,627,622,625,626,629,63 ,651,694,638,652,641,640,642,643,644,649,697,654,616,662,31,32,33,702,81,141,672 676,677,673,666,416,17,18,700,671,88,78,645,635,38,679,43,386,680,681,24,11,25,1 0,686,701,688,690,696,699,704,16,15,14,13,12,28,29,10,34,36,678,51,64,106,71,20, 84,21,632,325,22,668,705,667,669,326,613,624,628,711) AND last_post > '1185482826'; # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 28 Lock_time: 11 Rows_sent: 1 Rows_examined: 0 SELECT * FROM ibf_topics WHERE tid=9915; # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 274 Lock_time: 257 Rows_sent: 1 Rows_examined: 0 SELECT * FROM ibf_topics WHERE tid=18561; # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 229 Lock_time: 212 Rows_sent: 1 Rows_examined: 0 SELECT * FROM ibf_topics WHERE tid=18249; # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 194 Lock_time: 177 Rows_sent: 1 Rows_examined: 0 SELECT * FROM ibf_topics WHERE tid=18923; # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 38 Lock_time: 21 Rows_sent: 30 Rows_examined: 144 SELECT * FROM ibf_topics t WHERE t.forum_id=684 AND t.pinned IN (0,1) and t.approved=1 ORDER BY t.pinned DESC, t.last_post DESC LIMIT 0,30; # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 170 Lock_time: 153 Rows_sent: 30 Rows_examined: 30 SELECT * FROM ibf_topics t WHERE t.forum_id=20 AND t.pinned IN (0,1) and t.approved=1 ORDER BY t.pinned DESC, t.last_post DESC LIMIT 0,30; # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 39 Lock_time: 22 Rows_sent: 2 Rows_examined: 15917 SELECT tid, title, posts, starter_id as member_id, starter_name as member_name, start_date as post_date, views FROM ibf_topics WHERE forum_id IN(23,138,116,376,48,50,486,636,646,37,80,57,621,403,653,648,637,657,661,685,68 ,698,689,703,695,406,617,117,103,670,633,710,58,59,60,62,96,402,65,66,68,69,95,6 6,132,543,462,131,639,133,134,135,105,674,109,110,111,623,475,75,474,97,556,559, 57,558,140,405,665,463,476,544,545,693,83,84,85,86,87,614,627,622,625,626,629,63 ,651,694,638,652,641,640,642,643,644,649,697,654,616,662,31,32,33,702,81,141,672 676,677,673,666,416,17,18,700,671,88,78,645,635,38,679,43,386,680,681,24,11,25,1 0,686,701,688,690,696,699,704,16,15,14,13,12,28,29,10,34,36,678,51,64,106,71,20, 84,21,632,325,22,668,705,667,669,326,613,624,628,711) AND approved=1 and state != 'closed' and (moved_to is null or moved_to = '') ORDER BY start_date DESC LIMIT 0,2; # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 202 Lock_time: 185 Rows_sent: 1 Rows_examined: 91 SELECT count(*) as count FROM ibf_topics WHERE approved=1 AND state != 'link' AND forum_id IN(23,138,116,376,48,50,486,636,646,37,80,57,621,403,653,648,637,657,661,685,68 ,698,689,703,695,406,617,117,103,670,633,710,58,59,60,62,96,402,65,66,68,69,95,6 6,132,543,462,131,639,133,134,135,105,674,109,110,111,623,475,75,474,97,556,559, 57,558,140,405,665,463,476,544,545,693,83,84,85,86,87,614,627,622,625,626,629,63 ,651,694,638,652,641,640,642,643,644,649,697,654,616,662,31,32,33,702,81,141,672 676,677,673,666,416,17,18,700,671,88,78,645,635,38,679,43,386,680,681,24,11,25,1 0,686,701,688,690,696,699,704,16,15,14,13,12,28,29,10,34,36,678,51,64,106,71,20, 84,21,632,325,22,668,705,667,669,326,613,624,628,711) AND last_post > '1185519209'; # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 243 Lock_time: 226 Rows_sent: 1 Rows_examined: 0 SELECT * FROM ibf_topics WHERE tid=18559; # Time: 070727 12:58:56 # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 239 Lock_time: 219 Rows_sent: 30 Rows_examined: 205 SELECT * FROM ibf_topics t WHERE t.forum_id=702 AND t.pinned IN (0,1) and t.approved=1 ORDER BY t.pinned DESC, t.last_post DESC LIMIT 0,30; # Time: 070727 12:59:02 # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 30 Lock_time: 3 Rows_sent: 30 Rows_examined: 205 SELECT * FROM ibf_topics t WHERE t.forum_id=702 AND t.pinned IN (0,1) and t.approved=1 ORDER BY t.pinned DESC, t.last_post DESC LIMIT 0,30; # Time: 070727 12:59:11 # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 31 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 INSERT INTO ibf_search_results (id,search_date,post_max,sort_key,sort_order,member_id,ip_address,query_cache) VALUES('964823c17e477c55b25903071efaab72',1185533920,97,'last_post','desc',1248,'80.131.163.137','SELECT t.*, t.title as topic_title FROM ibf_topics t WHERE t.approved=1 AND t.state != \'link\' AND t.forum_id IN(23,138,116,376,48,50,486,636,646,37,80,57,621,403,653,648,637,657,661,685,68 ,698,689,703,695,406,617,117,103,670,633,710,58,59,60,62,96,402,65,66,68,69,95,6 6,132,543,462,131,639,133,134,135,105,674,109,110,111,623,475,75,474,97,556,559, 57,558,140,405,665,463,476,544,545,693,83,84,85,86,87,614,627,622,625,626,629,63 ,651,694,638,652,641,640,642,643,644,649,697,654,616,662,31,32,33,702,81,141,672 676,677,673,666,416,17,18,700,671,88,78,645,635,38,679,43,386,680,681,24,11,25,1 0,686,701,688,690,696,699,704,16,15,14,13,12,28,29,10,34,36,678,51,64,106,71,20, 84,21,632,325,22,668,705,667,669,326,613,624,628,711) AND t.last_post > 1185482826 ORDER BY t.last_post DESC'); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 58 Lock_time: 22 Rows_sent: 2 Rows_examined: 15917 SELECT tid, title, posts, starter_id as member_id, starter_name as member_name, start_date as post_date, views FROM ibf_topics WHERE forum_id IN(23,138,116,376,48,50,486,636,646,37,80,57,621,403,653,648,637,657,661,685,68 ,698,689,703,695,406,617,117,103,670,633,710,58,59,60,62,96,402,65,66,68,69,95,6 6,132,543,462,131,639,133,134,135,105,674,109,110,111,623,475,75,474,97,556,559, 57,558,140,405,665,463,476,544,545,693,83,84,85,86,87,614,627,622,625,626,629,63 ,651,694,638,652,641,640,642,643,644,649,697,654,616,662,31,32,33,702,81,141,672 676,677,673,666,416,17,18,700,671,88,78,645,635,38,679,43,386,680,681,24,11,25,1 0,686,701,688,690,696,699,704,16,15,14,13,12,28,29,10,34,36,678,51,64,106,71,20, 84,21,632,325,22,668,705,667,669,326,613,624,628,711) AND approved=1 and state != 'closed' and (moved_to is null or moved_to = '') ORDER BY start_date DESC LIMIT 0,2; # Time: 070727 12:59:54 # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 69 Lock_time: 18 Rows_sent: 1 Rows_examined: 0 SELECT COUNT(*) as cnt FROM ibf_attachments WHERE attach_post_key='efef2de3b9289930328c4428c8a9f251'; # Time: 070727 13:01:59 # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 188 Lock_time: 5 Rows_sent: 19 Rows_examined: 19 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 199 Lock_time: 0 Rows_sent: 19 Rows_examined: 19 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # Time: 070727 13:02:00 # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 190 Lock_time: 0 Rows_sent: 19 Rows_examined: 19 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # Time: 070727 13:02:04 # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 173 Lock_time: 0 Rows_sent: 19 Rows_examined: 19 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 192 Lock_time: 19 Rows_sent: 18 Rows_examined: 18 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'ranks','profilefields','attachtypes','badwords','bbcode','emoticons','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 182 Lock_time: 0 Rows_sent: 19 Rows_examined: 19 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 192 Lock_time: 19 Rows_sent: 16 Rows_examined: 16 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','attachtypes','multimod','ranks','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 201 Lock_time: 19 Rows_sent: 14 Rows_examined: 14 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'announcements','multimod','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # Time: 070727 13:02:05 # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 193 Lock_time: 18 Rows_sent: 19 Rows_examined: 19 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 338 Lock_time: 128 Rows_sent: 1 Rows_examined: 1272 SELECT t.*, p.poll_only FROM ibf_topics t LEFT JOIN ibf_polls p ON ( p.tid=t.tid ) WHERE t.forum_id=669 AND t.tid=13824; # Time: 070727 13:02:06 # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 316 Lock_time: 105 Rows_sent: 1 Rows_examined: 1272 SELECT t.*, p.poll_only FROM ibf_topics t LEFT JOIN ibf_polls p ON ( p.tid=t.tid ) WHERE t.forum_id=130 AND t.tid=12414; # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 205 Lock_time: 21 Rows_sent: 6 Rows_examined: 6 SELECT author_id, topic_id FROM ibf_posts WHERE author_id=3785 AND topic_id IN(7855,15283,15648,16502,17445,18252,18320,18515,18522,18777,18803,18825,18826 18827,18838,18839,18841,18851,18856,18903,18910,18923,18928,18939,18942,18944,18 47,18950,18964,18980); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 184 Lock_time: 1 Rows_sent: 18 Rows_examined: 18 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'ranks','profilefields','attachtypes','badwords','bbcode','emoticons','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 200 Lock_time: 17 Rows_sent: 7 Rows_examined: 7 SELECT author_id, topic_id FROM ibf_posts WHERE author_id=547 AND topic_id IN(3120,7821,7822,10299,13931,18559,18561,18581); # Time: 070727 13:02:07 # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 240 Lock_time: 28 Rows_sent: 1 Rows_examined: 1272 SELECT t.*, p.poll_only FROM ibf_topics t LEFT JOIN ibf_polls p ON ( p.tid=t.tid ) WHERE t.forum_id=702 AND t.tid=17831; # Time: 070727 13:02:09 # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 207 Lock_time: 14 Rows_sent: 19 Rows_examined: 19 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 209 Lock_time: 0 Rows_sent: 19 Rows_examined: 19 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 200 Lock_time: 21 Rows_sent: 2945 Rows_examined: 2945 SELECT author_id, topic_id FROM ibf_posts WHERE author_id=1498 AND topic_id IN(11971,14018,15087,15261,15327,16042,16116,16504,16571,17047,17229,17239,1748 ,17831,17836,17921,18077,18079,18095,18114,18332,18341,18403,18482,18609,18842,1 889,18951,18952,18959); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 170 Lock_time: 62 Rows_sent: 2945 Rows_examined: 2945 SELECT author_id, topic_id FROM ibf_posts WHERE author_id=1498 AND topic_id IN(11971,14018,15087,15261,15327,16042,16116,16504,16571,17047,17229,17239,1748 ,17831,17836,17921,18077,18079,18095,18114,18332,18341,18403,18482,18609,18842,1 889,18951,18952,18959); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 209 Lock_time: 1 Rows_sent: 2945 Rows_examined: 2945 SELECT author_id, topic_id FROM ibf_posts WHERE author_id=1498 AND topic_id IN(11971,14018,15087,15261,15327,16042,16116,16504,16571,17047,17229,17239,1748 ,17831,17836,17921,18077,18079,18095,18114,18332,18341,18403,18482,18609,18842,1 889,18951,18952,18959); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 203 Lock_time: 17 Rows_sent: 2945 Rows_examined: 2945 SELECT author_id, topic_id FROM ibf_posts WHERE author_id=1498 AND topic_id IN(11971,14018,15087,15261,15327,16042,16116,16504,16571,17047,17229,17239,1748 ,17831,17836,17921,18077,18079,18095,18114,18332,18341,18403,18482,18609,18842,1 889,18951,18952,18959); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 207 Lock_time: 14 Rows_sent: 2945 Rows_examined: 2945 SELECT author_id, topic_id FROM ibf_posts WHERE author_id=1498 AND topic_id IN(11971,14018,15087,15261,15327,16042,16116,16504,16571,17047,17229,17239,1748 ,17831,17836,17921,18077,18079,18095,18114,18332,18341,18403,18482,18609,18842,1 889,18951,18952,18959); # Time: 070727 13:02:15 # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 210 Lock_time: 17 Rows_sent: 19 Rows_examined: 19 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 212 Lock_time: 28 Rows_sent: 2945 Rows_examined: 2945 SELECT author_id, topic_id FROM ibf_posts WHERE author_id=1498 AND topic_id IN(11971,14018,15087,15261,15327,16042,16116,16504,16571,17047,17229,17239,1748 ,17831,17836,17921,18077,18079,18095,18114,18332,18341,18403,18482,18609,18842,1 889,18951,18952,18959); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 172 Lock_time: 77 Rows_sent: 2945 Rows_examined: 2945 SELECT author_id, topic_id FROM ibf_posts WHERE author_id=1498 AND topic_id IN(11971,14018,15087,15261,15327,16042,16116,16504,16571,17047,17229,17239,1748 ,17831,17836,17921,18077,18079,18095,18114,18332,18341,18403,18482,18609,18842,1 889,18951,18952,18959); # Time: 070727 13:02:16 # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 214 Lock_time: 14 Rows_sent: 2945 Rows_examined: 2945 SELECT author_id, topic_id FROM ibf_posts WHERE author_id=1498 AND topic_id IN(11971,14018,15087,15261,15327,16042,16116,16504,16571,17047,17229,17239,1748 ,17831,17836,17921,18077,18079,18095,18114,18332,18341,18403,18482,18609,18842,1 889,18951,18952,18959); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 216 Lock_time: 10 Rows_sent: 2945 Rows_examined: 2945 SELECT author_id, topic_id FROM ibf_posts WHERE author_id=1498 AND topic_id IN(11971,14018,15087,15261,15327,16042,16116,16504,16571,17047,17229,17239,1748 ,17831,17836,17921,18077,18079,18095,18114,18332,18341,18403,18482,18609,18842,1 889,18951,18952,18959); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 216 Lock_time: 0 Rows_sent: 2945 Rows_examined: 2945 SELECT author_id, topic_id FROM ibf_posts WHERE author_id=1498 AND topic_id IN(11971,14018,15087,15261,15327,16042,16116,16504,16571,17047,17229,17239,1748 ,17831,17836,17921,18077,18079,18095,18114,18332,18341,18403,18482,18609,18842,1 889,18951,18952,18959); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 187 Lock_time: 53 Rows_sent: 2945 Rows_examined: 2945 SELECT author_id, topic_id FROM ibf_posts WHERE author_id=1498 AND topic_id IN(11971,14018,15087,15261,15327,16042,16116,16504,16571,17047,17229,17239,1748 ,17831,17836,17921,18077,18079,18095,18114,18332,18341,18403,18482,18609,18842,1 889,18951,18952,18959); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 200 Lock_time: 3 Rows_sent: 19 Rows_examined: 19 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # Time: 070727 13:02:26 # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 218 Lock_time: 17 Rows_sent: 19 Rows_examined: 19 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 210 Lock_time: 15 Rows_sent: 12 Rows_examined: 12 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 226 Lock_time: 0 Rows_sent: 19 Rows_examined: 19 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 224 Lock_time: 14 Rows_sent: 19 Rows_examined: 19 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # Time: 070727 13:02:27 # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 223 Lock_time: 18 Rows_sent: 19 Rows_examined: 19 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 215 Lock_time: 18 Rows_sent: 19 Rows_examined: 19 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 223 Lock_time: 18 Rows_sent: 15 Rows_examined: 15 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'chatting','birthdays','calendar','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 208 Lock_time: 12 Rows_sent: 15 Rows_examined: 15 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'chatting','birthdays','calendar','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 211 Lock_time: 15 Rows_sent: 18 Rows_examined: 18 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages','bbcode','emoticons','badwords','multimod','ranks','profilefields' ); # Time: 070727 13:02:29 # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 320 Lock_time: 86 Rows_sent: 1 Rows_examined: 3 SELECT t.*,p.* FROM ibf_topics t,ibf_posts p WHERE t.starter_id=4091 AND t.forum_id IN(23,138,116,376,48,50,486,636,646,37,80,57,621,403,653,648,637,657,661,685,68 ,698,689,703,695,406,617,117,103,670,633,710,58,59,60,62,96,402,65,66,68,69,95,6 6,132,543,462,131,639,133,134,135,105,674,109,110,111,623,475,75,474,97,556,559, 57,558,140,405,665,463,476,544,545,693,83,84,85,86,87,614,627,622,625,626,629,63 ,651,694,638,652,641,640,642,643,644,649,697,654,616,662,31,32,33,702,81,141,672 676,677,673,666,416,17,18,700,671,88,78,645,635,38,679,43,386,680,681,24,11,25,1 0,686,701,688,690,696,699,704,16,15,14,13,12,28,29,10,34,36,678,51,64,106,71,20, 84,21,632,325,22,668,705,667,669,326,613,624,628,711) AND t.approved=1 AND t.topic_firstpost=p.pid ORDER BY t.start_date DESC LIMIT 0,5; # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 226 Lock_time: 19 Rows_sent: 14 Rows_examined: 14 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'announcements','multimod','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 217 Lock_time: 19 Rows_sent: 19 Rows_examined: 19 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 217 Lock_time: 19 Rows_sent: 15 Rows_examined: 15 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'chatting','birthdays','calendar','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 388 Lock_time: 155 Rows_sent: 1 Rows_examined: 1272 SELECT t.*, p.poll_only FROM ibf_topics t LEFT JOIN ibf_polls p ON ( p.tid=t.tid ) WHERE t.forum_id=80 AND t.tid=9795; # Time: 070727 13:02:30 # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 227 Lock_time: 18 Rows_sent: 15 Rows_examined: 15 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages','bbcode','emoticons','d22shoutbox' ); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 229 Lock_time: 9 Rows_sent: 19 Rows_examined: 19 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # Time: 070727 13:02:31 # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 215 Lock_time: 15 Rows_sent: 15 Rows_examined: 15 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages','bbcode','emoticons','d22shoutbox' ); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 215 Lock_time: 15 Rows_sent: 15 Rows_examined: 15 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages','bbcode','emoticons','d22shoutbox' ); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 456 Lock_time: 220 Rows_sent: 1 Rows_examined: 1272 SELECT t.*, p.poll_only FROM ibf_topics t LEFT JOIN ibf_polls p ON ( p.tid=t.tid ) WHERE t.forum_id=543 AND t.tid=18249; # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 229 Lock_time: 28 Rows_sent: 20 Rows_examined: 20 SELECT typed,image,clickable,emo_set FROM ibf_emoticons; # Time: 070727 13:02:34 # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 214 Lock_time: 11 Rows_sent: 19 Rows_examined: 19 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 221 Lock_time: 18 Rows_sent: 15 Rows_examined: 15 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'chatting','birthdays','calendar','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 230 Lock_time: 27 Rows_sent: 19 Rows_examined: 19 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 218 Lock_time: 15 Rows_sent: 15 Rows_examined: 15 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages','bbcode','emoticons','d22shoutbox' ); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 225 Lock_time: 21 Rows_sent: 0 Rows_examined: 0 INSERT INTO ibf_search_results (id,search_date,post_max,sort_key,sort_order,member_id,ip_address,query_cache) VALUES('116facc3f775589680022b2f9c684e92',1185533925,97,'last_post','desc',1248,'80.131.163.137','SELECT t.*, t.title as topic_title FROM ibf_topics t WHERE t.approved=1 AND t.state != \'link\' AND t.forum_id IN(23,138,116,376,48,50,486,636,646,37,80,57,621,403,653,648,637,657,661,685,68 ,698,689,703,695,406,617,117,103,670,633,710,58,59,60,62,96,402,65,66,68,69,95,6 6,132,543,462,131,639,133,134,135,105,674,109,110,111,623,475,75,474,97,556,559, 57,558,140,405,665,463,476,544,545,693,83,84,85,86,87,614,627,622,625,626,629,63 ,651,694,638,652,641,640,642,643,644,649,697,654,616,662,31,32,33,702,81,141,672 676,677,673,666,416,17,18,700,671,88,78,645,635,38,679,43,386,680,681,24,11,25,1 0,686,701,688,690,696,699,704,16,15,14,13,12,28,29,10,34,36,678,51,64,106,71,20, 84,21,632,325,22,668,705,667,669,326,613,624,628,711) AND t.last_post > 1185482826 ORDER BY t.last_post DESC'); # User@Host: port_startf[port_startf] @ localhost [] # Query_time: 212 Lock_time: 0 Rows_sent: 1 Rows_examined: 0 use port_dru; SELECT data, created, headers, expire FROM cache WHERE cid = 'variables'; # Time: 070727 13:02:35 # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 232 Lock_time: 18 Rows_sent: 15 Rows_examined: 15 use joel_ipb; SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages','bbcode','emoticons','d22shoutbox' ); # Time: 070727 13:02:38 # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 164 Lock_time: 2 Rows_sent: 15 Rows_examined: 15 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'chatting','birthdays','calendar','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 234 Lock_time: 70 Rows_sent: 16 Rows_examined: 16 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','attachtypes','multimod','ranks','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # Time: 070727 13:02:39 # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 215 Lock_time: 52 Rows_sent: 19 Rows_examined: 19 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 230 Lock_time: 16 Rows_sent: 2 Rows_examined: 2 SELECT author_id, topic_id FROM ibf_posts WHERE author_id=547 AND topic_id IN(14858,14879,18644,18645,18646,18647,18707,18752,18985); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 214 Lock_time: 53 Rows_sent: 15 Rows_examined: 15 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'chatting','birthdays','calendar','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # Time: 070727 13:02:44 # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 217 Lock_time: 53 Rows_sent: 1 Rows_examined: 2 SELECT s.member_id, s.member_name, s.member_group, s.id, s.login_type, s.location, s.running_time,t.forum_id FROM ibf_sessions s LEFT JOIN ibf_topics t ON ( t.tid=s.location_1_id ) WHERE s.location_2_type='forum' AND s.location_2_id=543 AND s.running_time > 1185533047 AND s.in_error=0; # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 218 Lock_time: 52 Rows_sent: 19 Rows_examined: 19 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'badwords','emoticons','attachtypes','bbcode','multimod','ranks','profilefields','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 234 Lock_time: 64 Rows_sent: 0 Rows_examined: 0 INSERT INTO ibf_search_results (id,search_date,post_max,sort_key,sort_order,member_id,ip_address,query_cache) VALUES('02cc310fb5680bd21011cb28fc4fa4f2',1185533927,238,'last_post','desc',547,'78.48.41.71','SELECT t.*, t.title as topic_title FROM ibf_topics t WHERE t.approved=1 AND t.state != \'link\' AND t.forum_id IN(23,138,116,376,48,50,486,636,646,37,80,57,621,403,653,648,637,657,661,685,68 ,698,689,703,695,406,617,117,103,670,633,710,658,58,59,60,62,96,402,65,66,68,69, 5,656,132,543,462,131,639,133,134,135,105,674,109,110,111,623,475,75,474,97,556, 59,557,558,140,405,665,463,476,544,545,693,83,84,85,86,87,614,627,622,625,626,62 ,630,651,694,638,652,641,640,642,643,644,649,697,654,616,662,31,32,33,702,81,141 672,676,677,673,666,416,17,18,700,671,88,78,645,635,38,679,43,386,680,681,24,11, 5,130,686,701,688,690,696,699,704,16,15,14,13,12,28,29,10,54,34,36,678,51,64,106 71,20,684,21,632,325,22,668,705,667,669,326,613,624,628,711) AND t.last_post > 1185414679 ORDER BY t.last_post DESC'); # Time: 070727 13:02:45 # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 233 Lock_time: 69 Rows_sent: 0 Rows_examined: 0 INSERT INTO ibf_search_results (id,search_date,post_max,sort_key,sort_order,member_id,ip_address,query_cache) VALUES('816f7e20c4859ece76fa39a2bc1a2e66',1185533921,97,'last_post','desc',1248,'80.131.163.137','SELECT t.*, t.title as topic_title FROM ibf_topics t WHERE t.approved=1 AND t.state != \'link\' AND t.forum_id IN(23,138,116,376,48,50,486,636,646,37,80,57,621,403,653,648,637,657,661,685,68 ,698,689,703,695,406,617,117,103,670,633,710,58,59,60,62,96,402,65,66,68,69,95,6 6,132,543,462,131,639,133,134,135,105,674,109,110,111,623,475,75,474,97,556,559, 57,558,140,405,665,463,476,544,545,693,83,84,85,86,87,614,627,622,625,626,629,63 ,651,694,638,652,641,640,642,643,644,649,697,654,616,662,31,32,33,702,81,141,672 676,677,673,666,416,17,18,700,671,88,78,645,635,38,679,43,386,680,681,24,11,25,1 0,686,701,688,690,696,699,704,16,15,14,13,12,28,29,10,34,36,678,51,64,106,71,20, 84,21,632,325,22,668,705,667,669,326,613,624,628,711) AND t.last_post > 1185482826 ORDER BY t.last_post DESC'); # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 221 Lock_time: 57 Rows_sent: 0 Rows_examined: 0 INSERT INTO ibf_search_results (id,search_date,post_max,sort_key,sort_order,member_id,ip_address,query_cache) VALUES('19f638d7855b968622c06b93a1385e25',1185533933,238,'last_post','desc',547,'78.48.41.71','SELECT t.*, t.title as topic_title FROM ibf_topics t WHERE t.approved=1 AND t.state != \'link\' AND t.forum_id IN(23,138,116,376,48,50,486,636,646,37,80,57,621,403,653,648,637,657,661,685,68 ,698,689,703,695,406,617,117,103,670,633,710,658,58,59,60,62,96,402,65,66,68,69, 5,656,132,543,462,131,639,133,134,135,105,674,109,110,111,623,475,75,474,97,556, 59,557,558,140,405,665,463,476,544,545,693,83,84,85,86,87,614,627,622,625,626,62 ,630,651,694,638,652,641,640,642,643,644,649,697,654,616,662,31,32,33,702,81,141 672,676,677,673,666,416,17,18,700,671,88,78,645,635,38,679,43,386,680,681,24,11, 5,130,686,701,688,690,696,699,704,16,15,14,13,12,28,29,10,54,34,36,678,51,64,106 71,20,684,21,632,325,22,668,705,667,669,326,613,624,628,711) AND t.last_post > 1185414679 ORDER BY t.last_post DESC');
bfarber Posted July 27, 2007 Posted July 27, 2007 Some of those queries just absolutely shouldn't be taking that long. For example # User@Host: joel_port[joel_port] @ localhost [] # Query_time: 164 Lock_time: 2 Rows_sent: 15 Rows_examined: 15 SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'chatting','birthdays','calendar','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' );# Time: 070727 13:02:38 Let's take a look at this . The query took 164 seconds to run (which is just ridiculous - no one would wait 3 minutes for a page to load these days). Now, it was LOCKED for 2 seconds, so it actually took 162 seconds for mysql to process the query. Why? It's an optimized query pulling 15 rows from a database table, using an index. There's just no way on earth it should take that long. Try going to phpmyadmin and running this queryexplain SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'chatting','birthdays','calendar','skin_remap','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ); Does it come back fast? What does it say? What kind of server do you have (processor, memory, dedicated/vps/shared)? If it's dedicated or vps can you post your my.cnf file, and also how many active users (within 15 minutes, shown at the bottom of your board) do you have? How many total topics and posts?
rct2·com Posted July 27, 2007 Posted July 27, 2007 Off topic, sorry. I don't normally look in logs to inspect slow queries. Where is this log, out of interest?
bfarber Posted July 27, 2007 Posted July 27, 2007 You can enable slow query logging in the my.cnf, and set the threshold for what is considered a "slow" query (default being 10 seconds). :) When you do that, you specify where the log should be generated.
joelle Posted July 27, 2007 Posted July 27, 2007 It came back pretty fast. But I have to admit that I restarted the server 15 minutes ago because the response time of our site was unexeptable. This is what I received: id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ibf_cache_store range PRIMARY PRIMARY 765 NULL 16 Using where Specs: CPU - AuthenticAMD, AMD Athlon 64 Processor 3000+ OS - os_CentOS 4.2 Memory - 1GB Dedicated Usually I got around 150 active users with guests included. But from time to time I got around 500 active users. The server can easly handle that amount of users. Posts: 370 000 Topics: 16 000 my.cnf [mysqld] set-variable=local-infile=0 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 set-variable = max_connections=450 set-variable = key_buffer=16M set-variable = join_buffer=1M set-variable = record_buffer=1M set-variable = sort_buffer=2M set-variable = table_cache=1024 set-variable = thread_cache_size=256 set-variable = wait_timeout=9600 set-variable = connect_timeout=10 set-variable = max_allowed_packet=16M set-variable = max_connect_errors=10 log-slow-queries=/var/log/mysql/log-slow-queries.log [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid A single bad/unindexed query can bring a server to its knees but I can't localize the bottleneck, bad file or bad query which causes this server slow down/crash. After I imported the vbulletin database into the IPB.Board database the permission sets were a little mixed up but I am not sure if the transition causes the slow queries.
bfarber Posted July 30, 2007 Posted July 30, 2007 Firstly, I think you'd have trouble handling 500 users with 1 GB of RAM. I think 150 is fair, but your peaks are going to be hard to handle with only 1GB, depending on what all those visitors are doing. Secondly, the index appears to be used for that query, yet it shows up a few times in your slow query log, so I'm leaning towards the issue not being an index. You can check your indexes in the ACP under the Support tab in IPB - if any are missing you can create them (or get the query to create them). I think a few changes in your mysql variables would help, but first I'd need to know if you intend to add some more memory or not. Even 1GB more would make a world of difference, but if you put a total of 4GB in the server, you could likely handle closer to 800-900 without any issues. At 1GB of memory I'd recommend upping the key_buffer to 256M, setting wait_timeout to 30. There might be a few other changes that would help, but probably not as much as the key_buffer change (which generally should be set to 25-50% of the system's memory). I assume there aren't any other sites on the server that should be factored in? Also, these are myisam tables right? innodb is good in some cases, but probably not with your current setup. And search you should be sure is using fulltext search method.
joelle Posted July 31, 2007 Posted July 31, 2007 I am not planing on upgrading the server hardware within the next couple months. When I used vbulletin with the same server specs I had no server slow down problems at all, so I am pretty sure that the current server specs can handle the traffic. At the moment, the IP.Blog & the IP.Gallery response time is fast and the IP.Board is very slow, which is very strange. There are only 50 guests and 30 members online. Yes, they are myisam tables and no other sites. All the index appear to be fine. The ACP error log says:=================================================== Date: Tue, 31 Jul 2007 19:48:09 +0200 Error Number: 1062 Error: Duplicate entry '486-2683' for key 1 IP Address: 80.143.95.162 mySQL query error: INSERT INTO ibf_topic_markers (marker_unread,marker_topics_read,marker_last_update,marker_member_id,marker_for m_id) VALUES(1671,'a:1:{i:16899;i:1185904089;}',1185904089,2683,486) =================================================== Date: Tue, 31 Jul 2007 20:13:23 +0200 Error Number: 1062 Error: Duplicate entry '636-2683' for key 1 IP Address: 80.143.95.162 mySQL query error: INSERT INTO ibf_topic_markers (marker_unread,marker_topics_read,marker_last_update,marker_member_id,marker_for m_id) VALUES(280,'a:0:{}',1185905600,2683,636) =================================================== Date: Tue, 31 Jul 2007 20:20:53 +0200 Error Number: 1062 Error: Duplicate entry '84-1840' for key 1 IP Address: 78.48.152.34 mySQL query error: INSERT INTO ibf_topic_markers (marker_unread,marker_topics_read,marker_last_update,marker_member_id,marker_for m_id) VALUES(33,'a:0:{}',1185906052,1840,84) =================================================== Date: Tue, 31 Jul 2007 20:57:52 +0200 Error Number: 1062 Error: Duplicate entry '71-3955' for key 1 IP Address: 85.177.179.236 mySQL query error: INSERT INTO ibf_topic_markers (marker_unread,marker_topics_read,marker_last_update,marker_member_id,marker_for m_id) VALUES(9,'a:0:{}',1185908270,3955,71) =================================================== Date: Tue, 31 Jul 2007 20:57:52 +0200 Error Number: 1062 Error: Duplicate entry '71-3955' for key 1 IP Address: 85.177.179.236 mySQL query error: INSERT INTO ibf_topic_markers (marker_unread,marker_topics_read,marker_last_update,marker_member_id,marker_for m_id) VALUES(9,'a:0:{}',1185908270,3955,71) =================================================== Date: Tue, 31 Jul 2007 20:57:52 +0200 Error Number: 1062 Error: Duplicate entry '71-3955' for key 1 IP Address: 85.177.179.236 mySQL query error: INSERT INTO ibf_topic_markers (marker_unread,marker_topics_read,marker_last_update,marker_member_id,marker_for m_id) VALUES(9,'a:0:{}',1185908270,3955,71)
njustice Posted July 31, 2007 Posted July 31, 2007 set-variable = key_buffer=16M WAY too small for 370K posts. The best way to set the size is to add up the total of your .MYI files, or use a tool like this MySQL tuning script. I'd suggest starting at 128MB.
bfarber Posted July 31, 2007 Posted July 31, 2007 80 users should be fine on those specs - I was just pointing out your peak traffic. As Blair said, you need to increase the key_buffer size. The rule of thumb I go with is to start around 25% of total memory. Now, MySQL and webserver are on one server it sounds like so you may want to start lower (128M will be an improvement over 16M even) but you can increment it higher if you find your server can handle it. Another thing you can check is to run this querySHOW STATUS LIKE '%key_read%'; Key_read_requests / key_reads should be right somewhere around 1000 to 1. For example, here's the data for IPS Beyond presently Key_read_requests 1081257869 Key_reads 2621032 It's about 412 to 1. This tells me I could probably get better performance with tweaking the key_buffer (which is set to 8M here, the default). (Heck, actually now that I bothered to take the time to do that, I might ssh in tomorrow and try to update it.)
joelle Posted August 3, 2007 Posted August 3, 2007 Thank you for your help. Some table lock must crash the system. The server runs for a certain time very fast and all of the sudden the response time gets real slow eventhough the amount of users doesn't increase.
njustice Posted August 3, 2007 Posted August 3, 2007 I'm no MySQL expert, and I don't play one on TV, but I have spent enough tweaking my servers to learn enough to be dangerous... You may not need to do anything other than your last edit, increasing your key_buffer to 128MB.QUERY CACHE Query cache is supported but not enabled Perhaps you should set the query_cache_size Maybe start with this: query_cache_limit=4M query_cache_size=1M query_cache_type=1MAX CONNECTIONS Current max_connections = 400 Seems like a lot for 1GB RAM. Lower to 150, or less.KEY BUFFER Current MyISAM index space = 237 M Your key buffer should probably be around 256MB. Another GB of RAM would help, A LOT.TEMP TABLES Current max_heap_table_size = 16 M Current tmp_table_size = 32 M I never specifiy max_heap_table_size, but I'm guessing it should be equal to tmp_table_size. I'd try doubling the tmp_table_size to 64M. 128M may be ideal, but you're memory limited.TABLE LOCKING Current Lock Wait ratio = 1 : 1347 You may benefit from selective use of InnoDB. Brandon has said these can safely be changed to InnoDB, and may help with locking on some busy sites: ibf_cache_store (change ibf_ if you've used a different prefix) ibf_topic_markers A couple other tweaks to add to my.cnf: key_cache_division_limit=40 low_priority_updates=1 This tuning script is dynamic. You want to make some changes, let it run a couple of days and then run again. Keep tweaking until you get the optimal config. You will also need to rerun and change as your database grows. Your current server may have handled vBulletin, but your database is continually growing, and you would have likely had the same problems with it. Really, the best thing you could do is add another 1GB of RAM. A couple other things it could be. A search on a very popular word, or maybe a cron for your server processing stats.
bfarber Posted August 4, 2007 Posted August 4, 2007 Yes, the InnoDB tables Blair mentioned are fine - especially the topic_markers. If you have any caching software (such as eaccelerator or xcache, for example) you can actually use those too with IPB - which pulls a little load off of the database server at much higher speeds. The key_buffer_size is the key really. I'd go with 25% of the system memory (at least) if mysql seems to be the CPU/Memory hog. It's maxing out it's available resources and swapping. With a site your size, that's easy to do (250,000+ posts). My recommendation - add another 1 GB (or 3GB, for room to grow) of RAM. It's really not too expensive. You can get RAM from places like NewEgg for cheap a lot of times. There's a stick of ECC Unbuffered Kingston RAM (and one of Crucial), 1 GB, for under $50 on NewEgg right now with under $5 shipping. I've heard of hosts offering an extra stick of RAM to be added to a server for as little as $15 one time fee (of course you don't own it, but still). It's going to make a huge impact, and as Blair said - you would have hit the same problems in vBulletin. You may not have hit them yet, but you would have, and it wouldn't have taken very long.
joelle Posted August 7, 2007 Posted August 7, 2007 Thank you for your help. I'll be trying out different settings. Also, I will ask my host if I can upgrade the memory of my current server.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.