Databases
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.
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 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 moreMySQL 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.
Read morePluggable 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?
Read moreThe 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 .
Read moreMySQL Replibeertion
MySQL Replibeertion was the last scheduled session on Day 2, but not withstanding there was free beer (a lot of), there was a serious side with a Replication Discussion. One of the first questions by Jeremy was “Are the any big replication users?
Read moreMySQL Camp – Introductions & Comments
The great thing about this unconference, is the lack of total formal structure. For now , our first session we are having an open introduction of people, there are at good 60+ people here already, and people rolling in, and it’s great to hear people’s background, and also to bag Jeremy Cole at every opportunity.
Read moreMySQL Quotes
Frank was on a role with MySQL quotes (it’s 1am here in New York – All that Red Bull & Vodka). Here are some of them: Let me scale you!
Read moreThe impact of Mathematics in our RDBMS world
We sometimes forget the impact of early mathematicians. Take for example John Venn who introduced the Venn diagram in 1881. This is fundamental for Set Theory, and also fundamental for SQL, the basis of retrieving data in a RDBMS.
Read moreLog Buffer #13: a Carnival of the Vanities for DBAs
Unlike fellow author Giuseppe of last week’s Log Buffer #12 I volunteered for the job of this week’s Log Buffer . Lots to say, so little time, so lets get started with Log Buffer #13.
Read more