Looking to upgrade to MySQL 5.6? Check out my webinar on Jan 29!

We are nearing the one-year anniversary since MySQL 5.6 went GA – which is typically a good time even for the most conservative users to start thinking about upgrading. At this point there is a fair amount of practical use and experience; many bugs have also been fixed (1991 to be exact according to Morgan […]

2 cases for MySQL server overload

Your MySQL server is overloaded. You see hundreds of running queries in the SHOW PROCESSLIST taking many seconds to run, or can’t connect at all because all connections slots are busy. If you have worked with MySQL long enough you surely have seen it, probably more than once. This is what I would call “MySQL […]

Tuning MySQL 5.6 configuration – Webinar followup

We had a wonderful time during the Sept. 25 webinar, “MySQL 5.6 Configuration Optimization,” and I got a lot more questions than I could answer during the hour. So here is a followup with answers to the most interesting questions you guys asked. (You can also watch a recording of entire webinar here.) Q: What […]

Inexpensive SSDs for Database Workloads

The cost of SSDs has been dropping rapidly, and at the time of this writing, 2.5-drives have reached the 1TB capacity mark.  You can actually get inexpensive drives for as little as 60 cents per GB. Even inexpensive SSDs can perform tens of thousands of IOPs and come with 1.5M – 2M hous MTBF and […]

MySQL 5.6 Configuration Optimization Webinar, Sept. 25

This Wednesday in our next webinar I’ll share how to configure a better-performing MySQL 5.6 server. You’ll lean a practical approach to generating a sensible configuration file that sets what is needed and omits what is not. Why dedicate an entire webinar to the new configuration settings within MySQL 5.6? Mainly because the default configuration […]

Let’s connect at MySQL Connect

Later this week I’m traveling to San Francisco to attend MySQL Connect – which looks like an exciting event to be at. I’m going to deliver two talks at this show, both on Sunday – MySQL Indexing Best Practices for MySQL 5.6 and Optimizing MySQL Configuration for MySQL 5.6. I will also be there for […]

September: A busy month for MySQL events

Now with summer winding down and school back in session, we get into a very busy time with many great opportunities to discover more about MySQL with several excellent MySQL events. At first I wanted to cover all autumn events here but if I did that this post would be far too long. So instead I’m […]

MySQL 5.6 security vs ease of use

MySQL 5.6 surely changes the game when it comes to security vs ease of use. Before MySQL 5.6 we would get default MySQL installation being pretty insecure – the user “root” will be created with no password as well as anonymous user with limited access from local host (though still enough to cause DOS attack […]