mysql

When and How Best to Index Data?

Dive deep into ways to best index your data and learn how to mysql if index does not exist create…

1 week ago

How to Load Billions of Records Into MySQL? MySQL INSERT Explained

Dive deep into ways to load big data sets into MySQL with BreachDirectory. From MySQL INSERT operations to LOAD DATA…

1 week ago

Can the SQL EXPLAIN Statement be a DoS Vector?

Can the SQL EXPLAIN statement be a DoS vector and how to mitigate this threat? Find out here.

1 week ago

Where Does MySQL Get Its Host?

Where does MySQL get its host? This question is asked by many novices and experienced MySQL DBAs alike. Dig into…

6 months ago

Don’t Perform a MySQL Update After MySQL 8.0.37!

If you run thousands of tables, don't perform any MySQL update beyond MySQL 8.0.37, at least for now. Read this…

6 months ago

PostgreSQL vs MySQL: A Comparison

In this PostgreSQL vs MySQL blog, we walk you through when to choose PostgreSQL or MySQL for your use case.

8 months ago

Protecting MySQL Beyond mysql_secure_installation: A Guide

In this blog, we walk you through how to protect your MySQL instances beyond using mysql_secure_installation.

2 years ago

MyISAM vs. InnoDB: The Problem

In this blog post, we tell you how does MyISAM compare with InnoDB.

2 years ago

Choosing Character Sets in MySQL: A Short Guide

In this blog, we will look a little closer into the character sets available in MySQL – we will tell…

2 years ago