Looking for host: in their own right
S o, was unfortunately now again long hiatus on the blog, but have since begun the semester break, I vow to improve 
To my problem: I'm actually with my hosting service from her very happy, but he just gets the flooding of one of my forum (SMF) is not under control - too many queries to the MySQL database server is always full in the knee. This started by a couple of months bots and spam scripts, so I've got pretty much all via htaccess and robots.txt kicked out -. Which of course has its drawbacks. All stories are on a dedicated server, so I do not share it with others.
Does anyone have good experience with a host done in the "high number of hits on database" made? My traffic is so in the direction of 60 GB / month. For advice, I would be very grateful!
PS: If someone can do something with it - SMF indicates that the Forum could work together with the following cache accelerators:
* APC
* EAccelerator
* Turck MMCache
* MemCache
* Zend Platform / Performance Suite (not Zend Optimizer)
3 Comments
Submit my comment
Feed readers:
Translator
 |  |  |  | ||||||||||||||||||||||||||||||||||||||
Since you are using Mysql, I think you have a forum PHP on base. Theoretically, a forum on CGI (latest version only) can create or servlet-based remedy, because there are no individual is repeatedly calling for the calls, such a program will start only once and simultaneously manages everything. Aussedem you have to own a database management (MySQL without'm not sure?)
Otherwise, I could only suggest the move to another expensive server.
But am not omniscient, so I would recommend to you more information.
So I can recommend eAccelerator, who runs with us and also for Debian Etch probably get updated very often (unofficial packages, so that the previous hoster that would get relatively easily installed). Ansonste would be a 2nd Server offering, takes over the database, then the load is distributed much more.
60GB is even yet not really a lot of traffic.
Just once installed APC ( http://pecl.php.net/apc ), so that PHP can be accelerated by 50% (but is on the Anwednung) on.
Memcache must support the application, otherwise it can not accelerate, but this seems to be the case with you.
Regards,
Martin