Log Buffer #225, A Carnival of the Vanities for DBAs
Jun 17, 2011 / By Fahd Mirza
March of bloggers goes on and so is the unstoppable production of the blog posts. It’s getting more exciting week after week watching the new and old bloggers adding spice to the database blogosphere. This edition of Log Buffer brings some of the simmering and scintillating posts from around the globe in Log Buffer #225.
Kevin Closson hasn’t quit blogging, as he declares in his blog post while giving a glimpse of the future and a cute photo.
Jonathan Lewis sheds light on an interesting variation on the notion that failing to have a db_Nk_cache_size setting for your database could cause a statement to crash when it tried to address an object (or tablespace) using a non-standard block size, reporting errors.
Andy Colvin, a new exadata blogger gives very valuable tips regarding exadata interconnect.
Greg Rahn directs towards some OLTP demos that demonstrate how much performance and throughput can be wasted by poor design and suboptimal database programming.
Robin Moffatt has an insightful blog post about global statistics high/low values when using DBMS_STATS.COPY_TABLE_STATS
Larry Leonard has shared a script to tell you how big your table(s) are, subtotaled by indexes, with a grand total. Includes LOBs, and excludes dropped pages.
BuckWoody does a lot of public speaking and he loves it but he is not sure that he enjoys the session evaluations.
In his recent post, Michelle Ufford dishes out the updates index defrag script, v4.1 with FAQ, and Change Log.
Enforcing Business Rules Vs. Avoiding Triggers: Which Is Better? Michael Swart answers the question.
In his latest blog post, Sarvesh Singh is going to explain that the order of the columns in an index is important.
IP address storage is something that some do right and others have done wrong for years. How many times have you seen or created a MySQL table having something very similar to what Keith Larson is discussing in his blog post?
Singer Wang encountered an odd issue while trying to move a schema from one MySQL server to another.
Arjen has done an update to the hdlatency tool, it now has a –quick option to have it only do its tests with 16KB blocks rather than a whole range of sizes.
There are really no examples on how to use PHP’s AMQP PECL module, yet the documentation at php.net is still great and easy to understand. So, after reading the documentation in 5 mins Dathan Pattishall was able to put together a PHP Producer and reuse my Node.js Consumer.
Ansgar Becker happily announces the first combined release of MariaDB + HeidiSQL.