Ideas, releases, practical guides, and perspectives from the people building with MySQL.
I encountered this error, “Error in my_thread_global_end(): xx threads didn’t exit“, while working on MySQL benchmarking using sysbench. In this blog I’ll share my experience, reveal the fix, and help…
The post MySQL Benchmarking and error in my_thread_global_end() first appeared on Change Is Inevitable.
MySQL Heatwave User camp is back! The engineering team will will talk about the latest and greatest in MySQL Heatwave. Listen to talks about Machine Learning, HA and Lakehouse on the cloud while knowing about Docker, Kubernetes and Performance tuning on-prem. Will will also introduce our latest Javascript Stored procedures while keeping you updated with […]
MySQL HeatWave User Camp Bangalore
In a previous blog post, we've advertised the use of SQL EXISTS rather than COUNT(*) to check for existence of a value in SQL. I.e. to check if in the Sakila database, actors called WAHLBERG have played in any films, instead of: SELECT count(*) FROM actor a JOIN film_actor fa USING (actor_id) WHERE a.last_name = … Continue reading An Efficient Way to Check for Existence of Multiple Values in SQL →
We have in the past covered Installing Galera Cluster 4 with MySQL 8 on Ubuntu 18.04 and also Installing Galera 4 with MySQL 8 on Ubuntu 20.04, and it would seem appropriate to also cover Ubuntu 22.04 LTS (Jammy Jellyfish). We do have excellent documentation and we also have the ability for you to automate all of this via the GUI tool, Galera Manager.
Prerequisites
This is the fourth article in the series dedicated on transition from keyring plugins to keyring components. In the previous article we have discussed component_keyring_encrypted_file keyring component, how different is it from the keyring_encrypted_file plugin and how to install it using a manifest and configuration file. In this post we will be discussing component_keyring_oci keyring […]
In this post we will discuss how to use the OCI TypeScript/JavaScript SDK to retrieve information about a specific MySQL HeatWave instance and how to start/stop that instance programatically.
Recently during the Swedish MySQL User Group (SMUG), I presented a session dedicated to MySQL InnoDB Primary Keys.
I forgot to mention a detail that many people are not aware, but Jeremy Cole has pointed out.
Primary Key always included in secondary indexes at the right-most column
When we define a secondary index, the secondary index includes the Primary Key as the right-most column of the index. It’s silently added, meaning that it’s not visible but it’s used to point back to the record in the clustered index.
This is an example with a table having a Primary Key composed of multiple columns:
CREATE TABLE `t1` (
`a` int NOT NULL,
`b` int NOT NULL,
`c` int NOT NULL,
`d` int NOT NULL,
`e` int …This is the third article in the series dedicated on transition from keyring plugins to keyring components. In the previous article we have discussed component_keyring_file (file-based keyring component), how different is it from the keyring_file plugin and how to install it using a manifest and configuration file. In this post we will be discussing component_keyring_encrypted_file […]
This post is the second in a series that will demonstrate how to view and manage MySQL HeatWave instances in Oracle Cloud Infrastructure (OCI). Oracle offers several SDKs that can be used to view and manage resources in OCI. In this post, we will discuss how to leverage the TypeScript/JavaScript SDK to retrieve information about a single MySQL HeatWave instance and how we […]