MySQL Forums
Forum List  »  MySQL & Storage

MySQL on SSD
Posted by: Edwin DeSouza
Date: January 31, 2008 09:27AM

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.

Options: ReplyQuote


Subject
Written By
Posted
MySQL on SSD
January 31, 2008 09:27AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.