Log Buffer #188, A Carnival of the Vanities for DBAs
May 7, 2010 / By Vanessa Simmons
It’s Friday already, and we know what that means! Log Buffer, the industry’s weekly review of database blogs is here again for your reading pleasure in the 188th issue.
Starting off this week’s issue is a request from Mark Grennan a DBA who would like to let the community know about his blog MySQL Fan Boy, where he wrote an interesting post on including a script to replace MySQL table files on a live system, making it faster and limiting locking on large table loads. Also a post this week on whether MariaDB is a drop in replacement for MySQL.
Next up we have Pythian’s Chen Shapira, with weekly commentary & favorites. Thanks Chen!
Jonathan Lewis, on Oracle Scratchpad, posts a brilliant little utility that makes viewing 10053 trace files much easier. The only drawback is that most don’t look at 10053 traces all that often, so it will be a challenge to remember that this exists when we do.
He also shares an interesting case where a function based index is not used, even though it should be.
Jaffar blogs to update that crs_stat command was depricated in 11gR2 and we must now use “crsctl stat”. Chen always thought that having so many similar tools to manage clusterware is very confusing, so this is a welcome step in the right direction.
Kellyn Pedersen updates her blog, DBA Kevlar and tells us how she solved an interesting problem: OEM complained that OC4J agent was down, when this wasn’t the case. Chen bookmarked this one, because she has a feeling she may run into this in the future.
Gary Myers at the Sydney DBA blog, Sydney Oracle Lab asks a simple question – how many rows are in a view? Of course it’s a trick question. The answer depends on where you are, and the order in which you specify tables in the FROM clause.
Riyaj Shamsudeen posts a detailed review of the different query transformation techniques the Oracle query optimizer may use on your query.
He also publishes a reading list for MongoDB. Either list should be enough to keep you busy all weekend.
Alex Gorbachev was interviewed in the May NoCOUG Journal, on the BAAG (Battle Against Any Guess) movement promoting scientific troubleshooting techniques. As a bonus, the BAAG chapter contributed by Alex from Expert Oracle Practices is also included, noted as “required reading” by their reviewer Dave Abercrombie for all DBAs, especially those who are performance experts, or who work with large databases, security, or are curious about cloud computing.
I also heard from Ronald Bradford who sent along an important post this week by Guiseppe Maxia on The Data charmer, MySQL meets the IOUG. Good indications of Independent Oracle User Groups being very accommodating, as they openly approach the MySQL community and ask for their valued input. Related to this are posts by Ronald himself on the impact the MySQL community is having on Oracle communities, and Sheeri Cabral with the announcement of MySQL sessions at ODTUG Kaleidoscope.
Our own Edwin Sarmiento chimes in with his picks for the week below:
The SQL Server CSS Engineers note that Error 18056 can be unwanted noise in certain scenarios with blog post on when this message can be safely ignored and when it is supposed to raise alarm bells.
Buck Woody, on SQL Blog.com posts about SQL Server PowerShell Provider follows the Version of PowerShell on the Host and other errata as he tries to clear up some misunderstanding on how the PowerShell Provider for SQL Server works.
Jonathan Keheyias, also on SQL Blog, learned something new this week with his post on Master database Compatibility level after an In-place Upgrade
From Stacia Misner, we have Introducing Microsoft SQL Server 2008 R2 – Business Intelligence Samples based on the free ebook Introducing Microsoft SQL Server 2008 R2 and two sample files for download for readers wanting a more interactive learning experience.
Paul Randall, on his SQL Skills In Recovery blog, talks about adventures in query tuning: unexpected key lookups.
Suggested by Mohammed Mawla, is Sanjay Mishra, on SQL Cat, blogs about moving the transaction log file of a mirror database, from a recent customer request.
Alisher Yuldashev, a Sr. Pythian Oracle DBA is a fan of Doug Burns’ post on Statistics on Partitioned Tables, Part 6C – COPY_TABLE_STATS – Bugs and Patches, part of an ongoing series.
He also likes Richard Foote’s Oracle Blog post on Concatenated Bitmap Indexes – Part 1.
And to wrap things up, I would like to add that the call for papers is now open for SQL PASS Summit 2010, in Seattle, WA, November 8-11, 2010. Deadline is just around the corner – June 5, 2010.