A while ago someone asked on the forums for the Archive engine to
support autoincrements. I finally got around to doing this last
night.
Yes it can support both unique and non-unique indexes on the
autoincrement. Though you will pay in performance if you insert
say "5" and then insert "4" on a unique index since it has to do
a manual scan. Otherwise its fine and zippy.
Thus far it doesn't look to have any issues but I am sure I will
find at least one :)
Pushed into 5.1, which should go beta fairly soon.
And for your example:
CREATE TABLE `t5` (
`a` int(11) NOT NULL auto_increment,
b char(12),
PRIMARY KEY (`a`)
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1;
INSERT INTO t5 VALUES (0, "foo");
INSERT INTO t5 VALUES (0, "foo");
INSERT INTO t5 VALUES (0, "foo");
INSERT INTO t5 VALUES (0, "foo");
INSERT INTO t5 VALUES (0, …
A while ago someone asked on the forums for the Archive engine to
support autoincrements. I finally got around to doing this last
night.
Yes it can support both unique and non-unique indexes on the
autoincrement. Though you will pay in performance if you insert
say "5" and then insert "4" on a unique index since it has to do
a manual scan. Otherwise its fine and zippy.
Thus far it doesn't look to have any issues but I am sure I will
find at least one :)
Pushed into 5.1, which should go beta fairly soon.
And for your example:
CREATE TABLE `t5` (
`a` int(11) NOT NULL auto_increment,
b char(12),
PRIMARY KEY (`a`)
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1;
INSERT INTO t5 VALUES (0, "foo");
INSERT INTO t5 VALUES (0, "foo");
INSERT INTO t5 VALUES (0, "foo");
INSERT INTO t5 VALUES (0, "foo");
INSERT INTO t5 VALUES (0, …
First off, thanks to all of you who wished me good luck yesterday! That was really nice to feel welcomed ... and it really means a lot to me. Thanks!
Secondly, I will be in Miami, FL, tomorrow, Wednesday the 11th through Saturday the 14th attending a MySQL Sales conference. I'm keen to meet many in the Sales team and inquire how the Community team can best assist them in their endeavours, as well as let them know about some of the things going in the community. However, I'd love to meet any of you out there who enjoy using MySQL or products which run on MySQL. Kind of an impromptu meetup, I suppose, but I wanted to take advantage of being in Miami to meet some local like-minded South Floridians.
So, if you're up for a meetup, post a comment and I will get in touch!
p.s. As a side note, I'm finishing off my Many-to-Many article part 2 this week, so stay tuned. Sorry for the delay; things have been a bit crazy as of late …
[Read more]
According to the latest Fortune magazine's list of top 100 companies to work for, Genentech
is the top company to work for with 50% women in their workforce.
Other notable mentions include Cisco (25), Yahoo! (73), Intel (97), Intuit (43),
Microsoft (42), QucikTrip (21) and Starbucks (29). Surprisingly
(and rightfully so) Google is NOT in the list (Hurray!).
Just yesterday I blogged about that I am willing to work for any
company so long its not Google and today these ratings make me
feel part of the community.
American Express Project manager for technology also gets almost
$100K a year on average.
Neither …
Ooooh... a dns system that gets its info from a database. Now all
I need is a DHCP daemon that will talk to the same database. Then
my domain name system will be as cool as Active Directory
:)
http://wiki.powerdns.com/projects/trac/
Ooooh... a dns system that gets its info from a database. Now all
I need is a DHCP daemon that will talk to the same database. Then
my domain name system will be as cool as Active Directory
:)
http://wiki.powerdns.com/projects/trac/
It always surprises me how knee-jerk we can be in the open source world. If someone writes a glowing report of Project X, we slobber all over ourselves to salute them, however inaccurate they might be. If someone indicates a need for improvement, we slam them.
My recent post on OpenOffice is a case in point. I just don't think it's very good, and I also don't think it matters that it's not very good (because my goal in life is not to beat Microsoft at its game, but rather to make Microsoft play on my turf. Here are a few reasons OpenOffice is weak, and is not likely to ever attain Apache/Linux/BIND/etc. status.
-
OpenOffice isn't a piece of software that most developers care about, and developer-aligned open source software is much more likely to be superior software. If there's no itch to be …
Horay, Jay Pipes is our new Community person specifically
focusing on North America (like Lenz Grimmer for Europe).
In addition, it's hoped Jay will provide me with some sanity
around the users conference ;-), assisting with the preparations
and also later on-side so we'll both have more time to meet and
talk with people.
You've probably already seen Jay active with his blog, and/or on the
MySQL
forums...
Welcome Jay!
Horay, Jay Pipes is our new Community person specifically
focusing on North America (like Lenz Grimmer for Europe).
In addition, it's hoped Jay will provide me with some sanity
around the users conference ;-), assisting with the preparations
and also later on-side so we'll both have more time to meet and
talk with people.
You've probably already seen Jay active with his blog, and/or on the
MySQL
forums...
Welcome Jay!
I have been really busy for the past few days and didn't get a
chance to post anything on my MySQL blog. I have recently moved
to Lavonia, GA (don't ask me why) and have been working on my
Open
Encyclopedia project.
First, thanks to everyone for helping me out with my last post.
Honestly, the power of the community at MySQL makes me love it
more and more every day.
While implementing Jeremy's mytop, I decided to give the help files a
full read this time and was quite surprised to find Jeremy
recruiting for Yahoo!. Since then I have been really thinking
about sending my resume to Yahoo (the one I wrote for Google but
never mailed). I have decided I can willingly work for any
company so long its not Google.
Here are some news briefs that I wanted to blog about:
During the …