The MySQL SELECT statement controls which columns and values appear in query results, making it one of the most important ...
Multi version concurrency control plays an important role in deciding relational databases. Each database management system ...
In database management, it’s easy to assume that newer technologies are always better. While many database solutions have gained popularity in recent years, MySQL—one of the oldest and most widely ...
At some point, you’re going to need to connect to a MySQL 8 database remotely to manage your databases. Here’s how to make this possible. Recently, I was tasked to add a MySQL database GUI for a ...
A missing quote made MySQL scan 7.2 million rows. Here's how EXPLAIN exposed the problem and what it taught us about safe ...
A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...
In May of 2025, MySQL celebrated its 30th anniversary. Not many technology projects go strong for three decades, let alone at the level of use that MySQL enjoys. MySQL is listed at #2 on the ...
A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...
Grafana needs data to be useful. Phil Hajjar walks you through the process of using a MySQL database as a source for data visualization in Grafana. Grafana is one of the most widely-used interactive ...
A quick, step-by-step guide to setting up, configuring, and managing a MySQL database server on Windows, Linux, and macOS. Long a staple of open source computing, MySQL serves as the database back end ...