I launched a site based upon Drupal 7.14 with at least 100 simultaneous users accessing the site at all times.
From the Devel module, I see that every page is generating about 200 to 400 Mysql requests.
First question: Is that a lot with 5 customs blocks per page?
With the full caching system for anonymous user, the site is running smoothly.
I had to make two updates. For that, I put the site in maintenance mode, made my modifications and uploading new files, flushed the cache and put the site live again. The first update did not generate any issues. But the second one, my MySQL server crashed due to a huge amount of simultaneous requests.
So how to avoid the flushing of all pages and updating properly JS, CSS and templates files? What's is the correct workflow? Because after the maintenance, if 10 users request a non-cached page, it's more likely that the server won't be able to handle the load.
Does Drupal automatically regenerate the page cache if a JS, CSS or template associated file has been changed? So, is no flushing needed? The page would be correctly regenerated according to the cache configuration?
Here the server specifications:
ProLiant DL360 G5 CPU Intel Xeon 5133 (dual core) 2GHz RAM 2×512Mb DDR2