I'm off in few hours to attend DebConf 8 in lovely Mar del Plata, Argentina.  The only bummer is that its winter down there so this seaside resort is going to be a bit chlly and as a result Im not able to pack as light as I usually do.  That being said, getting away from the string of 100 degree days that we've been having here in Austin isn't such a bad thing.

I had a great time at DebConf 7 in Edinburgh, particularly since it was a homecoming of sorts for me.  This time its exciting since I've never been to Argentina before and have heard great things. Like last year, Sun is a Silver Sponsor of the event.

On …

Excited with the release of the MySQL Connector/C++, I thought I’d get it going on Mac OS X.

You’ll first hit the problem that Mac OS X doesn’t come with CMake. So you’ll have to download it from the site - there’s a warning there that the .dmg installer only works for Tiger, but I ran it on Leopard, and its just fine. Don’t forget to allow it to create links in /usr/bin for ease of use.

After that, you will need to install glib. But to get glib going, you need some dependencies:

• gettext
• …

On Wednesday, September 17 there will be a web based seminar on MySQL 5.1.

Seminar will be in Italian and anyone who is interested is invited to join us!

You can find details here.

If you are a database administrator or a developer and you are courious about new features coming with MySQL 5.1 then this is the right webinar to attend. In the meantime, to better understand MySQL 5.1, take have a look at "Inside MySQL 5.1" white paper.

See you soon!

…

On Wednesday, September 17 there will be a web based seminar on MySQL 5.1. 

Seminar will be in Italian and anyone who is interested is invited to join us!

You can find details here.

If you are a database administrator or a developer and you are courious about new features coming with MySQL 5.1 then this is the right webinar to attend. In the meantime, to better understand MySQL 5.1, take have a look at "Inside MySQL 5.1" white paper.

See you soon! 

On Wednesday, September 17 there will be a web based seminar on MySQL 5.1. 

Seminar will be in Italian and anyone who is interested is invited to join us!

You can find details here.

If you are a database administrator or a developer and you are courious about new features coming with MySQL 5.1 then this is the right webinar to attend. In the meantime, to better understand MySQL 5.1, take have a look at "Inside MySQL 5.1" white paper.

See you soon! 

Finally the on-demand version of the web based seminar is online. You can find recording here and you can also download presentation slides.

Please note that due to a technical problem in the time span  11:10 - 13:20 slides are not visible, but audio is good. Sorry for the inconvenience and thanks to everyone who attended!

Finally the on-demand version of the web based seminar is online. You can find recording here and you can also download presentation slides.

Please note that due to a technical problem in the time span  11:10 - 13:20 slides are not visible, but audio is good. Sorry for the inconvenience and thanks to everyone who attended!

I have never, ever seen this before. I don’t even know how the table was created with a different collation. However, I had all my other tables created with the character set utf8, no collation specified.

I had to convert the second table to match the character set. This probably wouldn’t have been a problem if I wasn’t joining on a character field.

alter table exclusion CONVERT TO CHARACTER SET utf8;

First time I’ve ever seen that one.

One common question I guess is how much should I see performance improved in case I increase memory say from 16GB to 32GB. The benefit indeed can be very application dependent - if you have working set of say 30GB with uniform data access raising memory from 16GB to 32GB can improve performance order of magnitude by converting very IO bound load to CPU bound, it is well possible to see limited gains - if your working set already fits in 16GB you may not see any significant gains upgrading memory to 32GB. Interesting enough similar can happen for very large working set - for example if your main queries do full table scan of 100GB table it does not matter if you have 16GB or 32GB the load is going to be way too much IO bound anyway.

Interesting enough because of MySQL scaling issues it is also possible to see performance to go down as you increase buffer pool size. Some threads which would be safely sleeping waiting on IO completion are now …

For those unfamiliar with SQL Server clustering let me give you a quick blurb.  Microsoft markets SQL Server as having active-active clustering.  When most people hear active/active or clustering in the database they generally immediately think of features like Oracle Rac.  SQL Servers implementation of Active-Acitve clustering ( as of 2005 anyways ) is really a HA setup with one instance active on the A side, and a seperate unrelated instance active on the B Side.  These servers hove different ports, install directories,  and share nothing at the DB level.  A san is used with its disk presented to each node in the cluster.  Microsoft Clustering Services (MCS) is used to manage the IP take over,  handle resource transitions, etc.   The setup is really active-passive, passive-active.  This ends up confusing and even mis-leading people who are both technical and in management positions.

Why …