MySQL on SSD
Posted by: Edwin DeSouza
Date: January 31, 2008 09:27AM
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.
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.
Subject
Written By
Posted
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.