Blog
Get behind a new exciting site
As I write this blog I have over 90 draft blog posts. That’s 9-0. Why do I have so many posts? The main reason is I want to say something, and I’ve either not completed it, or researched it sufficiently to consider the entry complete.
Read moreGoogle Maps for Personal Use
Just as I talked yesterday about Google Maps for Traffic Updates , today Google Maps released a new feature today called My Maps. I’ve just started using it, my first map is incomplete but you can see the workings at Travel Locations
Read moreMySQL 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.
Read moreGoogle 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.
Read moreT60 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.
Read moreTop 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.
Read moreThat 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:
Read moreWatching 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 "
Read moreSmarter 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.
Read moreWhat 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.
Read moreUsing 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.
Read moreMySQL 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.
Read moreHow’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.
Read more