A Brief Introduction to MySQL Transactions
In this article, you will learn about transactions, their properties, transactional control commands, and how to use them in MySQL.
7 months ago
MySQL
MySQL
public
Temporary Tables in MySQL: A High-level Overview
In MySQL, temporary tables are usually created automatically and only considered when certain types of problems arise. This post outlines when and why MySQL uses temporary tables and how you can avoid them.
7 months ago
How To Secure MySQL 8 with SSL/TLS on Ubuntu 20.04
By default, MySQL is configured to only allow connections from the local system. If you want to connect to a MySQL server from a remote system, it is recommended to secure it with SSL/TLS. Enabling SSL/TLS will encrypt the data being sent to and from the database.
7 months ago
Set Up MySQL 8 Replication with Linux Nodes
This guide will show you how to set up a 2 node replication server by configuring mysqld.
7 months ago
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.
7 months 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.
8 months ago
MySQL
public
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.
8 months ago
Performance
public
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.
8 months ago
Featured
public
Performance
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.
8 months ago