localhost 18 Sleep ?

[edi67]

I need your help again today i had problems of connections with my forum ( crazyzone.biz ) often there was message:

Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.

Well i wrote to my hosting service and them told me this:

Your site is using too much database connections. Please optimize your scripts, some of your scripts using mysql_pconnect
The script is index.php and it is long problem. Your scripts always used too much database connections

Id User Host/IP Time Cmd
200785 crazyzone localhost 0 Sleep
200787 crazyzone localhost 0 Sleep
200776 crazyzone localhost 3 Sleep
200768 crazyzone localhost 4 Sleep
200769 crazyzone localhost 4 Sleep
200771 crazyzone localhost 4 Sleep
200772 crazyzone localhost 4 Sleep
200759 crazyzone localhost 5 Sleep
200761 crazyzone localhost 5 Sleep
200762 crazyzone localhost 5 Sleep
200763 crazyzone localhost 5 Sleep
200764 crazyzone localhost 5 Sleep
200765 crazyzone localhost 5 Sleep
200766 crazyzone localhost 5 Sleep
200767 crazyzone localhost 5 Sleep
200758 crazyzone localhost 6 Sleep
200718 crazyzone localhost 18 Sleep
200723 crazyzone localhost 18 Sleep

Well i have this hosting by months, and never had such problem, today only , but is strange this because i dont made nothing change, i dont add nothing in my index.php so i cannot understand what made this problem, users are always the same 6 or 7 more but always the same.

Please somebody could help me to find one solution or may be understand if my hosting service tell me not correct things for make me pay more for performance?

i cannot find solution i cannot find the script that make problem.

i hope that somebody can help me.

thx again

[Oranos]

There's nothing wrong with your files. It's just your host pointing fingers at the software because their cheap, overloaded servers can't handle something as basic as a user connecting to a forum. I recommend you find yourself a new host...

[edi67]

There's nothing wrong with your files. It's just your host pointing fingers at the software because their cheap, overloaded servers can't handle something as basic as a user connecting to a forum. I recommend you find yourself a new host...

really you think that ?

[Oranos]

Yes, I do.

[edi67]

listen them wrote me this now:

"We are too often see such messages form CMS supporters with un-optimized code.
We are limiting resources to prevent overloading by few users. You can check loading via ssh with "top" command. "

what means?

[Oranos]

It means that they can't tell the difference between a content management system, and a forum, which is rather sad in my opinion. Just think of it this way, you pay them to host your site with them. They do NOT want you to leave their hosting no matter what because they'd be losing money. So even if they know they are at fault, it doesn't matter. They will blame anything except for themselves, because they want your money. As for me, well, SMF is free. You don't pay to use it. No one here benefits from you using it, especially not me. I honestly couldn't care less what forum software you use. What I mean by that is that I'm not blaming your host because I want you to like SMF. I'm blaming your host because they truly are a pile of crap. There are THOUSANDS of users who use SMF on shared servers, probably with a bigger database than you, but they don't overload. Why? Because their host doesn't suck

Trust me, you'll be MUCH better off finding a better host. If you want, I can give you my personal recommendation via PM. I won't post it here as I don't want anyone to think I'm advertising for them.

[Masterd]

There's nothing wrong with your files. It's just your host pointing fingers at the software because their cheap, overloaded servers can't handle something as basic as a user connecting to a forum. I recommend you find yourself a new host...

That will be a solution.

[edi67]

tha for support  ( i wrote you pm )

here them last reply

My question:
I really dont understand this situation for MONTHS was ok and NOW in one day i have all this problem scripts etc etc WITHOUT DONT MADE any change in my code index.php.
Sorry but Is so strange for me understand

Reply:
probably you have big amount of new users/search bots.

"Good" bots - yes. It is bots from search engines and they're using robots.txt file as rule. But if you're will limit them - this will not good for SEO of your site.

Via .htaccess you can limit every IP adress from visiting your website (as result - from generating mysql requests). Resources like http://banstran.ru/ can help you to understand how to do it (sorry, but http://banstran.ru/ is russian resource).

Something like this in .htaccess will block 41.200.0.0/15 IPs form visiting your website.
ErrorDocument 403 http://example.ru/you_are_blocked.html
<Limit GET HEAD POST>
order allow,deny
deny from 41.200.0.0/15
allow from all
</LIMIT>

i can advice you to look through http://crazyzone.biz/webstat/ and check statistics for last days. Maybe this will help to find new "bad" bots.

Also reason can be that you have new slow queries. Normally queries take sth like 0.1 second to execute. So you can execute huge amount of them per minute and formally - huge amount of users can be online at website. But if each user generates query which executes 30 seconds - it blockes new mysql queries for you (not cause of 1 slow query, off course). It can be cause you have some overloaded tables (for example 10.000 strings) and query which read this table without any filtres

[Oranos]

All I can say is FAIL...I hope you will take my suggestion in my PM, for you see, the reason I want you to get away from that host is because I want your forum to run smoothly on a reliable server with a great host