I’ve been using Alan Beaulieu’s Learning SQL to teach my SQL Development class with MySQL 8. It’s a great book overall but Chapter 12 lacks a complete exercise. Here’s all that the author provides to the reader. This is inadequate for most readers to work with to solve the concept of a transaction.

Exercise 12-1

Generate a unit of work to transfer $50 from account 123 to account 789. You will need to insert two rows into the transaction table and update two rows in the account table. Use the following table definitions/data:

                      Account:
account_id     avail_balance    last_activity_date
-----------    --------------   ------------------
       123               450    2019-07-10 20:53:27
       789               125    2019-06-22 15:18:35

                      Transaction:
txn_id    txn_date      account_id    txn_type_cd    amount
------    ----------    -------+--    -----------    ------
  1001 …

MySQL HeatWave Faster Point-in-time Recovery

Though we try our best to avoid it, it's easy to let underperforming queries slip through the cracks in our workloads, negatively impacting the performance of a database system. This is especially true in large-scale database environments, with many gigabytes or terabytes of data, hundreds of tables, and thousands of query patterns being executed on a daily basis.

Thankfully, MySQL has the ability to collect data that can be leveraged for identifying problematic queries, and can also do profiling on them in order to drill into their poor performance. In this article, I'll go over several built-in techniques for how to do this in native MySQL. If you use PlanetScale, this type of information can be gathered more easily and intuitively using the PlanetScale Insights dashboard. I'll include a brief discussion of this feature later on.

For this …

Any Galera documentation about limitations will state that tables must have primary keys. They state that DELETEs are unsupported and other DMLs could have unwanted side-effects such as inconsistent ordering: rows can appear in different order on different nodes in your cluster.If you are not actively relying on row orders, this could seem acceptable. Deletes […]

MySQL is a free, open-source, relational database management platform powered by Oracle Cloud. This tutorial will show you how to install MySQL 8 on Ubuntu 22.04 server.

Today, accessing and managing databases remotely is a fundamental skill for developers, system administrators, and anyone working with data-driven applications. In this article, we will demonstrate how to establish an SSH connection to a MySQL database on a DigitalOcean Droplet—a virtual private server that can host various applications and databases.

The post How to Connect to a MySQL Database on a DigitalOcean Droplet Using dbForge Studio appeared first on Devart Blog.

The latest Episode of MySQL Shorts is now available! Check out Episode 59 on the MySQL YouTube Channel to learn how to import data from a csv file into a MySQL database using MySQL Shell.

Episode #59 of MySQL Shorts in now available!

Duplicates pose an ongoing risk to the data consistency and the overall database efficiency. This article will explore the issue of duplicate records, including their origins, the effects they have on databases, and strategies for swiftly detecting and permanently removing duplicates.

The post How to Remove Duplicate Rows in MySQL appeared first on Devart Blog.

The MySQL Heatwave Service (MHS) in Oracle Cloud Infrastructure (OCI) includes a backup feature for MySQL HeatWave database systems (DB systems). However, these backups are scheduled either once in every 24 hours or can be created on-demand. If any event occurs in between to alter the data, the customer could potentially loose data worth minutes […]