Search found 30 matches

by parsim
Mon Jan 05, 2015 5:30 am
Forum: Extension Writers Discussion
Topic: How to create an Avatar Driver?
Replies: 2
Views: 1306

How to create an Avatar Driver?

In 3.0, our forum uses a three-line MOD to specify a different server for hosting user avatar images. It's incredibly simple: it just prepends the server name to the beginning of the avatar path. But I can't figure out how to do this in 3.1. We don't need to worry about how avatars get set; that's h...
by parsim
Sun Nov 09, 2014 1:41 am
Forum: phpBB Discussion
Topic: Where is the "View Your Posts" link at the top?
Replies: 36
Views: 2434

Re: Where is the "View Your Posts" link at the top?

Must say, I think hiding "View your posts" behind an extra click is a terrible mistake. I run a forum with a little under 20 million posts, doing many million pageviews per month, and "View your posts" is the #1 most viewed page, comprising 15% of all forum traffic: 15%: /search.php?search_id=egose...
by parsim
Tue Oct 28, 2014 4:38 am
Forum: phpBB Discussion
Topic: Where is the "View Your Posts" link at the top?
Replies: 36
Views: 2434

Re: Where is the "View Your Posts" link at the top?

Must say, I think hiding "View your posts" behind an extra click is a terrible mistake. I run a forum with a little under 20 million posts, doing many million pageviews per month, and "View your posts" is the #1 most viewed page, comprising 15% of all forum traffic: 15%: /search.php?search_id=egosea...
by parsim
Wed May 16, 2012 4:08 am
Forum: phpBB Discussion
Topic: [3.0.x] Tweaks for large forums
Replies: 204
Views: 48572

Re: [3.0.x] Tweaks for large forums

Derky wrote:Please create a bug report about this
Done.
by parsim
Fri May 11, 2012 6:04 am
Forum: phpBB Discussion
Topic: [3.0.x] Tweaks for large forums
Replies: 204
Views: 48572

Re: [3.0.x] Tweaks for large forums

I notice the "View unanswered posts" function generates a database query that can't use any indexes, requiring a full table scan of phpbb_topics: mysql> EXPLAIN SELECT DISTINCT t.topic_last_post_time, p.topic_id FROM phpbb_posts p, phpbb_topics t WHERE t.topic_replies = 0 AND t.topic_moved_id = 0 AN...
by parsim
Fri May 11, 2012 2:54 am
Forum: [3.0.x] Support Forum
Topic: Large forum, MySQL slow on particular query
Replies: 19
Views: 10454

Re: Large forum, MySQL slow on particular query

I think you would benefit from converting some of the tables like posts, forums, users, topics and sessions to InnoDB. Those are the tables which see a lot of concurrent read/writes and row-level locking should give you better performance IMO. Thanks for the advice! I have wondered about this. It's...
by parsim
Fri May 11, 2012 1:41 am
Forum: [3.0.x] Support Forum
Topic: Large forum, MySQL slow on particular query
Replies: 19
Views: 10454

Re: Large forum, MySQL slow on particular query

But I noticed here that: "For data blocks, MySQL uses no special cache. Instead it relies on the native operating system file system cache." So this struck me as an explanation for why I have a database server bogged down in I/O even though it has plenty of free RAM. That is applicable for MyISAM t...
by parsim
Thu May 10, 2012 11:41 pm
Forum: [3.0.x] Support Forum
Topic: Large forum, MySQL slow on particular query
Replies: 19
Views: 10454

Re: Large forum, MySQL slow on particular query

Your database should not be keeping the entire dataset in memory. Indexes should hopefully be kept in memory, and for actual rows the database should be hitting the disk. If your indexes are getting swapped out of memory you might need to tune something or make the indexes smaller or cut some out. ...
by parsim
Thu May 10, 2012 11:08 pm
Forum: [3.0.x] MODs in Development
Topic: [Beta] Sphinx search for phpBB 1.0.beta2
Replies: 294
Views: 91908

Re: [Beta] Sphinx search for phpBB 1.0.beta2

Hi, is this working with phpBB 3.0.8-3.0.10 and Sphinx 2.0.4 ? What vrsion should I download? This one https://github.com/figvam/sphinx-for-phpbb or this https://github.com/phpbb/sphinx-for-phpbb ? It's worked for me on every version of phpBB and Sphinx I've ever tried. Currently working with phpBB...
by parsim
Thu May 10, 2012 6:31 am
Forum: [3.0.x] Support Forum
Topic: Large forum, MySQL slow on particular query
Replies: 19
Views: 10454

Re: Large forum, MySQL slow on particular query

Sorry to be such a noob, but what is a good way to benchmark that? I know I can avoid the key buffer with SQL_NO_CACHE, but I think my slower queries occur because MySQL relies on the filesystem cache for data. My forum database size is 6.9GB, and the server has 7.5GB of memory; add in the key buffe...
by parsim
Thu May 10, 2012 5:54 am
Forum: [3.0.x] Support Forum
Topic: Large forum, MySQL slow on particular query
Replies: 19
Views: 10454

Re: Large forum, MySQL slow on particular query

Thanks for the reply!

I've submitted a MySQL bug. Hope that's the right place.
by parsim
Sun May 06, 2012 1:06 am
Forum: [3.0.x] Support Forum
Topic: Large forum, MySQL slow on particular query
Replies: 19
Views: 10454

Re: Large forum, MySQL slow on particular query

I should mention, I did actually go ahead and add 'IGNORE INDEX(forum_id)' to the query starting at line 83 in viewtopic.php on our production box, and that query has vanished from our mysql-slow.log. Disk activity is still quite high, but very noticeably lower than before.
by parsim
Sun May 06, 2012 12:58 am
Forum: [3.0.x] Support Forum
Topic: Large forum, MySQL slow on particular query
Replies: 19
Views: 10454

Re: Large forum, MySQL slow on particular query

Thank you very much for the replies! Did you run analyze table after changing indexes? I did, yes. But to be sure, I went back and recreated the indexes and tried it again (see below). Are you giving mysql enough memory? Yes. I'm trying things on both a live production server and a cloned test serve...
by parsim
Fri May 04, 2012 5:58 am
Forum: [3.0.x] Support Forum
Topic: Large forum, MySQL slow on particular query
Replies: 19
Views: 10454

Re: Large forum, MySQL slow on particular query

Reporting back as promised. If you are on mysql < 5.5 I would suggest upgrading to 5.5 before doing anything else as I hear they have added some optimizer improvements. Done! We are now running 5.5.22-0ubuntu1-log. Unfortunately, there is no noticeable improvement. You can probably replace the index...
by parsim
Thu Apr 05, 2012 11:41 pm
Forum: [3.0.x] Support Forum
Topic: Large forum, MySQL slow on particular query
Replies: 19
Views: 10454

Re: Large forum, MySQL slow on particular query

Thank you very much!

We are running MySQL 5.1.61 on Ubuntu 10.04, so I guess it's time for an OS upgrade. I'll give this a shot and report back.

Edit: Which will probably be in a month or two, as we'll try to go direct from Ubuntu 10.04 LTS to 12.04 LTS.

Go to advanced search