EmergencyEMERGENCY? Get 24/7 Help Now!

pt-online-schema-change (if misused) can’t save the day

 | May 24, 2016 |  Posted In: Insight for DBAs, MySQL, Percona Toolkit, Replication

MySQL-replication

In this blog post we’ll discuss pt-online-schema-change, and how to correctly use it. Always use pt-osc? Altering large tables can be still a problematic DBA task, even now after we’ve improved Online DDL features in MySQL 5.6 and 5.7. Some ALTER types are still not online, or sometimes just too expensive to execute on busy production […]

Read More

CPU governor performance

 | May 6, 2016 |  Posted In: MySQL

CPU governor performance

In this blog, we’ll examine how CPU governor performance affects MySQL. It’s been a while since we looked into CPU governors and with the new Intel CPUs and new Linux distros, I wanted to check how CPU governors affect MySQL performance. Before jumping to results, let’s review what drivers manage CPU frequency. Traditionally, the default driver […]

Read More

Upgrading to MySQL 5.7, focusing on temporal types

 | April 27, 2016 |  Posted In: MySQL, Percona Server

temporal types

In this post, we’ll discuss how MySQL 5.7 handles the old temporal types during an upgrade. MySQL changed the temporal types in MySQL 5.6.4, and it introduced a new feature: microseconds resolution in the TIME, TIMESTAMP and DATETIME types. Now these parameters can be set down to microsecond granularity. Obviously, this means format changes, but why […]

Read More

Percona Live 2016: What’s New in MySQL

 | April 21, 2016 |  Posted In: Percona Live

percona live 2016

The second day of Percona Live 2016 is wrapping up, but I still wanted to get to one last lecture. Fortunately, there was a great one available: What’s New in MySQL with Geir Høydalsvik, Senior Software Development Director at Oracle, and Simon Mudd, DBA at booking.com. MySQL 5.7 is an extremely exciting new version of the world’s most popular open […]

Read More

The final three Database Performance Team characters are . . .

 | April 16, 2016 |  Posted In: Percona Managed Services

Full team banner

The last email introduced two members of the Percona Database Performance Team: The Maven and The Specialist. Now we’re ready to reveal the identity of the final three team members. The Database Performance Team is comprised of our services experts, who work tirelessly every day to guarantee the performance of your database. Percona’s support team is […]

Read More

Orchestrator-agent: How to recover a MySQL database

 | April 13, 2016 |  Posted In: MySQL, Orchestrator

orchestrator-agent

In our previous post, we showed how Orchestrator can handle complex replication topologies. Today we will discuss how the Orchestrator-agent complements Orchestrator by monitoring our servers, and provides us a snapshot and recovery abilities if there are problems. Please be aware that the following scripts and settings in this post are not production ready (missing error handling, etc.) […]

Read More

Webinar April 7, 10am PDT – Introduction to Troubleshooting Performance: What Affects Query Execution?

 | April 5, 2016 |  Posted In: MySQL

Query Execution

Join us for our latest webinar on Thursday, April 7, at 10 am PDT (UTC-7) on Introduction to Troubleshooting Performance: What Affects Query Execution? MySQL installations experience a multitude of issues: server hangs, wrong data stored in the database, slow running queries, stopped replications, poor user connections and many others. It’s often difficult not only […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.