MySQL Forums
Forum List  »  InnoDB

Re: How to disable write cache in every way on mysql / innodb?
Posted by: Peter Brawley
Date: September 01, 2018 04:16PM

The design objectives you're asking about, eg get rid of all buffering, flush everything instantly &c, aren't realistic with a multiuser transactional database system. And in general, a system whose power can be disconnected often & arbitrarily isn't suitable for storing a relational database.

Mostly, we want relational databases on reliable servers with uninterruptible power supplies, automatic backup calibrated to minimise data loss from hardware and software crashes, often replication, and many other failover provisions.

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.