PPCGeeks Forums HTC Arrive HTC HD2 HTC Thunderbolt HTC Touch Pro 2 HTC Evo 4G HTC Evo 3D Samsung Galaxy S II Motorola Droid X Apple iPhone Blackberry
Go Back   PPCGeeks > Site Information > Site News & Announcements

Notices



Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 07-29-2007, 11:56 PM
Wideawake's Avatar
Founder & Owner
Offline
Pocket PC: iPhone 6S Plus
Carrier: Sprint
Location: Clayton, NC
 
Join Date: May 2006
Posts: 5,569
Reputation: 4614
Wideawake should be added to the payroll for their contributionsWideawake should be added to the payroll for their contributionsWideawake should be added to the payroll for their contributionsWideawake should be added to the payroll for their contributionsWideawake should be added to the payroll for their contributionsWideawake should be added to the payroll for their contributionsWideawake should be added to the payroll for their contributionsWideawake should be added to the payroll for their contributionsWideawake should be added to the payroll for their contributionsWideawake should be added to the payroll for their contributionsWideawake should be added to the payroll for their contributions
Mentioned: 8 Post(s)
Tagged: 0 Thread(s)
Send a message via Skype™ to Wideawake
503 Errors and Search. *Updated and HELP Needed*

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
__________________
Please read this before posting.

Reply With Quote
  #2 (permalink)  
Old 07-30-2007, 01:03 AM
bunnytrigger's Avatar
Retired Staff
Offline
Pocket PC: HTC Touch Pro
Carrier: Sprint
Location: Jonesboro, AR
 
Join Date: May 2006
Posts: 1,387
Reputation: 225
bunnytrigger is keeping up the good workbunnytrigger is keeping up the good workbunnytrigger is keeping up the good work
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Send a message via AIM to bunnytrigger Send a message via MSN to bunnytrigger Send a message via Yahoo to bunnytrigger Send a message via Skype™ to bunnytrigger
rgr, i checked it out earlier, it was really screwy, thank you for fixing it
__________________
If you ever reach total enlightment while drinking beer, I bet you could shoot beer out of your nose

haven't you heard? corporations are the new government. They're constitutionally-exempt.

92% of teens have moved onto WoW. if you are part of the 8% that still play REAL games, copy n paste



Reply With Quote
  #3 (permalink)  
Old 07-30-2007, 01:17 AM
Pibe38's Avatar
The Enforcer
Offline
Pocket PC: Samsung Epic 4G, ViewSonic gTablet, BB Bold 9650
Carrier: Sprint
Location: O-Town
 
Join Date: Sep 2006
Posts: 4,311
Reputation: 2571
Pibe38 is a VIPPibe38 is a VIPPibe38 is a VIPPibe38 is a VIPPibe38 is a VIPPibe38 is a VIPPibe38 is a VIPPibe38 is a VIPPibe38 is a VIPPibe38 is a VIPPibe38 is a VIP
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
I feel the site loading faster already!
__________________
Samsung Epic 4G - LegendaryROM / Samurai kernel
ViewSonic gTablet - Flashback Honeycomb Alpha 10.1

---
Don't forget to Search first!
Reply With Quote
  #4 (permalink)  
Old 07-30-2007, 06:47 AM
stroths's Avatar
VIP & Master of my Domain
Offline
Pocket PC: HTC Evo 4g
Carrier: Sprint
Location: Dallas area
 
Join Date: Oct 2006
Posts: 1,370
Reputation: 2008
stroths is a VIPstroths is a VIPstroths is a VIPstroths is a VIPstroths is a VIPstroths is a VIPstroths is a VIPstroths is a VIPstroths is a VIPstroths is a VIPstroths is a VIP
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
The 503s have been pretty constant this weekend as well as this morning.
__________________
Treo 600 -> Treo 650 ->Treo 700p -> Treo 700wx -> Mogul -> Touch Pro -> Touch Pro 2 -> HTC Evo
- [Guide] Get Root access & NAND Unlock your Evo (Full Root)
- My Current AppBrain List

Reply With Quote
  #5 (permalink)  
Old 07-30-2007, 08:21 AM
jax0m's Avatar
Lurker
Offline
Location: Iraq
 
Join Date: Jul 2007
Posts: 3
Reputation: 0
jax0m is a n00b
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Send a message via AIM to jax0m
God

Please fix the 503's. It's driving your users nuckin' futz!
__________________
PPC 6700
Reply With Quote
  #6 (permalink)  
Old 07-30-2007, 11:33 AM
blazingwolf's Avatar
VIP Member
Offline
Pocket PC: Samsung Omnia i910
Carrier: Verizon
 
Join Date: Dec 2006
Posts: 2,599
Reputation: 3495
blazingwolf is still contributing even after becoming a VIPblazingwolf is still contributing even after becoming a VIPblazingwolf is still contributing even after becoming a VIPblazingwolf is still contributing even after becoming a VIPblazingwolf is still contributing even after becoming a VIPblazingwolf is still contributing even after becoming a VIPblazingwolf is still contributing even after becoming a VIPblazingwolf is still contributing even after becoming a VIPblazingwolf is still contributing even after becoming a VIPblazingwolf is still contributing even after becoming a VIPblazingwolf is still contributing even after becoming a VIP
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
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.
__________________
Moto Droid
I make ROMs because I like to. If you want to buy me a Pepsi though: Donate

Follow me on mytabletlife.com
Reply With Quote
  #7 (permalink)  
Old 07-30-2007, 11:35 AM
Vertigo's Avatar
Halfway to VIP Status
Offline
Pocket PC: Evo 3D
Carrier: Sprint
Location: East Islip, NY
 
Join Date: Mar 2007
Posts: 653
Reputation: 420
Vertigo is becoming a PPCGeeks regularVertigo is becoming a PPCGeeks regularVertigo is becoming a PPCGeeks regularVertigo is becoming a PPCGeeks regularVertigo is becoming a PPCGeeks regular
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Thank you Wideawake! I Was having withdraws w/o the site!
__________________
Reply With Quote
  #8 (permalink)  
Old 07-30-2007, 11:39 AM
Wideawake's Avatar
Founder & Owner
Offline
Pocket PC: iPhone 6S Plus
Carrier: Sprint
Threadstarter
Location: Clayton, NC
 
Join Date: May 2006
Posts: 5,569
Reputation: 4614
Wideawake should be added to the payroll for their contributionsWideawake should be added to the payroll for their contributionsWideawake should be added to the payroll for their contributionsWideawake should be added to the payroll for their contributionsWideawake should be added to the payroll for their contributionsWideawake should be added to the payroll for their contributionsWideawake should be added to the payroll for their contributionsWideawake should be added to the payroll for their contributionsWideawake should be added to the payroll for their contributionsWideawake should be added to the payroll for their contributionsWideawake should be added to the payroll for their contributions
Mentioned: 8 Post(s)
Tagged: 0 Thread(s)
Send a message via Skype™ to Wideawake
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
Reply With Quote
  #9 (permalink)  
Old 07-30-2007, 11:39 AM
jamesus's Avatar
VIP Member
Offline
Pocket PC: HTC Mogul, HTC Apache
Carrier: Sprint
Location: Chicago, IL
 
Join Date: Sep 2006
Posts: 3,345
Reputation: 556
jamesus knows their stuffjamesus knows their stuffjamesus knows their stuffjamesus knows their stuffjamesus knows their stuffjamesus knows their stuff
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Send a message via AIM to jamesus Send a message via Yahoo to jamesus
Site running quickly now...still need help? I might have someone I can ask if it is still needed...
__________________
Device History: PPC 6800 (Mogul) < PPC 6700 < PPC 6600 < iPAQ 2200 Series < Palm 505 < Pen & Paper





A mass of tears have transformed to stones now sharpened on suffering and woven into slings...
Reply With Quote
  #10 (permalink)  
Old 07-30-2007, 11:41 AM
brightedge's Avatar
Regular 'Geeker
Offline
Pocket PC: Touch Pro
Carrier: Sprint
Location: Columbus, OH
 
Join Date: Feb 2007
Posts: 418
Reputation: 140
brightedge is keeping up the good workbrightedge is keeping up the good work
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Re: 503 Errors and Search. *Updated and HELP Needed*

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
__________________
One ROM to rule them all,
One ROM to find them.
One ROM to bring them all,
And in the kitchen, bind them.
Reply With Quote
Reply

  PPCGeeks > Site Information > Site News & Announcements

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT -4. The time now is 01:38 AM.


Powered by vBulletin® ©2000 - 2019, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.6.0
©2012 - PPCGeeks.com