MySQL is heavily tunable and some of the configuration can have significant impact on its performance. During my experiment for numa scalability I encountered one such configuration. Default configuration tends to suggest heavy contention for write workload but once tuned it helps scale MySQL by more than 2x.

Understanding the problem

I started testing write-workloads with different numa levels (1 numa [32 cores]/2 numa [64 cores]/ 4 numa [128 cores]) and observed a weird behavior.

• With increasing compute power we expected throughput to grow. The pattern is observed when we move from 1 numa to 2 numa but there is significant throughput loss (despite double compute power) when switched from 2 numa to 4 numa.
• This is exactly what we call as NUMA SCALABILITY BOTTLENECK (vs a SCALABILITY BOTTLENECK that tends to achieve optimal performance with a given set of compute and io …

Celebrate with us France's deconfinement Day by attending our MySQL Day from the beach, the park, your favorite coffee shop or from the banks of the Seine.

This is a Free conference but space is limited so register today, and join us to discover what's new with MySQL on-premises, in the cloud, the Kubernetes operator, and more.

Register now!

Agenda:
10h00 - What's new in MySQL 8.0 up to 8.0.25
10h30 - MySQL Database Service and HeatWave
11h00 - Oracle Analytics Cloud with MySQL Database Service
11h30 - Develop cloud natives applications in …

Celebrate with us France's deconfinement Day by attending our MySQL Day from the beach, the park, your favorite coffee shop or from the banks of the Seine. This is a Free conference but space is limited so register today, and join us to discover what's new with MySQL on-premises, in the cloud, the K...

Many of my students wanted to know how to write a simple PSM (Persistent Stored Module) for MySQL that saved the writes to all table as a group. So, to that end here’s simple example.

1. Create four sample tables in a re-runnable script file:

   /* Drop and create four tables. */
   DROP TABLE IF EXISTS one, two, three, four;
   CREATE TABLE one   ( id int primary key auto_increment, msg varchar(10));
   CREATE TABLE two   ( id int primary key auto_increment, msg varchar(10));
   CREATE TABLE three ( id int primary key auto_increment, msg varchar(10));
   CREATE TABLE four  ( id int primary key auto_increment, msg varchar(10));
   

2. Create a locking PSM across the four tables:

   /* Conditionally drop procedure. */
   DROP PROCEDURE IF EXISTS locking;
   
   /* Set delimiter to $$ to allow ; inside the procedure. */
   DELIMITER $$
   
   /* Create a transaction procedure. */
   CREATE PROCEDURE locking(IN pv_one   varchar(10)
                           ,IN pv_two …

Indexes in MySQL are a very complex beast. We have covered MySQL indexes in the past, but we have never taken a deeper dive into them - we will do that in these series of blog posts. This blog post should act as a very general guide to indexes while the other parts of these series will dive a little bit deeper into these subjects. 

What are Indexes?

In general, as already noted in a previous blog post about indexes, an index is an alphabetical list of records with references to the pages on which they are mentioned. In MySQL, an index is a data structure that is most commonly used to quickly find rows. You might also hear the term “keys” - it refers to indexes too.

What do Indexes Do?

In MySQL indexes are used to quickly find rows with specific column values and to prevent reading through the entire table to find …

The AWS ledger database (QLDB) is an auditors best friend and lives up to the stated description of “Amazon QLDB can be used to track each and every application data change and maintains a complete and verifiable history of changes over time.”

This presentation will go over what was done to take a MySQL application that provided auditing activity changes for key data, and how it is being migrated to QLDB.

While QLDB does use a SQL-format for DML (PartiQL), and you can perform the traditional INSERT/UPDATE/DELETE/SELECT, the ability to extend these statements to manipulate Amazon Ion data (a superset of JSON) gives you improved capabilities and statements.

Get a comparison of how to map a MySQL structure multiple tables and lots of columns into a …

MySQL Server offers, among the different security features, encryption at rest (or Transparent Data Encryption, TDE) in the commercial release (find the differences with Community here).

While testing TDE with MySQL InnoDB Cluster, I was wondering what inner mechanism was implemented to deal with TDE, master keys and keyrings, and the clone plugin. If I need to clone an instance, how would everything work so to guarantee my InnoDB Cluster instances will still be encrypted, and the keyring chosen would still use a good master key to decrypt tablespace keys and finally tablespace pages?

The answer is obviously that this is fully managed. You can add instances to …

This is the next blog in our competitor comparison series in which we look at the main solutions for MySQL high availability, disaster recovery and geographic distribution. Here we focus on highly available, geo-scale, multi-region MySQL for mission-critical sites and apps with ClusterControl as compared to MySQL clusters with Continuent Tungsten, the only complete, fully-integrated clustering solution for MySQL - on-premises, in the cloud, hybrid-cloud or multi-cloud.

Tags: clustercontrolhigh availability (HA)MySQLdisaster recovery (DR) …

May 13th is the day for the MySQL Tracks at the Percona Live  conference. 

Besides an announcement for an exciting new product, you will find sessions on:

• MySQL Server Component Manifest Files
• Insights into the new Oracle MySQL Database Service
• Oracle MySQL Database Service with HeatWave for Real-Time Analytics
• MySQL Architectures in a Nutshell
• Successfully run your MySQL NDB Cluster in Kubernetes
• Validating JSON
• Migration from 5.6 to 8.xx.xx
• Dbdeployer in action - Optimised MySQL sandboxes
• MySQL Shell for DBAs (including Dump & Load)

All opinions expressed in this blog are those of Dave Stokes who is actually amazed to find …

During many decision-making phases in programming code (conditional logic), there are times execution depends on several different factors. Multiple conditional tests are powerful and constraining, oftentimes requiring more than one test to be passed in order for program flow to proceed. For MySQL (and standard SQL in general) the CASE expression is used for IF/THEN/ELSE conditional logic. The post, MySQL Simple CASE Expression – with examples, covered Simple CASE queries which are essentially equality tests. MySQL Simple CASE is but one variant of 2, with the other being a MySQL Searched CASE Expression.  A MySQL Searched CASE Expression can have multiple conditional tests in each WHEN …