Example:..
Discuz 8 year old user emergency today--posted 10,000 +, 30,000 IP Forum paralyzed 2 weeks ...
http://www。.discuz。.net/thread-1257742-1-1。.html。.
Fault Forum: ...
1, the highest post of 70,000, daily average of 10,000 + gaming forums..
2, a stick of about 1000 local forums ...
Both forums are on the same server..
Failure condition:..
Server environment is Windows 2003 IIS6 ... 0+MySQL5 ... 1 ... 32+PHP5 ... 29+zend3 ... 3+Phpmyadmin3 ... 13..
Server configuration: Inter (r) Core (TM) 2 Duo CPU E4500@2.. 20GHz, 2G, 160G..
In addition to running these 2 forums, servers are running on a dozen negligible small station. These stations do not have any IP ...
Server environment is made of easydiscuz formation, 3 weeks ago, suddenly unable to start server MYSQL services, and frequent blue screen, repeatedly to repair failed, so in desperation, I have room to do a little system.
Who knew the engine room when doing system found that letter is wrong, the original c becomes e disks, the original drive d to become the c drive. E disk now has become a system disk..
And there is a problem, that is, install some software on your system there will be some trouble, so rooms pulled out after a memory (memory 1 g left), commonly used software is installed correctly, the server has also been normal ...
So I manually install MySQL5 ... 1 ... 32+PHP5 ... 29+zend3 ... 3+Phpmyadmin3 ... 13..
Temporary error occurred because the old server system, I have not had time to database backup for a 2 forums, so I direct the mydql/data directory of the original database file, copied to the new environment in the MySQL/data directory to use. However, the new server system configured PHP environment, with all the latest version of the program, than ever before with easydiscuz1 ... 0 new installed server PHP environment so directly copying the database will cause problems? ...
After installation or normal use, after 1 week of usage, the server begins PHP Web site application pool process memory intensive, and other small sites are normal, is 2 discuz Forum W3wp.. exe memory-up to about 700M, causing IIS suspended animation, server down..
I search on Baidu and DISCUZ a great deal of information, basically has to do is to do, still can't resolve..
But it's not all in this situation, sometimes, to restart IIS, application pools under dauteng or something, no problem can persist for hours, but not insist on more than 12 hours ...
The gaming forum IP a day about 30,000, in under 2 weeks of tossing, sentiment was also up at once, the Forum also is about to die ...
Suspected environmental problems, or Web site database not normal backup problems, request Discuz official help survey the real reason, grateful!..
I give kangsheng vision has been to call yesterday, phone comrades said that today will try to arrange for people to help me..
http://www。.williamlong。.info/archives/776。.html。.
Dang a blog development for famous blog of when, blog of access volume usually will very large, using using virtual host words, personal blog due to access volume had large often will and caused server performance problem, this is many people of troubles, was using canceled RSS, errors of method to resolved problem, clearly is Xia wrong drug, so for website large flow brings of problem, correctly of resolved method should is what does? Here are some of my personal summary of experience, for everybody reference..
First, make sure that the server hardware is sufficient to support the current flow..
Ordinary P4 server generally can support up to 100,000 unique IP per day, if you visit greater than this, you must first configure a higher-performance dedicated servers to resolve the problem or how to optimize cannot completely solve the performance problem ...
Second, the optimization of database access..
Server load is too large, an important cause is excessive CPU load, reducing server load on the CPU to be able to effectively break the bottleneck. Use static pages to minimize CPU load. The foreground completely static, of course, the best, can be completely without accessing the database, however, for frequently updated site, static often do not meet certain features ...
Caching technology is another solution, that is, dynamic data stored in the cache file, these files dynamic Web pages called directly, without having to access the database, WordPress and Z-Blog are a large number use this caching technology. I myself wrote a Z-Blog counter plugin is based on the principle ...
If you do not prevent access to the database, you can try to optimize database queries SQL ... avoid using Select*from such a statement, each time the query returns only one of your own results, avoid a large number of SQL queries within a short time ...
Third, prohibit external daolian..
Pictures of external Web sites or file daolian usually brings a lot of load pressure and should therefore be strictly limited external pictures or files for its own daolian, fortunately, you can simply refer to control daolian, Apache can be configured to prevent myself daolian, IIS has some third-party ISAPI can achieve the same functionality. Of course, forged refer can also be achieved through code daolian, but not many deliberate forgery refer daolian's can be the first not to think about, or the use of technical means to solve, such as increasing the picture watermark ...
IV, control the download of large files..
Downloads of large files will take a lot of traffic, and for non-SCSI hard drive, and a large number of files downloaded consumes CPU to make websites in response to the reduced capacity. Therefore, do not provide more than 2M of large file downloads as much as possible, if you want to provide, it is recommended to put large files on another server. There are many free Web 2.0 sites offer photo sharing and file sharing capabilities, so you can try to upload images and files to the shared Web site..
V, with a different main host shunt flow..
Place the file on a different host, providing a different mirror for the user to download. For example, if you feel that RSS files are taking up the flow is large, then using a service such as FeedBurner or FeedSky RSS output on a different host, so that others access the traffic pressure on the hosts that are mostly concentrated in FeedBurner, RSS does not consume too many resources..
VI, using traffic analysis and statistics software.
On the Web site to install a traffic analysis and statistics software, you can instantly know where to spend a lot of traffic, and which pages need to be optimized, so solve flow problems also need for accurate statistical analysis only. I recommend using traffic analysis and statistics software is Google Analytics (Google analysis). I feel the effect is very good in using, I take a closer look at some of Google Analytics using the knowledge and skills ...
