Log Buffer #174: A Carnival of the Vanities for DBAs

Jan 8, 2010 / By David Edwards

Tags: , , ,

Happy New Year to all our readers! Welcome to 2010 and the 174th edition of Log Buffer, the weekly review of database blogs.

MySQL

The MySQL ‘sphere since the holidays has been thick with posts on the matter of Oracle’s purchase of Sun, and thereby of MySQL. And in particular, there’s been a lot of talk about MySQL founder Monty Widenius’s response. I call all of this the . . .

Monty My-Thon

On the 28th of December, Monty framed the issue thus: Help keep the Internet free.

Singer Wang of Pythian, in reply, offers his perspective on GPL/ASL/BSD License Misconceptions and MySQL.

On Poo-tee-weet, Lukas Kahwe Smith is heard to say, Come on Monty . . .  “What on earth is Monty . . . thinking? How can you spin around 180 and expect to come of believable? How can suddenly the GPL be the wrong choice? How can suddenly OSS depend on proprietary sales?”

On the WireLust blog, Terrence Curran writes, Monty Widenius is trying to regain control of MySQL and why this is bad for OSS.

Kristian Nielsen shares some Oracle speculations, stating, “I think it is basically a matter of obtaining control over MySQL.”

Antony Curtis throws in his two cents: “The topic of today is [Monty’s] ‘Save MySQL’ campaign and how I believe it is unnecessary.  . . .  In fact, I believe that it could be harmful.”

All that aside, things keep rolling, and DBAs keep DBAing. Simon Mudd shared his thoughts and some suggestions on managing MySQL grants.

On someGreatTechName, Piotr Jasiulewicz shows how to get data without reading it – the power of covering indexes in MySQL.

Geert Vanderkelen, Some Abstract Type, has the coolest-looking rows ever in his post, A chessboard in MySQL: make your moves.

Peter Zaitsev of the MySQL Performance Blog lays out the principles of upgrading MySQL, ” . . . a very interesting task as you can approach it with so much different ‘depth’. For some this is 15 minutes job for others it is many month projects. Why is that?”

SQL Server

On the SQL Server side, Aaron Bertrand likewise shares his experiences upgrading 2005 => 2008, describing the steps he took in his careful crossover.

Aaron also has a quick poll: what is your favorite Management Studio tip or trick?

Dan Jones has a question too: ” . . . there are two types of DBAs: those who are myopic and those who are leaders.”what kind of DBA are you?

Simon Sabin wonders aloud, Should PASS hold the conference on the East coast?

Simon also has his latest TSQL challenge – remove duplicates from a string.

If that’s not enough T-SQL for you, Adam Machanic has issued his invitation for T-SQL Tuesday #002.

Oracle

Let’s begin with nothing. Tanel Poder wishes to remind us that NULL is not zero!, with, “an example [of] how misunderstanding NULLs may cause your application to return different results than what was intended.”

Martin Widlake has been busy decoding high_value and low_value for us. He writes, “The table DBA_TAB_COLUMNS holds the LOW_VALUE and HIGH_VALUE for columns. This information is potentially very useful to us . . .  What is not so helpful is that Oracle stores, and displays, the information in an internal raw format. Which is utterly unhelpful to us of course.”

Jonathan Lewis clarifies copy stats. ” . . . someone was having trouble,” he writes, “copying stats from one index to another using the import_index_stats and export_index_stats procedures from package dbms_stats modifying the contents of their ‘stat table’ between the export and import.  . . .  Part of the problem with this approach is that you’re not really supposed to do what they were trying to do . . . ”

Guy Harrison, meanwhile, elucidates 11gR2’s IGNORE_ROW_ON_DUPKEY_INDEX hint, ” . . . [one] of the strangest new features in 11GR2 . . .  Why is this so strange? Mainly because unlike almost all other hints, this hint has a semantic effect: it changes the actual behavior – not just the optimization – of the SQL.”

Walking in the footsteps on Vasco da Gama, Luis Moreno Campos proclaims himself the first Portuguese Oracle nerd to unpack an Oracle-Sun Exadata v2. Congratulations, Luis! I think.

And we close this edition of Log Buffer with Jonathan Lewis, who on first principles, ” . . . just had to start the new year with a little humour,” courtesy of Og, Sumerian DBA.

That’s all for now. If I’ve missed you favourite DB blog from the last week, please leave a comment. See you again for LB #175.

2 Responses to “Log Buffer #174: A Carnival of the Vanities for DBAs”

  • hmm in recent times Log buffer seems to avoid talking or referring to PostgreSQL related blog posts. I’m starting to wonder if that is done on purpose or just due to a “don’t care” mentality…

    • Hi Stefan. You’re right, that has happened more recently, but not for either of the reasons you suggest.

      It has mostly to do with volume, I’m afraid. I find it harder to cover everything adequately, particularly as the number of Oracle, MySQL, and SQL Server blogs has ballooned in the last couple of years. The number of Postgres blogs has not risen dramatically, and by dint of that, the others are wheels that squeak more. Sometimes getting through all of the former three leaves me with too little time, space, or attention to take proper care of Postgres (not to mention others such as Firebird, DB2, and IDS).

      I’ll try to be fairer, particularly as I really enjoy PG blogs such as yours, Hubert Lubaciewski’s, and Selena Deckelmann’s, to name only three.

      Please also remember—Log Buffer isn’t my thing or Pythian’s thing alone, so comments of any kind are most welcome, and I’d love to see more of them with blog recommendations. Add away, everyone–your links have value.

      More editors would be nice too, but I recognize that this is now quite a big task, and so it’s a rare blogger who has the inclination.

      Thanks for the comment, Stefan.

Leave a Reply

  • (will not be published)

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>