View Single Post
  #4  
Old 04-29-2007, 06:13 AM
bolly.beats's Avatar
bolly.beats bolly.beats is offline
 
Join Date: Aug 2006
Location: USA
Posts: 114
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by GearTripper View Post
stay away from netfirms, do research.
Hmmmm... Thanks 4 ur advice...

Can someone tell me, which host is good for my forum, coz i am faicing few problems on the server, like i m getting warnings to remove all addons. Let me show you the mail from my server.



Quote:
Hello,

I'm writing you about your database "db_forums". It is causing severe
server loads with the following query:

# User@Host: jaimesh546468897@*(&)()_(&*&%$%$@^&
# Query_time: 0 Lock_time: 0 Rows_sent: 14181 Rows_examined: 56658
SELECT thanks.*, post.userid as postuserid, user.username
FROM thanks as thanks
LEFT JOIN post as post ON (post.postid = thanks.postid)
LEFT JOIN user as user ON (user.userid = thanks.userid)
ORDER BY thanks.dateline DESC;

being ran many times a second, sometimes 20 or more of them running at
once. We can't allow one customer to interrupt service for all other
customers on a server, so I've had to disable the table for now. Please
disable whatever is running this query, or clear out lots of old data to
keep it from having to examine so many rows. If you have further
problems or questions on this issue, you can email me at
justin5@dreamhost.com.

Thanks!
Justin
Though we have resolved the issue, but still we dont want such troubles on other server. Our server load has been mentioned in the first post of this thread. So according to that. Can anyone please suggest me a better host. Also we dont wanna spend more $$$.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01238 seconds
  • Memory Usage 1,768KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete