NOTE: If you want to read and play with the interactive application, please go
href="https://3manuek.shinyapps.io/FTS_Innodb/">to the shinnyapps article. It has been developed using Shiny/R in order to allow you to see the effects of the algorithms.
Thanks to Valerie Parham-Thompson at Pythian and Daniel Prince at Oracle.
href="https://github.com/3manuek/fts_article">Github repository contains the code to generate and load the data and also, the Shiny/R code.
Since documentation is not very clear to me on the topic of InnoDB flushing in combination with Linux IO (specifically the write system call), I decided to put together this article in hopes of shedding some light on the matter.