Showing entries 1 to 10 of 43
10 Older Entries »
Displaying posts with tag: engineering (reset)
The MySQL adaptive hash index

The adaptive hash index help to improve performance of the already-fast B-tree lookups

Profiling memory usage in MySQL

Learn how to visualize the memory usage of a MySQL connection

Identifying and profiling problematic MySQL queries

MySQL has built-in functionality for collecting statistics on and profiling your MySQL queries. Learn how to leverage these features to identify problems.

The Problem with Using a UUID Primary Key in MySQL

Understand the different versions of UUIDs and why using them as a primary key in MySQL can hurt database performance.

Three common MySQL database design mistakes

Learn about a few common mistakes when designing your MySQL database schema.

Working with Geospatial Features in MySQL

In this blog post, we explore how complex data and geographic features can be represented in MySQL.

MySQL isolation levels and how they work

Learn about the various isolation levels used by MySQL to allow concurrency in your database.

Upgrading GitHub.com to MySQL 8.0

Over 15 years ago, GitHub started as a Ruby on Rails application with a single MySQL database. Since then, GitHub has evolved its MySQL architecture to meet the scaling and resiliency needs of the platform—including building for high availability, implementing testing automation, and partitioning the data. Today, MySQL remains a core part of GitHub’s infrastructure and our relational database of choice.

This is the story of how we upgraded our fleet of 1200+ MySQL hosts to 8.0. Upgrading the fleet with no impact to our Service Level Objectives (SLO) was no small feat–planning, testing and the upgrade itself took over a year and …

[Read more]
Three surprising benefits of sharding a MySQL database

There is more to sharding than simply increasing data throughput. In this article, we explore three different benefits of sharding your database.

MySQL replication: Best practices and considerations

Learn the best practices for configuring MySQL replication, and how to ensure your data is always available.

Showing entries 1 to 10 of 43
10 Older Entries »