Author: MySQL Planet

Feed: Planet MySQL; Author: Mikael Ronström;  In a blog post I posted on the 16th of January I showed some graphs of CPUusage, network usage and disk usage. The benchmark that was running wasa modified variant of YCSB (Yahoo Cloud Serving Benchmark) based on version0.15.0 of YCSB.In this blog post I will describe the setup of the NVMe drives for thisbenchmark using DenseIO machines in the Oracle Cloud.Oracle Cloud has a variety of machines available. In this benchmark we wantedto show NDB with a database size of around 20 TByte of user data in a replicatedsetup.There are numerous ways to connect ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Disclaimer: the following script only works for Percona Server for MySQL 5.7, and relies on enabling performance schema (PS) instrumentation which can add overhead on high concurrent systems, and is not intended for continuous production usage as it’s a POC (proof of concept).IntroductionIn Percona Support, we frequently receive tickets related to deadlocks and even though the deadlock concept is simple, troubleshooting might not be in all cases. As explained in How to Deal with MySQL Deadlocks, a deadlock occurs when two or more transactions mutually hold and request for locks, creating a cycle of dependencies ... Read More

Feed: Planet MySQL; Author: Dave Stokes;  I have two talks this week on MySQL 8.0 that you can attend virtually. And another session that is one line also plus an article.  Busy week!First is a follow on to a earlier session I did for the good folks at cPanel want you to register here for MySQL 8.0 changes for DBAs and DevOps on August 12th, 2020  at 2PM CDT. The first talk was mainly for developers and this time I am, heavily covering InnoDB Cluster and features that are of more interest to the folks who keep MySQL instances running.MergePHP ... Read More

Feed: Planet MySQL; Author: Justin Swanhart; I like bugs.  Probably not as much as Valerii Kravchuk (http://mysqlentomologist.blogspot.com/) a former colleague of mine who posted about MySQL bugs for a long time, but I still like bugs.  I like finding bugs, I like fixing bugs, and I like analyzing bugs.   While I work on the WARP storage engine, I am filing bugs and feature requests for issues I find with MySQL.  I also like to comment on MySQL bugs in the bug database to help the MySQL engineers find root causes, and to help end users with workarounds, or explaining ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; In Percona Kubernetes Operator for Percona XtraDB Cluster (PXC) versions prior to 1.5.0, there were two methods for upgrading PXC clusters, and both of these use built-in StatefulSet update strategies. The first one is manual (OnDelete update strategy) and the second one is semi-automatic (RollingUpdate strategy). Since the Kubernetes operator is about automating the database management, and there are use cases to always keep the database up to date, a new smart update strategy was implemented.Smart Update StrategyThe smart update strategy can be used to enable automatic context-aware upgrades of PXC clusters between ... Read More

Feed: Planet MySQL; Author: Dave Stokes;     MySQL has had replication for decades but the various options can be confusing.  One social media post I read recently could be summarized with the statement 'there are too many good options but how do I know which is right for me?'Cluster    Of all the words used in the computer related world, 'cluster' is the one that I wish we could have found a replacement for as the confusion over the word has created it's own cluster. Since MySQL has InnoDB Cluster and NDB cluster with other vendors using the word we end ... Read More

Feed: Planet MySQL; Author: Hardik Savani; In this short tutorial we will cover an how to call mysql view in laravel. I’m going to show you about laravel migration create view. Here you will learn laravel migration make view. i explained simply step by step how to use mysql view in laravel. Let's see bellow example laravel using mysql views.In this post, i will show you how to create mysql view using laravel migration and how to use mysql view with laravel eloquent model.basically, we are using sql view because we don't require to write long query on our database ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Rewriting a MySQL query for performance is an important process that every DBA should be aware of so they can fix the wrong queries on runtime without code changes on the application end. ProxySQL has great support for rewriting the queries, which Alkin Tezuysal already explored in his excellent blog ProxySQL Query Rewrite Use Case.So far, MySQL community provides two built-in query rewrite plugins to perform this task. Recently they introduced the plugin “ddl_rewriter”.query rewriter plugin : It has support for INSERT / UPDATE / DELETE / REPLACE statements from MySQL 8.0.12. ddl_rewritter plugin: It ... Read More

Feed: Planet MySQL; Author: Marcelo Altmann; At the Percona engineering team, we often receive requests to analyze changes in MySQL/Percona Server for MySQL behavior from one version to another, either due to regression or a bug fix (when having to point out to a customer that commit X has fixed their issue and upgrading to a version including that fix will solve their problem).In this blog post, we will analyze the approach used to fix PS-7019 – Correct query results for LEFT JOIN with GROUP BY.Each release comes with a lot of changes. For example, the difference between MySQL 8.0.19 ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Recently I had the opportunity to test a storage device from ScaleFlux called CSD 2000. In this blog post, I will share the results of using it to run MySQL in comparison with an Intel device that had a similar capacity.First of all, why do we need another storage device? Why is ScaleFlux any different?The answer is simple; it gives us built-in compression and atomic writes. For many workloads, but especially for database-type workloads, these are very important features.Because of built-in compression, we can store more data on the ScaleFlux device than on ... Read More