EmergencyEMERGENCY? Get 24/7 Help Now!

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

Percona Live Keynote Speakers and Topics!

 | September 10, 2015 |  Posted In: Events and Announcements

The countdown for the annual Percona Live Data Performance Conference and Expo in Europe continues with today’s announcement of our keynote speakers! This three-day conference focuses on the latest trends, news and best practices in the MySQL, NoSQL and data in the cloud markets, while looking forward to what’s on the long-term horizon within the global data […]

Read More

The MySQL query cache: Worst enemy or best friend?

 | August 7, 2015 |  Posted In: Benchmarks, MySQL

During the last couple of months I have been involved in an unusually high amount of performance audits for e-commerce applications running with Magento. And although the systems were quite different, they also had one thing in common: the MySQL query cache was very useful. That was counter-intuitive for me as I’ve always expected the […]

Read More

Oracle license revenue and the MySQL ecosystem

 | June 25, 2015 |  Posted In: MySQL

Oracle was in the news recently with the story of its license revenue declining as much as 17% in the recent quarter. This is blamed on transitioning to the cloud in some publications, but others, such as Bloomberg and TechRepublic, look deeper, seeing open source software responsible for the bulk of it. Things are especially […]

Read More

Optimizer hints in MySQL 5.7.7 – The missed manual

 | April 30, 2015 |  Posted In: EXPLAIN, Insight for DBAs, MySQL, Percona Live, query tuning

In version MySQL 5.7.7 Oracle presented a new promising feature: optimizer hints. However it did not publish any documentation about the hints. The only note which I found in the user manual about the hints is: It is now possible to provide hints to the optimizer by including /*+ … */ comments following the SELECT, […]

Read More

Generated (Virtual) Columns in MySQL 5.7 (labs)

 | April 29, 2015 |  Posted In: MySQL, MySQL 5.7

About 2 weeks ago Oracle published the MySQL 5.7.7-labs-json version which includes a very interesting feature called “Generated columns” (also know as Virtual or Computed columns). MariaDB has a similar feature as well: Virtual (Computed) Columns. The idea is very simple: if we store a column

in our table we may want to filter or group […]

Read More

Percona Live & OpenStack Live 2015 wrap-up

 | April 24, 2015 |  Posted In: Events and Announcements, MySQL, OpenStack Live, Percona Live

With highlights that included news of Percona’s acquisition of Tokutek, a lively keynote discussion with Apple legend Steve “Woz” Wozniak, scores of technical sessions, tutorials and a festive MySQL community dinner and game night, last week’s Percona Live MySQL Conference and Expo had something for everyone. More than 1,200 attendees from around the world converged […]

Read More

Checking table definition consistency with mysqldiff

 | April 15, 2015 |  Posted In: MySQL

Data inconsistencies in replication environments are a pretty common. There are lots of posts that explain how to fix those using pt-table-checksum and pt-table-sync. Usually we only care about the data but from time to time we receive this question in support: How can I check the table definition consistency between servers? Replication also allow […]

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.