Search found 920 matches

by Oleg
Wed Dec 05, 2012 3:16 pm
Forum: [3.0.x] Support Forum
Topic: Host having to kill query that's hogging server. What to do?
Replies: 13
Views: 622

Re: Host having to kill query that's hogging server. What to

That query is not the issue then. Either it was waiting for locks held by other queries (more likely) or your server was extremely overloaded.
by Oleg
Wed Dec 05, 2012 6:32 am
Forum: [3.0.x] Support Forum
Topic: forum e-mails going to spam filter
Replies: 2
Views: 190

Re: forum e-mails going to spam filter

1. Check that you have your MTA/server correctly configured. Forward and reverse DNS, etc. 2. If you are on a shared host or send mail via an IP that also sends someone else's mail, find out who else sends what from the same IP. 3. You may be on a netblock that sends spam. Is your host reputable? Ta...
by Oleg
Wed Dec 05, 2012 6:24 am
Forum: [3.0.x] Support Forum
Topic: optimizing slow sql queries?
Replies: 14
Views: 782

Re: optimizing slow sql queries?

1) I compared the current board with an other board I own (vanilla phpbb3 up-to-date, very fast board but with only 2Gb database), the structures are exactly the same. Plus index is not missing apprently in my current board concerning last_posted_time, that you mentionned previously : http://upsimp...
by Oleg
Wed Dec 05, 2012 6:19 am
Forum: [3.0.x] Support Forum
Topic: optimizing slow sql queries?
Replies: 14
Views: 782

Re: optimizing slow sql queries?

http://upsimple.com/uploads/anonymous/wut.jpg-200.jpg ouch. Try to add an index on (topic_type, topic_last_post_time). Warning: this will take a while. http://upsimple.com/uploads/anonymous/damn.jpg-200.jpg PHP? :shock: Unfortunately because you have modifications installed it is impossible to tell...
by Oleg
Wed Dec 05, 2012 3:53 am
Forum: [3.0.x] Abandoned MODs
Topic: [ABD] GRA4 Social Network for phpBB
Replies: 65
Views: 12273

Re: [RC2] GRA4 Social Network (friends,blogs,wall,pages,etc.

It does not execute any scripts of the server side on the client side - it's pure content. So it's no more harmful than, say, picture with the number of visitors, generated by some counter (tracker), or some script showing RSS ticker inside your page. Not quite. The client passes through anything r...
by Oleg
Wed Dec 05, 2012 3:29 am
Forum: [3.0.x] Support Forum
Topic: optimizing slow sql queries?
Replies: 14
Views: 782

Re: optimizing slow sql queries?

Thank you for your help. 1) How do I add an index on last_post_time? I mean, how should I name it? I don't want to mess it up, it's very painfull to backup a 17Gb db everytime I perform a sensitive tweak on the db. First of all you should be experimenting on a local copy. Then you only need to back...
by Oleg
Wed Dec 05, 2012 12:16 am
Forum: [3.0.x] Support Forum
Topic: Spider bots are crashing my server !!
Replies: 12
Views: 2800

Re: Spider bots are crashing my server !!

ungovernable wrote: Is there a way to allow spider vots to visit my forum only once every minute ?
You can configure crawl rate in google webmaster tools. I don't know whether bing provides a similar option.
by Oleg
Tue Dec 04, 2012 11:18 am
Forum: [3.0.x] Support Forum
Topic: Host having to kill query that's hogging server. What to do?
Replies: 13
Views: 622

Re: Host having to kill query that's hogging server. What to

Take out the explain and run it and note how long it takes. At 47 rows examined it should complete in under a second.
by Oleg
Tue Dec 04, 2012 11:13 am
Forum: phpBB Discussion
Topic: Discuss: phpBB 3.0.11 released
Replies: 86
Views: 24663

Re: Discuss: phpBB 3.0.11 released

It has been 3 months since 3.0.11 was released. 3.0.x maintenance releases are made every 6-8 months or so.

http://tracker.phpbb.com/secure/IssueNa ... stId=10593
by Oleg
Tue Dec 04, 2012 11:00 am
Forum: [3.0.x] Support Forum
Topic: Benefits/downfalls of deleting inactive users?
Replies: 4
Views: 524

Re: Benefits/downfalls of deleting inactive users?

Size of users table tends to not noticeably affect performance. If these users never did anything (posts/topics/etc.) then deleting them will not make your board appreciably faster. The biggest benefit you get is the memberlist gets smaller, which some people find significant and some don't.
by Oleg
Tue Dec 04, 2012 10:52 am
Forum: [3.0.x] Support Forum
Topic: optimizing slow sql queries?
Replies: 14
Views: 782

Re: optimizing slow sql queries?

these ones take 11sec: viewtopic SELECT t.*, f.forum_name, f.enable_icons FROM (phpbb_topics t CROSS JOIN phpbb_forums f) WHERE t.forum_id = 2 AND f.forum_id = t.forum_id AND t.topic_title LIKE '%WORD%' OR '%WORD2%' OR '%WORD3%' AND t.topic_status <> 2 AND t.topic_id <> 2601592 ORDER BY t.topic_id ...
by Oleg
Tue Dec 04, 2012 10:46 am
Forum: [3.0.x] Support Forum
Topic: optimizing slow sql queries?
Replies: 14
Views: 782

Re: optimizing slow sql queries?

http://upsimple.com/uploads/anonymous/viewforum.jpg You are missing index on last_post_time on topics. https://github.com/phpbb/phpbb3/blob/develop/phpBB/install/schemas/mysql_41_schema.sql This forces a file sort. http://upsimple.com/uploads/anonymous/viewtopic.jpg - no slow queries there. You need...

Go to advanced search