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

Welcome to the 160^th edition of Log Buffer, the weekly review of database blogs.

MySQL

Blame it on MyISAM, says Mark Callaghan of High Availability MySQL, on considering sql_mode and type coercion. “I think that MyISAM has its place,” writes Mark. “It does fast table scans, but InnoDB is much faster on just about everything else. I am just not thrilled with the impact it has had on MySQL.”

Not that those other engines are without flaw. Peter Zaitsev reports on an InnoDB performance gotcha with larger queries.

Here on the Pythian Blog, Singer Wang unearthed a MySQL 5.1 and InnoDB hot backup gotcha.

Eric Bergen offers his InnoDB deadlock count patch, which he introduces thus: “[Deadlocks] usually aren’t a problem until they start happening too frequently.  . . .  [SHOW ENGINE INNODB STATUS] can be useful for debugging but it’s almost impossible to get the rate at which deadlocks are occurring. [This patch] adds a counter to show table status that tracks the number of deadlocks.”

Baron Schwartz, had a script snippet to relative-ize numbers embedded in text to share.

From Planet Geek! came a fix for a OSX Snow Leopard MySQL startup problem.

SQL Server

While we’re on the subject of flaws, let’s begin our look at SQL Server blogs with Musings on Database Security and its post on passwords leakage from MS SQL Server. “Turns out that SQL Server saves in memory in clear text user credentials (passwords) of users logging in using SQL Server native authentication.  . . .  We . . . were convinced that SQL Server administrators out there should be aware of the danger and also should have a way to mitigate it so we’ve decided to publicize it and release a free tool to remove the clear text passwords from memory.”

Anyone who reads code of any kind can tell you that unreadable code is a sometimes fatal flaw. With that is mind, Buck Woody of Carpe Datum collected some T-SQL prettifiers.

Jamie Thomson examined extracting insert, update, delete rowcounts from T-SQL MERGE. Jamie writes, “Just lately I’ve been using T-SQL’s MERGE statement . . . and one thing that I needed to do was extract rowcounts for each DML operation . . . conducted by a MERGE. I was surprised to find that while @@ROWCOUNT is supported for MERGE, it only returns the total number of affected rows and there are no built in functions for getting the counts for each DML operation . . . ” Jamie’s workaround code follows.

Pythian’s André Araujo shared his procedure making for easier SQL Server database restores.

Kalen Delaney wondered, What’s a SQL Server Education Worth?. It’s not just a rhetorical question, either. It’s addressed to you. Yes, YOU!

Maybe conferences such as the PASS Summit are worth it? But the cost! Here’s Jeremiah Peschka with his tips on getting to PASS on the cheap.

Oracle

11gR2 was released. Let’s see what Oracle bloggers had to say about it. Here’s Doug Burns’s take on the 11.2 release—two highlights: Parallel Query, and changes to ASH.

The Oracle Security Blog itemizes new security features Oracle 11g Release 2.

On the AMIS Technology Blog, Marco Gralike writes, “I noticed yesterday a new feature that could have the potential to be a small, by me unnoticed, gem called ‘Flash Cache’.

It was quiz night again at the Oracle Scratchpad. In this second one, Jonathan Lewis and his contestants submit their explanations for bundle of statements in the library cache using bind variables.

Kevin Closson related his experience using Linux /proc To identify ORACLE_HOME and instance trace directories. In the post, Kevin writes, “ . . . you’ll see how to find the ORACLE_HOME and trace directories for an instance by looking at /proc//fd and /proc//exe of the LGWR process.”

DB2

Rav Ahuja says, moving to DB2 is easy, sharing a video that he writes, “ . . . highlights some of the new features in DB2 9.7 that make it very easy to enable Oracle applications to DB2.”

Easy and fun, apparently. Willie Favero, for instance, knows how to have fun and learn about DB2 LUW. It involves tuning in to the new “DB2night Show” on September 24^th.

Over and out, for now. Please add your favourite DB blogs from this week in the comments, and we’ll meet again next week. Till then!

PlanetMySQL Voting: Vote UP / Vote DOWN

OpenSQLCamp 2009 is happening “in parallel to the Free and Open Source Conference 2009 (FrOSCon) on Saturday 22nd and Sunday 23rd August in St. Augustin, Germany …. close to Bonn and Cologne.”

I plan on being at FrOSCon and OpenSQLCamp. Where I go before and after that is up to *you*. Yes, that is right, perhaps I will visit a user group, such as France’s MySQL User Group. Or perhaps your company needs the type of services Pythian can offer — we can do the “traditional consulting” model where we look over your systems for performance tuning and security gains, or fix problems in an emergency. Even more of a win, we specialize in recurring engineering — we can supplement your existing IT staff with database expertise, and do all the database work your current staff does not have time to do.

We do it all, whether it’s large project work that would ordinarily be farmed out to consultants such as new schema development, ETL and reporting scripts and data warehouse creation; or the ordinary but important stuff that keeps the business running like ensuring backups work, constructing a no-downtime architecture, making the development environment realistic, testing failover, and capacity planning.

If you have a mixed environment, that’s OK too — we cover the major database vendors (open and closed source) and have a team of system administrators if you need help in that arena.

Keep in mind — I’m not a sales person, I’m a tech person. Day-to-day I not only lead a team of MySQL DBA’s, I am one myself, and have my hands in the tech stuff all the time. Most of the reasons I like working at Pythian are the same reasons our clients love us — 24×7 coverage to me means “my pager only goes off past 5 pm if it’s the one weekend a month I’m oncall”, to a client it means “whoever is paged is already awake most of the time.”

So if you would like to sit down with me and have a drink, just say “hi”, speak at an upcoming User Group, or talk about what Pythian can do for you, comment here, or e-mail me at “cabral at pythian dot com” and we will work something out. I can come to your European location, meet you at FrOSCon or OpenSQLCamp, or we can arrange a meeting at our Prague office sometime around the end of August.