bbPress Support Forums Tag: XDForum

bbPress Support Forums Tag: XDForum http://bbpress.org/forums/ bbPress Support Forums Tag: XDForum en Sat, 10 Jan 2009 00:01:39 +0000 sambauers on "Slow Queries - 300 second query times" http://bbpress.org/forums/topic/slow-queries-300-second-query-times#post-19607 Thu, 02 Oct 2008 22:52:08 +0000 sambauers 19607@http://bbpress.org/forums/ I think that query is generated by the forum-last-poster plugin. If it is the one that is showing up over and over again, then get rid of it. chrishajer on "Slow Queries - 300 second query times" http://bbpress.org/forums/topic/slow-queries-300-second-query-times#post-19597 Thu, 02 Oct 2008 01:41:10 +0000 chrishajer 19597@http://bbpress.org/forums/ There have been some relevant discussions here: <a href="http://bbpress.org/forums/topic/bbpress-0901-gt-30-queries-per-page" rel="nofollow">http://bbpress.org/forums/topic/bbpress-0901-gt-30-queries-per-page</a> <a href="http://bbpress.org/forums/topic/server-overload" rel="nofollow">http://bbpress.org/forums/topic/server-overload</a> <a href="http://bbpress.org/forums/topic/fulltext-searching-very-slow" rel="nofollow">http://bbpress.org/forums/topic/fulltext-searching-very-slow</a> <a href="http://bbpress.org/forums/topic/how-to-evaluate-server-speed" rel="nofollow">http://bbpress.org/forums/topic/how-to-evaluate-server-speed</a> Looking at the front page of your forum, I see a total of 3074 threads and 22,121 posts. Is there more than meets the eye here to come up with 2.5 million rows of data? Or maybe there's not 2.5 millions rows in bb_topics, it's just because of the subquery that it looks at that many records (like it's something I don't understand about the way MySQL displays the number or rows searched)? Did the amount of data grow exponentially after the conversion from xdforums? Maybe there were 20K rows in xdforums, but something with the conversion didn't go well and it duplicated a bunch of data? How many rows were there in comparable tables before and after conversion? Something doesn't add up. Also, are all those queries the same, and if so, is that query just trying to determine the last poster, from the "Forum Last Poster" plugin? If so, have you tried just turning that plugin off? If that works, then maybe just optimizing the query for your installation would work and you could turn it back on after modifying the plugin. Of all the plugins, the only other one I could see affecting the queries like that would be the Post Count Plus. That would be the second one I turn off and check for a performance difference. clicknathan on "Slow Queries - 300 second query times" http://bbpress.org/forums/topic/slow-queries-300-second-query-times#post-19594 Wed, 01 Oct 2008 21:33:50 +0000 clicknathan 19594@http://bbpress.org/forums/ Hello, I've recently set up a BBPress forum for non-profit Bike Pittsburgh and their host, Pair Networks, shut down their database because of the load BBPress was putting on the server. Pair has since reinstated the db, but I was wondering if anyone could offer any insight as to how I might trim down the size of the queries that BBPress is putting through. A little background: <ol> <li>I used <a href="http://fastpipe.com/2008/06/23/converting-xdforum-to-bbpress">this method</a> to convert a WordPress XDForum into BBPress. I know the author of that post mentions that the method he uses might not be the most efficient, however at this point (after the conversion), I wouldn't think that BBPress is using any of this info any more, correct?</li> <li>We're running BBPress v. 0.9.0.2</li> <li>We're using the following plugins: Akismet, Use Display Name, BBPress Private Messaging, Post Count Plus, Forum Last Poster, and Images Allowed</li> </ol> The information from the host was this: <blockquote> With that said, we wanted to provide a follow up in terms of the nature of the problem itself. The problem is that the database is running some very inefficient queries, trying to sort through 2.5 million rows and are returning very few to no results. These queries take a long time to run and are called "slow queries". As you gain in traffic, the more of these slow queries that are run, the higher the load on the server, and therefore the more affect you have on other customers. I've included some examples of these queries below for your review: # Time: 080930 20:55:01 # <a href="mailto:User@Host:">User@Host:</a> bikepgh[bikepgh] @ [209.68.4.180] # Query_time: 54 Lock_time: 0 Rows_sent: 10 Rows_examined: 2469001 SELECT forum_id, topic_id FROM bb_topics WHERE topic_last_post_id IN (SELECT MAX (topic_last_post_id) FROM bb_topics WHERE topic_status=0 GROUP BY forum_id); # Time: 080930 20:56:05 # <a href="mailto:User@Host:">User@Host:</a> bikepgh[bikepgh] @ [209.68.4.180] # Query_time: 71 Lock_time: 0 Rows_sent: 10 Rows_examined: 2469001 SELECT forum_id, topic_id FROM bb_topics WHERE topic_last_post_id IN (SELECT MAX (topic_last_post_id) FROM bb_topics WHERE topic_status=0 GROUP BY forum_id); # Time: 080930 20:56:43 # <a href="mailto:User@Host:">User@Host:</a> bikepgh[bikepgh] @ [209.68.4.180] # Query_time: 67 Lock_time: 0 Rows_sent: 10 Rows_examined: 2469001 SELECT forum_id, topic_id FROM bb_topics WHERE topic_last_post_id IN (SELECT MAX (topic_last_post_id) FROM bb_topics WHERE topic_status=0 GROUP BY forum_id); # Time: 080930 20:57:38 # <a href="mailto:User@Host:">User@Host:</a> bikepgh[bikepgh] @ [209.68.4.180] # Query_time: 52 Lock_time: 0 Rows_sent: 10 Rows_examined: 2469001 SELECT forum_id, topic_id FROM bb_topics WHERE topic_last_post_id IN (SELECT MAX (topic_last_post_id) FROM bb_topics WHERE topic_status=0 GROUP BY forum_id); # Time: 080930 21:20:46 # <a href="mailto:User@Host:">User@Host:</a> bikepgh[bikepgh] @ [209.68.4.180] # Query_time: 263 Lock_time: 0 Rows_sent: 10 Rows_examined: 2469001 SELECT forum_id, topic_id FROM bb_topics WHERE topic_last_post_id IN (SELECT MAX (topic_last_post_id) FROM bb_topics WHERE topic_status=0 GROUP BY forum_id); # Time: 080930 21:22:35 # <a href="mailto:User@Host:">User@Host:</a> bikepgh[bikepgh] @ [209.68.4.180] # Query_time: 281 Lock_time: 0 Rows_sent: 0 Rows_examined: 1952752 SELECT forum_id, topic_id FROM bb_topics WHERE topic_last_post_id IN (SELECT MAX (topic_last_post_id) FROM bb_topics WHERE topic_status=0 GROUP BY forum_id); As you can see, these queries are taking almost 300 seconds to complete (query_time). This is an extremely high time, as a query on a shared server should take under 10 seconds to complete. I hope this helps provide some needed details for you. If we can be of any further assistance, please do not hesitate to ask.</blockquote> Any help as to what I might do in PHPMyAdmin or otherwise to help lower the load on the db would be VERY MUCH appreciated! fastpipe on "Converting XDForum to BBPress" http://bbpress.org/forums/topic/converting-xdforum-to-bbpress#post-17440 Sat, 19 Jul 2008 16:10:37 +0000 fastpipe 17440@http://bbpress.org/forums/ No problem. I like to keep Wordpress up to date and the XDForum plug-in was holding me back. _ck_ on "Converting XDForum to BBPress" http://bbpress.org/forums/topic/converting-xdforum-to-bbpress#post-17437 Sat, 19 Jul 2008 15:42:49 +0000 _ck_ 17437@http://bbpress.org/forums/ Thanks for sharing this! fastpipe on "Converting XDForum to BBPress" http://bbpress.org/forums/topic/converting-xdforum-to-bbpress#post-16873 Mon, 23 Jun 2008 16:48:26 +0000 fastpipe 16873@http://bbpress.org/forums/ XDForum, another Wordpress forum plug-in, stopped development a few months ago. For anyone considering converting their XDForum to BBPress, I've posted detailed instructions for <a href="http://www.fastpipe.com/2008/06/23/converting-xdforum-to-bbpress">converting XDForum tables to BBPress tables</a> on my site. The instructions include a method for tagging your existing content. I looked for something like this a few months ago and couldn't find it. Hopefully, someone will find this useful. The result of the conversion can be viewed <a href="http://www.hdtvok.com/forums/">here</a>...