phpBB • Free and Open Source Forum Software

Ok, thanks!

I assumed (perhaps incorrectly) that the output of the RSS Feed was cached, so that it wouldn't be regenerated every time someone viewed it. Just seems to me like without a cache that would be a lot of extra load on the DB.

Philip

Can someone tell me if the rss feed has any cache settings, and if so how do I adjust them? I looked on the Feed Settings page, but didn't see anything, nor did I find anything when searching the phpBB support forum on this (only on mods).

Thanks,
Philip

nn - Thank you for all your help! I've learned quite alot about database optimization from your guidance, and am happy to report that all seems good on the board now. No more cpu spikes, even before I added caching! :) I will take your advice and lower the refresh time on the rss from 60 minutes dow...

Explain output is below mysql> explain SELECT f.forum_id,f.forum_name, f.forum_desc_options, t.topic_title, t.topic_id,t.topic_last_post_id,t.topic_last_poster_name, p.post_time, p.post_text, p.bbcode_uid, p.bbcode_bitfield, u.username, u.user_id FROM phpbb3_forums f,phpbb3_topics t, phpbb3_posts p,...

Hi nn - After running the analyze on phpbb3_topics, I did get different results: +----+-------------+-------+--------+-------------------------------------------------------+---------+---------+--------------------------------------+-------+-------------------------------+ | id | select_type | table...

Hi nn - Oops, sorry I didn't put the times in last time. I ran it again and here is the execution time: 30 rows in set (0.58 sec). The other two queries had identical times. Getting all the rows: 10431 rows in set (0.80 sec) I then ran the analyze command as requested. Here is the output: mysql> ana...

Hi nn - I checked the rss mod, and it does indeed have the query that you asked me about. I've attached a copy of the php file it uses. It looks pretty harmless, but I'm no expert. I've temporarily removed the rss file to prevent it from being invoked to see if it prevents the error from recurring i...

Hi nn - Three files are attached, each one containing the "explain" results, as well as the same query without the "explain". I only had one mod installed, simple_rss_1.0.4. However, I think most of the changes for this mod were overwritten when I did my last upgrade. I'll double-check the mod to se...

Here you go: id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra 1 | SIMPLE | f | ALL | PRIMARY | NULL | NULL | NULL | 22 | Using temporary; Using filesort 1 | SIMPLE | t | ref | forum_id,forum_id_type,forum_appr_last,fid_time_moved | forum_id_type | 3 | primarydb.f....

Here is the output of verbose process list. Thanks again for the help!

Philip

Hi nn - thanks for the quick reply. Here is the info you requested: 1. there are about 49,000 posts on the board. 2. the phpbb3 tables are all MyISAM...is that what you are asking? 3. no spike yet, but will run 'show full processlist' as soon as it happens 4. I do have root privs on the system, and ...

Hi - I've been having an issue where my MySQL db cpu spikes about once every day or two. When this happens, the db becomes unresponsive for about 10-20 min, then clears up on its own. Looking at the db, it looks like it is trying to access locked phpBB3 tables. I was a few patches behind, so i tried...

Thanks to everyone for (1) the hack to show the old links (2) the understanding of the impact of putting in the hack. DavidIQ - I know you mentioned that the PR is generally not very important, and I agree that the PR on its own probably isn't. But I have many pages that have been highly indexed and...

Well, I am happy that the URL didn't change too much...but isn't the addition of the "f=id" enough to still make it seem like a different page to search engines? Wouldn't the old pages get unindexed, in favor of the newer (and therefore lower rank) pages?
Philip