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.
In this article, you will learn about transactions, their properties, transactional control commands, and how to use them in MySQL.
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.
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.
This guide will show you how to set up a 2 node replication server by configuring mysqld.
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.
This blog post will go over some of the things you can do to optimize your MySQL (or MariaDB) instances for TEXT-type data.
This article will demonstrate the differences between LOAD DATA INFILE and INSERT and explain when you should use both for data entry in MySQL.
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.
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.