Blog
Google Maps at Halloween
If you didn’t spot it Google Maps – Street View had a Halloween icon. You can see it clearly below as I dragged it over a clear space.
Ubuntu Tricks today
ctrl-alt-l – Lock Screen ctrl-alt-d – Desktop # Multi Cut-Paste History apt-get install glipper Add to System|Preferences|Sessions|Startup Programs Thanks Yves
Perl Tricks
perl_modules.pl #!/usr/bin/perl use ExtUtils::Installed; my $instmod = ExtUtils::Installed->new(); foreach my $module ($instmod->modules()) { my $version = $instmod->version($module) || "???"; print "$module -- $versionn"; } remove_perl_module.pl #!/usr/bin/perl -w use ExtUtils::Packlist; use ExtUtils::Installed; $ARGV[0] or die "
Ban the Backquote
I really don’t like the backquote character (`). This is primarily due to it’s use by MySQL in internal and community tools. MySQL allows objects, .e.g table names, column names etc to contain both reserved words and spaces, providing they are appropriately surrounded by backquotes, so tools now simply enclose everything with backquotes.
NY Users Group – Analyzing MySQL Status and your SQL
This month I continued my Performance Analysis talks at the Local NY MySQL Meetup . Previous discussions can be found here . Our focus was a more in-depth look at gathering and reviewing MySQL Status and your applications SQL statements using MySQL Proxy .
Ubuntu 7.04 Fiesty
I upgraded my work laptop to Ubuntu 7.04 Fiesty . The process was not as smooth as I expected. First it complained about not enough space on /var, so I cleaned up sufficient space.
LAST_INSERT_ID(expr) – The lesser known usage
I am of the attitude, the day you stop learning something is the day you die. I’m not prepared to induce MySQL into both sides of that equation, however some days it never ceases to amaze me what little thing I didn’t know about MySQL.
MySQL Camp II – Memorable Quotes Day 1
Better late then never, this week I finally have the chance to catch up on some overdue posts. At the first MySQL Camp I made a list of memorable Quotes, see Day 1 , Day 2 , Day 3 .
DateTime vs Timestamp
I was asked a question today, “DATETIME vs TIMESTAMP. When to use which & why?” It’s a good MySQL introduction question, here are some general considerations for choosing one. Do you need Date values other then an EPOCH value?
The woes of MySQL Community tools under Solaris
Yesterday I attempted to get a working MySQL environment to support the number of utilities we all use including mytop , innotop , mybench , mysqltoolkit . These products require a number of Perl Dependencies, and while that may be a rather trivial task under Linux and with the power of cpan , working on Solaris is a whole different story.
A MySQL Story
The Taso Dump I’ve gotto go, my time has come. (maintenance window needed) Could not get a lock. (table lock) I needed a blocker to ensure a single thread. (–single-transaction)
MySQL Camp II – Post Dinner
MySQL Camp II is complete. A small group of about 18 had post dinner at Tiny Thai in New York City. Some elected to drive from Brooklyn, they arrived at least 30 minutes after those of us that the subway.
MySQL Camp II – Introductions
We have started MySQL Camp II . The first session is Introductions. I didn’t catch all the employers, but here is part of the list of attendees at the Introduction section.