EmergencyEMERGENCY? Get 24/7 Help Now!

UDF -vs- MySQL Stored Function

 | September 6, 2010 |  Posted In: MySQL

Few days ago I was working on a case where we needed to modify a lot of data before pushing it to sphinx – MySQL did not have a function to do the thing so I thought I’ll write MySQL Stored Function and we’ll be good to go. It worked! But not so well really […]

Read More

Tokyo Tyrant -The Extras Part III : Write Bottleneck

 | November 12, 2009 |  Posted In: Benchmarks, Cloud and NoSQL, MySQL

This is part 3 of my Tyrant extra’s, part 1 focused on durability, part 2 focused on the perceived performance wall. #3.  Tokyo Cabinet Can have only a single writer thread, bottlenecking performance When writing an application using Tokyo Cabinet only one connection can be opened as a “writer”  while the rest are readers.  Tyrant […]

Read More

SystemTap – DTrace for Linux ?

 | September 14, 2009 |  Posted In: Insight for DBAs

Since DTrace was released for Solaris I am missing it on Linux systems… It can’t be included in Linux by the same reason why ZFS can’t be – it’s licensing issue. Both ZFS and DTrace are under CDDL, which is incompatible with GPL. So you can see DTrace and ZFS on Solaris, FreeBSD, MacOS, but […]

Read More

Is DRBD the right choice for me?

 | July 7, 2009 |  Posted In: Insight for DBAs

It seems pretty common to find customers install DRBD for the wrong reasons. There are many pros/cons to compare DRBD to replication, but I’ve managed to cut down my spiel I give to customers to these two points: DRBD’s aim (assuming replication mode C) is to provide 100% consistency, and then as much uptime as […]

Read More