The latest from the MySQL community

Yesterday I blogged about the MySQL Challenge to limit rows accessed. Sheeri had some great comments about the subject, but didn't know either why the first 4 rows were not counted in my original solution:

mysql> explain select actor_id from actor where actor_id % 5 = 0 and actor_id < 26;

*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: actor
type: range
possible_keys: PRIMARY
key: PRIMARY
key_len: 2
ref: NULL
rows: 20
Extra: Using where; Using index

mysql>

I've been thinking about this some more, and wondered what would happen if I tried this query:

mysql> select actor_id from actor where actor_id …

We were chatting with Jeremy Cole today and he brought to my attention last version of MySQL Community Eddition (5.0.51) was released in November 2007 - over 7 months ago. MySQL 5.0.51a and MySQL 5.0.51b security fixes were released but these can't be considered proper releases.

If we look at the old Kaj's Announcement we can see there suppose to be 2 yearly binary releases (which are overdue) and 4 predictable yearly source releases, which we have not seen either.

Though, Honestly, I do not care that much any more. I have adapted my ways not to go to dev.mysql.com for MySQL downloads any more but go to …

Quite a few Blog postings pop up recently, let me outline two of them.

Gerry Narvaja talks about multi-page printing by using the MySQL Workbench community edition utilizing the PDF output. Find his posting here.

Weizh posted a nice step-by-step tutorial on how to use Workbench to show differences between two databases. Find it here.

Both workflows get you what you want by using the Community Edition. For those of you who want everything on a silver plate there is the Standard Edition of course, which simplifies these tasks even more.

On a side note: To get more information about the printing topic Gerry …

I just finished the third of four week-long residence weeks for school. One more to go and I'll get some semblance of a life back...my wife can't wait. "The Opposable Mind" by Roger Martin was one of the books we had to read as prep for the week. Roger is dean of the Rotman School of Management at the University of Toronto. Roger is one of the most prominent and prolific supporters of integrative thinking. What is integrative thinking? "Integrative Thinking is the ability to constructively face the tensions of opposing models, and instead of choosing one at the expense... READ MORE

I was contacted by the folks at MONyog and asked if I would review MONyog. Since using MONyog is something I have been wanting to do for a while, I jumped at the chance. Of course, “jumped” is relative; Rohit asked me at the MySQL User Conference back in April, and here it is two months later, in June. My apologies to folks for being slow.

This review is an overall review of MONyog as well as specifically reviewing the newest features released in the recent beta (Version 2.5 Beta 2). Feature requests are easily delineated with (feature request). This review is quite long, feel free to bookmark it and read it at your leisure. If you have comments please add them, even if it takes a while for you to read this entire article.

While the webyog website gives some information about what MONyog can do, it is a bit vague about what MONyog is, although there …

A few hours ago the German Soccer team reached the European Football Championship Final but did not win the title. Now it's XAMPP's turn. ;) XAMPP got nominated for the SourceForge Community Choice Award 2008 in three categories:
Best Project
Best Project for Educators
Best Tool or Utility for DevelopersThank you all for your support and votes during the nomination. It worked!! :)

Now, for the final please support us again and vote for XAMPP. Help us spread the word.

The UPS decided to visit today and left this on the front doorstep:

Woot! If it’s even half as good as the tips and tricks described in the authors’ blogs we should all be in for a treat.

…and while I’m posting pictures, I can’t resist sharing this photo we took while visiting my family in Maine last week:

Yes, that’s a full size riding lawn mower strapped to the top of a small Ford Escort hatchback.

Version 0.7 of Q4M (a pluggable message queue storage engine for MySQL) has been released with following changes.

1. Faster SELECT COUNT(*)

   Q4M now caches the number of rows within a table. It is now possible to heavily issue SELECT COUNT(*) queries to monitor queue usage.

2. Dropped binlog capability flags

   Q4M tables were incorrectly marked as binlog-capable in previous releases.

3. Added examples/crawler

   Q4M now includes an example web spider implementation. According to a test using preliminary version (detail in Japanese), the implementation was about two times faster than a crawler …

As I said before, I was invited to be on a panel at Velocity Conference.  I was delighted to go.  I had never been to San Francisco.  I have been to Portland and Santa Clara several times.  The panel was great.  It was the Brian and photo sharing sites show.  Seriously, it was me (dealnews.com), John Allspaw of Flickr, Don MacAskill of SmugMug and Farhan Mashraqi of Fotolog.  Oh, there was also Shayan Zadeh of Zoosk, a social dating network and Michael Halligan, a consultant from BitPusher.  We all had similar ideas.  I told my …

Spot the problem:

You work for company X.

• Phone rings: “Hi, my name is Alice, I work for company X”
• “Hi Alice, this is Bob, in order to verify that you do actually work for X, what is your employee number and phone extension, I’ll call you back when verified”.
• “Okay Bob, it’s Alice, employee number 1234 and I’m on 555-5555″
• You look up the employee database and sure enough, Alice is there with number 1234.

Were you talking to Alice?

Will you be talking to Alice if you dial 555-5555?