Posted by Vadim |
… nice benchmarks where InnoDB on
SSD outperforms RAID 10, but recently…times – come on, it’s
SSD, we should have much more…conclusion to warranty Durability with
SSD we have to disable write…Possible solution could be put
SSD into RAID controller with battery…
Posted by Vadim |
…random reads:
I’d say
SSDs show comparable results with FusionIO…percona.com/docs/wiki/benchmark:
ssd:start, in summary table, randwr…is hard task for both
SSDs and FusionIO, it does not…writes
Complexity of having 8
SSD drives may be significant. You…
Posted by Vadim |
… on board; Intel X25-E
SSD connected to HighPoint controller, FusionIO … results:
RAID10 – 7439.850 TPM
SSD – 10681.050 TPM
FusionIO – 17372…lost-transactions/).
While results for
SSD (note it is single device…5.2$ per GB.
For
SSD I can get 32GB card…
Posted by mike |
…,
With regard to Q34 about
SSD. There are vendors that have onboard RAM cache incorporated into their
SSD.
The first vendor of … to hear comments about using
SSD from a vendor
like BitMicro … my log files to
SSD unless the
SSD incorporated an onboard …
Posted by
mike @ 11:37 am ::
Innodb ::
Posted by peter |
… writes. Sequential Reads single Intel
SSD will have speed similar to…Writes are more expensive for
SSDs so for Sequential Writes standard…low latency for writes. The
SSDs as I see write directly…with battery or capacitors but
SSD do not get the leverage…
Posted by Robert Young |
…sites have gobs of information about
SSDs:
–
SSD news and history (some test…3667&p=1
Points about
SSD;
- NAND is commodity; Samsung parts … Point: don’t bother using
SSD if all you’re doing …a lot). the real win with
SSD is being able to run …
Posted by peter |
… the log file group and the
SSD dynamic wear leveling algorithm. I’m…wondering if you would recommend using
SSD for this purpose, and how … Log files is not something
SSD can give the main benefit … so much faster than Flash.
SSD Drives would be big win …
Posted by
peter @ 11:37 am ::
Innodb ::
Posted by Devananda |
… 8 disk RAID10 and 2 32GB
SSDs used for ZIL and L2ARC, 72G… that this system is using 2
SSD’s for the ZIL and L2ARC,… as everyone should know by now,
SSD’s lifetime is determined by the…shorter lifetime, and so a shorter
SSD lifetime is a negative side effect…
Posted by peter |
… interesting thing to tune Innodb for
SSD devices. In fact I think we … to specify if we’re working with
SSD or normal device because a lot … pages is a good idea on
SSD, also you can do read ahead … copy on write file systems which are often in use with
SSD.
Posted by Baron Schwartz |
…my opinion that a database truly designed for
SSD simply doesn’t exist.
Also realize that
SSD is a Flash device with a hard-drive-emulation in front… memory and hard drive” or “memory plus
SSD.”
SSD might only be an interim technology as…