The tag has no wiki summary.

learn more… | top users | synonyms

128
votes
4answers
40k views

LVM dangers and caveats

I have recently started using LVM on some servers for hard drives larger than 1 TB. They're useful, expandable and quite easy to install. However, I could not find any data about the dangers and ...
14
votes
6answers
8k views

SATA Disks that handle write caching properly?

It's pretty common to see advice to disable the write cache on individual disks used for databases because otherwise some disks will acknowledge writes that haven't yet made it to the disk surface. ...
5
votes
2answers
3k views

It is XFS reliable? In case of a power gone off is xfs riskier that ext3 in data corruption/safey?

I have been having some electrical issues,mostly power going out suddenly for a few months,and although ups solve the thing mostly. But still i am worried about filesystem corruption,and data lost. ...
5
votes
3answers
4k views

Making SATA disk write cache safe

Supposedly (see, e.g., a question about it here), with NCQ enabled drives, the drive write cache is supposed to be safe, as in it doesn't like to the OS about data being committed to the platters when ...
2
votes
2answers
621 views

What happens to InnoDB and MyISAM tables if the power fails during a transaction?

We have two MySQL tables, one is InnoDB and the other is MyISAM. If I execute a chunk of inserts in a single transaction on both tables and the power fails in the middle, what will be the status? ...