Quote:
Originally Posted by GearTripper
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 $$$.