MySQL 5.6 includes some new features in the performance schema, specifically for collecting query performance data. This creates new opportunities to inspect queries, but itself it's very useful, as ...

In database management, optimizing MySQL queries is not just a best practice—it’s necessary for achieving high performance and resource efficiency. The MySQL EXPLAIN statement is one of the most ...

One of the ways we measure applications is through performance. One of the metrics for application performance is user experience, which generally translates to “did the user need to wait longer than ...

This is the final post in a 3-part series about MySQL monitoring. Part 1 explores the key metrics available from MySQL, and Part 2 explains how to collect those metrics. If you’ve already read our ...

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 ...

MySQL and PostgreSQL are two of the most used open source SQL databases, and both fulfill the role of a general-purpose database well. How do you choose which one to use for a project? Let's look at ...

CIOs and IT department heads are used to the idea of doing more with less, but if your business relies heavily on relational database management systems (RDBMSs), there’s a pretty good chance you ...