-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 11.03.2010 16:21, Dag-Erling Smørgrav wrote: > Miroslav Lachman <000.fbsd_at_quip.cz> writes: >> Yes, rewriting by dd or any other way works for reallocating or >> clearing pending sectors counter, but in server environment > > In a server environment, you'd be a fool not to have some sort of > redundancy set up. > >> I need to know the affected file, as it can be for example database >> file and then it is a big problem! Rewriting the sector inside InnoDB >> ib_data file can cause DB crash, data loss etc. > > How is that different from *not* rewriting the sector? If there's a bad > sector somewhere in your data, your database is still going to crash. Only if he hasn't listened to your first advice and set it up on a non-redundant IO solution. If he's set it up on proper hardware, he'll just get a friendly mail about replacing said disk next time he's in the serverroom with a new fresh hostpare. //Svein - -- - --------+-------------------+------------------------------- /"\ |Svein Skogen | svein_at_d80.iso100.no \ / |Solberg Østli 9 | PGP Key: 0xE5E76831 X |2020 Skedsmokorset | svein_at_jernhuset.no / \ |Norway | PGP Key: 0xCE96CE13 | | svein_at_stillbilde.net ascii | | PGP Key: 0x58CD33B6 ribbon |System Admin | svein-listmail_at_stillbilde.net Campaign|stillbilde.net | PGP Key: 0x22D494A4 +-------------------+------------------------------- |msn messenger: | Mobile Phone: +47 907 03 575 |svein_at_jernhuset.no | RIPE handle: SS16503-RIPE - --------+-------------------+------------------------------- If you really are in a hurry, mail me at svein-mobile_at_stillbilde.net This mailbox goes directly to my cellphone and is checked even when I'm not in front of my computer. - ------------------------------------------------------------ Picture Gallery: https://gallery.stillbilde.net/v/svein/ - ------------------------------------------------------------ -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.12 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkuZCyQACgkQODUnwSLUlKS2ngCgqF+bE4SqHC39lYAoMpQG1Ysb IzcAoLusP1O4LV0CDoq3GSXjV3YGDLDk =Ljac -----END PGP SIGNATURE-----Received on Thu Mar 11 2010 - 14:24:06 UTC
This archive was generated by hypermail 2.4.0 : Wed May 19 2021 - 11:40:01 UTC