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.
