A friend asked for this, so I thought it’d be helpful and provide the code for, All tables with no primary key, and one showing, All tables and their primary keys, if exist. Enjoy!
I have been using this (see post) SQL*Plus command for a while now, and guess what? It doesn’t work with 10g.I thought MySQL was trying to become as big as Oracle but it could be that Oracle is trying to become as cool as MySQL — it has had something like this for a long time!
Welcome to the 81st edition of Log Buffer, the weekly review of database blogs.
Do you need to know why the standby periodically lags during the day, if the standby redo apply rate lag during the day and when, or how fast is the current archived redo log being applied? If you answered yes to any of these look no further. The following SQL script will help you answer these questions.
It is indeed a different world here. I have a feeling I’ll like it even more over the next three months I am here on Pythian duties. I will be writing more, so stay tuned.
At the risk of making it seem like this is all we’re talking about here at Pythian, here we go again. Paul Vallee pointed me towards this article by John Dvorak that more or less echoes a blog post I wrote in French the day previous for my personal blog that you can read here. So, first things first, Dvorak’s article leads me to think my theory is indeed wrong: if Dvorak says I’m right ; I’m afraid I’m wrong.
The 80th edition of Log Buffer has been published by Gwen Shapira on her blog, I’m just a simple DBA on a complex production system.
Play or download the podcast interview with Brian Aker of MySQL here. A special thank you to our sponsor, The Pythian Group, www.pythian.com.
I’m sorry that I haven’t commented on the BEA acquisition. It’s just been too obvious for too long, I can’t get excited even though it’s really really big. Manifest destiny manifested, that’s it. On the other hand…Tip of the hat to Lucas Jellema at AMIS who posts his own commentary on the acquisition and also provides this great find where Springsource CEO Rod Johnson comments at length on the deal.
t 2 pm EST (-5 GMT), OurSQL will be interviewing Brian Aker, MySQL’s Director of Architecture, about today’s announcement that Sun Microsystems bought MySQL. If you have a burning question (about the purchase), please comment here. If you’d like to be identified, please leave your name and where you’re from in your comment