June 18, 2013

Post: Choosing a MySQL HA Solution - Post-Webinar Q&A

Thanks to everyone who was in attendance on 05 June 2013 for my “Choosing … like you’ll need to wait for the next release of MHA. Q: How do you monitor MySQL to determine when it’s… this is a viable use case. If someone can prove me wrong, I’d be interested in knowing how you’ve…

Comment: 10 years of MySQL User Conferences

… MySQL/Sun. Oh, yeah, I knew who he was: he was the guy I contacted to have my blog aggregated into planet…. So I looked up Giuseppe who said “I don’t have time now, could you meet me tomorrow morning (Tuesday) just before… ballroom before keynote; no time to talk to me, would you please come sit with us? OK, sitting next to Giuseppe & Dups. “Just how do…

Post: Open Source, the MySQL market (and TokuDB in particular)

…the Open Source model is something different. Now let me state that I am not an Open Source … during the next year. However, becoming Open Source, by itself, is by no means enough to have a … on why the future belongs to MariaDB.” To quote that article: “In principle, anyone who has an interest in …

Comment: SimCity outages, traffic control and Thread Pool for MySQL

… available to discuss publicly. The Thread Pool code was originally written by a very smart engineer at eBay who‘s name escapes me. Because eBay wanted to have a supported version of this code… on the agreement that the code would be able to all in the next open source version (that would be 5.1…

Comment: What's up with HandlerSocket?

… performance as much as the next guy (probably more than most, depending on who we decide is standing next to me), but I also need… perform analogously to handlersockets. Then my existing code and code base would run faster and the development staff who knows how to write SQL wouldn’t need to turn around and learn another API to fetch/set data…

Comment: What's up with HandlerSocket?

… performance as much as the next guy (probably more than most, depending on who we decide is standing next to me), but I also need… perform analogously to handlersockets. Then my existing code and code base would run faster and the development staff who knows how to write SQL wouldn’t need to turn around and learn another API to fetch/set data…

Post: High-Performance Click Analysis with MySQL

…-ness in the meantime, you might have to do some awkward backpedaling with customers, who now expect realtime data.  The database… moved those other values around to store them “next, to in the same row” instead of “below, in the next row.” So we’re… table (somehow the image of putting columns next to each other makes me think of putting cards next to each other and shoving). Archive If…

Comment: Is there a performance difference between JOIN and WHERE?

who was claiming that and his “proof” was also “they told me“). Using outer joins without need is rare mistake among people whoto the idea why joins are necessary at all. (Inner, outer, natural .. who cares? They are all the same aren’t they?) Next… is little more difficult to forget join condition and end up with unwanted Cartesian product. It would be next to impossible if ON…

Post: How Percona does a MySQL Performance Audit

… you’re not. It’s just like a mechanic who listens to the car and says “I hear the valves…machine setup is fine, and the client has asked me to figure out why the website is slow; assume …is set to 22GB, it’s much easier to see 22GB than 23622320128, especially since that number is buried next to a…

Post: Percona is hiring performance experts

… we have openings for more experts in the next couple of months. Let me explain a little about what we’re looking… the highest caliber. You have to be a fast learner who pushes to learn new things. You have to be great with people; good… months to see how things go. Due to the above considerations and our growing demand, we’re particularly interested in people who might…