[Clicknathan]

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:

1. I used this method 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?
2. We’re running BBPress v. 0.9.0.2
3. We’re using the following plugins: Akismet, Use Display Name, BBPress Private Messaging, Post Count Plus, Forum Last Poster, and Images Allowed

The information from the host was this:

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

# User@Host: 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

# User@Host: 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

# User@Host: 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

# User@Host: 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

# User@Host: 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

# User@Host: 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.

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!

[chrishajer]

You might want to post this on the plugin page:

https://bbpress.org/plugins/topic/private-forums/

Or contact the plugin author.

[chrishajer]

Regarding being unable to activate plugins, are you on a Windows host? What is your bbPress version, and what is your hosting platform?

Is this related?

https://bbpress.org/forums/topic/plugins-not-activating-on-local-xampp

I don’t understand your second question, sorry. My Spanish is not that good.

[rpophessagr]

I’m editing current Theme for the bbPress Alpha 1.0 Release… I have created a Side bar that appears on almost all the pages with forums listed. Just like WP category. (site: http://howtoreachmygoals.com/ask/). Now, I’m facing some problem with Looping through the Forums (bb_forums()).

My side bar is executed before main contents. so when main contents require to loop the forums again, like Category listing page / Forum on posting (selecting dropdown box). its returning NULL / empty.

I wanted to find-out is there any way that i can Reset the bb_forums( ) loop and make it available again for next time?

many thanks!

[_ck_]

WP-Syntax should take all of 10 minutes to port to bbPress:

http://bbshowcase.org/forums/topic/syntax-highlighter-plugin

I have a “Syntax-Lite” plugin in development that is less than 1k and uses PHP’s built-in (high speed) highlighter but only works with PHP code of course. It also won’t be available for quite awhile as I don’t have time for bbPress projects these days.

[beernews]

Ok, fair enough. I will delete the alpha off of my local and play around with the older version instead. Is the upgradability from release to release as seamless as WP?

[Olaf Lederer]

A syntax highlighter in wordpress/bbpress is always a hard to do.

Geshi and tinyMCE = forget it

I have finally a parser in WP but need to work in code view only.

[Olaf Lederer]

maybe because your list is empty? which bbpress version are you using?

[_ck_]

There have been so many new features added in the past few weeks in the trunk that there’s no way it’s ever going to be stable this month (October).

Even if they release another alpha (or beta but that would be crazy), that doesn’t mean it’s stable, it means it needs to be tested and debugged, thoroughly. Sam only has a limited environment to test things. Problems with PHP4 or Windows come up constantly and other things he can’t easily test. There’s also a good chance plugins will become broken (again/still).

Do NOT use the alpha on a live, active site. Period. Seriously. Not kidding. It’s not a trick. Alphas are for testing purposes only. Objects may be closer than they appear.

If you ignore this warning, you are on your own.

[chrishajer]

The rewritten links have zero to do with cookies. The rewrite rules are not working for you on GoDaddy (ed: was Dreamhost here). Have you browsed other people’s experience by following that godaddy tag?

[chrishajer]

My completely uninformed guess is … no. I wouldn’t wait. Install something and see how it goes.

If you log in here, you can see the number of open tickets by milestone: https://trac.bbpress.org/report/3 . There are quite a few open for 1.0. Also, there hasn’t been a 1.0 beta or release candidate either. So, just my guess, no.

[beernews]

any chance this becomes stable this week?

i’m antsy to add a forum to my blog but dont know if i should wait for the stable version?

[chrishajer]

Regarding permalinks, you will find lots of people expressing some problem with permalinks on GoDaddy. Just check the tag for other discussions.

That .htaccess would not work for the forum directory. That just looks like the WordPress rewrite rules changed slightly for your forum directory. You need to follow these directions:

https://bbpress.org/documentation/faq/#pretty-permalinks

[chrishajer]

Norvu, those version are incompatible. You don’t integrate the cookies. If you want integrated logins, you need to use bbPress 0.9.* with WordPress 2.5 or bbPress Alpha with WordPress 2.6.

https://bbpress.org/forums/topic/wordpress-and-bbpress-integration-101#post-17409

[eschen]

OK, on the second issue, if I am already logged into WP but not bbPress, the link at the forum page works. So it is being logged into one or the other but not both at the same time. Oh..hum

[norvu]

WordPress version 2.6.2 and bbPress version 0.9.0.2

[eschen]

I installed bbPress 0.9.0.2 and tried to integrate with WP 2.5 site. The two are at http://www.my-site/forum and http://www.mysite/blog under the root directory. I have two issues:

First is with permalinks set to the default (/forum.php?id=1), no problem, I can view profiles and posts within bbPress. However if I use either of the other settings for a permalink, when I click on any profile or post topic within admin control panel or site view, I only get a blank page, no error. Example: the post should be at “forum/post-name”, which is exactly where the link takes me but a blank page exists. However I can view the user profiles registered at bbPress within the WP admin area, so I believe the two are at least partially integrated.

The host is GoDaddy and there are no problems with WP permalinks. I have tried the using the following htaccess code with the /forum directory:

# BEGIN bbPress

<IfModule mod_rewrite.c>

RewriteEngine On

RewriteBase /forum/

RewriteCond %{REQUEST_FILENAME} !-f

RewriteCond %{REQUEST_FILENAME} !-d

RewriteRule . /forum/index.php [L]

</IfModule>

Also just having one line:

Options +MultiViews

Also the exact code generated at bb-admin/rewrite-rules.php

Second issue is after login to bbPress, a simple link to the WP admin requests me to login again. Does this take more than a simple link to “…/blog/wp-admin/”? I have checked the cookies and both look identical.

Thanks for any help

[chrishajer]

Have you tried with a different browser? I have seen a weird problem that I can’t consistently reproduce where after submitting info to the login form, it just redirects to the login form. I was able to log in with a different browser once before, and I haven’t seen the problem since.

https://bbpress.org/forums/topic/bbpress-10-alpha/page/2#post-19153

[chrishajer]

Norvu – what versions of bbPress and WordPress are you using?

[chrishajer]

If you click the tag integration, you will see lots of people discussing it.

What do you mean by integration?

[chrishajer]

matchfox: did you already try this?

https://bbpress.org/documentation/faq/#pretty-permalinks

If your site works without permalinks, it’s most definitely an issue with the rewrite rules.

[kchealy]

I am hosting a site with bluehost. I installed bbpress with simplescripts. Although the installation seems to have gone correctly, I cannot log in. Every time I try, I’m just taken back to the log in page with no error message.

This is a standalone install – I have not attempted to integrate it with my wordpress install.

[keress]

You were right about the templates. I used Dreamhost’s webftp client to move my wordpress site. It tells you to create the folder first. I took that to mean the main folders, and didn’t create all the many subfolders. I’m assuming that had something to do with why our template folder was not quite there. I could see it in webftp, but my ftpclient on my computer wasn’t showing it. Once I’d ftp’d all the files back, the site reappeared.

Dreamhost is saying that can’t happen, but that’s what I experienced.

Thanks for the help.

[blankpoint]

I was thinking this might have something to do with the fact that when I log in through the WP admin, I do not have access to the bbpress admin interface (though I show up as logged in as admin there, and can do admin functions that are on the forum pages etc). I need to login through bbpress to be able to access the bbpress admin. But this DOES allow me access to the WP admin too (as it should).

[blankpoint]

I have a WordPress 2.6.2 installation (xxxxxxx.com) sharing a user tables with bbPress 1.0 Alpha (xxxxxxx.com/forum). There are two separate databases, and bbPress uses the user tables from the WP database. The installations are integrated, but something strange is happening.

If I try to integrate WordPress into bbpress (I need to for everything I am doing), using the following call at the beginning of bb-config.php:

require_once(‘/homepages/15/d202815449/htdocs/wordpress/wp-blog-header.php’);

then my keymaster accounts immediately become admin accounts (and lose the admin tabs of “design”, “settings”, and so on in the admin interface). They show up as admins instead of keymasters on the user page in bb-admin. As soon as I take the call to wp-blog-header.php out again, the accounts go back to keymaster status. Any idea why this could be happening?