Search found 148 matches

by lanzer
Wed Mar 23, 2005 12:09 pm
Forum: 2.0.x Support Forum
Topic: Sessions problems crashing my DB...please help!
Replies: 2
Views: 606

Here's something you can try, no gaurantee though since I have no clue as to what was causing your problem. Assuming that the old problem with some clients just have the tendency to create thousands of new sessions in the session table, you can add a line to remove sessions from within the same IP. ...
by lanzer
Tue Mar 08, 2005 5:19 am
Forum: 2.0.x Discussion
Topic: mySQL vs Postgre for larger PHPBB forums (locked tables?)
Replies: 6
Views: 1373

Just make sure your DB server has 2+ gigs of RAM, then edit your my.cnf file to support innodb and start converting the active tables to type=innodb. In no time your site will be flying. :) Not saying if one DB is better than the other, but mysql can do everything you need with little config changes...
by lanzer
Sun Feb 27, 2005 12:52 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 631960

Has anyone tried this? I installed it a while back and just today noticed that the unserialize of the smilies data does not work. I get FALSE returned from the unserialize command. I also noticed that there is no $board_config['time_now'] variable so I just substituted time() in there. Hi EverettB:...
by lanzer
Sun Feb 27, 2005 12:23 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 631960

Hi Cifroes: The query you mentioned has a hack that will take the functionality away and replace it with a query that tells the user which forum has new messages, as opposed to listing all the new topics since the user last logged in. It was mentioned as one of the first hacks in this thread. Otherw...
by lanzer
Sun Feb 27, 2005 12:11 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 631960

Hello Darkangel: I can hardly remember what were the limitations around the amount of traffic you mentioned, but as things approached thousands of users online database performance seemed to be the dominating factor in performance issues. When the database has any queries that takes more than a few ...
by lanzer
Wed Dec 01, 2004 8:32 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 631960

Question. Heard any horror stories or problems converting large tables from MyISAM to InnoDB? Like I said previously, my posts and post_text are each about 364,000 rows, my wordlist is sitting on 165,000 and my wordmatch is about 2,100,000. Just a little concerned with converting tables that large....
by lanzer
Sat Sep 25, 2004 8:48 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 631960

Hello arod: there is probably something i dont see, but please, humor me: issue you describe here, relate to the fact that a very read-busy table needs to be written to just to update counters. wouldnt it make more sense to create a new table that will hold the counters only? As the database was see...
by lanzer
Thu Aug 26, 2004 11:37 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 631960

Hey Lanzer, I am p3ngu!n at Gaia and it's quite a pleasure and honor to actually read some of the actual work you've done to make Gaia such a great place. Anyway, I was wondering if you even plan on upgrading Gaia to phpBB 2.2 (a massive undertaking, I presume, considering the heavy modifications y...
by lanzer
Wed Jun 30, 2004 11:06 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 631960

Fun with compound indexes

Doing the usual slow query sweep today when I noticed something that's running slow: (from doing a show processlist command, I spotted a query that's been running for 5 seconds) | 158188363 | anihq | 192.168.1.2:44763 | anihq | Query | 5 | Sending data | SELECT vote_id FROM bb_vote_voters WHERE vote...
by lanzer
Fri Jun 11, 2004 11:26 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 631960

Message archiving

As our board kept growing in size our forum started having a problem with the size of our table. Though pages does seek quite fast with the hacks made, ultimately if a user tries to pull old messages out of a really long thread we're still looking at long seek times. Another problem is that the mess...
by lanzer
Wed May 19, 2004 10:07 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 631960

Hi DavG: Can be a lot of things, most likely something to do with the code itself. Feel free to PM me with the part of the code which you added in your viewtopic.php file and I can definitely help you take a look at it. For debugging's sake, you can slip in a line like "print "$sql<BR>"; just so you...
by lanzer
Sun May 16, 2004 10:17 am
Forum: [2.0.x] MOD Requests
Topic: Is there a mod to limit sigs by a user in a thread to just 1
Replies: 3
Views: 682

To add the feature, you can edit viewtopic.php manually and find the line which says "Okay, let's do the loop..." and after that, slip in: for($i = $total_posts - 1; $i >= 0 ; $i--) { if ($postrow[$i]['user_id'] != ANONYMOUS) { $user_id = $postrow[$i]['user_id']; if ($repeat_id[$user_id] != 1) { $po...
by lanzer
Sun May 16, 2004 10:07 am
Forum: 2.0.x Discussion
Topic: Performance with InnoDB
Replies: 1
Views: 673

It really isn't that bad! lol :D The table that gets written like hell is the users table, second to that are the topic tables, and the queries that uses count on those are the stats on the index page. Just converting those to InnoDB will show performance gains. You don't want to convert everything ...
by lanzer
Sun May 16, 2004 9:53 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 631960

anyone knows how to tweak attachment mod? especially this query: Yup, I'm betting that the slowness is caused by a lack of indexing too. :? Just run mysql from the command line and run: create index attach_id on phpbb_attachments_desc (attach_id); Just finished another site update. Starting work on...
by lanzer
Sun May 16, 2004 9:42 am
Forum: 2.0.x Discussion
Topic: Bandwidth
Replies: 14
Views: 1236

One interesting note about Gzip is that once it's turned on, pages are smaller for transmission, and it would technically take less time for a user to download a page from your site.

If CPU power isn't a big concern, enabling it would be more beneficial in my perspective.

Go to advanced search