Buy Percona ServicesBuy Now!

MySQL Test Framework for Percona XtraDB Cluster

 | May 30, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Percona XtraDB Cluster

MySQL Test Framework

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 assumes you are familiar with MTR and can write tests for MySQL servers. If you are […]

Read More

Webinar Wed, 5/23: Troubleshooting MySQL Concurrency Issues with Load Testing Tools

 | May 21, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Technical Webinars

Benchmarking tools for troubleshooting

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   Normally, we use benchmarking tools when we are developing applications. When applications are deployed, benchmarks tests are usually too […]

Read More

Webinar Thursday, April 12, 2018: MySQL Test Framework for Troubleshooting

 | April 10, 2018 |  Posted In: MySQL, Technical Webinars

MySQL Testing Framework

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 developers and contributors write the tests in the framework, and use them to ensure the build […]

Read More

Webinar Thursday March 29, 2018: Effective Testing for Live Applications

 | March 27, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Technical Webinars

Testing for Live Applications

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, it is often difficult to: Repeat a problematic scenario without the risk of […]

Read More

ANALYZE TABLE Is No Longer a Blocking Operation

 | March 27, 2018 |  Posted In: InnoDB, Insight for DBAs, MyRocks, MySQL, TokuDB

analyze table

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 Laurynas Biveinis. The fix, included with Percona Server for MySQL since versions 5.6.38-83.0 and 5.7.20-18, stops ANALYZE TABLE from invalidating query and […]

Read More

Webinar Thursday, March 15, 2018: Basic External MySQL Troubleshooting Tools

 | March 13, 2018 |  Posted In: Database Monitoring, MySQL, Percona Monitoring and Management, Percona Toolkit, Technical Webinars

Troubleshooting Tools

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 instruments available via the SQL interface. While they are effective and help to understand […]

Read More