MySQL on SSD

[Edwin DeSouza]

FaceBook FlashCache:
http://github.com/facebook/flashcache
http://www.facebook.com/note.php?note_id=388112370932
http://www.percona.com/files/presentations/UC2010-An-Overview-of-Flash-Storage-for-Databases.pdf
http://perspectives.mvdirona.com/2010/04/29/FacebookFlashcache.aspx
http://www.mysqlperformanceblog.com/2010/04/27/level-2-flash-cache-is-there/
http://www.mysqlperformanceblog.com/2010/05/10/flashcache-first-experiments/
http://www.mysqlperformanceblog.com/2010/05/18/flashcache-more-benchmarks/
http://www.mysqlperformanceblog.com/2010/05/25/flashcache-tpcc-workload/

innodb_secondary_buffer_pool
http://code.google.com/p/david-mysql-tools/wiki/innodb_secondary_buffer_pool

Some food for thoughts: How to make use of new SSD devices
http://mikaelronstrom.blogspot.com/2008/08/some-food-for-thoughts-how-to-make-use.html

Who needs hash join -- Intel SSD will soon be here
http://mysqlha.blogspot.com/2008/10/who-needs-hash-join-intel-ssd-will-soon.html

On SSDs, rotations and I/O
http://mituzas.lt/2008/11/09/on-ssd-io/

SSDs for Performance Engineers
http://blogs.sun.com/realneel/entry/ssds_for_performance_engineers

SSD vs Memory - The End is Nigh!
http://feedblog.org/2007/12/13/ssd-vs-memory-the-end-is-nigh/

SSD vs HDD: InnoDB vs MyISAM
http://feedblog.org/2008/02/03/more-ssd-vs-hdd-vs-innodb-vs-myisam-numbers/

MySQL and Intel X-25e SSD
http://www.bigdbahead.com/?p=518 (Part 1)
http://www.bigdbahead.com/?p=532 (Part 1B)

24 Hour DBT2 run on the Intel X-25M SSD
http://www.bigdbahead.com/?p=71

24 Hours with an SSD and MySQL
http://feedblog.org/2008/01/30/24-hours-with-an-ssd-and-mysql/

Independent Mtron SSD + MyISAM Benchmarks
http://feedblog.org/2008/02/09/independent-mtron-ssd-myisam-benchmarks/

Testing MySQL on the Violin Memory Flash 1010
http://www.bigdbahead.com/?p=334

MySQL Performance on a Texas Memory System RAMSAN-500 (Parts 1/2/3)
http://www.bigdbahead.com/?p=139
http://www.bigdbahead.com/?p=140
http://www.bigdbahead.com/?p=141

SSD Without noatime Mount Option Considered Harmful - HUGE Performance Boost
http://feedblog.org/2008/02/20/ssd-without-noatime-mount-option-considered-harmful-huge-performance-boost/

Final Thoughts on SSD and MySQL AKA Battleship Spinn3r
http://feedblog.org/2008/02/22/final-thoughts-on-ssd-and-mysql-aka-battleship-spinn3r/

More Details on MySQL & SSD drive performance…
http://www.bigdbahead.com/?p=37

DBT2 MySQL SSD Results
http://www.bigdbahead.com/?p=36
http://www.bigdbahead.com/?p=43
http://www.bigdbahead.com/?p=44

Sysbench Benchmark on MySQL using Solid State Drives
http://blogs.sun.com/blueprints/entry/running_sysbench_benchmark_on_mysql

Tables on SSD, Redo/Binlog/SYSTEM-tablespace on HDD
http://www.slideshare.net/matsunobu/ssd-deployment-strategies-for-mysql
http://yoshinorimatsunobu.blogspot.com/2009/05/tables-on-ssd-redobinlogsystem.html

Could SSD Mean a Rise in MyISAM Usage?
http://feedblog.org/2008/01/04/could-ssd-mean-a-rise-in-myisam-usage/

MySQL + Secure Digital = Cheap SSDs?
http://www.moocowproductions.org/blog/details.php?postid=319

Linus Torvalds: .. so I got one of the new Intel SSD's
http://torvalds-family.blogspot.com/2008/10/so-i-got-one-of-new-intel-ssds.html

Intel X25-M SSD: Intel Delivers One of the World's Fastest Drives
http://www.anandtech.com/cpuchipsets/intel/showdoc.aspx?i=3403&p=1

Intel SSD Write Cache… Is it an issue or isn’t it?
http://www.bigdbahead.com/?p=422

Intel X25-M SSD: Benchmarking MySQL
http://labs.cybozu.co.jp/blog/kazuhoatwork/2008/10/benchmarking_ssd_for_mysql.php

Future of RDBMS is RAM Clouds & SSD
http://www.igvita.com/2009/12/07/future-of-rdbms-is-ram-clouds-ssd/

SSD Peformance With Different File Systems
http://venublog.com/2009/03/12/ssd-peformance-with-different-file-systems/

Aligning filesystems to an SSD’s erase block size
http://thunk.org/tytso/blog/2009/02/20/aligning-filesystems-to-an-ssds-erase-block-size/

Helping Out SSDs
http://www.linux-mag.com/id/7599/1/
http://www.linux-mag.com/id/7599/2/

SSD’s, Journaling, and noatime/relatime
http://www.linuxfoundation.org/news-media/blogs/browse/2009/03/ssd%E2%80%99s-journaling-and-noatimerelatime

Fusion-IO and MySQL:
http://www.brentozar.com/archive/2010/03/fusion-io-iodrive-review-fusionio/
http://www.mysqlperformanceblog.com/2009/05/01/raid-vs-ssd-vs-fusionio/
http://www.mysqlperformanceblog.com/2010/03/24/raid-throughput-on-fusionio/
http://www.mysqlperformanceblog.com/2010/03/23/fsyncs-on-software-raid-on-fusionio/



Edited 29 time(s). Last edit at 11/11/2010 11:56PM by Edwin DeSouza.