Blog
MySQL LOAD DATA Trick
I leaned a new trick today with LOAD DATA INFILE . I’m migrating some data from an external source, and the Date Format is not the MySQL required YYYY-MM-DD, it was DD-MMM-YY.
Google Maps for Traffic Updates
Saw a new button on Google Maps today called Traffic. Seems they are highlighting traffic congestion. Some real life examples. San Francisco New York . Below is a screen print I took today of the SF area.
T60 Configuration
This is a long story, of the absolute nightmare I have had with this lemon. I wish I could send it back! I got my new Lenovo T60 from MySQL.
Top 10 Things for IT Professionals
These IT related lists are really quite accurate. I sound like a broken record sometimes when I repeat these things. The articles provides very good detailed descriptions, I’ve included the bullet points just to temp you to read more.
That missing INNODB STATUS
On Thursday I saw something I’d not seen before. An Empty Innodb Status. Now given the amount of output normally shown it was certainly a first. And it looked like:
Watching Replication in action
For all those instant GUI people out there, there is an easy way to watch the present status of your MySQL Slaves using the watch command. $ watch -n 1 -d "
Smarter indexing for column LIKE ‘%string%’
With my very heavy travel load and skilling load I’ve not had time to scratch myself. It hasn’t stopped the brain working overtime on various issues including the classic find a pattern in a string starting with a wildcard character.
What is the maximum number of colons ‘:’ that may appear in a valid URL?
In idle conversation I was asked by MM. Question: What is the maximum number of colons ‘:’ that may appear in a valid URL? If you said zero to one, then you are victim of browsers, and you have never used anything but a browser.
CU@UC07
I’ll be speaking at the upcoming 2007 MySQL Conference & Expo (Why they dropped the word User, who knows), this time with Guy Harrison (Author of many books including [MySQL Stored Procedures][1]).
Using Innodb Primary Keys wisely
At a customer site recently I came across the following table definition for an Innodb table. 140 columns, 3 part primary key totally 44 bytes, 2 million rows giving over 900MB in data size.
MySQL Camp T-Shirts
For those that attended the MySQL Camp at Google HQ late last year you may have seen me with my own T-Shirt designs. A number of people inquired about getting them.
How’s your desktop
People that know me, know that I can’t just do one thing at once. People that have seen me work also know just how I can’t just work on a single thing, but work with multiple monitors, desktops and programs everywhere.
MySQL Predictions for 2007
I’m interested to know what people consider will behold MySQL in 2007? The announcement of “You” as Time person of the year can only considered a huge boost to the opportunities in 2007.
NY Tech Meetup – Idea Virus
On more thing that came from the NY Tech Meetup last night was the Idea Virus. It was handed out on a piece of paper. Here is what it said.