I am currently finishing some features to make a program highly resilient to occasional crashing bugs. A particular function was found to crash on queries of the form WHERE x IN(NULL), and that crashed the entire program. Now we have a framework for intelligently recovering from arbitrary crashes. I will write more on this in the future, because I think it’s a very interesting thing to share.
The technology industry moves incredibly fast, from one bubble to another. Web 2.0. Online auctions. (Remember when the Internet was filled with hundreds of eBay clones?) Social. Mobile. Location-based. Big Data. Whatever.
Register for a Private Happy Hour and Food Event at Sfuzzi Las Colinas, Irving, TX
Please join us for our MySQL tech event hosted by Oracle and learn more about the continued investment in the world’s most popular open source database. MySQL expert Benjamin Wood will be on hand to discuss new features, commercial extensions, and provide details on MySQL 5.6.
id="attachment_7393" class="wp-caption alignright" style="width: 310px">
class="size-full wp-image-7393 " title="Join in my Webinar "Learn How MySQL 5.6 Makes Query Optimization Easier" for more tips on the 5.6 optimizer" alt="Percona Webinars" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2011/11/percona-webinars.png" width="300" height="165" />
class="alignright size-medium wp-image-13691" alt="Percona Remote DBA for MySQL" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/03/Percona-Remote-DBA-for-MySQL-300x194.jpg" width="300" height="194" />As part of
One of the most rewarding things you can do is help someone get a great job or hire a great person for the position they need to fill. I have traveled a lot, written books, done a bunch of consulting, and spoken widely on MySQL, other databases, open source, and so forth. I’ve gotten to know a lot of people, some I’d call good friends, and many of them are leading large organizations. I think this is both a privilege and a serious responsibility.
I discussed my previous post on O_DIRECT_NO_FSYNC with the InnoDB team and they fixed my understanding of a few parts of the code that contribute to the stalls I have been reporting. We also discussed a problem I have been ignoring. The InnoDB code that does an fsync for a tablespace (fil_flush) can make a thread sleep when there are concurrent attempts to do the fsync. The amount of time to sleep, 20 milliseconds, was probably chosen in 1995.
I was a guest on the Food Fight Show last week, along with a bevy of really smart people asking and answering tough questions on fault detection. We didn’t talk a lot about MySQL, but given that VividCortex is focusing on MySQL initially, pretty much all of my experience with zero-threshold, zero-configuration fault detection is MySQL-based.