MyFlashSQL: Flash is more than faster-harddisk
We are witnessing the advent of all-flash era. As pure read/write block device, flash SSD simply outperforms harddisk in terms of IOPS and cost-effectiveness. But this is not the whole story. As IO device, flash SSD has many different characteristics: to name a few, asymmetric read/write performance, abundant internal parallelism and an indirect address mapping layer, called FTL. We (SKKU MyFlashSQL Team) have been optimizing MySQL by leveraging these characteristics of flash SSD. In this talk, we will review a set of flash-based optimization techniques prototyped in MyFlashSQL and share their performance effects on various classes of commercial SSDs using two popular benchmarks, TPC-C and LinkBench. Hopefully, this will give more insights to flash-optimized research and practice in MySQL community. * Brief review of SSD characteristics * How to accelerate secondary index scan by exploiting SSD parallelism * How to remove the stall of single-page flush by taking new read/write protocol * How to avoid double write using new SSD interface, SHARE * Further directions
Professor, Sungkyunkwan University
Sang-Won Lee is a Professor in the College of Software at Sungkyunkwan University, Korea. Before that, he was a research professor at Ewha Women University and a technical staff at Oracle, Korea. He received a Ph.D degree from the Computer Science Department of Seoul National University in 1999. His research interest is in next-generation database and system software technology for non-volatile-memory including flash memory and NVDIMM. He has published several papers on flash-based database and system software in ACM SIGMOD, VLDB, and USENIX FAST conference.