#mysql

Articles tagged with #mysql

Learn MySQL Internals and Query Performance Optimization Techniques
Over the course of the past few months, I have been publishing articles summarizing a really nice book called High Performance MySQL. I have only posted about the first 7 chapters which I think are the most essential ones for anyone learning relation...
Jul 10, 20215 min read1.5K
High Performance MySQL [Ch.7: Advanced MySQL Features]
So in the previous chapter we discussed query performance optimization techniques such as, improving data access types or restructuring queries. In this chapter will go over some of the advanced features that MySQL has to offer and see how we can lev...
Jun 19, 202113 min read1.9K
Amazon Aurora: MySQL on Steroids
A couple of weeks, I published a series of three articles explaining two papers published by the AWS Aurora team. The papers discussed the internal design of Aurora and the design considerations for building high throughput cloud-native database. The...
Jun 15, 20212 min read788
High Performance MySQL [Ch.6 | Part 2: Query Performance Optimization]
So in the last article, we discussed the first part of chapter 6 of High Performance MySQL where we talked about how schema design optimization and indexing are necessary for good performance but not solely enough as you still need to write optimized...
May 19, 202114 min read1.6K
High Performance MySQL [Ch.6 | Part 1: Query Performance Optimization]
So the last article discussed chapter 5 of High Performance MySQL titled Indexing for High Performance. Today's article discusses chapter 6 titled Query Performance Optimization. In last two chapters we discussed schema design optimization and indexi...
Apr 17, 202114 min read2.1K
High Performance MySQL [Ch.5: Indexing for High Performance]
So the last article discussed chapter 4 of High Performance MySQL titled Optimizing Schema and Data Types. Today's article discusses chapter 5 titled Indexing for High Performance. In the last chapter we discussed schema design choices and optimizati...
Apr 17, 202129 min read10K