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.
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.
Indexing MySQL For High Performance: A High-level Overview
Some MySQL engineers might call them the cornerstone of improving performance in MySQL: indexes are data structures that are frequently used to quickly find rows matching a given query.
Monitor PostgreSQL Performance Using a Database Health Dashboard
A PostgreSQL database health dashboard allows us to monitor the database in real-time and helps us to more fully understand some features which are unique to PostgreSQL.