Search found 148 matches

by lanzer
Sat Jun 16, 2007 12:28 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 616643

Re: phpBB tweaks for large forums

So you are saying LANZER doesn't do the work on his site now himself? As far as the forum is concerned, that's actually true. There are 35 of us all working on different aspects of the site, and the forum section has its specific owner, then we're finishing up on building a universal posting engine...
by lanzer
Fri Apr 14, 2006 8:54 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 616643

Hello dcz: Today Gaia has a about 150 web servers behind our load balancer, and about 20 databases handling different features. Many of our old servers had been either de-commissioned or converted to storage servers. The new servers we're installing are all Opteron servers that are 4 times faster th...
by lanzer
Thu Apr 06, 2006 10:25 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 616643

Life without Lanzer

Hello Caspert Ghost: 1: I literally started learning PHP months before starting Gaia. I never wanted to be a professional programmer, but between me and 3 other artists, I was the only guy capable of programming for Gaia. :) Having C and Perl background, learning PHP was not difficult. Aside from Go...
by lanzer
Wed Dec 21, 2005 1:57 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 616643

capleton wrote: Hi, this isn't exactly a tweak but thought i ask here since you guys seems to be experts in SQL.
...
Thankful if someone could help out!


Hi Capleton, to avoid going off-topic, I've replied on another thread:

http://www.phpbb.com/phpBB/viewtopic.ph ... 29#1911629
by lanzer
Wed Dec 21, 2005 1:55 pm
Forum: 2.0.x Discussion
Topic: Lanzer's answers
Replies: 0
Views: 1161

Lanzer's answers

Hi Capleton: There are several answers to your question, let's look at the problem one by one - 1) Your code right now sets the variable as empty if your query fails. Meanwhile, if your query suceed, it set variable to the image string if your query returns a row of results while it does nothing at ...
by lanzer
Mon Sep 19, 2005 1:52 pm
Forum: 2.0.x Discussion
Topic: Thanks psoTFX
Replies: 135
Views: 117914

Oh no! I'm so sorry to hear about your departure from phpbb. For all these years your leading contribution had always been a source of inspiration and needless to say, what you had done as an individual had benefitted tens of thousands and it's quite an achivement. At times it's fustrating to be jud...
by lanzer
Fri Sep 16, 2005 10:50 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 616643

Late night chatter

younghistorians> Yes, we had considered the Google search appliance, and unfortunately the cheaper model cannot handle our traffic load, and the high end model is out of our budget. XxDawgxX> Thank you for your flattering post. ^^; I just tried to carry the same spirit of what everyone in the commun...
by lanzer
Thu Aug 25, 2005 12:49 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 616643

Hi Gulson: Yes, quite a while back I had cronjobs which ran through posts adding them to the search table to minimize on the wait it takes to post. Though eventually there were so many posts that the system couldn't keep up with the updates. Eventually those cronjobs were scratched also. My conclusi...
by lanzer
Thu Aug 25, 2005 12:07 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 616643

Re: Searching improvements for larger forums.

Hi Serberus: If you want more speed with the function, you can probably not worry about strtolower and make sure that your list of stopwords and synonyms are stored in lowercase when you enter them (run strtolower in the admin interface) and instead of running str_replace multiple times in a loop, s...
by lanzer
Wed Aug 24, 2005 7:47 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 616643

Hi Xkevinx: I like to install Cacti on our web servers for monitoring health, especially with the amount of servers we have now. Though in reality, seeing performance from one single machine is kind of a boring thing, and aggregated results will show similar results but with bigger numbers. :? Serve...
by lanzer
Wed Jun 29, 2005 12:57 pm
Forum: 2.0.x Support Forum
Topic: extremly slow mysql queries cause server overload!? :O
Replies: 13
Views: 6270

First glance from your slow query log tells me that the search related queries and your mods are causing you most of your problems. Remember that most mods are built for feature, not for speed. If you have speed problems, then you might want to start with a fresh phpbb install and see if you are get...
by lanzer
Sun Jun 05, 2005 8:46 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 616643

Re: backing up your database

Hi arod-1, when I run mysqldump I don't change the nice value, where as I have the mysql daemon running as -20. If any single database takes more than an hour to back up, that just means it's probably time to seek a solution different than just running mysqldump. just wonder: do you run mysqldump un...
by lanzer
Thu May 05, 2005 8:13 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 616643

Re: backing up your database

Question: I find mysqldump to be very slow for large databases/tables. I start getting "Linux is dangerously overloaded" type warnings. Also tried to do tar on the data tables, but then since the tables are live, start getting tar errors. How do you handle this? Hello Steve, when it comes to making...
by lanzer
Wed Mar 23, 2005 1:18 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 616643

Re: backing up your database

We do nightly backup with mysqldump for most of our databases. A script was made to list all the tables within the database, then each table will be dumped into a backup file by the same name. (you can also just tell mysqldump to dump all tables into one big file) This happens on all our database se...
by lanzer
Wed Mar 23, 2005 12:21 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 616643

Hi Kevin: We tried using memcache, and although memcache is fast handling single connections, it actually didn't show a great improvement as a session handler. With a high amount of load we actually started having connection errors even with load distributed amoung servers. Another problem with memc...

Go to advanced search