EmergencyEMERGENCY? Get 24/7 Help Now!

Author Archives: Ryan Lowe

Optimizing MySQL Performance: Choosing the Right Tool for the Job

by:

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 …

Read More
 

MySQL & Sphinx: Register now for Nov. 20 Webinar

by:

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 …

Read More
 

How InnoDB promotes UNIQUE constraints

by:

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 …

Read More
 

Running MySQL 5.6 on Amazon RDS: Webinar followup questions answered

by:

Thanks to everyone who attended last week’s webinar, Running MySQL 5.6 on Amazon RDS.” If you weren’t able to attend, the recording and slides are available for viewing/download (or, if you were able to attend …

Read More
 

Amazon RDS with MySQL 5.6 – Configuration Variables

by:

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. …

Read More
 

Configuring MySQL For High Number of Connections per Second

by:

One thing I noticed during the observation was that there were roughly 2,000 new connections to MySQL per second during peak times. This is a high number by any account. When a new connection to …

Read More
 

Percona Training In Sydney

by:

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 …

Read More
 

What’s up with HandlerSocket?

by:

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 …

Read More
 

Where does HandlerSocket really save you time?

by:

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 …

Read More
 

Upcoming Webinar on HandlerSocket

by:

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 …

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.

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