Hello Ceriel, It may be in firmware or in driver or not implemented at all. It is also possible that I provide obsolete hints, I haven't monitored SSD new for a year and one year is a very long time in this industry.
Anyway, all you need is to make relatively frequent full backups and reserve some money for a second SSD (or for pile of HDDs). Even in case of partial failure the SSD will remain very useful for transaction logs and temporary files. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com On Mon, 2009-10-26 at 19:52 +0100, Ceriel Jacobs wrote: > Hi Ivan, > > On Thu, 22 Oct 2009 21:19:01 +0700 Ivan Mikhailov wrote: > > > In addition, I should warn you that SSD's lifetime under any database > > application can be smaller than expected, depending on OS and drivers. > > That's due to the nature of file I/O in databases. Some smart drivers > > try to balance numbers of writes to individual blocks > > Isn't this "wear leveling" done from the firmware inside the SSD drive, > or do you mean something different? > > Best, > ~Ceriel > > > --- a new version > > of file is written on blank space, not on place that is already > > occupied > > by the file or its previous copy. They promise even more sophisticated > > logic in the future (say, if a big movie is written only once to the > > disk and it occupies half of device whereas second half of space is > > nearly out of resource then the movie will be placed in heavily used > > half and frequently changed data will reside in almost new blocks used > > for the movie before). That tricks do not work if file exists > > continuously, like database file, and changes are frequent. > > > ------------------------------------------------------------------------------ > Come build with us! The BlackBerry(R) Developer Conference in SF, CA > is the only developer event you need to attend this year. Jumpstart your > developing skills, take BlackBerry mobile applications to market and stay > ahead of the curve. Join us from November 9 - 12, 2009. Register now! > http://p.sf.net/sfu/devconference > _______________________________________________ > Virtuoso-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
