Set Up MySQL 8 Master-Slave Replication on Ubuntu 20.04
This guide will show you how to set up a MySQL 8 Master-Slave replication on Ubuntu 20.04.
4 days ago
MySQL
How to Partition MySQL Tables
Would it be strange to eat a whole pizza, starting from the crust and working your way inward? Similar to slicing a pizza before eating it, table partitioning is the process of dividing huge tables into smaller tables so that data can be more easily and efficiently queried.
13 days ago
Optimizing MySQL and MariaDB for TEXT: A Guide
This blog post will go over some of the things you can do to optimize your MySQL (or MariaDB) instances for TEXT-type data.
20 days ago
LOAD DATA INFILE vs. INSERT in MySQL: Why, How, When?
This article will demonstrate the differences between LOAD DATA INFILE and INSERT and explain when you should use both for data entry in MySQL.
25 days ago
The Basics of MySQL Query Caching
MySQL's Query Cache is incredibly versatile. It’s usually able to store a wide variety of values and return them from the memory (rather than the disk) to improve query execution times. This guide will explore the usages and limitations of query caching.
a month ago
Featured
MySQL
Slow Query Basics: Why Are Queries Slow?
Slow query performance is a huge thing—so much so that modern database performance optimization techniques are in large part targeted at mitigating slow queries. Surprising? We think not.
a month ago
Unused Indexes in MySQL: A Basic Guide
Indexes are frequent friends for SELECT queries; however, if we want to use indexes, we must ensure that our database instances use them first. Indexes that are not utilized by our database instances are useless – they waste space and make INSERT, UPDATE, and DELETE queries slower.
a month ago
A Guide to MySQL JOINS
Large quantities of data are often stored in MySQL databases. Analysts and DBAs are constantly required to extract records from two or more tables based on specific requirements in order to evaluate that data quickly. This is when JOINS come in handy.
a month ago
Nostalgia: What Happened to MyISAM?
Before InnoDB replaced it, MyISAM was one of the flagship storage engines available in MySQL. However, as time moved on, InnoDB replaced it as MySQL engineers found it to be a better choice.
2 months ago