StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>This is a foolish policy.</p> <p>Here's why:</p> <ul> <li><p>If you need to reboot a server weekly (and somehow it adds to your infrastructure's stability), you are covering up the real problem with a server or its software. A memory leak? A bad driver? The solution to these problems are to <em>fix</em> them, not cover them up with a lazy policy.</p></li> <li><p>Servers often get rebooted for updates, at least in the Windows world. Rebooting for critical kernel updates happens anyway.</p></li> <li><p>Database servers cache a lot of information in RAM. When you reboot your server, this cache gets empty and very cold. Assuming you have a typical usage pattern, a cold, empty cache will result in slow performance for users when they attempt their queries after a reboot. It <em>may</em> also increase the time needed to perform some types of maintenance like backups because the disk may need to be accessed more.</p></li> <li><p>Your servers go down! Your maintenance windows for backups and other things get shortened because your server is off for some nonzero period of time. You also may end up having to tell your users that you will have downtime, depending on your systems' architecture.</p></li> <li><p>Assuming you have some sort of notification system for alerting, you will have to configure it to ignore your downtime window. This can mask problems that happen around the time your server reboots, and adds to the amount of configuration you will need to do on your servers.</p></li> </ul> <p>That being said, reboots sometimes are beneficial as a last resort on resources that you don't necessarily have full control over (old vendor-written software, "black box" devices where explicitly prescribed by the vendor, etc...). But this should be handled on a case by case basis, and not with a naive blanket policy.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload