by Sveta Smirnova | Jul 28, 2020 | MySQL, Percona Software
I got this question on the “How to Avoid Pitfalls in Schema Upgrade with Percona XtraDB Cluster (PXC)” webinar and wanted to answer it in a separate post. Will RSU have an effect on GTID consistency if replication PXC cluster to another cluster? Answer for... by Sveta Smirnova | Jun 4, 2020 | MySQL, Percona Software, Webinars
First I want to thank everyone who attended my May 21, 2020 webinar “How Safe is Asynchronous Master-Master Setup in MySQL?“. Recording and slides are available on the webinar page.Here are answers to the questions from participants which I was not able to... by Sveta Smirnova | Apr 9, 2020 | Insight for DBAs, MySQL, Open Source
March is not only the month when a pandemic closed all borders and people had to stay home on the quarantine; it’s also the month when daylight saving time change happens. For some regions, this is not only a time change but also a switch to a different... by Sveta Smirnova | Jan 2, 2020 | MySQL
First I want to thank everyone who attended my December 19, 2019 webinar “Top 3 Features of MySQL“. Recording and slides are available on the webinar page.Here are answers to the questions from participants which I was not able to provide during the... by Sveta Smirnova | Dec 19, 2019 | MySQL, Webinars
by Sveta Smirnova | May 7, 2019 | MariaDB, MySQL, Percona Events, Percona Live
Less than one month left until Percona Live. This time the Committee work was a bit unusual. Instead of having one big committee for the whole conference we had a few mini-committees, each responsible for a track. Each independent mini-committee, in turn, had a leader... by Sveta Smirnova | May 2, 2019 | MySQL, Percona Services, Percona Software
When users experience memory usage issues with any software, including MySQL®, their first response is to think that it’s a symptom of a memory leak. As this story will show, this is not always the case.This story is about a bug.All Percona Support customers... by Sveta Smirnova | Apr 25, 2019 | Insight for DBAs, MySQL, Webinars
Please join Percona’s Principal Support Engineer Sveta Smirnova as she presents Billion Goods in Few Categories: How Histograms Save a Life? Watch the Recorded Webinar We store data with the intention to use it: search, retrieve, group, sort, etc. To perform... by Sveta Smirnova | Mar 19, 2019 | Insight for DBAs, MySQL, Webinars
Please join Percona’s Principal Support Engineer, Sveta Smirnova, as she presents MySQL Performance Schema in 1 hour on Thursday, March 21st, 2019, at 10:00 am PDT (UTC-7) / 1:00 pm EDT (UTC-4). View the Recording MySQL 8.0 Performance Schema is a mature tool,... by Sveta Smirnova | Mar 15, 2019 | Insight for DBAs, MySQL
Just about a month ago, Pavel Ivanov released Ripple under the Apache-2.0 license. Ripple is a MySQL binlog server: software which receives binary logs from MySQL or MariaDB servers and delivers them to another MySQL or MariaDB server. Practically ,this is an... by Sveta Smirnova | Sep 25, 2018 | MySQL
Lately, I worked on several queries which started returning wrong results after upgrading MySQL Server to version 5.7 The reason for the failure was derived merge optimization which is one of the default optimizer_switch options. Issues were solved, though at... by Sveta Smirnova | Jun 26, 2018 | Insight for DBAs, Insight for Developers, MariaDB, MySQL, Percona Software, Webinars
Please join Percona’s Principal Support Escalation Specialist Sveta Smirnova as she presents Troubleshooting Best Practices: Monitoring the Production Database Without Killing Performance on Wednesday, June 27th at 11:00 AM PDT (UTC-7) / 2:00 PM EDT... by Sveta Smirnova | Jun 5, 2018 | Benchmarks, MySQL
If you attended my latest Troubleshooting MySQL Concurrency Issues with Load Testing Tools webinar you learned how I exploit benchmarking tools to replicate locking issues and crashes. But I told you nothing about proper use of these tools: for reliable benchmarks. I... by Sveta Smirnova | Jun 4, 2018 | Benchmarks, MySQL
In this blog, I will provide answers to the Q & A for the Troubleshooting MySQL Concurrency Issues with Load Testing Tools webinar.First, I want to thank everybody for attending my May 23, 2018, webinar on troubleshooting tools for MySQL. The recording and slides... by Sveta Smirnova | May 30, 2018 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
At my latest webinar “MySQL Test Framework (MTR) for Troubleshooting”, I received an interesting question about MTR test cases for Percona XtraDB Cluster (PXC). Particularly about testing SST and IST.This post is intended to answer this question. It... by Sveta Smirnova | May 21, 2018 | Insight for DBAs, Insight for Developers, MySQL, Webinars
Please join Percona’s Principal Support Escalation Specialist, Sveta Smirnova, as she presents Troubleshooting MySQL Concurrency Issues with Load Testing Tools on Wednesday, May 23, 2018 at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Register Now... by Sveta Smirnova | Apr 10, 2018 | MySQL, Webinars
Percona’s Principal Support Engineer, Sveta Smirnova presents the webinar MySQL Test Framework for Troubleshooting on April 12, 2018, at 10:00 am PDT (UTC-7) / 1:00 pm EDT (UTC-4).MySQL Test Framework (MTR) provides a unit test suite for MySQL. MySQL Server... by Sveta Smirnova | Apr 4, 2018 | Insight for DBAs, MySQL
In this blog, I will provide answers to the Q & A for the Performance Schema for MySQL Troubleshooting webinar.First, I want to thank everybody for attending my March 1, 2018, webinar. The recording and slides for the webinar are available here. Below is the... by Sveta Smirnova | Mar 27, 2018 | Insight for DBAs, Insight for Developers, MySQL, Webinars
Please join Percona’s Principal Support Engineer, Sveta Smirnova, as she presents Effective Testing for Live Applications on March 29, 2018, at 10:00 am PDT (UTC-7) / 1:00 pm EDT (UTC-4).When an application is hit with trouble in a live production environment,... by Sveta Smirnova | Mar 27, 2018 | Insight for DBAs, MySQL, Storage Engine
In this post, I’ll discuss the fix for lp:1704195 (migrated to PS-2503), which prevents ANALYZE TABLE from blocking all subsequent queries on the same table.In November 2017, Percona released a fix for lp:1704195 (migrated to PS-2503), created by...