Buy Percona ServicesBuy Now!

Webinar 6/27: MySQL Troubleshooting Best Practices: Monitoring the Production Database Without Killing Performance

 | June 26, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MariaDB, MySQL, MySQL 101, Percona Server for MySQL, Performance Schema, Technical Webinars

performance troubleshooting MySQL monitoring tools

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 (UTC-4). Register Now   During the MySQL Troubleshooting webinar series, I covered many monitoring and logging tools such as: General, slow, […]

Read More

Webinar Thursday March 1, 2018: Performance Schema for MySQL Troubleshooting

 | February 28, 2018 |  Posted In: Insight for DBAs, MySQL, Performance Schema, Technical Webinars

Performance Schema for MySQL Troubleshooting

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 5.5, is a really powerful tool. It is actively under development, and each new version provides […]

Read More

ClickHouse in a General Analytical Workload (Based on a Star Schema Benchmark)

 | June 22, 2017 |  Posted In: Benchmarks, MySQL, Performance Schema

ClickHouse

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test. We have mentioned ClickHouse in some recent posts (ClickHouse: New Open Source Columnar Database, Column Store Database Benchmarks: MariaDB ColumnStore vs. Clickhouse vs. Apache Spark), where it showed excellent results. ClickHouse by itself seems […]

Read More

Quickly Troubleshoot Metadata Locks in MySQL 5.7

 | December 28, 2016 |  Posted In: MySQL, Performance Schema

Metadata Locks

In a previous article, Ovais demonstrated how a DDL can render a table blocked from new queries. In another article, Valerii introduced performance_schema.metadata_locks, which is available in MySQL 5.7 and exposes metadata lock details. Given this information, here’s a quick way to troubleshoot metadata locks by creating a stored procedure that can: Find out which […]

Read More

Webinar Tuesday, May 24: Understanding how your MongoDB schema affects scaling, and when to consider sharding for help

 | May 19, 2016 |  Posted In: MongoDB, Performance Schema

Please join David Murphy on Tuesday, May 24 at 10 am PDT (UTC-7) as he presents “Understanding how your MongoDB schema affects scaling, and when to consider sharding for help.” David will discuss the pros and cons of a few MongoDB schema design patterns on a stand-alone machine, and then will look at how sharding […]

Read More

Performance Schema: Measure Multi-Threaded Slave Activity

 | December 18, 2015 |  Posted In: MySQL, Performance Schema

multi-threaded slave

Performance Schema In many types of database workloads, using a multi-threaded slave from 5.6+ helps improve replication performance. I’ve had a number of users enable this feature, but have not seen anyone ask how each thread is performing. Here’s a quick way with Performance_Schema to measure the amount of multi-threaded slave activity on each thread (after you […]

Read More

Act Quickly for Percona Live Super Saver rate – Plus an added incentive!

 | December 15, 2015 |  Posted In: Percona Live, Performance Schema

Our Super Saver discount rate for Percona Live 2016 is only available ‘til December 31st! This rate gets you all the excellent and amazing opportunities that Percona Live offers, at a discount. The Percona Live Data Performance Conference is the premier open source event for the data performance ecosystem. It is the place to be […]

Read More

Upcoming Webinars

All Webinars »