General
MySQL Conference – Opening Keynote with Marton Mickos
It’s an early start this morning at 8:20am at MySQL Conference 2007 with CEO Mårten Mickos keynote talk Welcome and State of MySQL AB. Here are some of the key points that impressed on me.
Read moreMySQL Conference – Rewarding the Community
At MySQL Conference 2007, CEO Mårten Mickos in his opening keynote Welcome and State of MySQL AB rewarded the community. Those that contributed to “The best database in the world”.
Read moreMySQL 6.0
If you were quick you may have noticed at the MySQL Conference 2007 keynote Welcome and State of MySQL AB talk this morning, Robin Schumacher in his quick demo of MySQL Monitoring & Advisory Service showed the MySQL Network Enterprise Dashboard, you would have noticed the MySQL Version 6.
Read moreOpening Keynote at MySQL Conf
It’s an early start this morning at 8:20am at MySQL Conference 2007 with CEO Mårten Mickos keynote talk Welcome and State of MySQL AB. His spirit is evident with his opening slide “The Participatory & Disruptive spirit of the Dolphin.
Read moreMYSQL Conference – Scaling and High Availablilty Architectures Tutorial
My first tutorial today at MySQL Conference 2007 is Scaling and High Availablilty Architectures by Jeremy Cole and Eric Bergen of Proven Scaling. Basic Tenets While not discussed, the premise is to Cache Everything.
Read moreMySQL 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 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 more