503 Errors and Search. *Updated and HELP Needed*

**Wideawake** · #1 (**permalink**) 07-29-2007, 11:56 PM

Ok anyone wanna help with this one. Im no php expert nor do I know whats going on here but I just recieved a letter from our host complaining about our db. Heres the letter, if anyone can help please drop ur suggestions here!
Thanks,
Mike

Quote:

Hello,

This query is running on your ppcgeeks database and causing high server
loads. It needs to be fixed soon because it is causing slowness and high
loads, if it isn't and causes further issues I will need to disable the
database. If you have further questions you can write me at
xx@dreamhost.com. If the query can't be optimized, then sorry but
the database is too inefficient for shared hosting, and you will need to
look at a VPS or dedicated solution:

http://dreamhost.com/dedicated-hosting.html

# User@Host: user[user] @ geyser.dreamhost.com [208.97.183.12]

# Query_time: 93 Lock_time: 0 Rows_sent: 15 Rows_examined: 267055

SELECT f.forum_name, t.topic_title, u.user_id, u.username, u.user_sig,
u.user_sig_bbcode_uid, p.post_id, pt.post_te

xt, pt.post_subject, pt.bbcode_uid, p.post_time, t.topic_replies,
t.topic_first_post_id

FROM phpbb_forums AS f, phpbb_topics AS t, phpbb_users AS u,
phpbb_posts AS p, phpbb_posts_text as pt

WHERE

t.forum_id = f.forum_id

AND f.auth_view = 0

AND p.poster_id = u.user_id

AND pt.post_id = p.post_id

AND p.topic_id = t.topic_id

ORDER BY p.post_time DESC LIMIT 15;

Thanks!

Justin

**bunnytrigger** · #2 (**permalink**) 07-30-2007, 01:03 AM

rgr, i checked it out earlier, it was really screwy, thank you for fixing it

**Pibe38** · #3 (**permalink**) 07-30-2007, 01:17 AM

I feel the site loading faster already!

**stroths** · #4 (**permalink**) 07-30-2007, 06:47 AM

The 503s have been pretty constant this weekend as well as this morning.

jax0m · #5 (**permalink**) 07-30-2007, 08:21 AM

Please fix the 503's. It's driving your users nuckin' futz!

**blazingwolf** · #6 (**permalink**) 07-30-2007, 11:33 AM

Yeah they are getting to be a pain. I could not get on the site at all for the last couple of hours because of them.

Vertigo · #7 (**permalink**) 07-30-2007, 11:35 AM

Thank you Wideawake! I Was having withdraws w/o the site!

**Wideawake** · #8 (**permalink**) 07-30-2007, 11:39 AM

Updated the first post and need u users that know sql, php, and phpbbs help! If anyone wants to help please send me a pm or reply here!
Thanks,
Mike

**jamesus** · #9 (**permalink**) 07-30-2007, 11:39 AM

Site running quickly now...still need help? I might have someone I can ask if it is still needed...

brightedge · #10 (**permalink**) 07-30-2007, 11:41 AM

Quote:

Originally Posted by Wideawake

Ok anyone wanna help with this one. Im no php expert nor do I know whats going on here but I just recieved a letter from our host complaining about our db. Heres the letter, if anyone can help please drop ur suggestions here!
Thanks,
Mike

Mike,

I ran across a topic in the phpbb community forum that may help to alleviate some of the performance issues.

http://www.phpbb.com/community/viewt...st=0&sk=t&sd=a

Paul