Next Thursday, May 8, the New England SQL Server Users Group will have a special meeting, featuring Craig Freedman from the SQL Server development team. At the meeting next week, Craig will discuss some of what he talked about in the chapter, including the basics of how the query processor works and what iterators are. He’ll cover the various operators you’ll commonly see in query plans, and describe how they actually work internally.This should be a great meeting, and we expect it to be very well attended. In order to help us figure out food and drink, in addition to securing enough chairs for the meeting room, we need you to RSVP if you’re planning to attend. In order to RSVP, sign up for our mailing list.
All of the videos from the 2008 MySQL Conference have been processed and uploaded. Links to the videos, slides, notes, photos for each presentation are all on the mega-conference page linked to in this post. If you know of any video, audio, notes, slides, photos, etc that are not linked, please link them at the wiki page. If you can’t or won’t, please comment here and I will update the wiki for you.
By now it is no surprise that I won one of the three 2008 MySQL Community Member of the Year awards. I am going to detail in this blog post the secrets to my success. This year, I thought to myself, “how can I make it so I am not on this stage receiving this award next year?” So here is my challenge to you. I will open source my methods, and in return I will give $100 to each 2009 MySQL Community Member of the Year (in whatever form they want, whether it’s US cash, a $100 Amazon.com gift certificate, a donation to an organization, whatever).
I have already blogged about this keynote but if you would like to see the video you can watch it here. This is not to be missed!
When I do a show slave status\G, sometimes mysqld will lie to me and give me a wrong Exec_Master_Log_Pos. Let me explain with a situation from last night. In summary, the slave SQL thread is stuck (in this case because of a problem during the transfer of the binlog data to the slave’s relay log). The show slave status\G command tells me that it is stuck at the master binlog file mysql-bin.000480, position 126.
I present a challenge to MySQL employees who have derived tangible benefits from the sale to Sun: what percentage have you put back into the MySQL community, and how? I’d love to see comments on what folks are doing, even without percentages of money and such, because I am willing to wager that most of the folks who work for MySQL give plenty back to the community on non-company time. My theory is based on the fact that most MySQLers that I’ve met do not see working at MySQL as “their job”, they see it as “I get paid to do what I love doing, and would do anyway.”
If Ingres thinks they can win customers over by swooping in when a controversy is happening, they are way more evil than I would ever have guessed. It’s not good business practice to do this kind of thing — it is cold, calculated, uncalled for, and just plain wrong. There is so much else that bothered me about the e-mail I received, so I will just copy it here for full context for readers.
Chose MySQL for performance and stability, and less important but still there, experience and support. Support is becoming increasingly more and more important.
Here are the slides and links I am using for the “Database Security Using White-Hat Google Hacking” at the 2008 MySQL Users Conference and Expo.
Yesterday’s keynote panel on “Scaling MySQL — Up or Out?” Download or stream the presentation here.