Donations to Upgrade Forum Server?
-
- Posts: 603
- Joined: Mon Jan 31, 2011 2:07 am
-
- Posts: 1659
- Joined: Fri Dec 02, 2011 1:24 am
-
- Posts: 603
- Joined: Mon Jan 31, 2011 2:07 am
-
- Posts: 1659
- Joined: Fri Dec 02, 2011 1:24 am
I'm glad you started on this bigato. It allowed me to accept yet another offer for overtime today without any guilt about putting this off again.
Good luck.
So the server died in the middle of me downloading the database, giving me an incomplete file? LOL geez. I might've never realized.
Sorry to hear the import script didn't work. It sounds like you figured out the reason for that, but one of the reasons I gave you the credentials was because I thought it would be more accurate to copy the files and folder structure from the server to your test server rather than running a conversion with a clean installation of bbPress--just in case the installation on the server is unique (e.g. modified by plug-ins, etc). Not sure if that could have anything to do with the script's lack of success.
![Smile :)](./images/smilies/icon_e_smile.gif)
So the server died in the middle of me downloading the database, giving me an incomplete file? LOL geez. I might've never realized.
Sorry to hear the import script didn't work. It sounds like you figured out the reason for that, but one of the reasons I gave you the credentials was because I thought it would be more accurate to copy the files and folder structure from the server to your test server rather than running a conversion with a clean installation of bbPress--just in case the installation on the server is unique (e.g. modified by plug-ins, etc). Not sure if that could have anything to do with the script's lack of success.
I agree that the best long term solution is to migrate the forum to a more modern and maintainable stack however we may get a few quick wins by optimizing current deployment until the migration is complete.
Do we actually know what's the bottleneck/root cause here? I understand that bbpress is not very efficient piece of software but I would recommend to take a step back and evaluate the performance of entire platform to get a better understanding about the problem. Likely an inefficient handling of db queries by the php code in combination with limitation of the DB itself but I'd like to gather some more data to get more detailed answer.
Can someone please provide more details about the server and its configuration?
1) Is this VPS? what's the HW spec?
2) Is this built on top of LAMP? What Operating System / Distribution, version, architecture, daemon versions?
3) Is the DB and Web running on the same server?
4) run following commands for basic diagnostic when the system is under heavy load:
uname -a > uname-a.out
uptime > uptime.out
iostat -x 5 5 > iostat.out
sysctl -a > sysctl.out
df -h > df-h.out
df -i > df-i.out
vmstat -s > vmstat-s.out
vmstat -t 5 5 > vmstat-t.out
ps -fuax > ps-fuax.out
top -b -d 5 -n 4 > top.out
free -m > free-m.out
ifconfig -a > ifconfig-a.out
mpstat -P ALL 5 4 > mpstat-p.out
netstat -s > netstat-s.out
#Please replace <backtick> with an actual backtick as I couldn't figure out how to display it.
for i in <backtick>pgrep "(mysql|httpd|apache|php)"</backtick>; do pidstat -t -p $i 3 3 >> pidstat.out; done
tar cfz out.tgz *.out
If you could send me out.tgz, php.ini, apache and mysql config I can have a closer look.
Thanks.
Do we actually know what's the bottleneck/root cause here? I understand that bbpress is not very efficient piece of software but I would recommend to take a step back and evaluate the performance of entire platform to get a better understanding about the problem. Likely an inefficient handling of db queries by the php code in combination with limitation of the DB itself but I'd like to gather some more data to get more detailed answer.
Can someone please provide more details about the server and its configuration?
1) Is this VPS? what's the HW spec?
2) Is this built on top of LAMP? What Operating System / Distribution, version, architecture, daemon versions?
3) Is the DB and Web running on the same server?
4) run following commands for basic diagnostic when the system is under heavy load:
uname -a > uname-a.out
uptime > uptime.out
iostat -x 5 5 > iostat.out
sysctl -a > sysctl.out
df -h > df-h.out
df -i > df-i.out
vmstat -s > vmstat-s.out
vmstat -t 5 5 > vmstat-t.out
ps -fuax > ps-fuax.out
top -b -d 5 -n 4 > top.out
free -m > free-m.out
ifconfig -a > ifconfig-a.out
mpstat -P ALL 5 4 > mpstat-p.out
netstat -s > netstat-s.out
#Please replace <backtick> with an actual backtick as I couldn't figure out how to display it.
for i in <backtick>pgrep "(mysql|httpd|apache|php)"</backtick>; do pidstat -t -p $i 3 3 >> pidstat.out; done
tar cfz out.tgz *.out
If you could send me out.tgz, php.ini, apache and mysql config I can have a closer look.
Thanks.
- jennypenny
- Posts: 6858
- Joined: Sun Jul 03, 2011 2:20 pm
- jennypenny
- Posts: 6858
- Joined: Sun Jul 03, 2011 2:20 pm
Looks great! I have a question though.
Sometimes people on the forum want to/need to change their name from the username they created. The way we've always gotten around that is by changing the "name" in the user profile and then choosing to be identified by their "name" instead of their "username" in the profile preferences. Will we still be able to do that?
FYI the board is down at the moment
Sometimes people on the forum want to/need to change their name from the username they created. The way we've always gotten around that is by changing the "name" in the user profile and then choosing to be identified by their "name" instead of their "username" in the profile preferences. Will we still be able to do that?
FYI the board is down at the moment
I've been poking around the new forums and have some questions:
1. By default word censoring is enabled in display options for the user. Will there actually be a word censor list? If so, will it be humorous?![Razz :P](./images/smilies/icon_razz.gif)
2. There doesn't appear to be a way to change the number of posts per page, and it's currently set at 10. I personally prefer 20 or 25/page. Are there plans to change the default or let users choose their own settings? (Looks like you can get a plugin to do that.)
1. By default word censoring is enabled in display options for the user. Will there actually be a word censor list? If so, will it be humorous?
![Razz :P](./images/smilies/icon_razz.gif)
2. There doesn't appear to be a way to change the number of posts per page, and it's currently set at 10. I personally prefer 20 or 25/page. Are there plans to change the default or let users choose their own settings? (Looks like you can get a plugin to do that.)
Thanks bigato! 25 per page is much better!
Re: stress testing. Usually what broke other forums I was on, was the search feature. People would search, it wouldn't find what they were looking for, so they'd search repeatedly (all while other users are browsing the forum normally, of course, chewing up more bandwidth). I'm not sure how we can stress test that without getting a bunch of people over at once, or someone creating/running some scripts to simulate that kind of activity. It's definitely beyond my knowledge.
Re: stress testing. Usually what broke other forums I was on, was the search feature. People would search, it wouldn't find what they were looking for, so they'd search repeatedly (all while other users are browsing the forum normally, of course, chewing up more bandwidth). I'm not sure how we can stress test that without getting a bunch of people over at once, or someone creating/running some scripts to simulate that kind of activity. It's definitely beyond my knowledge.
Just checked out the avatar feature - has it been deliberately set up so users have to link a URL for their avatar and can't upload from computer? If you use a URL for an avatar image, is it being uploaded/cached to the forum server or is it being hotlinked from the original site?
P.S. I also set it to keep me logged in always but every time I close the tab and go back, I'm logged out again and have to re-enter my info. Dunno if that's just something on your test server though, as opposed to something on the live environment.
P.P.S. Just tried testing images in signatures with an obnoxiously large image (http://upload.wikimedia.org/wikipedia/c ... _Night.jpg). Could we set up a max image dimension/size, as for avatars, for images in signatures? Forum should probably have a way to auto-shrink or flat out reject image tags in signatures that are too big.
P.S. I also set it to keep me logged in always but every time I close the tab and go back, I'm logged out again and have to re-enter my info. Dunno if that's just something on your test server though, as opposed to something on the live environment.
P.P.S. Just tried testing images in signatures with an obnoxiously large image (http://upload.wikimedia.org/wikipedia/c ... _Night.jpg). Could we set up a max image dimension/size, as for avatars, for images in signatures? Forum should probably have a way to auto-shrink or flat out reject image tags in signatures that are too big.
-
- Posts: 267
- Joined: Fri Mar 02, 2012 5:29 pm
Long time lurker, but thought I'd chime in for this. I was just wondering if there's a way to default phpBB to a "latest discussions" view like the current forum is setup? I think that's my favorite feature about this forum because I know I'd miss interesting stuff if I had to dig through individual sub-forums. If you're logged into phpBB "View New Posts" gives you something similar although it's not quite the same since if you logout and then back in that whole list disappears even if you haven't read them, but it's not even an option if you're not logged in. Thanks for all the hard work bigato.
-
- Site Admin
- Posts: 16001
- Joined: Fri Jun 28, 2013 8:38 pm
- Location: USA, Zone 5b, Koppen Dfa, Elev. 620ft, Walkscore 77
- Contact:
@bigato - I don't think the server is necessarily totally down when the error message appears. It's just unable to serve that particular request. "All our operators are currently busy, please hold."
I think a Pareto explanation is more likely. Most hits are lurkers. Many are one time search engine hits. Many won't click because they don't see how they can help. Many won't click more than once. All in all, the only people likely to click are regulars who are also software savvy.
FVIW, when I did those survey polls on the blog, it took a week to get 200 people to click. Compare to the traffic of 20000+ visitors.
I think in general, over the internet, one can only expect an active reaction (feedback) from about 1% of the people. It's the same thing with book reviews. Ten thousand copies sold -> about 100 reviews.
I think a Pareto explanation is more likely. Most hits are lurkers. Many are one time search engine hits. Many won't click because they don't see how they can help. Many won't click more than once. All in all, the only people likely to click are regulars who are also software savvy.
FVIW, when I did those survey polls on the blog, it took a week to get 200 people to click. Compare to the traffic of 20000+ visitors.
I think in general, over the internet, one can only expect an active reaction (feedback) from about 1% of the people. It's the same thing with book reviews. Ten thousand copies sold -> about 100 reviews.
-
- Site Admin
- Posts: 16001
- Joined: Fri Jun 28, 2013 8:38 pm
- Location: USA, Zone 5b, Koppen Dfa, Elev. 620ft, Walkscore 77
- Contact:
The forums need a theme. Bigato sent me a link to different themes. The closest one I found was
https://www.phpbb.com/customise/db/styl ... 12c6d9fa06
https://www.phpbb.com/customise/db/styl ... 12c6d9fa06
- jennypenny
- Posts: 6858
- Joined: Sun Jul 03, 2011 2:20 pm
- jennypenny
- Posts: 6858
- Joined: Sun Jul 03, 2011 2:20 pm