Blog
MySQL Conference & Expo
The MySQL Conference has started. It will be a long week, still yet to prepare my own presentation for tomorrow. Old friendships already renewed, plenty of faces to names already, and we have yet to hit the first session.
Read moreSHOW PROFILE
I’ve been playing more with the SHOW PROFILE command available as part of MySQL Community 5.0.37. Thanks to the author Jeremy Cole. This command can provide some interesting insight into the workings of MySQL.
Read moreGoogle’s worse nightmare
Today while waiting at the airport, I took a look at the news stand, and right there on the cover of Fast Company were two words Google, and Wikipedia. Given Wikipedia is a poster boy of MySQL it was an immediate purchase just to see what was being said.
Read moreGet 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 more