Search found 331 matches

by EverettB
Wed May 30, 2012 2:20 pm
Forum: phpBB Discussion
Topic: [3.0.x] Tweaks for large forums
Replies: 204
Views: 47302

Re: [3.0.x] Tweaks for large forums

I was interested so I looked at the code and you could move that NOT IN logic to the code. I see it's doing a NOT IN for all the banned user ids. Run the query, then skip all those banned ids in the loops right afterward (there are 2 loops) OR Let it load up notify_rows array in both of the loops it...
by EverettB
Wed Feb 15, 2012 5:25 pm
Forum: phpBB Discussion
Topic: Backing up you forum
Replies: 18
Views: 2467

Re: Backing up you forum

I don't know but I am guessing the page may time out.

Of course, this can depend on many factors - speed of server, speed of database, if you have a shared server, etc.
by EverettB
Wed Feb 15, 2012 12:22 am
Forum: phpBB Discussion
Topic: Backing up you forum
Replies: 18
Views: 2467

Re: Backing up you forum

Big John wrote:I just go to the Maintenace Tab in the ACP and c;ick on Backup. Is this way ok?
This should work until you have a lot of posts. Maybe 100,000?
by EverettB
Mon Feb 13, 2012 6:59 pm
Forum: phpBB Discussion
Topic: Backing up you forum
Replies: 18
Views: 2467

Re: Backing up you forum

I use a cron job with mysqldump to back up the critical data every night and download it to my local computer every morning. I turn the site off for 10 minutes and use mysqlhotcopy when I want a full back up. In terms of attachments/user uploads, I do a file copy to another "new" directory on every ...
by EverettB
Thu Jul 14, 2011 5:24 am
Forum: [3.0.x] Convertors
Topic: How to change POSTS table SQL for fast phpBB3 conversion?
Replies: 6
Views: 884

Re: How to change POSTS table SQL for fast phpBB3 conversion

Yes, as the table got more and more full, it began inserting less posts before it refreshed the screen. The 16 hours was for the POSTS only. The entire process took 20 hours. I did run OPTIMIZE and ANALYZE on the posts table a few times in the middle just for the heck of it, which did seem to boost ...
by EverettB
Sat Jul 09, 2011 10:21 pm
Forum: [3.0.x] Convertors
Topic: Convert search_wordlist from phpBB2 -> phpBB3, no rebuild
Replies: 4
Views: 880

Re: Convert search_wordlist from phpBB2 -> phpBB3, no rebuil

Thank you for the additional information.
by EverettB
Sat Jul 09, 2011 5:57 am
Forum: [3.0.x] Convertors
Topic: Convert search_wordlist from phpBB2 -> phpBB3, no rebuild
Replies: 4
Views: 880

Re: Convert search_wordlist from phpBB2 -> phpBB3, no rebuil

Thanks for the response. I have over 4.5 Million posts and from what I can tell, it is going to take about a week to rebuild the search index. I have been running it locally as a test and it started out doing 40-50 posts/second but after a few million, now it's doing about 7-10 posts/second. 7 posts...
by EverettB
Sat Jul 09, 2011 12:44 am
Forum: [3.0.x] Convertors
Topic: Convert search_wordlist from phpBB2 -> phpBB3, no rebuild
Replies: 4
Views: 880

Convert search_wordlist from phpBB2 -> phpBB3, no rebuild

I am looking at migrating my phpBB2 Forum to phpBB3. I have over 4.5 Million posts and from what I can tell, it is going to take about a week to rebuild the search index. I have been running it locally as a test and it started out doing 40-50 posts/second but after a few million, now it's doing abou...
by EverettB
Sat Jul 09, 2011 12:12 am
Forum: [3.0.x] Convertors
Topic: How to change POSTS table SQL for fast phpBB3 conversion?
Replies: 6
Views: 884

Re: How to change POSTS table SQL for fast phpBB3 conversion

To post a follow-up, everything seems to have converted successfully and much faster, although not as fast I was expecting as there is still a speed issue with the actual insert of rows into the new phpBB3 POSTS table once it gets a few million records. With 4.5M posts, the time was reduced from ove...
by EverettB
Tue Jul 05, 2011 7:55 pm
Forum: [3.0.x] Convertors
Topic: How to change POSTS table SQL for fast phpBB3 conversion?
Replies: 6
Views: 884

Re: How to change POSTS table SQL for fast phpBB3 conversion

Thanks, that seems to be working for speeding up that part of the query. I replaced $___result = $src_db->sql_query_limit($sql, $convert->batch_size, $skip_rows); with if (strpos($sql, "FROM phpbb_posts posts, phpbb_posts_text posts_text") === FALSE) { $___result = $src_db->sql_query_limit($sql, $co...
by EverettB
Tue Jul 05, 2011 6:05 pm
Forum: [3.0.x] Convertors
Topic: How to change POSTS table SQL for fast phpBB3 conversion?
Replies: 6
Views: 884

How to change POSTS table SQL for fast phpBB3 conversion?

I have a 2.0 board I am looking at converting to 3.0. It has 4.5 million posts. I'm using mySQL 5.1 on a dedicated server I set up my local machine and ran a test conversion locally. It took about 24 hours just to do the POSTS table conversion. The rest of the tables take a few hours so no big deal ...
by EverettB
Mon Jun 08, 2009 6:19 pm
Forum: phpBB Discussion
Topic: Whats the size of phpbb.com's database?
Replies: 13
Views: 806

Re: Whats the size of phpbb.com's database?

I've been always wondering if mysql can work fine with such a big database Did you guys tried to dump and restore this database with this size through mysqldump command? it will work fine? I have a 5GB database on my site, no problems. I use mysqlhotcopy for backups. mysqldump for the InnoDB tables...
by EverettB
Sat Jun 14, 2008 3:09 am
Forum: [2.0.x] MOD Database Releases
Topic: Log IP Address on Registration
Replies: 1060
Views: 204428

Re: Log IP Address on Registration

Got it, that's a good idea, I need that too. I think this is what you want: I changed the static IP text in the user admin screen to be a link to the admin_ip_search page. In admin_users.php FIND $user_regip = decode_ip($this_userdata['user_regip']); REPLACE WITH $user_regip = decode_ip($this_userda...
by EverettB
Sat May 03, 2008 4:19 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 630365

Re: phpBB tweaks for large forums

I think with a fixed amount of 50-100,000 posts you will be ok implementing a phrase-type search. I would try using a full-text index in mySQL before doing a large rewrite. As a comparison, there is a separate non-Forums portion of my site that I have made searchable that hovers around 50,000 active...

Go to advanced search