Log Buffer #231, A Carnival of the Vanities for DBAs

Posted in: Technical Track

Log Writer is busily and efficiently pumping out innumerable bytes from log buffer to online redo logs, while more and more exciting features are being added to the MySQL and the SQL Server community is getting more vibrant with each passing day, and in all this beautiful frenzy, we manage to catch some elegant blog posts from across all these Log Buffer editions and present you this Log Buffer #231.


Alex Gorbachev, the Oracle ACE Director at Pythian is taking a step back and listing the stakeholders of Oracle Mix Voting.

Randolf Geist is discussing the implications of “cost is time” model for the time estimate of the Cost-Based Optimizer (CBO) in the Oracle patch set.

Jonathan Lewis illuminates the blogosphere with yet another striking post about Real Application Cluster.

Gavin Soorma explains the procedure used to install Grid Control on a Linux operating system (64 bit Red Hat Enterprise Linux Server release 5.6) as well as the steps taken to upgrade the repository database from the default version to

Chris discusses the concept of automated nesting of Application Modules (AMs) when using Bounded Task Flows (BTFs) with a combination of the transactional options Always Begin New Transaction, Always Use Existing Transaction and Use Existing Transaction if possible.

SQL Server:

Matt Wollner shares his presentation at the Atlanta Microsoft BI user group about SSIS Logging and Auditing Framework.

Jason Brimhall is having fun with the activity monitoring and profiler tools.

Ryan Adams is walking through the basic steps to move the MSDTC for a cluster to a new SAN drive.

People often get HA (High Availability) and DR (Disaster Recovery) mixed up. Denny Cherry describes the reasons for this and then explains lucidly.

Mike Walsh shares a life lesson which was taught to him by government agency.


What scales best?  OldSQL, NoSQL, NewSQL? Tony Bain chimes into the interesting constant debate in the world of Big Data.

Multi-master replication between sites is the holy grail of applications ranging from credit card processing to large-scale software-as-a-service (SaaS) operations. Eero Teerikorpi blogs about upcoming webinar in this regard.

Jay Janseen blogs about MySQL MHA HA solution and talks about salient points raised by Yoshinori Matsunobu.

Long awaited InnoDB support for full-text index is available in InnoDB lab release. InnoDB Team post talks about the performance of InnoDB’s full-text support over MyISAM’s full-text support.

Baron Schwartz answers the million dollar question: What’s required to tune MySQL?



Want to talk with an expert? Schedule a call with our team to get the conversation started.

About the Author

I have been in love with Oracle blogging since 2007. This blogging, coupled with extensive participation in Oracle forums, plus Oracle related speaking engagements, various Oracle certifications, teaching, and working in the trenches with Oracle technologies has enabled me to receive the Oracle ACE award. I was the first ever Pakistani to get that award. From Oracle Open World SF to Foresight 20:20 Perth. I have been expressing my love for Exadata. For the last few years, I am loving the data at Pythian, and proudly writing their log buffer carnivals.

3 Comments. Leave new

Good work Fahd.Keep it up :)


Thanks My Friend :)

Log Buffers of July | Oracle Administrators Blog - by Aman Sood
January 27, 2012 9:27 am

[…] Log Buffer #231, A Carnival of the Vanities for DBAs […]


Leave a Reply

Your email address will not be published. Required fields are marked *