MySQL

Gearing Up for MySQLConf 2010

I’m looking forward to traveling to San Jose for this year’s MySQL Conference. If there’s anything that can trump the drama of conf two years ago, where we observed how Sun would handle its new property, and then the drama of last year, where we observed how Oracle would handle the pending acquisition, it’s going to be the drama around this one — the first MySQLConf since the Oracle/Sun merger has been finalized and approved.

Meet the First Oracle ACE Director in MySQL — Sheeri Cabral

I’m excited to share the news that Oracle ACE program has been extended to cover MySQL community now and Pythian’s Sheeri Cabral has become the very first Oracle ACE Director in MySQL expertize area. It’s a special privilege for me to blog about it because I had a pleasure to nominate Sheeri in the first place. Being an Oracle ACE Director myself and knowing what’s involved, I believed that if Oracle ACE program is extended to MySQL, Sheeri must be the number one candidate.

Hotsos Symposium 2010 — Battle Against Any Guess Is Won

What’s unusual about this session is that it’s not some technical stuff that I usually do but a more conceptual and motivational talk. Could I pull it off? Well, I think it went fairly well in general even though I did identify few rough places and my lack of English language mastering. Might need to work a little bit more on the flow of the presentation. We had quite a few good laughs. Later, people in the next hall were asking about it and Dan was making the jokes on the stage so it must have been loud. Anyway, I think nobody fell asleep and I managed to get people thinking about the topic. I received many “thank you” notes yesterday and compliments on a good session so by the end of the day I was more and more pleased. Thanks everyone for attending and especially big thanks to those of you who brought to my attention examples from their own battles. If you have more to discuss — contact me by email (my last name) {at} pythian.com.

International Women’s Day

Start planning your blog posts for Ada Lovelace day now (March 24th) To that end, I would like to point out all the women currently in science and tech fields that I admire and think are doing great things. I think it would be great if everyone, male or female, made a list like this

Database tuning: ratio vs. rate

If I told you that your database had a ratio of temporary tables written to disk of 20%, you might think “aha, my database is slow because of a lot of file I/O caused by writing temporary tables to disk!”. However, that 20% ratio may actually mean a rate of 2 per hour — which is most likely not causing excessive I/O. To get a sense of this concept, and also how mysqltuner works, I will show the lines from the mysqltuner default configuration that deal with temporary tables written to disk.

Page 41 of 85« First Page...10...3940414243...50...Last Page »