/explore
|
You are here 
|
major.io | ||
| | | | |
www.ajfriesen.com
How to migrate the Ghost MySQL database collation from MySQL 5.7 default to MySQL 8.0 default. |
|
| | | | | ||
| | | | |
vitess.io
An in-depth technical discussion on the limitations of foreign keys in MySQL and why the can't play nicely with online DDL |
|
| | | | | ||
| | | | |
antzucaro.com
The Scenario Let's suppose you are modeling a database in MySQL 5.5. Based on your knowledge of the requirements for the application behind this database you can guess which of the tables within it are going to be huge. For those huge tables you want to plan ahead to make sure that you can scale out your data such that you have less headaches in the future. Here's the catch: you want to keep it simple until it comes time to scale out. |
|
| | | | | ||
| | | | |
www.crunchydata.com
What is a sequential scan vs index scan vs parallel scan .... and what is a bitmap heap scan? Postgres scan types explained and diagrammed. |
|
| | | |||
