PlanetMysql.ru – информация о СУБД MySQL

Welcome to Log Buffer. The weekly review of DBA industry news. Enjoy Log Buffer #199.

Remember if you find a link or interesting blog post that you think Log Buffer should mention, send a note to the editor at Log Buffer and be sure to include the link, and a short note outlining why you think that particular post would be of value to other DBAs, or what you learned from reading it.

And, for inquiries about hosting or editing a future edition of Log Buffer on your own blog, send your query to the Log Buffer coordinator. (Please include the words “Log Buffer” in the subject.)

Kicking off this week are posts recommended by Gwen Shapira who also took a few minutes to share her production advice for developers.

Not strictly Oracle related, but fun story of how Catherine the Python-Oracle geek got hacked during her own presentation.

Dominic Brooks looked for upgrade tips and got some excellent advice.

Jonathan Lewis started a series about joins. Jonathan is the master of building clear and excellent test cases, and this post is a good example of this.

Pythian’s Singer Wang points out a post from Greg Baker, highlighting an announcement of proof that P is not equal to NP.

Baron Schwartz, on MySQL Performance Blog, shares sound advice on why you can’t rely on a replica for disaster recovery.

Ronald Bradford makes the case against using rpm packaging for MySQL.

Kerry Osborne is stunned by Exadata’s storage indexes as he does a little testing.

Willie Favero talks about parallelism improvements in DB2.

Leo Hsu and Regina Obe, on Postgres Journal, talk about starting PostgreSQL in windows without install.

In SQL Server news Linchea Shea says for performance impact, forget about sets and focus on loops.

And to close things off a last minute entry by Christo Kutrovsky – designing for Exadata, maximizing storage indexes use.

Welcome to Log Buffer, a weekly review of the database industry. This week’s issue Log Buffer #198 is generously published by Sam DeFilippis, who manages Oracle Notes blogs, with latest postings on Oracle GoldenGate.

As always, if you’d like to host your own issue of Log Buffer, simply reach out to the Log Buffer coordinator.
Please enjoy Sam’s issue of Log Buffer #198.

Log Buffer #197 marks the middle of summer, and the fact that we’re a mere two weeks away from our 200th edition.

To begin this week’s reading, I’d like to highlight two Oracle blogs maintained by Sam J. DeFilippis: Oracle Notes, where he’s recently posted about troubleshooting GoldenGate and positioning a read of Extract/Replicat Trail file or Oracle redo log. Sam volunteered to host a future edition of Log Buffer (thanks, Sam!). You can too, by sending an email to the Log Buffer coordinator, we’re always looking for volunteer publishers.

Brad Hudson a points that PostgreSQL test servers have moved from Oracle to EnterpriseDB.

Marc Fielding posts Part 2 of his series A Grand Tour of Oracle Exadata. He’s also hosting a webinar on how to successfully implement Exadata, Aug. 11th.

Cary Millsap explains why thinking clearly is more important than being correct.

On PL/SQL Challenge, Steven Feuerstein and his readers try to figure out where to find a list of all the tables and debate what is a table these days.

Sheeri Cabral catches up on her blogging this week with posts datawarehousing best practices, comparing Oracle and MySQL. Part 1 covers introduction and power, and Part 2 talks about partitioning. Another, explains Pythian’s method for continuously verifying replication sync, and lastly is a farewell post, as Sheeri forks off…. Pythian wishes Sheeri all the best in her future pursuits.

Iggy Fernandez tries to decide whether to use correlated subquery or join in a query.

Always wanted to learn more about Google’s BigTable database, but find the google papers intimidating?
myNoSQL blog links to a slide-deck that makes it all clear.

Ronald Bradford outlines clear evidence that in the short to medium term Oracle will continue to promote and enhance MySQL, and invites readers to chime in to his discussion on will Oracle kill MySQL?

And, on a side note, Pythian is looking for senior systems administrators who have RedHat Linux administration experience in Australia & other international locations. Visit our candidate system to match your skills with all of our current openings or submit your resume.

For those in Canada – enjoy Civic holiday weekend.

Josh Berkus gave a great talk at linux.conf.au 2010 (the CFP for linux.conf.au 2011 is open until August 7th) entitled “How to destroy your community” (lwn coverage). It was a simple, patented, 10 step program, finely homed over time to have maximum effect. Each step is simple and we can all name a dozen companies that have done at least three of them.

Simon Phipps this past week at OSCON talked about Open Source Continuity in practice – specifically mentioning some open source software projects that were at Sun but have since been abandoned by Oracle and different strategies you can put in place to ensure your software survives, and check lists for software you use to see if it will survive.

So what can you do to not destroy your community, but ensure you never get one to begin with?

Similar to destroying your community, you can just make it hard: “#1 is to make the project depend as much as possible on difficult tools.”

#1 A Contributor License Agreement and Copyright Assignment.

If you happen to be in the unfortunate situation of being employed, this means you get to talk to lawyers. While your employer may well have an excellent Open Source Contribution Policy that lets you hack on GPL software on nights and weekends without a problem – if you’re handing over all the rights to another company – there gets to be lawyer time.

Your 1hr of contribution has now just ballooned. You’re going to use up resources of your employer (hey, lawyers are not cheap), it’s going to suck up your work time talking to them, and if you can get away from this in under several hours over a few weeks, you’re doing amazingly well – especially if you work for a large company.

If you are the kind of person with strong moral convictions, this is a non-starter. It is completely valid to not want to waste your employers’ time and money for a weekend project.

People scratching their own itch, however small is how free software gets to be so awesome.

I think we got this almost right with OpenStack. If you compare the agreement to the Apache License, there’s so much common wording it ends up pretty much saying that you agree you are able to submit things to the project under the Apache license.  This (of course) makes the entire thing pretty redundant as if people are going to be dishonest about submitting things under the Apache licnese there’s no reason they’re not going to be dishonest and sign this too.

You could also never make it about people – just make it about your company.

#2 Make it all about the company, and never about the project

People are not going to show up, do free work for you to make your company big, huge and yourself rich.

People are self serving. They see software they want only a few patches away, they see software that serves their company only a few patches away. They see software that is an excellent starting point for something totally different.

I’m not sure why this is down at number three… it’s possibly the biggest one for danger signs that you’re going to destroy something that doesn’t even yet exist…

#3 Open Core

This pretty much automatically means that you’re not going to accept certain patches for reasons of increasing your own company’s short term profit. i.e. software is no longer judged on technical merits, but rather political ones.

There is enough politics in free software as it is, creating more is not a feature.

So when people ask me about how I think the OpenStack launch went, I really want people to know how amazing it can be to just not fuck it up to begin with. Initial damage is very, very hard to ever undo. The number of Open Source software projects originally coming out of a company that are long running, have a wide variety of contributors and survive the original company are much smaller than you think.

PostgreSQL has survived many companies coming and going around it, and is stronger than ever. MySQL only has a developer community around it almost in spite of the companies that have shepherded the project. With Drizzle I think we’ve been doing okay – I think we need to work on some things, but they’re more generic to teams of people working on software in general rather than anything to do with a company.

Welcome to Log Buffer, the weekly roundup of database industry news.

For your reading pleasure this week we have Log Buffer #196:

Charles Hooper blogs about an in-depth investigation on what can cause Oracle to ignore a hint.

Doug Burns reminds his readers that there are only two weeks left to submit papers for UKOUG. The deadline is Aug. 2.

A while back Greg Rahn at Structured Data blog thought that the best way to get results out of Exadata is by changing your application to get the most out of Exadata. He was very happy to see that Pythian thinks the same. On the subject of Exadata and data warehousing, Greg posts this week on the core performance fundamentals of Oracle Data Warehousing – set processing vs row processing.

Jonathan Lewis links to instructions and explanations on how to switch to a different UNDO tablespace. It is trickier than it sounds and Jonathan provided additional traps to watch out for.

Jonathan also continues his fragmentation series with an explanation of table fragmentation and its causes.

Alex Fatkulin explains about ASM mirroring and disk partnership and why you may have less redundancy than you thought.

On the same subject, Jeremy Schneider of Ardent Performance blog explains about hot disks, raid and what it means for ASM mirroring.

Back to blogging after a recent trip to TechInsights 2010, Edwin Sarmiento answers questions on what needs to be done as part of the installation of a SQL Server 2008 R2 Failover Cluster on Windows Server 2008 R2. A number of things related to Windows Clustering need to be considered.

Willie Favero introduces the “IBM zEnterprise System”, on his blog Getting the Most out of DB2 for z/OS and System z.

On Join-fu! the Art of SQL blog, Jay Pipes talks about getting started developing Nova on Linux, as he’s involved in a new OpenStack project.

Peter Zaitsev, on MySQL Performance Blog, posts about estimating replication capacity so that replication load can be dealt with before slave is unable to catch up.

Paul Randal publishes his survey results around the purchase and use of SSIDs.

And, if you happen to be attending Oracle OpenWorld, register before July 30 to take advantage of early bird rates.

We’re well into summer and almost at our 200th edition of Log Buffer, a blog of blogs about the database world.

Remember if you find a link or interesting blog post that you think Log Buffer should mention, send a note to the editor at Log Buffer and be sure to include the link, and a short note outlining why you think that particular post would be of value to other DBAs, or what you learned from reading it.

Now on to our weekly reading in Log Buffer #194:

Oracle Exadata is a topic that is getting hotter and hotter. Following Pythian’s announcement of Exadata services Oracle’s Greg Rahn stresses how important it is to “capitalize on the opportunity to re-engineer with Exadata and fully exploit the power of the Oracle Database Machine platform”. Also speaking of Exadata, Kerry Osborne talks on his blog, about the Oracle 11g Release 2 new feature, Parallel Queuing, and how it applies to data warehousing workloads on Exadata. Marc Fielding begins his grand tour of Exadata, writing to share his implementation experience.

Jamie Thomson outlines a number of reasons why a SQL server or BI developer should learn .net. And with more activity on SQLblog.com, Jonathan Kehayias writes about a bug in SQL Server 2008 and why you shouldn’t create large tables in the Model Database.

On In Recovery, Paul Randal posts on Benchmarking: Introducing SSDs (Part 2 – Sequential Inserts), following his first set of tests and analysis of the results. In Part 1 and Part 1b he covers not overloaded log file array.

Willie Favero addresses the demise of private protocol, one last time (he hopes) on his blog Getting the Most out of DB2 for z/OS and System z.

Ronald Bradford posts a quick one on installing MYSQL on Oracle Enterprise Linux and other good advice for optimizing SQL performance using the art of elimination.

Barry Leslie announces PBMS is now in the Drizzle tree.

And to sum things up, Gwen Shapira shares a few of her favorite recent archives, a little older than our weekly news, but valuable nontheless.

Not strictly a database topic, but certainly an important lesson for data architects. Brian Carper shares the difficult life of an edge case. Keep him in mind next time you develop an online shop. The same Brian Carper shares why he migrated from MySQL to NoSQL (Tokyo Cabinet) and why he moved back to SQL (Postgres this time).

Joshua Drake warns the end of life is near for Postgres 7.4, 8.0 and 8.1 and that anyone using these versions should upgrade.

Jonathan Lewis explains the difference between unrecoverable and nologging operations.

Martin Widlake gives an overview and demonstration of a little know view, DBA_TAB_MODIFICATIONS.

And, lastly to close things off on a light note, Iggy Fernandez highlights some of his favorite Dilbert-on-Databases Cartoons.

Welcome to Log Buffer, the weekly roundup of DBA industry happenings.

Read on for the latest updates in Log Buffer #193. Don’t forget, we’re always looking for volunteer editors to publish and host an issue of Log Buffer. If you’d like this to be you, contact the Log Buffer coordinator.

ODTUG/Kaleidoscope 2010 roundup:

Sheeri Cabral has posted slides and a summary of the first ever MySQL track at ODTUG/Kaleidoscope, citing a successful event.

Tim Hall, on Oracle-Base blog gives a daily report on the event summarizing his take on day 1 & 2, 3, 4, and 5.

Following the ODTUG/Kaleidoscope Oracle ACE Director’s briefing Alex Gorbachev continues the conversation on best practices with a blog post and encourages you to add your comments.

Marc Fielding, of Pythian’s consulting group suggests the following reads this week:

Pinal Dave who tries to clear up confustion and misconceptions about Statistics on SQL Blog Authority.

SQL Master noting a SQL Server 2008 Security gotcha, from a discussion he has on sql server security during interactions with the SASSUG user group.

On SQL Aloha, a post from Brad McGhee, who poses the question: Does your company have a SQL server DR plan? A quick poll he conducted provides scary results and he offers a list of resources for DBAs without a complete and tested DR plan in place.

Sramana Mitra, who writes about Oracle’s next move: data security, now that the Sun acquisition is complete.

OracleNerd outlining strategies for how to receive free passes to Oracle OpenWorld 2010.

Peter Finnigan talking about database forensics on his Oracle security blog, and the release of a new redo log mining tool to extract DDL from redo logs.

In other news, Willie Favero gives readers a heads up that the DB2 Catalog and directory are about to go through some major changes.

Guiseppe Maxia, The Data Charmer, learns a new programming language as he tries to integrate MySQL Sandbox and Cluster.

Dave Page on his Postgres blog, highlights what SQL injection attacks are and how DBAs can avoid them after another malicious attack targeting websites running Microsoft Internet Information Server (IIS).

Happy Canada Day for those north of the border, and for our friends to the south, Happy Independence Day and enjoy a great 4th of July weekend.

It’s Friday, and summer’s here. While it seems the industry is slowing down to a lazy pace, there is still some action so let’s splash right in to this week’s edition of Log Buffer DBA industry news in Log Buffer #192.

Alex Gorbachev had a few minutes to suggest the following interesting tidbits to me before running off to attend Oracle ACE Director activities at ODTUG/Kaleidoscope this weekend. One of these days we’ll have to see if he can share some of what goes on behind closed doors at those hush hush sessions.

He’s happy fellow OakTable member and Oracle ACE Director Tanel Poder is back to blogging with low-level undocumented internals for Oracle troubleshooting geeks.

Also an OakTable Network member, Jonathan Lewis, posted about the experience of one client migrating to 64 bit and increasing their SGA to see performance going down. The moral of this story is make sure your memory configuration is right.

Tom Kyte continues a series of blog posts about things he’s learning and likes, this time on SQL*Plus. And, at the same time includes something he doesn’t like, a feature in Windows 7 that he has mixed feelings on.

In the SQL Server world:

On his blog, In Recovery, Paul S. Randal runs some experiments to explore whether multiple data files can lead to an improvement in performance.

Adam Machanic smashes a DMV Myth: session_id > 50 == User Process on SQL blog.com.

Pinal Dave has two interesting posts this week on SQL Authority.com. In the first he shares his experience meeting and learning from trainer and industry guru Bryan Oliver. Secondly, he provides valuable advice for SQL Server developers dealing with XML from friend Jacob Sebastian on Select * FROM XML which he suggests looking at before reading his own advice on the same topic.

We continue to see the traction of MySQL within Oracle communities. More and more user group and Oracle-focused events are adding MySQL content to their agendas. At ODTUG/Kaleidoscope, Sheeri Cabral and Ronald Bradford were instrumental in developing the MySQL track of 19 sessions, and are speaking themselves.

Aleksander Kuzminsky announced that Percona Server 5.1.47-rel11 is available for download, noting new features and fixed bugs.

Craig Mullins writes how to access your DB2 Catalog “Poster” online for any of you constantly looking for DB2 Catalog table and column names.

Dave Page does a bit of comparison and gives his opinion on VoltDB, the new database server architected by the ‘father’ of Postgres, Dr Michael Stonebraker.

Until next week.

Welcome to Log Buffer, the weekly roundup of database blogs.

Kicking off this week in Log Buffer #191 are posts from Alisher Yuldashev:

Randolf Geist blogs on an Advanced Oracle Troubleshooting Session – PGA/UGA memory fragmentation for when a batch process takes significantly longer than expected.

James Morle talks about an example of a misleading average in Log File Sync and AWR – Not Good Bedfellows.

And a few faves from Bradd Piontek:

Marco Gralike, on Blog.Gralike.Com, revisits Enabling and Disabling Database Options, a small item that is easily overlooked. Marco also notes a cool tool: VirtualBox Appliance which makes a great start-up test environment. Word of caution however, it’s for testing purposes only.

On Askdba.org, Amit advises on downloading Oracle software directly to server in a post based on Pythian’s downloading from OTN directly to your database server. Watch for future posts from Brad on how he does it via Firefox, and edelivery.oracle.com.

Alex Gorbachev is spreading the word about The Ultimate SQL Tune-off with Jonathan Lewis and Kyle Hailey, two of his most respected Oracle performance experts, believing the session should be interesting to all DBAs, not just Oracle.

Robert Catteral continues to recap session highlights from the International DB2 Users Group Conference last month in Nuggets from DB2 by the Bay, Part 3, following Parts 1 & 2.

Chen Shapira contributed Cloning Oracle Home from RAC to Stand-Alone.

On In Recovery, Paul Randal wrote the whitepaper Proven SQL Server Architectures for High Availability and Disaster Recovery he wrote for the Spring SQL Server release has been published.

Moving to MySQL world, Vadim Tkachenko continues storage benchmarking of MySQL FlashCache (very much like Oracle FlashCache but for MySQL InnoDB engine). This time he is using FusionIO cards for FlashCache.

And, to round things off, Ronald Bradford writes about When SET GLOBAL affects SESSION scope.

Have a great weekend everyone.

If you’re near South Carolina next weekend, consider attending Southeast Linux Fest! There’s a list of illustrious speakers including several well-known in the database world: Joshua Drake and Andrew Dunstan (PostgreSQL), D. Richard Hipp (SQLite), and yes, yours truly (MySQL), plus a MySQL name that’s new to me: Brandon Checketts. There are a ton of non-database sessions too! Check out the full speaker & session list. This was a great show last year; I highly encourage everyone to attend.

Related posts:

1. Recap of Southeast Linux Fest 2009
2. How Linux iostat computes its results
3. How to find per-process I/O statistics on Linux
4. How to monitor server load on GNU/Linux
5. How to auto-mount removable devices in GNU/Linux