Gridpane question here (feel free to direct me to a more appropriate group)… We had a Facebook post go viral the other day and it hammered our Gridpane web server. I was looking for ways to reduce the server load, and ultimately built a new server. While examining /var/log/mysql/error.log I noticed it was complaining about not having binary logs, so I took a look at /etc/mysql/mysql.conf.d/mysqld.cnf and noticed that it now contains the disable_log_bin directive. So my question is: what was the thinking behind disabling binary logs for MySQL?
read more Best web hosting reddit 2020
Answers:
It’s mostly because fill up their drives with unnecessary logging. And when the drive gets full, MySQL goes down.
But at least at that point it doesn’t fill the drive up any further.
While all of your uncached sites are down. You can change it certainly. It’s just a bit safer overall, across more use cases.
Binary logs bloat up like crazy as it’s logging all transactions happening in the database. As in literally all. It’s used to recreate databases or “mirror” them out when you have a load balancing type setup. So yeah, it’s wise to disable binary logs on very busy sites.
Read more best web hosting au 2020