Perhaps a master/slave setup is in order? At least that way you can make it look to a read-only copy for the backups without affecting the site too much.
On 18 November 2013 21:39, Florian Effenberger < [email protected]> wrote: > Hi, > > we're currently running a larger SQL database backup, which exceeds the > currently allowed amount of parallel connections. > > Given that SQL right now uses about 30 GB (!) of RAM, I can't extend the > number of allowed connections further right now, so we have to wait until > the backup is finished. (It's 10:30 pm here, but I'm awake for a while, so > if it lasts too long, I will kill it to bring back the website.) > > Mid-term solution is to get stronger hardware, or at least put the SQL > server on a different machine. I'm still looking into what is causing the > high load. We know since when the problems occur, but sadly, it's not clear > what _what_ causes the high load - the database size seem to have grown > massively, and first investigations look like Piwik is using it heavily. I > will check with Cloph to see if that is true. > > Note that neither internal nor external e-mails, nor mailing lists, nor > the download per se is affected. > > Sorry for the inconveniences, > Florian > > -- > To unsubscribe e-mail to: [email protected] > Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to- > unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/website/ > All messages sent to this list will be publicly archived and cannot be > deleted > > -- *Andrew Cassidy BSc (Hons) MBCS SSCA* Managing Director *T <[email protected]> *03300 100 960 *F <[email protected]> *03300 100 961 *E <[email protected]> *[email protected] *W <[email protected]> *www.cassidywebservices.co.uk -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/website/ All messages sent to this list will be publicly archived and cannot be deleted
