EmergencyEMERGENCY? Get 24/7 Help Now!

Optimizing MySQL Performance: Choosing the Right Tool for the Job

 | April 7, 2014 |  Posted In: Insight for DBAs, MySQL, Technical Webinars

Next Wednesday, I will present a webinar about MySQL performance profiling tools that every MySQL DBA should know. Application performance is a key aspect of ensuring a good experience for your end users. But finding and fixing performance bottlenecks is difficult in the complex systems that define today’s web applications. Having a method and knowing how […]

Read More

MySQL & Sphinx: Register now for Nov. 20 Webinar

 | November 13, 2013 |  Posted In: Insight for DBAs, MySQL, Technical Webinars

Sphinx is a free, open-source search server that integrates nicely with MySQL. It provides a fast, scalable, and pluggable search framework. The Sphinx engine possesses a variety of tools enabling you to customize how searching/indexing interacts with or becomes a part of your environment. Join me and Sphinx Search CEO/CTO Andrew Aksyonoff, the founder and creative […]

Read More

How InnoDB promotes UNIQUE constraints

 | September 10, 2013 |  Posted In: Insight for DBAs, Insight for Developers, MySQL

The other day I was running pt-duplicate-key-checker on behalf of a customer and noticed some peculiar recommendations on an InnoDB table with an odd structure (no PRIMARY key, but multiple UNIQUE constraints). This got me thinking about how InnoDB promotes UNIQUE constraints to the role of PRIMARY KEYs. The documentation is pretty clear: [DOCS] When […]

Read More

Amazon RDS with MySQL 5.6 – Configuration Variables

 | August 21, 2013 |  Posted In: Cloud and NoSQL, MySQL, Technical Webinars

One longstanding complaint I have heard for the past several years, and still hear today, is that Amazon’s Relational Database Service (RDS) does not allow the configuration flexibility as running MySQL in an ec2 instance. While true, this ignores the consistent work that Amazon has done to provide access to the most important configuration variables […]

Read More

Percona Training In Sydney

 | August 30, 2011 |  Posted In: Events and Announcements, MySQL

For those that missed it – we added training in Sydney to our website. We’ve booked a training venue near the Museum of Contemporary Art (200 George Street). Some minor logistical changes: The start time will now be 9am to 5pm We look forward to seeing you there!

Read More

What’s up with HandlerSocket?

 | March 28, 2011 |  Posted In: Cloud and NoSQL, MySQL, Percona Software

I’ve presented at two different venues about HandlerSocket recently and the number one question that always arises is: Why hasn’t HandlerSocket become more popular than it is? Considering how fast and awesome HandlerSocket is, it’s not seeing as rapid adoption as some might expect. I theorize that there are five reasons for this:

Read More

Where does HandlerSocket really save you time?

 | March 16, 2011 |  Posted In: Insight for DBAs, MySQL

HandlerSocket has really generated a lot of interest because of the dual promises of ease-of-use and blazing-fast performance. The performance comes from eliminating CPU consumption. Akira Higuchi’s HandlerSocket presentation from a couple of months back had some really good profile results for libmysql versus libhsclient (starting at slide 15). Somebody in the audience at Percona […]

Read More

Upcoming Webinar on HandlerSocket

 | March 14, 2011 |  Posted In: Cloud and NoSQL, Events and Announcements, MySQL

On March 29th, I’ll be giving a webinar whose title is “Understanding HandlerSocket – A NoSQL PlugIn For MySQL”. This is a continuation and extension of the talk I gave during the Percona Live Event in San Francisco back in February. We’ll ask, and answer, the following questions: What is HandlerSocket? Where does HandlerSocket fit […]

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.