Buy Percona ServicesBuy Now!

Webinar Tues 19/6: MySQL: Scaling and High Availability – Production Experience from the Last Decade(s)

 | June 18, 2018 |  Posted In: High-availability, MySQL, open source databases, Technical Webinars

scale high availability

Please join Percona’s CEO, Peter Zaitsev as he presents MySQL: Scaling and High Availability – Production Experience Over the Last Decade(s) on Tuesday, June 19th, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Register Now   Percona is known as the MySQL performance experts. With over 4,000 customers, we’ve studied, mastered and […]

Read More

Webinar Wednesday, May 9, 2018: MySQL Troubleshooting and Performance Optimization with Percona Monitoring and Management (PMM)

 | May 7, 2018 |  Posted In: Insight for DBAs, Percona Monitoring and Management, Technical Webinars

MySQL Troubleshooting

Please join Percona’s CEO, Peter Zaitsev as he presents MySQL Troubleshooting and Performance Optimization with PMM on Wednesday, May 9, 2018, at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Optimizing MySQL performance and troubleshooting MySQL problems are two of the most critical and challenging tasks for MySQL DBAs. The databases powering your applications […]

Read More

MySQL Query Performance: Not Just Indexes

 | January 30, 2018 |  Posted In: Insight for DBAs, MySQL

MySQL Query Performance

In this blog post, I’ll look at whether optimizing indexing is always the key to improving MySQL query performance (spoiler, it isn’t). As we look at MySQL query performance, our first concern is often whether a query is using the right indexes to retrieve the data. This is based on the assumption that finding the data is […]

Read More

Webinar Thursday, January 25, 2018: Troubleshooting MySQL Crashes

and  | January 24, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, open source databases, Technical Webinars

MySQL Crashes

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 won’t focus on how to analyze core files, read the source […]

Read More

Does the Meltdown Fix Affect Performance for MySQL on Bare Metal?

and  | January 18, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Security

Meltdown Fix Affect Performance small

In this blog post, we’ll look at does the Meltdown fix affect performance for MySQL on bare metal servers. Since the news about the Meltdown bug, there were a lot of reports on the performance hit from proposed fixes. We have looked at how the fix affects MySQL (Percona Server for MySQL) under a sysbench workload. […]

Read More

How to Choose the MySQL innodb_log_file_size

 | October 18, 2017 |  Posted In: InnoDB, Insight for DBAs, MySQL

innodb_log_file_size

In this blog post, I’ll provide some guidance on how to choose the MySQL innodb_log_file_size. Like many database management systems, MySQL uses logs to achieve data durability (when using the default InnoDB storage engine). This ensures that when a transaction is committed, data is not lost in the event of crash or power loss. MySQL’s […]

Read More

Faster Node Rejoins with Improved IST performance

and  | July 21, 2017 |  Posted In: MySQL, Percona XtraDB Cluster

IST Performance

In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance. Introduction Starting in version 5.7.17-29.20 of Percona XtraDB Cluster significantly improved performance. Depending on the workload, the increase in throughput is in the range of 3-10x. (More details here). These optimization fixes also helped improve IST (Incremental State Transfer) performance. This […]

Read More