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

An ideal summer day is when the sun is shining, the warm sunshine refreshes your body, the light breeze becomes naught with your hair, the birds sitting on intoxicated leaves smile at you, and you to top all of that you get the latest hot issue of the Log Buffer. Yes to put cherry on your cake, Log Buffer #227 is here.

Oracle:

David Kurts tells us about applying Hints to Objects inside Database Views.

Jonathan Lewis answers another burning question on on multi-column bitmap indexes and the inability of Oracle to create a bitmap index join when (to the human eye) the strategy was an obvious choice.

A blog post about the mapping of Physical Disk, LUNS, Cell Disks, and Grid Disks in Exadata by lovely Oracle.

Assume that you had a detail table that contained several attributes for each of the unique key values.  How would one go about finding all of the unique key values that share the same set of attributes? Charles Hooper answers.

Randolf Geist gives a short heads-up note regarding a bug that obviously has been introduced with 11.2.0.2.

SQL Server:

Mark Broadbent has posted a tribute to the blogger Jen Stirrup, how has just been recognized by Microsoft by their MVP Award program and become a Most Valuable Professional.

ROW_NUMBER() can be used to generate a sequential number for each row in the result set. Unlike RANK() and DENSE_RANK(), ROW_NUMBER() in case of ties it does not generate same number, it simply ignores the tie and generates sequential numbers for each of the tied rows. Vishal gives an example.

Jason Brimhall is giving a interesting spin in the realm of SQL statistics.

Juneau is the code name for the new SQL Server Development Tool (SSDT), to be released along with the next version of SQL Server, codenamed “Denali“. James Serra has an interest overview.

Wes Brown is looking at assembling a basic data dictionary from the column level meta data stored in SQL Server.

Pradeep Adiga sheds light on SavetoSQLServer method error in his blogpost with a story to tell.

MySQL:

Mark Atwood shares his valuable thoughts on node.js and libdrizzle.

Michael “Monty” Widenus blogs about his last MariaDB 5.3 feature before they go beta and that is Progress reporting for ALTER TABLE, LOAD DATA INFILE etc.

In order to optimally size the amount of RAM to allocate to a set of new machines for running MTR, Jonathan Perkin ran a few tests to check the memory usage of an MTR run for mysql-trunk and cluster-7.1.

By far, the most popular way for PDI users to load data into LucidDB is to use the PDI Streaming Loader. Nicholas Goodman has a good blog post about this.

Haidong Ji has presented a comparison of HandlerSocket and mysql client libraries with Python.

Happy Summer !!!

Everyone loves the colorful and easy lighting fire logs you can buy in the store for between $3-5, and from our feedback we are savoring the fact that everyone also adores the vibrant and flamboyant log buffer.

Winter has started and the holiday season is approaching fast. With the chillness of winter and festive mode induced by the holidays, bloggers across the planet are coming up with more and more exciting ideas. Let’s start with sizzling log buffer #207.

Oracle Jewels:

Discussing the common errors by the DBAs, Hemant K Chitale from Oracle Singapore advises against blindly killing sessions.

Cellcli, an Exadata utility which is used to manage Exadata storage, is another hot topic of the week. Kerry Osborne sheds light on it here, and Pythian Blog here.

A very lucid, reproducible example about Index Joins has been put on display by Jonathan Lewis. It’s a compact introduction about Index Joins, which are also known as Index Hash Joins.

How much disk do I need for my new Oracle database? This is the question,one of my favorite blogger Martin Wildake asked and answered in his blog post. He is also an Oakie now, and even secretly doesn’t think that he deserved it. Congrats Martin, you really deserved it.

A Crisp and cool overview of Execute Queues and Work Managers in Oracle Weblogic servers has been provided this week by the Weblogic Wonders blog.

SQL Server Pearls:

Melissa Coates, the SQL Chick, throws light on the usage of variables, expressions and the custom code in his recent blog post and how they work in harmony in the SQL Server Reporting Services.

There is still not much information available in documentation or elsewhere on Reporting Services administration via scripts, but David Levy, so graciously provides a very useful script to change SSRS Report credentials with Powershell.

Pinal Dave on his weblog shows how to do concatenation in SQL Server. Its different than in Oracle and MySQL, and those small differences are always a challenge for beginners even when the solution is very simple.

Venkatesan discusses the composite primary key in SQL Server on his blog with screen shots.

Geekblogger presents some new and very useful SQL Server functions for DBAs and the programmers here.

MySQL Gems:

Shlomi Noach shed a positive light on mysqldump in response to Morgan’s blog post. Even though he agrees with some of Morgan’s arguments.

There is a good review of MySQL High Availability book by Simon Mudds on his blog.

Anders Karlsson releases a MySQL Plugin for MySQL 5.5 that allows to monitor the most recently executed, and the most frequently executed statements using 2 INFORMATION_SCHEMA tables.

Mark Callaghan elaborates on salient points about an interesting question as how are Index-Only scans implemented in InnoDB.

If you want to know or refresh the basics about moving from MyISAM to Innodb or to XtraDB, then this blog post is a good piece to look at.

NoSQL Ornaments:

Alex Popescu discuss about the options of running NoSQL and SQL in the cloud in a very easy manner.

Dan Pritchett says it all from the Engineering Mantra: NoSQL, SQL, Is that the Question?

CAP Theorem is another getting-hotter-by-day among many bloggers and Michael Stonebraker dishes out his take.

Jonathan Ellis expounds on the business requirements for the drive to find alternate data management solution to tackle the challenge of rapidly increasing data volumes in his post.

DB2 Flowers:

Adam Gartenberg blogs about as how companies are finding value in the Analytics. He presents some interesting statistics from the surveys.

Dan Krook wrote a brief overview of an article series that Mark Nusekabel, Yan Li Mu and he wrote about their experience migrating a large PHP and MySQL.

Dave Beulke appreciates that DB2 10 Security improves Java Performance in this blog post.. Its a good discussion about ROLES-based security model.

Well, That’s all for this week. Thanks for stopping by.

Welcome to Log Buffer, the weekly news blog about blogs in the datasphere… As we kick off Log Buffer #206, our own Gwen Shapira shares a few of her weekly favorites:

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 latest recording of his Exadata webinars.

Gary Mayers, on Sydney Oracle Lab explains Oracle user security model.

Riyaj Shamsudeen shows what really happens when you update a query with the same values it already had.

Jonathan Lewis explains how he tests list partitions, a post which gives an excellent review on how one should go about testing new features in general.

MySQL:

At MySQL Performance Blog, Aurimas posts a war story about a very unusual data recovery. Test your backups, or you may have to go through the same ordeal.

In same blog, Morgan Tucker gives another reason why you shouldn’t use mysqldump to take backups.

SQL Server:
MVP Edwin Sarmiento is blogging live from SQL PASS 2010 in Seattle.

Aaron Bertrand introduces a feature in SQL Server 2011, called SEQUENCE that most Oracle DBAs would recognize too.

And lastly a few general posts. One from Michael Lopp, who, on the “Rands in Repose” blog, explains how people follow conversations, with some amusing examples.

And the second from Singer Wang who reports that RedHat 6 is finally out after 4 years.

A big shout out to this week’s contributors wraps up this issue. Don’t forget, if you’re interested in hosting your own issue of Log Buffer – send an email to the Log Buffer Coordinator.

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 Log Buffer #203. Enjoy.

The hubdub from OOW10 continues:

Opinions on the newly announced Exalogic are starting to form. Alex Williams on Read Write Cloud points out why Exalogic is not an elastic cloud. David Dorf provides his perspective for Exalogic’s application to the retail industry as a means to simplifying infrastructure, in conjunction with Exadata. Lorraine Lawson tries to clear up the confusion around “what exactly is Exalogic”.

Floyd Teter, on ORCLville provides his thoughts on the show, and Ray Wang provides good final wrapup notes, OOW from an insider’s perspective.

Congratulations to Asif Momen of The Momen Blog, who won the t-shirt signature contest. The Apple TV meetup contest winners will be announced on Monday, and listed in next Friday’s Log Buffer.

A litigous Oracle is very different from the old Sun. Aside from the well-publicized Google Android lawsuits this week Oracle is suing Micron, Samsung and other-chip makers for pricing fixing.

Katherine Noyes reports on the ‘Unbreakable Enterprise Kernel’.

Greg Rhan, from Structured Data gives a good overview of the newly released Oracle Exadata Database Machine X2-2 & X2-8 for those who missed it. Referenced is Alex Gorbachev’s tidy table of hardware components, comparing Exadata V2, X2-2 & X2-8.

Moving away from Oracle, in the MySQL world:

Jayant Kumar experiments with MySQL/Postgres speed tests in a part 1 and part 2 post series.

MySQL cluster benchmarks appear on Johan Andersson’s Cluster and HA blog.

Andrew Hutchings, LinuxJedi, writes a drizzle migration article on his new blog, since joining Rackspace as a Drizzle developer.

Guiseppe Maxia, the Data Charmer, highlights a funny recipe to convert an IP address into an integer in order to use it as a server-ID, and then offers a better solution.

In SQL Server news, SP2 is out, promising tighter integration with Sharepoint.

Pinal Dave tells how to get query running session on SQLauthority.com.

Microsoft MVP Sean McCowan shows DBAs how to use PowerShell to Administer SQL Server 2008, a good thing to know, in his, and the “Scripting Guy’s” opinion. Vijay Patel talks about partitioning.

Robert Catteral focuses on catalogue statistics as a way to improve query performance in a DB2 for z/OS environment.

Now that I know many of you, I’ll be chasing you down personally to host an edition of Log Buffer. Seriously, to keep the tradition alive, we need more than the voice of “Vanessa Log Buffer”. Please connect to the Log Buffer coordinator (me), if you’re interested.

Have a great weekend.

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.

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.

A short post marks Pythian’s 195th edition of Log Buffer, a blog of blogs encapsulating what’s going on in the world of database administration.

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 on why you think that others will want to read it too.

Now on to Log Buffer #195. Alex Gorbachev starts us off with his suggested readings and funnily enough, Chen Shapira had many of the same favorites this week.

Jonathan Lewis introducing a new series about fragmentation. In this post he defines what he means by fragmentation. Alex is looking forward to reading the next bits.

Charles Hooper shows how to present performance data in visually pleasing charts.

Mark Calahan, on his High Availability MySQL blog announces a new book on MySQL replication and high availability from Charles, Mat and Lars, stating it’s a good read to save people from some inevitable failures when distributed systems are deployed for enought time over many servers.

Tanel Poder, back blogging full force shows what really happens when you drop a table, and why you can drop tables from a read-only tablespace.

Maria Colgan from Oracle Optimizer Team drills into details of CURSOR_SHARING. By the way, Oracle Optimizer blog has moved to the official Oracle blogs as Doug Burns noted. And he couldn’t resist mentioning another post from Maria Colgan about moving from the old Rule-Based Optimizer to the Cost-based Optimizer. Alex saw Maria speak at ODTUG/Kaleidoscope and since then follows her blog all the time. There are lots of other recently posted materials in the new location so read on.

Randolf Geist, Oracle ACE, and member of the OakTable Network, posted a monstrous (size-wise) article about limitations of index and table compression covering Oracle release from 9i up to the latest 11.2. Very thorough!

Michael Janke complains about the number of severe bugs in Oracle and tells some amusing anecdotes about defective parts in the industry.

Michelle Gutzait suggests a new free eBook available now on how to do performance tuning with Data Management Views in SQL Server.

Joshua Drake notes the call for papers for PgWest 2010 is now open and provides the link to submit your talk. Deadline for submission is September 5, 2010 and speakers will be notified the following week. They’re looking for general PostgreSQL and stack topics and tutorials.

Until next week.

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.