Planet for the MySQL Community

A blog aggregator for the MySQL Community/Ecosystem

A description of what this website tries to achieve is in the Planet MySQL Community - Requirements RFC.

And a clarification about the MySQL Community/Ecosystem: it is not limited the users of the MySQL Database. In the current context, it also includes people interested in MySQL Variants including MariaDB Server, Percona Server, Galera, Amazon RDS and Aurora, Google Cloud SQL for MySQL, and Azure and Alibaba flavor(s) of MySQL/MariaDB/Percona Servers.

Tuesday, 26. September 2023

Skeema v1.11.0 released (from Skeema Blog)

pSkeema v1.11.0 has been released! This new version includes spatial index support, safe trigger DDL operations with table locking, new options to ignore some types of table differences, and additional safety guardrails./p [...]
Published Tuesday, 26. September 2023 19:22 • 4 hours ago

Trying out OrioleDB (from Small Datum)

pI am curious about OrioleDB given my unsuccessful attempts to resolve some Postgres perf issues for the Insert Benchmark via tuning. /ppThe first step is to compile and install their Postgres fork from source./p  git clone github.com/orioledb/postgres.git oriole_pg  cd oriole_pgbr  git checkout patches16_18br  bash mk.pg.o3_native_lto ~/d/pg16oriolebr  make insta [...]
Published Tuesday, 26. September 2023 16:21 • 7 hours ago | Updated Tuesday, 26. September 2023 16:21 • 7 hours ago

Checking MyRocks 5.6 for regressions with the Insert Benchmark and a large server (from Small Datum)

pThis documents how performance changes from old to new releases of MyRocks using the Insert Benchmark and a large server. I use MyRocks 5.6 rather than 8.0 because the 5.6 release go back further in time. This post uses a large server. Previous posts are here for a small server and medium server./ppUpdate - the builds I used were bad so the results here are bogus. I fixed the b [...]
Published Friday, 25. August 2023 22:14 • 1 months ago | Updated Tuesday, 26. September 2023 15:19 • 8 hours ago

Chasing a performance regression in MyRocks vs the Insert Benchmark (from Small Datum)

pI found a few performance regressions with the Insert Benchmark and MyRocks on a large server and this explain the start of my search to for the root causes. The regressions are described in an earlier blog post (see the summaries here and here).brbrUpdate - the builds I used were bad so the results here are bogus. I fixed the builds, repeated the tests and share results here. There are no re [...]
Published Wednesday, 06. September 2023 20:35 • 20 days ago | Updated Tuesday, 26. September 2023 15:19 • 8 hours ago

Checking MyRocks 5.6 for regressions with the Insert Benchmark and a large server, revisited (from Small Datum)

pI previously shared results for MyRocks 5.6 and claimed there was a perf regression in the Insert Benchmark. I then shared a follow up post as I searched for the source of the regression. The results were bogus, there is no regression and this post explains what happened./ppThe mistake I made is that all builds used FDO (feedback driven optimization) and while the builds tested span ~18 [...]
Published Tuesday, 26. September 2023 15:07 • 8 hours ago | Updated Tuesday, 26. September 2023 15:07 • 8 hours ago

The MySQL Clone Plugin Is Not Your Backup (from Percona Database Blog)

♦This blog post discusses the limitations of the MySQL Clone plugin.The MySQL clone plugin significantly simplifies the process of replica provisioning. All you need to do is: Ensure that the source server has binary logs enabled Grant appropriate permissions Execute the [crayon-65133d0293854611707278-i/]  command on the recipient This works extremely easily when you provision a new […] [...]
Published Tuesday, 26. September 2023 14:03 • 9 hours ago

Implementing durability in a MySQL storage engine (from Laurynas Biveinis' blog)

pupdate 2023-09-26: codetrx->flush_log_later/code is actually used. Will edit the post./p p Let's review how a MySQL storage engine should implement transaction durability by flushing / syncing WAL writes to disk. For performance reasons (group 2PC), let's also review when it specifically should not sync writes to disk. The reference durability implementation is, of course, InnoDB. /p p The ma [...]
Published Monday, 25. September 2023 12:31 • a day ago | Updated Tuesday, 26. September 2023 12:29 • 11 hours ago

Explore the New Feature of MySQL To Restrict Users From Creating a Table Without a Primary Key (from Percona Database Blog)

♦As MySQL database administrators, we are well aware of the significance of implementing a primary key within a table. Throughout our careers, most of us have encountered situations where the absence of a primary key has led to operational challenges. Primary keys play an indispensable role in sound database design by uniquely identifying individual rows […] [...]
Published Tuesday, 26. September 2023 12:04 • 11 hours ago

Monday, 25. September 2023

Checking Postgres for perf regressions from 11.21 to 16.0 with sysbench and a small server (from Small Datum)

pThis has results for Sysbench, a small server and Postgres 11, 12, 13, 14, 15 and 16. The goal is to see if there are perf regressions over time. This is a common problem as code gets added over time the cumulative impact is using more CPU to do the same amount of work. MySQL is an example where there are significant regressions over time.brbrContext - the workload here is a cached database with 1 [...]
Published Monday, 25. September 2023 23:23 • 24 hours ago | Updated Monday, 25. September 2023 23:23 • 24 hours ago

Variance in peak RSS with jemalloc 5.2.1 (from Small Datum)

pPeak RSS for jemalloc 5.2.1 has much variance with the Insert Benchmark with MyRocks. The variance is a function of how you build and configure jemalloc. The worst case (largest peak RSS) is jemalloc 5.2.1 provided by Ubuntu 22.04 and I have yet to figure out how to reproduce that result using jemalloc 5.2.1 compiled from source.brbrI previously shared results to show that jemalloc and tcmalloc ar [...]
Published Monday, 25. September 2023 19:46 • a day ago | Updated Monday, 25. September 2023 19:46 • a day ago

Restrict MySQL Connections to Broken Replica in ProxySQL (from Percona Database Blog)

♦ProxySQL is a high-performance SQL proxy, which runs as a daemon watched by a monitoring process. The process monitors the daemon and restarts it in case of a crash to minimize downtime.The daemon accepts incoming traffic from MySQL clients and forwards it to backend MySQL servers.The proxy is designed to run continuously without needing to […] [...]
Published Monday, 25. September 2023 14:05 • a day ago

Quick Look – MySQL Data Directory Files (from Kedar MySQL Blog)

pDo you know what lies inside your MySQL Data Directory? This article is a quick guide about the files stored inside MySQL data directory. Data managed by the MySQL server…/p The post Quick Look – MySQL Data Directory Files first appeared on Change Is Inevitable. [...]
Published Monday, 25. September 2023 12:21 • a day ago

Cut & Paste a User Creation Statement with MySQL 8 to MySQL HeatWave (from The Oracle MySQL Blog)

During a migration to MySQL HeatWave, it could be interesting to cut & paste user creation statements. In this blog you learn how to achieve this. [...]
Published Monday, 25. September 2023 11:45 • a day ago

OpenLampTech issue #97 – Newsletter Repost (from Digital Owl's Prose)

pAnother packed full newsletter coming your way this week in OpenLampTech. So much goodness in this one. Take your time reading, enjoy, and share. Thank you. In OpenLampTech issue #97, there is great content on: Thanks so much for reading. Grab your free subscription and join and support the OpenLampTech community./p pThe post OpenLampTech issue #97 – Newsletter Repost appeared first on Digit [...]
Published Monday, 25. September 2023 11:00 • a day ago

Mission Impossible: Zero-Configuration SSL (from MariaDB Foundation Blog)

pSSL (let’s call it that, even though SSL 2.0 and SSL 3.0 were long replaced by TLS 1.0–1.3 protocols) support was implemented in MySQL in 2001, so MariaDB (born in 2009) always had it. … /p pContinue reading \"Mission Impossible: Zero-Configuration SSL\"/p pThe post Mission Impossible: Zero-Configuration SSL appeared first on MariaDB.org./p [...]
Published Monday, 25. September 2023 08:30 • a day ago

Mastering MariaDB Query Optimization: EXPLAIN in the Slow Query Log (from MinervaDB Blog)

pUnlocking MariaDB Query Performance: EXPLAIN and Slow Query Log Introduction Understanding how queries are executed by a database system is paramount for database administrators and developers seeking to optimize performance. In the realm of MariaDB, [...]/p pThe post Mastering MariaDB Query Optimization: EXPLAIN in the Slow Query Log appeared first on The WebScale Database Infrastructure Operatio [...]
Published Monday, 25. September 2023 07:05 • a day ago

Cut & Paste a User Creation Statement with MySQL 8 (from lefred's blog)

Sometimes it’s convenient to retrieve the user creation statement and to copy it to another server. However, with the new authentication method used as default since MySQL 8.0, caching_sha2_password, this can become a nightmare as the output is binary and some bytes can be hidden or decoded differently depending of the terminal and font used. […] [...]
Published Monday, 25. September 2023 07:00 • a day ago

Sunday, 24. September 2023

The Ins and Outs of innodb_flush_log_at_trx_commit (from Another Boring Tech Blog)

pToday, we’re going to take a journey through one of MySQL’s performance guardians – the innodb_flush_log_at_trx_commit. The innodb_flush_log_at_trx_commit has 3 valid values: 0, 1, and 2. Let’s see each of them. Option 1: The Safe Harbor (innodb_flush_log_at_trx_commit = 1) By default, MySQL is set up with a focus on safety. Imagine this as saving your.../p pO post The Ins and Ou [...]
Published Sunday, 24. September 2023 20:12 • 2 days ago

Setup PostgreSQL with Node.js: A Step-by-Step Guide (from Code For Geek)

Many developers use MongoDB to store data when working with Node.js since NoSQL is considered best for it. But what if someone wants to work with SQL databases? The traditional option is to go with MySQL database, but it lacks many things and advanced operations. Here comes PostgreSQL. PostgreSQL is one of the popular MySQL […] [...]
Published Sunday, 24. September 2023 17:04 • 2 days ago

Export and import of MySQL passwords using caching_sha2  (from TusaCentral - MySQL Blogs)

pSome fun is coming ♦/p pWhile I was writing the internal guidelines on how to migrate from MariaDB to Percona Server, I had to export the users accounts in a portable way. This given MariaDB uses  some non standard syntax brings me to first test some external tools such as Fred github.com/lefred/mysqlshell-plugins/wiki/user#getusersgrants and our PT-SHOW-GRANTS tool. /p pUseless to say t [...]
Published Sunday, 24. September 2023 15:39 • 2 days ago

Calculating Population Variance in Financial Data using MySQL 8: A Practical Guide (from MinervaDB Blog)

pVAR_POP: Population Variance In MySQL 8: MySQL 8 introduced the VAR_POP() function to calculate population variance. Step 1: Create a Table and Insert Financial Data Assuming you have a table named daily_returns for stock return data: CREATE TABLE [...]/p pThe post Calculating Population Variance in Financial Data using MySQL 8: A Practical Guide appeared first on The WebScale Database Infrastruct [...]
Published Sunday, 24. September 2023 10:16 • 3 days ago

Saturday, 23. September 2023

Postgres 16.0, sysbench and a medium server (from Small Datum)

pThis has results for Postgres 16.0 vs sysbench on a medium server and the news continues to be good. I previously shared results for this on a small server./pptl;dr/pp/pulliPostgres 16.0 is faster than 15.2/liliThe improvement for reads is larger than for writes/li/ulp/pBuildsp/pI compiled Postgres 15.2, 15.3, 15.4, 16 beta1, 16 beta2, 16 beta3, 16 rc1 and 16.0 from source. The builds are named&nb [...]
Published Saturday, 23. September 2023 17:28 • 3 days ago | Updated Saturday, 23. September 2023 17:28 • 3 days ago

Postgres 16.0, sysbench and a small server (from Small Datum)

pI recently shared results for Postgres 16rc1 vs sysbench on a small server. Now I have results for Postgres 16.0 and the news continues to be good./pptl;dr/pp/pulliinsert QPS might have dropped by ~5%, otherwise there are no regressions for writes/lilifor everything else QPS in Postgres 16.0 is within ~2% of 15.2, which is a great result/li/ulp/pBuildsp/pI compiled Postgres 15.2, 15.3, 15.4, 16 be [...]
Published Saturday, 23. September 2023 16:37 • 3 days ago | Updated Saturday, 23. September 2023 16:37 • 3 days ago

Friday, 22. September 2023

Hello world! (from Small Datum)

pSmall Datum LLC is a thing./p [...]
Published Friday, 22. September 2023 21:58 • 4 days ago | Updated Friday, 22. September 2023 21:58 • 4 days ago

You Need to Actively Support Open Source Software or It Will Disappear (from Percona Database Blog)

♦Percona is dedicated to open source software. But recently, open source software has come under attack. Once open source software is being locked away by changing licenses and code that you depended on. You either get to pay for the privilege of having less freedom or find yourself sequestered with rapidly aging software.Before open source […] [...]
Published Friday, 22. September 2023 13:41 • 4 days ago

Database Administration for Galera Cluster online training course in October (from Galera Blog)

Codership, the developers of Galera Cluster and Galera Manager, have new dates for the online DBA for Galera Cluster Training. There are two sets of times for our EMEA and American attendees, with the former happening on October 9th  and 10th, starting 10 AM CET and the latter happening on October 11th and 12th, starting 9 AM EST.​​​​​ This is […] [...]
Published Friday, 22. September 2023 08:20 • 5 days ago

Case Study: How the Engineers of SMD Found a Way to Process Millions of Database Records Faster With dbForge Studio for MySQL (from Devart MySQL Tool Blog)

pHere comes the success story of Specialized Media Dashboard, a project that comprises an open-source media monitoring system. The specialized media in question encompasses the spheres of journalism, law enforcement, and climate change./p pThe post Case Study: How the Engineers of SMD Found a Way to Process Millions of Database Records Faster With dbForge Studio for MySQL appeared first on Devart B [...]
Published Friday, 22. September 2023 06:14 • 5 days ago

Thursday, 21. September 2023

Node.js and MySQL Complete Tutorial (from Code For Geek)

Node.js and MySQL are some of the necessary binding needed for any web application that is frequently used by Full Stack developers. MySQL is one of the most popular open-source databases in the world and is efficient as well. Almost every popular programming language like Java and PHP provides drivers to access and perform operations […] [...]
Published Thursday, 21. September 2023 18:55 • 5 days ago

MongoDB vs DynamoDB: Choosing the Right Database for Your Project (from Code For Geek)

Databases have changed the way individuals and corporations handle and manage large amounts of data. It has enabled app developers, software engineers, data scientists and others to make life simpler than ever before. MongoDB, DynamoDB, PostgreSQL, MySQL, Cassandra, Redis, Aerospike, Firebase Realtime and others are well-known databases. We can divide these databases into two categories: […] [...]
Published Thursday, 21. September 2023 17:02 • 5 days ago

MariaDB Un(Conference) and ServerFest Schedule 3-5 Oct 2023 (from MariaDB Foundation Blog)

pWe are happy to release the schedule (mariadb.org/fest2023-schedule/) of our upcoming meeting week Tue-Thu 3-5 October 2023.br The week comes with meetings in four flavours:br During the week, we plan to work on the MariaDB Server roadmap together with ecosystem members who drive it. … /p pContinue reading \"MariaDB Un(Conference) and ServerFest Schedule 3-5 Oct 2023\"/p pThe post MariaDB Un [...]
Published Thursday, 21. September 2023 13:53 • 5 days ago

Why You Need To Be at the Southern California Linux Expo (from Percona Database Blog)

♦You can show your support for open source software by participating in an event next March in Pasadena, California – The Southern California Linux Expo, or SCaLE. SCaLE is the largest community-run open source and free software conference in North America. Percona has sponsored this show for many years, provided presenters, and participated in the […] [...]
Published Thursday, 21. September 2023 13:08 • 5 days ago

Where to find official MySQL container images ? (from The Oracle MySQL Blog)

Find the official MySQL container image in the Oracle Container Registry [...]
Published Thursday, 21. September 2023 08:46 • 6 days ago

How to scale your database and when to shard (from PlanetScale Blog)

Not sure when to shard your MySQL database? This article covers when you should consider horizontal sharding as a scaling strategy in MySQL and some other scaling options before then. [...]
Published Thursday, 21. September 2023 08:00 • 6 days ago

Where to find official MySQL container images ? (from lefred's blog)

If you are deploying MySQL on containers, one of the first tasks is to find the right image. There’s a certain amount of confusion, especially when we’re trying to help someone who’s having problems with their deployment. For example, when people say I’m using the official docker image… what does that really mean? Docker Hub, […] [...]
Published Thursday, 21. September 2023 05:13 • 6 days ago

Integrating DB Migrations Into Your MySQL Tests (from The Oracle MySQL Blog)

By integrating MySQL database migrations into your testing process, you can not only ensure your testing database is up to date with the most recent changes, but you can also test that the migrations themselves are performing as expected. In this post we will walk you though how to incorporate migrations with Knex and run those migrations on your test database being run in Testcontainers. [...]
Published Thursday, 21. September 2023 04:00 • 6 days ago

Optimizing MySQL Performance: A Guide to Redo Log Capacity Estimation (from Another Boring Tech Blog)

pWith MySQL 8.0.30 comes a feature that is a game changer in ensuring optimal MySQL performance – the dynamic redo log sizing. Overcoming Previous Limitations Before version 8.0.30 came into play, redo log configuration was static, set once during database setup and rarely touched thereafter due to the MySQL restart required to effect any changes.../p pO post Optimizing MySQL Performance: A Guide t [...]
Published Thursday, 21. September 2023 00:53 • 6 days ago

Rethinking the 80% InnoDB Buffer Pool Rule: Digging into Server RAM Allocation (from Another Boring Tech Blog)

pIn server optimization, various rules of thumb have guided professionals in making informed decisions about resource allocation. One such directive is the 80% rule, which suggests allocating 80% of a server’s RAM to InnoDB’s buffer pool, leaving the remaining 20% for other operations. Initially conceived as a general guideline to get servers up and running.../p pO post Rethinking the 80% Inn [...]
Published Thursday, 21. September 2023 00:38 • 6 days ago

Wednesday, 20. September 2023

Automated Workload-Aware Data Loading and Unloading for MySQL HeatWave (from The Oracle MySQL Blog)

We now added a new automated capability (AutoLoad) to MySQL Autopilot – Auto Load & Auto Unload which continuously monitors workload run in MySQL and use machine learning model to predict the queries that can offload to HeatWave for query acceleration. Based on the list of queries, the new AutoLoad dynamically loads or unloads tables to HeatWave cluster. [...]
Published Wednesday, 20. September 2023 19:17 • 6 days ago

MariaDB 11.3.0 preview release available (from MariaDB Foundation Blog)

pThe MariaDB Foundation is pleased to announce the availability of MariaDB 11.3.0, a preview release in the MariaDB 11.3 series. MariaDB 11.3 is a short-term release and will be maintained for one year after its G.A (stable) release. … /p pContinue reading \"MariaDB 11.3.0 preview release available\"/p pThe post MariaDB 11.3.0 preview release available appeared first on MariaDB.org./p [...]
Published Wednesday, 20. September 2023 18:06 • 6 days ago

Accelerating JSON Query Processing using MySQL HeatWave (from The Oracle MySQL Blog)

We are excited to introduce the JSON support in HeatWave which offers significant performance improvement with no change in applications, or no indexes needed for accelerating JSON processing. This provides significant enhancement for applications that heavily rely on JSON data structures, as query execution times are now drastically reduced, improving overall application performance. [...]
Published Wednesday, 20. September 2023 16:40 • 6 days ago

How to Read Simplified SHOW REPLICA STATUS Output (from Percona Database Blog)

♦As a MySQL database administrator, you’re likely familiar with the SHOW REPLICA STATUS command. It is an important command for monitoring the replication status on your MySQL replicas. However, its output can be overwhelming for beginners, especially regarding the binary log coordinates. I have seen confusion amongst new DBAs on which binary log file and […] [...]
Published Wednesday, 20. September 2023 13:47 • 6 days ago

Industry Analyst views on MySQL HeatWave’s Vector Store, Generative AI innovations (from The Oracle MySQL Blog)

To mark the 3rd day of Oracle CloudWorld 2023, Oracle announced significant enhancements to MySQL HeatWave. Hear what leading Industry Analysts have to say about the latest Vector store and generative AI innovations. [...]
Published Wednesday, 20. September 2023 12:43 • 6 days ago

Avoid Surprises When Restarting MySQL — Ensure Dynamic Changes Won’t Be Lost (from Percona Database Blog)

♦If you’re a DBA, one of your “easiest” tasks is to stop/start MySQL during a maintenance window, but even that could lead to unwanted scenarios if you modify some dynamic parameters at some point in your instance.Here’s a brief story of how this could happen, to make it clearer:You’re a DBA managing a few MySQL […] [...]
Published Wednesday, 20. September 2023 12:19 • 6 days ago

Inside Delhivery’s Data Marts Migration Journey to TiDB   (from TiDB and TiKV Blog)

pGuest post by Hari Kishan, Senior Engineering Manager at Delhivery, and Akash Deep Verma, Director of Technology at Delhivery As the leading fulfillment platform for digital commerce in India, Delhivery delivers a million packages a day, 365 days a year. Its 24 automated sort centers, 101 hubs, 3,100+ direct delivery centers, 1000+ partner centers, 11,000+ […]/p pThe post Inside Delhivery’s [...]
Published Wednesday, 20. September 2023 07:46 • 7 days ago

Tuesday, 19. September 2023

Introducing Vector Store and Generative AI in MySQL HeatWave (from The Oracle MySQL Blog)

MySQL HeatWave announced new and enhanced capabilities during Oracle CloudWorld 2023, including support for vector store, generative AI, new in-database machine learning features, MySQL Autopilot enhancements, new HeatWave Lakehouse capabilities, support for JavaScript, acceleration of JSON queries, and support for new analytic operators. This blog provides a technical deep dive into these enhancem [...]
Published Tuesday, 19. September 2023 21:40 • 7 days ago

Demystifying MySQL Parsing Problems in the Face of Intense and Diverse SQL Workloads (from MinervaDB Blog)

pUnderstanding How an Intense & Diverse SQL Workload Causes MySQL Parsing Problems In the world of database management, MySQL stands out as one of the most popular and widely used relational database management systems. It’s [...]/p pThe post Demystifying MySQL Parsing Problems in the Face of Intense and Diverse SQL Workloads appeared first on The WebScale Database Infrastructure Operatio [...]
Published Tuesday, 19. September 2023 17:03 • 7 days ago

Troubleshooting InnoDB IO Subsystem Reads: Tips and Tricks for MySQL Performance Optimization (from MinervaDB Blog)

pDetecting if the InnoDB IO subsystem reads are struggling and troubleshooting them effectively is crucial for maintaining MySQL database performance. Here are some tips and tricks to help you identify and address InnoDB IO subsystem [...]/p pThe post Troubleshooting InnoDB IO Subsystem Reads: Tips and Tricks for MySQL Performance Optimization appeared first on The WebScale Database Infrastructure [...]
Published Tuesday, 19. September 2023 16:43 • 7 days ago

Migrate to MariaDB Server from MySQL 5.7 using a single command (from MariaDB Corporation Blog)

MySQL 5.7 Extended Support from Oracle ends in October 2023 (source 1, source 2). MariaDB offers a compelling alternative to … Continued [...]
Published Tuesday, 19. September 2023 16:00 • 7 days ago

Use Physical Backups With MySQL InnoDB Redo Log Archiving (from Percona Database Blog)

♦In the world of data backup and security, physical backups play an extremely important role. Physical backup methods are faster than logical because they involve only file copying without conversion. This type of backup is suitable for large, important databases that need to be recovered quickly when problems occur.Physical backups are the backups that consist […] [...]
Published Tuesday, 19. September 2023 12:20 • 7 days ago

How HubSpot Upgraded a Thousand MySQL Clusters at Once (from HubSpot Product Team Blog)

♦ pWritten by Olga Shestopalova, Data Infra Engineer @ HubSpot.brbrHubSpot runs over a thousand MySQL clusters in each environment, and we were faced with the daunting task of upgrading all of these in a safe, automated manner. We jumped 9 major versions of Vitess, the clustering software we use for MySQL, along the way developing reusable testing tooling and automation to make all future u [...]
Published Tuesday, 19. September 2023 12:00 • 7 days ago

Perf regressions in MySQL from 5.6.21 to 8.0.34 using the Insert Benchmark and a small server (from Small Datum)

pThis post has results from the Insert Benchmark for some MySQL 5.6 releases, all 5.7 releases and all 8.0 releases. I previously shared results like this using sysbench.brbrDisclaimer - these results are from a low concurrency workload (1 to 3 concurrent connections). Results on a bigger server with more concurrency won't look as bad./pptl;dr/pp/pulliFrom MySQL 5.6.21 to 8.0.34/liulliThroughput fo [...]
Published Tuesday, 19. September 2023 00:54 • 8 days ago | Updated Tuesday, 19. September 2023 01:09 • 8 days ago

Monday, 18. September 2023

Postgres 16.0 vs the Insert Benchmark on a small server (from Small Datum)

pThis has results for Postgres 16.0 and rc1 vs the Insert Benchmark on a small server. My previous post had results for beta1, beta2 and beta3./pptl;dr/pp/pulliPostgres 16.0 looks good/liliAll versions of Postgres (old and new) have too much variance on this benchmark with the IO-bound setups. See rant below./li/ulRantbrThere is too much variance with Postgres vs the Insert Benchmark in IO-bound se [...]
Published Monday, 18. September 2023 16:40 • 8 days ago | Updated Monday, 18. September 2023 23:54 • 8 days ago

Postgres 16.0 vs the Insert Benchmark on a medium server (from Small Datum)

pThis has results for Postgres 16.0 and rc1 vs the Insert Benchmark on a medium server. Previous posts have results for this benchmark with Postgres 16.0 on a small server and with Postgres 16 beta on a medium server./pptl;dr/pp/pulliPostgres 16.0 looks good/liliAll versions of Postgres (old and new) have too much variance on this benchmark with the IO-bound setups. See rant here. I like Postgres b [...]
Published Monday, 18. September 2023 18:04 • 8 days ago | Updated Monday, 18. September 2023 18:04 • 8 days ago

New Versions of Percona Distribution for MongoDB, Percona Operator for MySQL: Release Roundup September 18, 2023 (from Percona Database Blog)

♦Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability.Our Release Roundups sh [...]
Published Monday, 18. September 2023 12:04 • 8 days ago

OpenLampTech issue #96 – Newsletter Repost (from Digital Owl's Prose)

pThank you for being here and reading the blog and the OpenLampTech newsletter. Issue #96 has some great content this week – like always. Enjoy! Be sure and grab your free OpenLampTech subscription and join the community. Your subscription means a lot for the newsletter. Thanks. In OpenLampTech issue #96, there are great articles on:/p pThe post OpenLampTech issue #96 – Newsletter Repos [...]
Published Monday, 18. September 2023 11:00 • 9 days ago

SEARCH DEPTH/BREADTH FIRST (from Modern SQL)

codesearch depth/code/codebreadth first/code: Compute an Extra Column to Order the Result of Recursive Queries♦olliMinor deviation: contents of <sequence column>/li/olpThe codesearch/code clause of codewith recursive/code creates a column that allows sorting the result in depth-first or breadth-first order./ppThe codesearch/code clause follows immediately after a recursive codewith/code eleme [...]
Published Monday, 18. September 2023 00:00 • 9 days ago

Friday, 15. September 2023

Achieving Zero-Downtime Upgrades with TiDB (from TiDB and TiKV Blog)

pIn the vast landscape of databases, ensuring zero-downtime upgrades and operation continuity remains a challenge. Due to inherent design limitations, traditional databases often introduce significant downtime during upgrades – a challenge that can spell operational chaos for businesses reliant on real-time data access.  Enter TiDB, a cutting-edge distributed SQL database that offers a s [...]
Published Friday, 15. September 2023 12:20 • 11 days ago

Convert MariaDB Binary Log File and Position-Based Replication to GTID Replication (from Percona Database Blog)

♦At Percona Managed Services, we manage Percona Server for MySQL, Community MySQL, and MariaDB. There are slight differences when configuring and managing MariaDB GTID replication. In this blog, we’ll show you how to convert MariaDB binary log file and position-based replication to GTID replication.In my lab, we have two test nodes; both servers will have […] [...]
Published Friday, 15. September 2023 11:53 • 11 days ago

Thursday, 14. September 2023

Troubleshoot networking issues during database migration with the AWS DMS diagnostic support AMI (from AWS Database Blog)

In this post, we introduce the key functionalities, architecture, and configurations of the AWS DMS diagnostic support AMI. Then, we show you how to launch the AMI with proper networking configurations and AWS Identity and Access Management (IAM) permissions using AWS CloudFormation. Last, we demonstrate an example of how network latency results in significant replication lag and how to use the AMI [...]
Published Thursday, 14. September 2023 16:26 • 12 days ago

Tungsten Replicator Parallel Applier Deep Dive (from Continuent Blog)

In this post, we will do a deep dive into how the Tungsten Replicator Parallel Applier works, and introduce a NEW filter for Parallel Apply called ShardByRulesFilter.Tags: parallel applierhow toTuning [...]
Published Thursday, 14. September 2023 13:49 • 12 days ago

Using MySQL Enterprise Monitor to monitor MySQL Heatwave Service (from MySQL Solutions - On Premises & Cloud)

p/pbrThis tutorials walk through the process to monitor the MySQL Heatwave Service using MySQL Enterprise Monitor(MEM) , Below are steps you needed to follow. p/ppbr/pp/pp Prerequisite:- /ppbr/p1. Installed MySQL Enterprise Monitor(MEM). br2. Putty - www.putty.org/ br3. Up & Running MySQL Heatwave Service on Oracle Cloud Infrastructure (OCI). br4. Up and Running Co [...]
Published Thursday, 14. September 2023 11:27 • 12 days ago | Updated Thursday, 14. September 2023 12:08 • 12 days ago

Complete Walkthrough: MySQL to ClickHouse Replication Using MaterializedMySQL Engine (from Percona Database Blog)

♦MySQL is an outstanding open source transactional database used by most web-based applications and is very good at handling OLTP workloads. However, modern business is very much dependent on analytical data. ClickHouse is a columnar database that handles analytical workloads quickly. I recommend you read our previous blog, Using ClickHouse as an Analytic Extension for […] [...]
Published Thursday, 14. September 2023 11:57 • 12 days ago

Wednesday, 13. September 2023

Perf regressions in MySQL from 5.6.21 to 8.0.34 using sysbench and a small server (from Small Datum)

pThis has results for sysbench vs upstream MySQL on a small server. I have results for every release in 5.7 and 8.0 and some releases in 5.6. The goal is to document where things get faster or slower over time for a low-concurrency and CPU-bound workload. The focus is on CPU regressions. /ppMy results here aren't universal. /pp/pulliThings won't look the same with an IO-bound workload. If [...]
Published Tuesday, 12. September 2023 15:21 • 14 days ago | Updated Wednesday, 13. September 2023 22:55 • 13 days ago

Streamline database management using the PlanetScale Netlify integration (from PlanetScale Blog)

Learn how to use the new PlanetScale Netlify integration to simplify the process of wiring up a database to your Netlify applications. [...]
Published Wednesday, 13. September 2023 12:00 • 13 days ago

Feedback requested: The Good/Bad/Ugly (from MariaDB Foundation Blog)

pHi, we from the MariaDB Foundation are having a set of meetings with developers and senior managers from all over the world. We’d like your feedback on the Good/Bad/Ugly bits of MariaDB Server as you see it, and generally what we could be doing better. … /p pContinue reading \"Feedback requested: The Good/Bad/Ugly\"/p pThe post Feedback requested: The Good/Bad/Ugly appeared first on Ma [...]
Published Wednesday, 13. September 2023 00:51 • 14 days ago

Tuesday, 12. September 2023

Focus on Lakehouse at Oracle CloudWorld (from The Oracle MySQL Blog)

Interested in data lakehouse platforms? Oracle CloudWorld offers you plenty of opportunities to learn about MySQL HeatWave Lakehouse and discover its new capabilities. Check out the recommended sessions. [...]
Published Tuesday, 12. September 2023 16:19 • 14 days ago

Samsung SDS Cuts Database Costs in Half by Moving from Oracle to MariaDB (from MariaDB Corporation Blog)

For many of us, our mobile device is a necessity in our daily life. We have our priceless video and … Continued [...]
Published Tuesday, 12. September 2023 16:00 • 14 days ago

How To Make Schema Changes and Not Die Trying (from Percona Database Blog)

♦Schema changes are required to add new features or to fix bugs in an application. However, there is no standard procedure to make the changes in a quick and safe manner. If the changes are not made considering the necessary precautions, you may face unwanted outages on the database that can cause serious problems to […] [...]
Published Tuesday, 12. September 2023 14:06 • 14 days ago

Auto-Increment Counter Persistence in MySQL 8: Comparing the Evolution From MySQL 5.7 (from Percona Database Blog)

♦The auto-increment feature, which generates unique values for primary key columns, is an integral part of the database’s design. With the release of MySQL 8, a notable enhancement was introduced to the auto-increment counter. Compared to MySQL 5.7, this enhancement ensures that the maximum auto-increment counter value persists between server restarts, providing enhanced consistency and [R [...]
Published Tuesday, 12. September 2023 12:15 • 14 days ago

Where can you find MySQL team in September 2023 (from The Oracle MySQL Blog)

Where can you find MySQL team in September 2023 [...]
Published Tuesday, 12. September 2023 11:35 • 14 days ago

Monday, 11. September 2023

Database changes should be SCARY (from MariaDB Foundation Blog)

p“The only workload that matters is my production workload” (for all values of “my”). So you can manage this responsibility, SCARY is a software tool which aims to take the uncertainty out of change; … /p pContinue reading \"Database changes should be SCARY\"/p pThe post Database changes should be SCARY appeared first on MariaDB.org./p [...]
Published Monday, 11. September 2023 21:05 • 15 days ago

Introducing the Advanced JDBC Wrapper Driver for Amazon Aurora (from AWS Database Blog)

Today’s modern applications are expected to be scalable and resilient. The top of this list is scalability, which depending on the size of the application workload could mean the ability to handle millions of users on demand. With stateful applications such as eCommerce, Financial Services and Games, this means having highly available databases. With the release of Amazon Aurora in 2015, customers [...]
Published Monday, 11. September 2023 17:18 • 15 days ago

Checking jemalloc versions for RSS regressions with MyRocks and the Insert Benchmark (from Small Datum)

pI previously shared a blog post with results for jemalloc, tcmalloc and glibc malloc vs MyRocks and the Insert Benchmark. The summary was to use jemalloc or tcmalloc with MyRocks, or anything that uses RocksDB, because they are much better than glibc malloc at reducing the peak RSS.brbrToday I share results for the same benchmark using jemalloc versions from 4.0.4 to 5.3.0./pptl;dr/polliThere was [...]
Published Monday, 11. September 2023 16:38 • 15 days ago | Updated Monday, 11. September 2023 16:38 • 15 days ago

New Backported Features Available in MariaDB Enterprise Server Releases 10.4-10.6 (from MariaDB Corporation Blog)

New maintenance releases for MariaDB Enterprise Server 10.6.15-10, 10.5.22-16 and 10.4.31-21 are now available. Download Now Backported Features New JSON … Continued [...]
Published Monday, 11. September 2023 15:22 • 15 days ago

RocksDB and glibc malloc don't play nice together (from Small Datum)

pPineapple and ham work great together on pizza. RocksDB and glibc malloc don't work great together. The primary problem is that for RocksDB processes the RSS with glibc malloc is much larger than with jemalloc or tcmalloc. I have written about this before -- see here and here. RocksDB is a stress test for an allocator./pptl;dr/pp/pulliFor a process using RocksDB the RSS with glibc malloc [...]
Published Sunday, 27. August 2023 22:33 • 1 months ago | Updated Monday, 11. September 2023 15:12 • 15 days ago

OpenLampTech issue #95 – Newsletter Repost (from Digital Owl's Prose)

pWith the short work week due to the US Labor Day holiday on last Monday, I barely got this week’s OpenLampTech newsletter out. But, here it is in all its glory. Thanks for reading. In OpenLampTech issue #95, there is great content on: Don’t miss the weekly OpenLampTech newsletter and the many developer interviews being […]/p pThe post OpenLampTech issue #95 – Newsletter Rep [...]
Published Monday, 11. September 2023 11:00 • 16 days ago

How to Run dbForge Studio for MySQL on Ubuntu With Wine (from Devart MySQL Tool Blog)

pIn recent years, Linux has witnessed an impressive increase in popularity as a robust and reliable operating system that caters to a diverse range of users, from casual enthusiasts to seasoned software developers. As Linux continues to gain ground across various industries, there's a growing need for software tools and applications originally designed for Windows environments to be installed and u [...]
Published Monday, 11. September 2023 07:57 • 16 days ago

Sunday, 10. September 2023

Export MySQL to Excel with PHP and PhpSpreadsheet (from Phpflow.com)

pin this article, You’ll learn How to export data from MySQL to Excel using PHP and phpspreadsheet, I have already shared the article without any third-party libs Exporting Data from MySQL to Excel using PHP. PhpSpreadsheet is a powerful open-source PHP library that allows developers to work with spreadsheet files, particularly Microsoft Excel formats (such […]/p pThe post Export MySQL [...]
Published Sunday, 10. September 2023 04:31 • 17 days ago

Friday, 08. September 2023

MySQL High Availability and Disaster Recovery [LRN2386] at CloudWorld 2023 (from The Oracle MySQL Blog)

MySQL High Availability and Disaster Recovery [LRN2386] at CloudWorld 2023 [...]
Published Friday, 08. September 2023 23:35 • 18 days ago

MySQL 5.7 End of Life Options – Free Course at Percona University Online (from Percona Database Blog)

♦Percona University Online has released a new free course, “MySQL 5.7 End of Life Options – Free Course at Percona University Online,” by Dave Stokes, Technical Evangelist at Percona. Dave is the author of MySQL & JSON – A Practical Programming Guide. He started to work with MySQL from the 3.29 version and was a part […] [...]
Published Friday, 08. September 2023 12:24 • 18 days ago

Thursday, 07. September 2023

High-Performance Data Architectures: Five Characteristics for Global Data Management (from TiDB and TiKV Blog)

pThe objective of making a database choice that meets the requirements of today’s data-driven environments is to build high-performance data architectures. But what do these architectures look like? Existing databases address the business problems arising from a fast-paced digital economy. However, the traditional approach of throwing databases at individual, siloed problems needs to be rethought. [...]
Published Thursday, 07. September 2023 18:02 • 19 days ago

MariaDB ColumnStore Quick Start Guide (from MariaDB Corporation Blog)

In this blog post, we will guide you through the process of setting up MariaDB Server with the ColumnStore storage … Continued [...]
Published Thursday, 07. September 2023 17:43 • 19 days ago

Building High-Performance MySQL Apps on OCI at Oracle Cloud World (from The Oracle MySQL Blog)

At Oracle Cloud World 2023, we'll cover the architecture of the fully-managed Oracle MySQL HeatWave database service and the most important features for transactional applications. [...]
Published Thursday, 07. September 2023 15:56 • 19 days ago

Performance demos at Oracle CloudWorld: MySQL HeatWave Lakehouse vs. Snowflake, Redshift, BigQuery, and Databricks (from The Oracle MySQL Blog)

How about seeing live how the performance of MySQL HeatWave Lakehouse compares to Snowflake, Amazon Redshift, Google BigQuery, and Databricks? Don’t miss the demos at the AMD booth at Oracle CloudWorld - Tuesday, Sept 19, and Wednesday, Sept 20. Plus, you can win a great prize! [...]
Published Thursday, 07. September 2023 15:41 • 19 days ago

MySQL Partial Revokes Privileges (from Percona Database Blog)

♦Have you ever encountered situations where you want to grant a user access to all databases except a few? Or have you ever tried to revoke partial privileges from a user and you have gotten the below error message? If yes, then this article may interest you. [crayon-65133d0297757995036410/] Recently, one of our clients requested to […] [...]
Published Thursday, 07. September 2023 12:18 • 19 days ago

Celebrating the Successful TiDB Future App Hackathon 2023 (from TiDB and TiKV Blog)

pOn August 15, we announced the winners of this year’s TiDB FutureApp Hackathon and celebrated the closing of a great community event that kicked off on June 6. During the Hackathon, we had 1,490 participants from 87 countries forming 180 teams and submitting 100 projects. Beyond the quantity, we were extremely impressed with the quality […]/p pThe post Celebrating the Successful TiDB Future [...]
Published Thursday, 07. September 2023 06:50 • 20 days ago

Wednesday, 06. September 2023

Emulating foreign key constraints with Drizzle relationships (from PlanetScale Blog)

Learn how to build virtual relationships between tables in PlanetScale while using the Drizzle TypeScript ORM. [...]
Published Wednesday, 06. September 2023 17:30 • 20 days ago

About Me (from Another Boring Tech Blog)

pO post About Me apareceu primeiro em Another Boring Tech Blog./p [...]
Published Wednesday, 06. September 2023 17:24 • 20 days ago

Transform and migrate data from a relational to non-relational database using an AWS Glue Spark ETL job (from AWS Database Blog)

This post describes a methodology to transform and migrate data from a relational database like Amazon Relational Database Service (Amazon RDS) for MySQL to a non-relational database like Amazon DocumentDB (with MongoDB compatibility) using AWS Glue. [...]
Published Wednesday, 06. September 2023 16:59 • 20 days ago

Putting the Fun in MySQL Functional Indexes (from Percona Database Blog)

♦Functional indexes are found in both of Percona’s relational databases, MySQL and PostgreSQL, but they are probably the least used and most understood index type, aside from geospatial. You may also hear this type of index being called Index on expression.So, what is a functional index?DefinitionsThe examples below use MySQL, but it is helpful to […] [...]
Published Wednesday, 06. September 2023 12:59 • 20 days ago

Quick Guide to SQL Joins (from Percona Database Blog)

♦A join in SQL combines columns from one or more tables to extract the required data. When used effectively, joins can simplify queries and save a lot of time. In this blog, we will look into an easy way to visualize the data captured by various joins using Venn diagrams and their SQL equivalent.Some of […] [...]
Published Wednesday, 06. September 2023 12:00 • 20 days ago

Developer Interview with Will Earp – Substack Repost (from Digital Owl's Prose)

pI'm resharing some of the best developer interviews from OpenLampTech. Subscribe to the publication so you don't miss it./p pThe post Developer Interview with Will Earp – Substack Repost appeared first on Digital Owl's Prose./p [...]
Published Wednesday, 06. September 2023 11:00 • 21 days ago

Get the Latest Maintenance Update of dbForge Edge! (from Devart MySQL Tool Blog)

pHere comes a new maintenance update of dbForge Edge, which delivers support for MySQL 8.1, Oracle Database 23c, and PostgreSQL 16. Make sure you don't miss it!/p pThe post Get the Latest Maintenance Update of dbForge Edge! appeared first on Devart Blog./p [...]
Published Wednesday, 06. September 2023 09:55 • 21 days ago

Tuesday, 05. September 2023

Focus on Machine Learning with MySQL HeatWave at Oracle CloudWorld (from The Oracle MySQL Blog)

Interested in machine learning? Check out those MySQL HeatWave sessions at Oracle CloudWorld to learn how you can benefit from and make the most of in-database ML. They include talks featuring customers such as NVIDIA, hands-on labs, demos, and more. [...]
Published Tuesday, 05. September 2023 16:15 • 21 days ago

Building Secure MySQL Applications at Oracle Cloud World (from The Oracle MySQL Blog)

Are you looking to build secure applications and secure your data with MySQL Enterprise Edition (EE)? If so, you're in luck! According to the Online Trust Alliance, 93% of security breaches are preventable! I hope that alone will movitate many to come attend my talk. Please come and check out my talk at Oracle CloudWorld on September 21, LRN2387. [...]
Published Tuesday, 05. September 2023 16:03 • 21 days ago

[Tutorial] How to Connect DBeaver to MySQL (from ScaleGrid Blog)

pDBeaver stands out as a leading open-source database management tool, supporting MySQL, SQL Server, and various NoSQL databases. When it comes to connecting DBeaver to these databases, the process is seamless, making it an indispensable tool for database administrators and experts.   Why Use DBeaver for MySQL? The synergy between DBeaver and MySQL offers database.../p p<p>The post [Tuto [...]
Published Tuesday, 05. September 2023 13:17 • 21 days ago

How to fix Percona XtraDB Cluster 8.0 Upgrade issues (from Kedar MySQL Blog)

pAre you planning an upgrade for your Percona XtraDB Cluster (PXC)? Upgrading to PXC 8.0 can be a smooth process, but sometimes challenges arise that require careful troubleshooting. In this…/p The post How to fix Percona XtraDB Cluster 8.0 Upgrade issues first appeared on Change Is Inevitable. [...]
Published Tuesday, 05. September 2023 10:08 • 22 days ago

Monday, 04. September 2023

Updated Versions of Percona Distribution for PostgreSQL, Percona XtraDB Cluster: Release Roundup September 4, 2023 (from Percona Database Blog)

♦Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability.Our Release Roundups sh [...]
Published Monday, 04. September 2023 15:52 • 22 days ago

OpenLampTech issue #94 – Substack Repost (from Digital Owl's Prose)

pThe content keeps dropping and I keep publishing OpenLampTech each and every week. We are nearing the 100-issue milestone. Thanks to you, the OpenLampTech publication is already a success. In OpenLampTech issue #94, we are looking at great content on: OpenLampTech is your one-stop source for original and curated MySQL, PHP, and LAMP stack content. […]/p pThe post OpenLampTech issue #94 ̵ [...]
Published Monday, 04. September 2023 11:00 • 23 days ago

Saturday, 02. September 2023

Postgres 16, sysbench and a small server (from Small Datum)

pThis post has results for Postgres 15 and 16 versus sysbench on a small server. I am searching for performance regressions. All tests use 1 database connection as my focus here is on CPU regressions. I will repeat this on larger hardware with more concurrency to search for problems with mutexes and RW-locks./pptl;dr/pp/pulliI did not find any significant CPU regressions. Throughput in PG 16rc1 is [...]
Published Saturday, 02. September 2023 21:16 • 24 days ago | Updated Saturday, 02. September 2023 21:24 • 24 days ago