Mark has found Double sysbench throughput with TCMalloc with is quite amazing.
In Drizzle, if TCMalloc is present, we’ve linked it in (and on Solaris, mtmalloc) for years now. well…. Drizzle years, which are rather like dog years.
Today:
I still need to:
The Linux Australia entry in Wikipedia, has a “needs references” banner on it. It’d be neat if someone fixed this up (it’s pretty easy to link to the appropriate sources on linux.org.au).
In fact… I’ll buy the person a beer (or other beverage of their choice).
2009-2010 Bill 56: Profanity – South Carolina Legislature Online
An Australian political party once had the slogan “keep the bastards honest.”
It’s already been mentioned in a /. comment…. but…
Bart: We can say these swears anytime we want because they’re in the Bible!
Milhouse: I don’t think “Leviticus†is a swear.
Bart: Shut the hell up, you damn ass whore!
#mysql isn’t too fair to include, as it’s really about users, not dev. #mysql-ndb is there because i heart ndb.
Oh, and linux.conf.au is there because it’s *awesome* and you should go.
Totally unscientific due to i’m only taking a sample once and whatever… but it kinda interests me…
Over the past few years (since we’ve been using MemberDB) total number of members voting has looked like this:
Year:Members voted - 2005:57, 2006:110, 2007:63, 2008:65
So what does this tell us? Err… Nothing much. Except that we should probably expect about 60-70 votes for this election.
If we look at how many candidates we’ve had for each position, it looks a little bit more interesting:
In this chart I’m using numbers of *candidates*, not nominees. I’m also using numbers that are after we’ve computed the results and already redistributed preferences for existing winners. e.g. if I was standing for President and Vice President and won President, I appear here as a candidate for President and not for VP.
What can we tell here? We don’t have too much choice for P, VP, S or T…Â In fact, Google Spreadsheet is just drawing it all over each other so you can’t really tell.
2005 was the last year there was a choice in President. It was also the last year there was a choice for Secretary.
There was a choice of Treasurer in 2006.
There has been a choice of Vice President in 2005, 2007 and 2008.
There has always been a choice for OCM.
It’d be great if we set a record this year for how many people voted (which for those counting means we need 111 votes).
Voting for the Linux Australia Council for 2009 is open!
Voting is open until 19:00 on 23/1/2009.
Results will be announced at the Linux Australia AGM at linux.conf.au
2009 (make sure you’re going, it’s going to be awesome!)
Head to https://www.linux.org.au/membership/ to cast your vote.
As usual, you can likely ignore the “Menlo Park, CA” part (I haven’t checked though… but am 99% sure).
umm…..
int Field_timestamp::store(double nr)
{
int error= 0;
if (nr < 0 || nr > 99991231235959.0)
{
set_datetime_warning(DRIZZLE_ERROR::WARN_LEVEL_WARN,
ER_WARN_DATA_OUT_OF_RANGE,
nr, DRIZZLE_TIMESTAMP_DATETIME);
nr= 0; // Avoid overflow on buff
error= 1;
}
error|= Field_timestamp::store((int64_t) rint(nr), false);
return error;
}
(likely the same in mysql as well… haven’t checked though). these date and time things scare me.
My dad found (and pointed me to) this site: Search an Appliance by Size – Appliances Online. Quite useful if you’re wanting appliances but possibly not replacing the whole kitchen.
Yes, it’s somehow gotten to 2009.
Have already:
Oh, we also brought in the New Year with a few (280) sparklers:
We’ve been working on fixing up the remaining test cases so that they run with Drizzle. We’ve found: bugs in Drizzle, bugs in MySQL (one that seems to have been there for at least 10 years), bugs in the tests, tests that no longer apply and occationally, something like this:
/* Please god, will someone rewrite this to be readable :( */
if (to->pack_length() == from->pack_length() &&
!(to->flags & UNSIGNED_FLAG && !(from->flags & UNSIGNED_FLAG)) &&
to->real_type() != DRIZZLE_TYPE_ENUM &&
(to->real_type() != DRIZZLE_TYPE_NEWDECIMAL || (to->field_length == from->field_length && (((Field_num*)to)->dec == ((Field_num*)from)->dec))) &&
from->charset() == to->charset() &&
to->table->s->db_low_byte_first == from->table->s->db_low_byte_first &&
(!(to->table->in_use->variables.sql_mode & (MODE_NO_ZERO_DATE | MODE_INVALID_DATES)) || (to->type() != DRIZZLE_TYPE_DATE && to->type() != DRIZZLE_TYPE_DATETIME)) &&
(from->real_type() != DRIZZLE_TYPE_VARCHAR || ((Field_varstring*)from)->length_bytes == ((Field_varstring*)to)->length_bytes))
{ // Identical fields
/* This may happen if one does 'UPDATE ... SET x=x' */
if (to->ptr != from->ptr)
memcpy(to->ptr,from->ptr,to->pack_length());
return 0;
}
and no, I haven’t really changed the formatting.
Yes, I’m speaking at the upcoming MySQL Conference & Expo 2009 – on April 20 – 23 (and yes, it’s in Santa Clara again).
I have three sessions:
MySQL Cluster Tutorial: this time with 6.4 feature goodness. Very hands-on, very interactive.
MySQL Cluster on Windows:Â (insert witty text about hating operating system freedom here)
Memory Management in MySQL and Drizzle: not magic setting of buffer variables, but memory allocation and management inside the server, a bunch of malloc() discussion and hopefully some interesting numbers.
Upgraded VirtualBox and booted up my OpenSolaris VM. VirtualBox 2.1.0 finally fixes the bug where if 127.0.0.1 was in resolv.conf on the host – no DNS for you in the guest (unless in the guest you were running a DNS server).
Haven’t tried it yet… but OpenGL Accelleration makes at least a checkbox appearance in VirtualBox 2.1…. so that could be rather awesome.
Going a lot better with OpenSolaris 2008.11 than previous releases.. It looks like it might be quite easy to get to the stage of building Drizzle on it.
Just figured out how to change to Dvorak! Yay, I can type again! (Go to Input Methods preference panel and add US/DVORAK as a language, move it to the top, and enable the input method application and do it that way).
Currently installing sunstudioexpress. Why not gcc? I’m pretty sure the version in OpenSolaris is still ancient (so won’t build drizzle) and Sun Studio does produce different warnings (which indicate real bugs in a bunch of cases).
Things I wish were packaged: latest protobufs, latest bzr, gcc 4.x
Just saw a brief “this is how it’s currently working” on Martin’s implementation of the SQL frontend to the NDB$INFO work.
It’s awesome.
Since I got fed up with Solaris the other day, the T1000 is running Debian. This means that “I’ll care about Drizzle on Linux Sparc”.
OMG were things broken in the most “trivial” ways.
A good quick intro to the issues is Memory alignment on SPARC, or a 300x speedup!
It all comes down to memory alignment.
So I pulled the MySQL 6.0 bzr tree onto the box to try it too… I haven’t seen so many compiler warnings in ages (okay… since I last built MySQL.. drizzle is warning-clean and it makes it hard to remember a time before that). I think it works purely by accident.
So I’m gradually getting all of Drizzle working on Linux Sparc (a few things fixed already).
It’d be great if the T1k had faster disk though (make -j30 is fun… but IO isn’t on a single 160GB 7200rpm disk)… anybody wanting to donate an SSD?
i get to ssh-keygen on a box instead of (well… not) copying my ssh keys across to it.
Means I can push to lp from multiple machines easily (and revoke rights from them too)
After what many hours trying to netboot the T1000 to install Solaris Express, I wondered “how hard is it for debian?”.
Easy. get the sparc64 boot.img, put it on TFTP server, add “filename “boot.img”;” or similar to dhcp, boot the T1000 from the service console something like this “bootmode bootscript=”boot net:dhcp”\n restart -c” and install away!
As for Solaris?
Well… dhcpd.conf:
option space SUNW;
option SUNW.root-mount-options code 1 = text;
option SUNW.root-server-ip-address code 2 = ip-address;
option SUNW.root-server-hostname code 3 = text;
option SUNW.root-path-name code 4 = text;
option SUNW.swap-server-ip-address code 5 = ip-address;
option SUNW.swap-file-path code 6 = text;
option SUNW.boot-file-path code 7 = text;
option SUNW.posix-timezone-string code 8 = text;
option SUNW.boot-read-size code 9 = unsigned integer 16;
option SUNW.install-server-ip-address code 10 = ip-address;
option SUNW.install-server-hostname code 11 = text;
option SUNW.install-path code 12 = text;
option SUNW.sysid-config-file-server code 13 = text;
option SUNW.JumpStart-server code 14 = text;
option SUNW.terminal-name code 15 = text;
option SUNW.SbootURI code 16 = text;
host hurricane {
hardware ethernet 0:14:4f:1e:28:e;
fixed-address 192.168.1.19;
option host-name “hurricane”;
filename “sparc64-etch-boot.img”;
#Â Â Â Â Â Â filename “sol-nv-b103-sparc”;
#Â Â Â Â Â Â option SUNW.install-server-ip-address 192.168.1.1;
#Â Â Â Â Â Â option SUNW.install-server-hostname “saturn”;
#Â Â Â Â Â Â option SUNW.install-path “/mnt/sol-nv-b103-sparc/”;
#Â Â Â Â Â Â option SUNW.root-server-ip-address 192.168.1.1;
#Â Â Â Â Â Â option SUNW.root-server-hostname “saturn”;
#Â Â Â Â Â Â option SUNW.root-path-name “/mnt/sol-nv-b103-sparc/Solaris_11/Tools/Boot”;
}
(obviously changing the comments around) and having the Solaris Express DVD mounted and NFS exported…. it *still* doesn’t work. It goes “unable to mount filesystem” with no further hints (even when tcpdumping the network).
Documentation for doing the simple thing of using $dhcp_server and $nfs_server to network boot a Solaris install on a Sparc box is *COMPLETELY* missing.
Now, I’m a smart guy (and if you don’t believe that, at least believe I’m not stupid). If I can’t get it to boot the installer, what chance do others have?
I’ll try OpenSolaris out when it’s on SPARC (and please oh please oh please just have an easy way to net boot the installer using a linux host). Please take the debian way (just a single file on tftp).
So now it’s goodbye Solaris (I’m not going to have something I can’t re-install, upgrade or security patch) and it’s hello Debian (and sanity).
Yes, this does mean I’ll care about Drizzle on Linux Sparc.
hopefully nothing really broke. Upgrade was smooth, the new UI seems rather nice (except for the edit post text box now being partially covered by the “publish” window in Epiphany.. grr…