Spring is making its way into everything, and the databases are blooming as the DBAs who manage them are savoring the fragrance of the changing weather and fresh new ideas in the world of blogging. In order to appreciate the springing blogging innovations, this week’s Log Buffer, Log Buffer #215 picks some of the flowers just for you.
Oracle:
Hemant, the Oracle ACE from Singapore writes superbly about OuterJoin with Filter Predicate as usual with a reproducible case.
When …
[Read more]Warm welcome to the Log Buffer, a weekly amalgamation of database news across different technologies. Let’s get warmed up with sizzling Log Buffer #213.
Oracle:
======
One of the leading performance gurus, Kellyn Pederson is letting us know how she is finding the initial months at Pythian and she rightly praises her fabulous team mates Mark Brinsmead, Paul Logan, and Andy Klock.
The famous Oracle Database Junkie – Arup Nanda, blogs more about Interested Transaction Lists.
Universal Connection Pool, Oracle’s next generation …
[Read more]I’ve seen many a good DBA make the master of starting slaves from the position in the master.info file, most recently this week, that I want to bring it to everyone’s attention. Of course I mean the underlying issue and not the names of the DBA because that would be cruel.
In the typical scenario where this is an issue, the sequence of events is roughly the same with some small variation. A cold backup or a snapshot is restored onto a new server to build out a new slave. The binary log position from the master.info file, which is part of the backup, is used to start replication. Eventually after a short while, someone notices data discrepancies on the new slave compared to the master or replication stops due to an error.
The problem can be best looked by looking the slave status output in MySQL like below:
mysql> show slave status\G *************************** 1. row *************************** …[Read more]
Welcome to Log Buffer, the weekly news update of happenings in the database world.
Its the holiday season and many DBAs would rather cuddle at home with their family rather than do exciting work and blog about it. Can you imagine? Many thanks to Fahd Mizra who helped me by collecting DB2 news. Grab your snuggie and cuddle up with Log Buffer #210.
MySQL:
Giuseppe Maxia, the Data Charmer looked for a way to add comments into the binary log and created an interesting discussion on the topic.
You’d think that having some idle …
[Read more]Welcome to Log Buffer, the weekly news update of happenings in the database world.
A big shout out to Pythian team members Andrey, Gwen, Fahd, and Don for their submissions. We have lots of news and recommended reading this week so let’s get going with Log Buffer #209.
Andrey Goryunov’s top
picks:
Dion Cho, the Oracle Performance
Storyteller, provides an explanation of parallel DML execution plan.
Christian …
[Read more]Welcome to Log Buffer, the weekly round up of news and happenings in the database world.
We’re planning our publishing calendar for 2011. Happy to announce that we’ll have a few guest hosts in the New Year. Don’t forget if you’d like to host or edit a future edition of Log Buffer on your own blog, send a note to the Log Buffer coordinator.
We’ve had several contributions of favorite reads from the team this week. Enjoy this issue, Log Buffer #208.
Gwen Shapira’s picks:
…
[Read more]Hello Birmingham!
It’s past Sunday midnight and I’m stuck in my room in the last couple hours finishing my slides for my masterclass tomorrow. Turns out that I’m presenting the very first session of the conference at 9am. I wish there is a keynote instead so that I could grab one more hour of sleep (it’s going to be deep into the night back home in Canada). Strange that the keynote was moved to Wednesday — I hope UKOUG has really good reason for that!
My two hours masterclass will start at the same time as Tom Kyte’s a-la keynote session — what a competition. On the other hand, there is no other sessions in server technology so I expect that folks without interest of database development will automatically end up in my session. I’m in Hall 5 – quite large room. Is it the second biggest room after the Hall 1?
I will need to work hard to keep the audience… maybe I shouldn’t plan for any breaks to make …
[Read more]Oracle:
Arup Nanda posted an excellent script on how to summarize backup information from the rman catalog. He also posted a tool for automatically purging time-based partitions.
Pythian’s resident Exadata expert, Marc Fielding posted links to the …
[Read more]Welcome to Log Buffer, the weekly roundup of happenings in the database world.
Lots to cover this week, so let’s get on with Log Buffer #204. Enjoy!
Oracle:
Pythian’s Gwen Shapira dabbles with MySQL and explores MySQL troubleshooting for the Oracle DBA.
Venkat Janakiraman explores how connectivity works for BI EE 11g on …
[Read more]Welcome to Log Buffer. The weekly roundup of posts, and news of what’s happening in the database world.
At Pythian, we’re pretty much recovered from a hectic Oracle OpenWorld 2010, and I’m no longer an OOW virgin. What an experience! I had the pleasure of meeting many of you Log Buffer readers and contributors at the Annual Blogger’s Meetup at Jillian’s. Great to put faces to names. And I now officially feel like “Vanessa from Log Buffer”, as many of your t-shirts will show.
Many thanks to Marc Fielding for providing the hot items for this week’s post, in …
[Read more]