MySQL
MySQL Conference – PBXT Recognized
As I mentioned in MySQL Conference – Rewarding the Community , Paul McCullagh, the creator of the Community Transactional Storage Engine PBXT won the Community Code Contributor of the Year award.
Read moreMySQL 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 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 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 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 more