by Sveta Smirnova | Mar 14, 2018 | MySQL, Webinars
In this blog, I will provide answers to the Q & A for the Basic Internal Troubleshooting Tools for MySQL Server webinar.First, I want to thank everybody for attending my February 15, 2018, webinar on troubleshooting tools for MySQL. The recording and slides for... by Sveta Smirnova | Mar 13, 2018 | Monitoring, MySQL, Percona Software, Webinars
Please join Percona’s Principal Support Engineer, Sveta Smirnova, as she presents Basic External MySQL Troubleshooting Tools on March 15, 2018 at 10:00 am PDT (UTC-7) / 1:00 pm EDT (UTC-4).In my troubleshooting webinar series, I normally like to discuss built-in... by Sveta Smirnova | Feb 28, 2018 | Insight for DBAs, MySQL, Webinars
Please join Percona’s Principal Support Engineer, Sveta Smirnova, as she presents Performance Schema for MySQL Troubleshooting on Thursday, March 1, 2018, at 10:00 am PST (UTC-8) / 1:00 pm EST (UTC-5). Register Now Performance Schema, first introduced in version... by Sveta Smirnova | Feb 15, 2018 | MySQL, Webinars
In this blog, I will provide answers to the Q & A for the Troubleshooting MySQL Crashes webinar.First, I want to thank everybody for attending our January 25, 2018, webinar. The recording and slides for the webinar are available here. Below is the list of... by Sveta Smirnova | Feb 12, 2018 | Insight for DBAs, MySQL, Open Source, Webinars
Please join Percona’s Principal Support Engineer, Sveta Smirnova, as she presents “Basic Internal Troubleshooting Tools for MySQL Server” on Thursday, February 15, 2018, at 10:00 am PST (UTC-8) / 1:00 pm EST (UTC-5).Register Now MySQL Server... by Sveta Smirnova | Jan 24, 2018 | Insight for DBAs, Insight for Developers, MySQL, Open Source, Webinars
Please join Percona’s Principal Support Engineer, Sveta Smirnova, as she presents Troubleshooting MySQL Crashes on January 25, 2018, at 10:00 am PST (UTC -8) / 1:00 pm EST (UTC -5). Register Now This webinar is for every MySQL user! In this talk, I... by Sveta Smirnova | Oct 12, 2017 | Insight for DBAs, MySQL, Percona Software
by Sveta Smirnova | Sep 11, 2017 | Insight for DBAs, Insight for Developers, Monitoring, MySQL
In this post, we will discuss the best way to update an InnoDB table manually.As a support engineer, I often see situations when the cardinality of a table is not correct. When InnoDB calculates the cardinality of an index, it does not scan the full table by... by Sveta Smirnova | Aug 23, 2017 | Cloud, MySQL
In this blog post, we’ll discuss migrating data from encrypted Amazon MySQL RDS to encrypted Amazon Aurora.One of my customers wanted to migrate from an encrypted MySQL RDS instance to an encrypted Aurora instance. They have a pretty large database,... by Sveta Smirnova | May 11, 2017 | MySQL, Storage Engine, Webinars
In this blog post, we’ll look at MyRocks and the LOCK IN SHARE MODE.Those who attended the March 30th webinar “MyRocks Troubleshooting” might remember our discussion with Yoshinori on LOCK IN SHARE MODE.I did more tests, and I can confirm... by Sveta Smirnova | Apr 13, 2017 | MySQL, Webinars
In this blog, we will provide answers to the Q & A for the TokuDB Troubleshooting webinar.First, we want to thank everybody for attending the March 22, 2017 webinar. The recording and slides for the webinar are available here. Below is the list of your questions... by Sveta Smirnova | Mar 28, 2017 | MySQL, Webinars
In this blog, I will provide answers to the Q & A for the Troubleshooting Issues with MySQL Character Sets webinar.First, I want to thank everybody for attending the March 9 MySQL character sets troubleshooting webinar. The recording and slides for the webinar are... by Sveta Smirnova | Mar 10, 2017 | MySQL, Security, Webinars
In this blog, I will provide answers to the Q & A for the Troubleshooting MySQL Access Privileges Issues webinar.First, I want to thank everybody for attending the February 23 webinar. The recording and slides for the webinar are available here. Below is the list... by Sveta Smirnova | Mar 1, 2017 | MySQL, Open Source
In this blog post, I’ll look for the bottleneck that prevented the performance in my previous post from achieving better results.The powerful machine I used in the tests in my previous post has a comparatively slow disk, and therefore I... by Sveta Smirnova | Feb 16, 2017 | MySQL
In this blog post, we’ll look at a workaround for MySQL bug 72804.Recently I worked on a ticket where a customer performed a point-in-time recovery PITR using a large set of binary logs. Normally we handle this by applying the last backup, then... by Sveta Smirnova | Jan 26, 2017 | MySQL, Open Source
In this blog post, we’ll look at Performance Schema benchmarks for OLTP Read/Write workloads.I am in love with Performance Schema and talk a lot about it. Performance Schema is a revolutionary MySQL troubleshooting instrument, but earlier versions had... by Sveta Smirnova | Jan 19, 2017 | Open Source
In the second post in my series on open source databases on big machines, we’ll look at whether READ COMMITTED scales with multiple cores.The default transaction level for InnoDB is REPEATABLE READ. A more permissive level is READ COMMITTED, and is... by Sveta Smirnova | Jan 6, 2017 | Benchmarks, MySQL, Open Source, Percona Live, PostgreSQL
This blog compares how PostgreSQL and MySQL handle millions of queries per second.Anastasia: Can open source databases cope with millions of queries per second? Many open source advocates would answer “yes.” However, assertions aren’t enough for... by Sveta Smirnova | Nov 18, 2016 | MongoDB
In this blog, I will provide answers to the Q & A for the WiredTiger B-Tree versus WiredTiger In-Memory webinar.First, I want to thank everybody for attending the October, 13 webinar. The recording and slides for the webinar are available here. Below is the list... by Sveta Smirnova | Sep 8, 2016 | MySQL, Webinars
In this blog, I will provide answers to the Q & A for the MySQL Replication Troubleshooting webinar.First, I want to thank everybody for attending the August 25 webinar. Below is the list of your questions that I wasn’t able to answer during the webinar,...