Colin Charles Agenda

I just built mysql-5.0-community, on my T7200 with 2GB of RAM (on Fedora Core 6), and it only took a mere:

real    7m51.127s

user    3m13.836s

sys     2m19.803s

The obligatory make test was run, and that was also pretty quick:

All 455 tests were successful.

The servers were restarted 109 times

Spent 1134.052 seconds actually executing testcases

Maybe we could have a competition to see how fast MySQL builds (under 8 minutes) and tests (under 19 minutes), something similar to the 7-second Linux kernel compile. With that it looks like 5.0.37 might make its way to the surface really soon now, since 5.0.35 was pending a release, before we canned that.

Why is MySQL Community Server 5.0.37 significant? Because it contains Jeremy Cole’s SHOW PROFILE feature. Notice how thats not just a patch any longer, its a feature, from the community, that’s been implemented in the MySQL Community Server release. Chad Miller (in Community Engineering) also extended the then patch further, and now you can also get said information via the INFORMATION_SCHEMA (look at the PROFILING table in the INFORMATION_SCHEMA).

Profiling isn’t enabled by default (check via: show variables like ‘profiling’;), so you’d do well to set profiling=’on’;. Once that is done, you can just execute SHOW PROFILE; to be greeted by the feature. Using the INFORMATION_SCHEMA database, and something like: select duration,source_function,source_file from profiling; I can see how much time MySQL takes to execute a function like the mysql_select or how long it takes to do open_tables - best of all, I can see which source file I might want to edit if need be.

I’m told this does not work on Windows, or Solaris (?), because they don’t have the getrusage() syscall, but it should probably work just fine on OS X based MySQL servers.

Technorati Tags: mysql, SHOW PROFILE, profiling, mysql community, mysql 5.0.37, timing builds

Today I saw an interesting opinion posted on a mailing list. I’ll quote from the fedora-list post:

What folks say here cant be taken as Fedora toting anything. It is just some user opinions.

Some of those “user opinions” came from @redhat.com addresses, I actually don’t take any notice of @anydomain.blah posters, as they are just like I, posting a personal opinion, but when you post with @redhat.com, it is next best thing to an official comment.

And I’m wondering, is this true with all users? Does it matter if the post comes from @projectname.com or not? Are your opinions more valued if you’re employed by an open source company or the project in question?

I personally think its silly. If I make a post to mysql-list, with my @mysql.com address, I don’t expect that to be an official comment or a reflection of our excellent (albeit, paid for) support. Are my opinions on fedora-devel-list any lesser, when I don’t have an @redhat.com address (or maybe, don’t use my @fedoraproject.org alias?). If anyone has any thoughts from the @canonical.com vs. @ubuntu.com in the Ubuntu Community, I’d love to hear about it.

Got to tread carefully if this is what goes on in minds. User opinions becoming the gospel? Tsk tsk.

Technorati Tags: community, alias, domain name, opinions, official comments