Microslow patch is used by many DBAs and developers to accurately time their queries and to catch those which run less than a second as they can also be a performance killer for a busy application. Recently I have started the development of an updated version of the patch. The basic idea is the same […]
Our patches for 5.0 have attracted significant interest.Â You can read about SecondLife’s experience here, as well as what Flickr had to say on their blog.Â The main improvements come in both performance gains and improvements to diagnostics (such as the improvements to the slow log output, and INDEX_STATISTICS). Despite having many requests to port […]
I started using MySQL 11 years ago. That’s not too long compared to other people in the industry, but nonetheless here’s my perspective on the state of the MySQL industry after attending Percona Live MySQL Conference & Expo 2104. In short, the attitude around MySQL has changed from “Does it work?” to “Is it fast […]
When I started with MySQL 3.22 I would start running MySQL from early beta (if not alpha) and update MySQL the same date as release would hit the web. Since that time I matured and so did MySQL ecosystem. MySQL is powering a lot more demanding and business critical applications now than 12 years ago […]
I don’t use many tools in my consulting practice but for the ones I do, I try to know them as best as I can. I’ve been using mk-query-digest for almost as long as it exists but it continues to surprise me in ways I couldn’t imagine it would. This time I’d like to share […]
Percona is hiring. As part of our growth process, we introduced the role of the Shift Support Captain in 2009 (see the original announcement here) to provide customers with a 24×7 technical contact person. The Shift Support Team dispatches incoming emergencies, assigns new issues, handles or escalates incoming Nagios alerts from some customers, and in […]
February and March as busy months for Community events.Â There’s MySQL University, Fosdem, the Seattle MySQL Meetup & Confoo.ca.
I thought I should praise Innodb team for all the work they have been doing recently. We see a lot of cool stuff happening, especially in the area of our interest which is Performance And Scalability. Innodb Plugin 1.0.4 had a lot of great performance improvements and 1.0.5/1.0.6 gets even further with long standing caching […]
Talks are great. I however very much like discussion and opinion share atmosphere of the Birds of a Feather sessions so we host/co-host number of BOFs at the comming OSCON conference. Future of MySQL Forks, Branches and Patches I guess is the topic a lot of us are interested in. Monty was going to Show […]
These days I’m working with a customer who has an application based entirely on stored routines on MySQL side. Even though I haven’t worked much with stored procedures, I though it’s going to be a piece of cake. In the end – it was, but there’s a catch.