Ledjohnny was right, 000webhosting is pretty shitty. Not only for the down-times, but the bullshit reasons on account cancellation.
So, I have good forum set-up for my friend's gmod clan and server. 53 members, a good amount of posts per board and shit like that. Apart from SMF databases time-outs, it was doing fine. Until they sent me emails apperantly in-which I did not check them. Stating that I am:
Slow MySQL queries are not allowed, because you share server resources with thousands of other users and your long lasting MySQL queries are slowering the server and other users are having MySQL performance and connectivity problems. Please optimize your MySQL queries as soon as possible.
Here are some good articles how to optimize MySQL queries: http://www.google.com/search?q=optimize+mysql+queries
Good tips how you can optimize your scripts and make our servers run faster:
- Disable all parts of your website that allows anonymous posting, such as open forums, guestbooks. These days automated software fills all open areas of web with junk and content spam and increasing your database size.
- Disable visitors monitoring and tracking (each move of your visitor makes database query)
- Disable all unused modules
- Disable internal stats for your website - use http://www.google.com/analytics/ for example
- You may also logon to the phpMyAdmin and check which table has the most records. Then, if you think that this table does not contain any valuable information (such as logs, stats or cache), you can click on the `Empty` or `Truncate` icon to clean it.
We thank you for understanding,
www.000webhost.com
They never said they would cancel my account because of it. I guess it's my fault for not-attending the issue, and not knowing much about php/mysql databases but they could have gave me a warning about it, to backup my database so I have all my users, posts, themes, icons and crap like that saved for a new transfer.
So I guess after 9 months of pretty good hosting, they decide to pull this.
I'm hoping to god x10 hosting is an improvement.
