Search found 19 matches

by philipissa
Tue Dec 21, 2010 9:27 pm
Forum: [3.0.x] Support Forum
Topic: Rss Feed caching
Replies: 4
Views: 86

Re: Rss Feed caching

Ok, thanks!
by philipissa
Tue Dec 21, 2010 9:20 pm
Forum: [3.0.x] Support Forum
Topic: Rss Feed caching
Replies: 4
Views: 86

Re: Rss Feed caching

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
by philipissa
Tue Dec 21, 2010 4:02 pm
Forum: [3.0.x] Support Forum
Topic: Rss Feed caching
Replies: 4
Views: 86

Rss Feed caching

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
by philipissa
Thu Apr 22, 2010 3:11 pm
Forum: [3.0.x] Support Forum
Topic: DB locking causing cpu spike
Replies: 18
Views: 2162

Re: DB locking causing cpu spike

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...
by philipissa
Tue Apr 20, 2010 5:29 pm
Forum: [3.0.x] Support Forum
Topic: DB locking causing cpu spike
Replies: 18
Views: 2162

Re: DB locking causing cpu spike

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,...
by philipissa
Tue Apr 20, 2010 1:49 am
Forum: [3.0.x] Support Forum
Topic: DB locking causing cpu spike
Replies: 18
Views: 2162

Re: DB locking causing cpu spike

Hi nn - After running the analyze on phpbb3_topics, I did get different results: +----+-------------+-------+--------+-------------------------------------------------------+---------+---------+--------------------------------------+-------+-------------------------------+ | id | select_type | table...
by philipissa
Sun Apr 18, 2010 7:12 pm
Forum: [3.0.x] Support Forum
Topic: DB locking causing cpu spike
Replies: 18
Views: 2162

Re: DB locking causing cpu spike

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...
by philipissa
Sat Apr 17, 2010 10:47 pm
Forum: [3.0.x] Support Forum
Topic: DB locking causing cpu spike
Replies: 18
Views: 2162

Re: DB locking causing cpu spike

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...
by philipissa
Sat Apr 17, 2010 9:53 pm
Forum: [3.0.x] Support Forum
Topic: DB locking causing cpu spike
Replies: 18
Views: 2162

Re: DB locking causing cpu spike

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...
by philipissa
Thu Apr 15, 2010 4:42 pm
Forum: [3.0.x] Support Forum
Topic: DB locking causing cpu spike
Replies: 18
Views: 2162

Re: DB locking causing cpu spike

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....
by philipissa
Thu Apr 15, 2010 1:45 am
Forum: [3.0.x] Support Forum
Topic: DB locking causing cpu spike
Replies: 18
Views: 2162

Re: DB locking causing cpu spike

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

Philip
by philipissa
Wed Apr 14, 2010 2:50 am
Forum: [3.0.x] Support Forum
Topic: DB locking causing cpu spike
Replies: 18
Views: 2162

Re: DB locking causing cpu spike

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 ...
by philipissa
Tue Apr 13, 2010 5:04 pm
Forum: [3.0.x] Support Forum
Topic: DB locking causing cpu spike
Replies: 18
Views: 2162

DB locking causing cpu spike

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...
by philipissa
Sat Oct 18, 2008 2:29 pm
Forum: [3.0.x] Support Forum
Topic: upgrading to phpbb3 without losing pagerank
Replies: 13
Views: 7840

Re: upgrading to phpbb3 without losing pagerank

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...
by philipissa
Sat Oct 18, 2008 3:43 am
Forum: [3.0.x] Support Forum
Topic: upgrading to phpbb3 without losing pagerank
Replies: 13
Views: 7840

Re: upgrading to phpbb3 without losing pagerank

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

Go to advanced search