MySQL
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.
SHOW 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.
Google’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.
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.
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.
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.
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.
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.
Pluggable Storage Engines – What is the potential?
I started this post a month ago, but after Kaj’s discussion on the same topic at the MySQL Camp I figured it was time to post. I had dinner with a friend recently (a very smart friend), and our conversation lead him to ask “What’s different with MySQL?
The desire for Performance SQL Tips
It seems, people are clammering for a more consolidated help guide for SQL Performance tips. Jay Pipes at the MySQL Camp ran a session Interactive Top 10 SQL performance Tips .