After almost a year I am at 18 TBW on my system/data SSD and that includes several re-installs of Windows plus a bunch of VM updates of the Windows "Insider" previews, so getting to 1200 TBW would be quite a task ... (Note, defrag does not run on SSDs since it is useless, but I have forced that more than once as just to see how it worked).
--- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Rowan Worth >Sent: Monday, 18 June, 2018 22:42 >To: SQLite mailing list >Subject: Re: [sqlite] Strange Corruption Issue > >Between updates, automatic maintenance, registry churn, event logs, >and >background "optimisations" I reckon windows could give 400G/day a run >for >its money :P > >-Rowan > >On 19 June 2018 at 12:37, Keith Medcalf <kmedc...@dessus.com> wrote: > >> >> The new "consumer" SSDs from Samsung carry a 1200 TBW/8 year >warranty on a >> 4 TB device. That is a lot of writing for a "consumer desktop" >computer >> ... that is about 400 GB written per DAY every day for 8 years! >> >> --- >> The fact that there's a Highway to Hell but only a Stairway to >Heaven says >> a lot about anticipated traffic volume. >> >> >> >-----Original Message----- >> >From: sqlite-users [mailto:sqlite-users- >> >boun...@mailinglists.sqlite.org] On Behalf Of Scott Doctor >> >Sent: Monday, 18 June, 2018 22:27 >> >To: sqlite-users@mailinglists.sqlite.org >> >Subject: Re: [sqlite] Strange Corruption Issue >> > >> >SSD's have a limited number of write cycles. You may have a >> >failing SSD. Those are still, IMO, another 5-10 years before >> >they solve the write lifetime reliabilty issue. >> > >> >------------------------- >> >Scott Doctor >> >sc...@scottdoctor.com >> >------------------------- >> > >> >On 6/18/2018 20:15, Patrick Herbst wrote: >> >> I'm using sqlite in an embedded application, running on SSD. >> >> >> >> journal_mode=persist >> >> so that it is more resilient to loss of power. >> >> >> >> I'm seeing corruption. I'm using sqlite to log events on the >> >system, >> >> and the corruption is well in the middle of a power session; not >at >> >> the tail end of log when a power loss might occur. >> >> >> >> What i'm seeing is just a few pages corrupted with random bits >> >being >> >> flipped. looking in a hex editor I can see the corrupted data, >and >> >> where I can tell what values it SHOULD be, I see that they're >> >wrong, >> >> but only by a single bit flip.... in random bytes here and >there. >> >for >> >> example a "A" is "a", or a "E" is "A". These are all changes of >a >> >> single bit. there are far more examples... but in pretty much >> >every >> >> case (even when RowID's are wrong) its just off by a bit. >> >> >> >> I'm using sqlite 3.7 (i know, old, but this this system is old). >> >Has >> >> anyone else seen random bit flips? Any idea what could be >causing >> >it? >> >> _______________________________________________ >> >> sqlite-users mailing list >> >> sqlite-users@mailinglists.sqlite.org >> >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite- >> >users >> > >> >_______________________________________________ >> >sqlite-users mailing list >> >sqlite-users@mailinglists.sqlite.org >> >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite- >users >> >> >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite- >users >> >_______________________________________________ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users