Looks like MySQL Camp 2006 was really interesting and useful for its attendees and for entire MySQL community. As the result of this meeting of many MySQL-related professionals we’ve got lots of interesting publications and I want to refer one of them in this post. Very interesting list of 84 MySQL performance tips has beed created on first day of this year MySQL Camp at Google headquarters:

1. Index stuff.
2. Don’t Index Everything
3. Use benchmarking
4. Minimize traffic by fetching only what you need.
   • Paging/chunked data retrieval to limit
   • Don’t use SELECT *
   • Be wary of lots of small quick queries if a longer query can be more efficient
5. Use EXPLAIN to profile the query …

The final day of the MySQL Camp quotes. See also Day 1 and Day 2.

“Patches on Patches on Patches.” — Jeremy in his Query Profiler patch talk.

“I bagged Jeremy, no I mean I bashed Jeremy and all I got was this badge.” — Sheeri

“You have an enum of ‘Red’, ‘Blue’, and ‘Yellow’, and what is the result if you add 1 five times to the value of the enum.”
— Brian Aker Quiz question. The answer is Blue, and the winner was Taso. Why. You will need to do the certification example, or email me and I’ll tell you.

“High bandwidth opaque identifier” — Chuckie talking about his Unique Internet Id

“So you have until the end of lunch to work out how to start the Instance Manager” — Brian Aker on …

Well, I have a lot to say about MySQL Camp, but for now, I just want to say thank you to Jay Pipes for organizing the Camp, and to Google for hosting and feeding us, and to MySQL for support.

I have a few lost and found items — if you lost or found something, please contact me by e-mailing me at awfief@gmail.com and I will see to it that you get your item back, or that found items get to the right place.

LOST:
white 4-port USB hub

FOUND:
a charger (looks like it’s for a phone, it’s small-duty)
small stack of Avery blank printer sheets, for file folder labels
Sunglasses

If you ended up with something that’s not yours, or are missing something, contact me and we’ll do as much as we can to get items to their owners.

Well, I have a lot to say about MySQL Camp, but for now, I just want to say thank you to Jay Pipes for organizing the Camp, and to Google for hosting and feeding us, and to MySQL for support.

I have a few lost and found items — if you lost or found something, please contact me by e-mailing me at awfief@gmail.com and I will see to it that you get your item back, or that found items get to the right place.

LOST:
white 4-port USB hub

FOUND:
a charger (looks like it’s for a phone, it’s small-duty)
small stack of Avery blank printer sheets, for file folder labels
Sunglasses

If you ended up with something that’s not yours, or are missing something, contact me and we’ll do as much as we can to get items to their owners.

Zimbra hit the front page of the Wall Street Journal on Monday.  Normally a CEO doesn't make front page of the Journal until he does an IPO or goes to prison. Satish, well done!  This is even better than Scott's bobblehead doll! 

I've been a big fan of Zimbra for a long time.  They've continued to invest in building out a great product line with the Zimbra Collaboration Suite (ZCS) a highly scalable open source email and calendaring suite that now has more than 4 million mailboxes under subscription with customers like H&R Block, Raytheon, ZipRealty, Interim Healthcare and others.

…

I was pretty busy last month with project which will be annonced very soon (I hope), but I can't miss bug fix
of my favorite bug 15815. I wrote about this problem before and also investigated in my presentation.
Finally bug fix was pushed into 5.0-bk tree and now I have it in my hands.

Let me refresh results with MySQL 5.0.27 (without bugfix):

select sql_calc_found_rows * from b limit 5;
executes for 20 sec (table b contains ~2 mil rows)

the same query but in 4 concurrent threads:
98 sec
101 sec
103 sec
103 sec

(I am still using 4-CPU box and expecting the …

MySQL AB and NitroSecurity, a provider of high performance and scalable enterprise security solutions, today announced they have signed a strategic agreement to jointly develop and market a database engine for MySQL® based on NitroSecurity?s NitroEDB? extreme performance relational database technology.

I had organized a session at MySQL camp on Saturday on the above topic. I should say I was one of the guilty ones who had slides for the session in an “unconference“.

Brian Aker (of MySQL) graciously stepped in to answer some questions and provided reasons for some of the design decisions in MySQL OnlineBackup. Some of them are:

• Envelope format for backup archive. This would allow backup as well as recovery to continue in case the storage engines failed to do backup or recovery respectively.

• Block size and envelope format will help in handling tape errors.

• Logical backup will be done in case storage engine does not have online backup API …

Sun has announced today that the Java programming language and runtime environment will be open sourced under the GPL license, the license also used by Linux, MySQL and roughly 70% of all open source projects tracked at Freshmeat.net. 

While Sun's Jonathan Schwartz had previously criticized the GPL license, there's clearly a change of heart here, due to the huge popularity of Linux.  By following the GPL license, Java can now be more readily …

I'm in the middle of working through the agenda for the upcoming Open Source Business Conference (May 22-23, 2007, San Francisco), and wanted to solicit outside input.

OSBC has made great strides for its 2007 show, if for no other reason than I'm actually listening to what other people want on the agenda. :-) OSBC's Advisory Board includes: Larry Augustin, Zack Urlocker (VP of Marketing, MySQL), Bill Hilf (General Manager, Platform Strategy, Microsoft), Mark Radcliffe (Partner, DLA Piper Rudnick Gray Cary, LLP), Tim Golden (SVP, Linux Engineering, Bank of America), Andrew Aitken (President, Olliance Group), and Robin Vasan (General Partner, Mayfield).

The board has been very active in shaping the conference, making it into a much more CIO-friendly event than in years past.

You'll see this emphasis in the preliminary (very) draft below of the conference. Some of the sessions …