3 ms·
How do you avoid off-chip references? As mySQL do not use query caching by default, only indexes, I guess most of the memory is HDD cache managed by the file-sy
by z3t4 8y ago
How do you avoid off-chip references? As mySQL do not use query caching by default, only indexes, I guess most of the memory is HDD cache managed by the file-system.
- lathiat 8y agoThat’s not actually true. With InnoDB the data is largely cached specifically by the database in the Buffer Pool. Of course they are using MyRocks here and while I don’t actually know I’d be very surprised if it wasn’t the same. File system cache only really helps you with reads in an ACID-ish system and write speed ups/journaling require a more actively managed cache.