EmergencyEMERGENCY? Get 24/7 Help Now!

How to avoid common (but deadly) MySQL development mistakes

 | February 28, 2014 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Technical Webinars

MySQL software developers are under pressure to do more in less time and create applications that adapt to ever-changing requirements. And it’s true that some of a developer’s time is wasted when his or her method of optimizing involves trying every combination of code and index definition. There is a better way. And next Wednesday […]

Read More

How rows_sent can be more than rows_examined?

 | February 28, 2014 |  Posted In: Insight for DBAs, MySQL

When looking at queries that are candidates for optimization I often recommend that people look at rows_sent and rows_examined values as available in the slow query log (as well as some other places). If rows_examined is by far larger than rows_sent, say 100 larger, then the query is a great candidate for optimization. Optimization could […]

Read More

Percona XtraDB Cluster performance monitoring and troubleshooting

 | February 26, 2014 |  Posted In: Insight for DBAs, MySQL, Percona MySQL Consulting, Percona XtraDB Cluster, Technical Webinars

First of all we would like to thank all of you who attended the Feb. 19 MySQL webinar, “Performance Monitoring and Troubleshooting of Percona XtraDB Cluster.” We got some really good questions – many of which we didn’t have time to address during the sessions, so Johan Andersson, Severalnines CTO,and I are answering them here […]

Read More

How to monitor ALTER TABLE progress in MySQL

 | February 26, 2014 |  Posted In: MySQL, Percona MySQL Support, Percona Toolkit

While working on a recent support issue as a Percona Support Engineer,  I got one question from a customer asking how to monitor ALTER TABLE progress. Actually, for MySQL 5.5 and prior versions, it’s quite difficult to ALTER the table in a running production environment especially for large tables (with millions records). Because it will rebuild and lock the table […]

Read More

Quick review of InfiniDB 4

 | February 25, 2014 |  Posted In: MySQL

I’ve mentioned InfiniDB before in a previous post titled, “Star Schema Bechmark: InfoBright, InfiniDB and LucidDB,” but it’s been 4 years since that was published. Recently I evaluated column-storage solutions for Percona Cloud Tools and took another look at InfiniDB 4. There was the release of version 4, which I think is worth attention. What […]

Read More

Percona Toolkit 2.2.7 is now available

 | February 25, 2014 |  Posted In: Events and Announcements, Percona Toolkit

Percona is glad to announce the release of Percona Toolkit 2.2.7 on February 24th, 2014 (Downloads are available here and from the Percona Software Repositories). This release is the current GA (Generally Available) stable release in the 2.2 series. This release fixes one security bug. An upgrade is recommended. Fixed bug 1279502: –version-check behaves like spyware The configuration for […]

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.