SQL Zone | The social network for developers

Peter Zaitsev05/24/13
369 views
0 replies

Experiences with the McAfee MySQL Audit Plugin

I recently had to do some customer work involving the McAfee MySQL Audit Plugin and would like to share my experience in this post.

Greg Duncan05/24/13
548 views
0 replies

SQL Server Database Project SqlBuildTask failing after installing SSMS 2012 SP1? Here's how to fix it (Update your SSDT)

I just ran into this and Michael's post saved me hours of "what the heck" and hair pulling, so I wanted to highlight it and give him a huge shout-out. Also I wanted to cache it here because I know I'm going to need this again...

Peter Zaitsev05/23/13
275 views
0 replies

MySQL and the SSB – Part 2 – MyISAM vs InnoDB low concurrency

In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the InnoDB storage engine. In my testing I discovered that innodb_old_blocks_time had an effect on performance of the benchmark.

Allen Coin05/22/13
3310 views
0 replies

Links You Don't Want to Miss (May 22)

Today: Memcached 10 years later, JS struggles, why can't testers and developers get along?; Neil deGrasse Tyson settles the Star Trek vs. Star Wars debate, and how to boost your eBook revenue.

Peter Zaitsev05/22/13
348 views
0 replies

Replication in MySQL 5.6: GTIDs benefits and limitations – Part 1

Global Transactions Identifiers are one of the new features regarding replication in MySQL 5.6. They open up a lot of opportunities to make the life of DBAs much easier when having to maintain servers under a specific replication topology.

Erik Ejlskov Jensen05/22/13
286 views
0 replies

SQL Server Compact Code Snippet of the Week #15 : flush data to disk immediately

Under normal operation, SQL Server Compact keeps all pending disk writes in memory, and flushes them to disk at least every 10 seconds. But you may want to flush to disk immediately under certain circumstances, and this weeks code snippet demonstrates how to do just that.

Peter Zaitsev05/21/13
410 views
0 replies

Webinar: SQL Query Patterns, Optimized

Using MySQL 5.6 Performance Schema to Troubleshoot Typical Workload BottlenecksNext Friday, May 31 at 10 a.m. Pacific, I’ll present Percona’s next webinar, “SQL Query Patterns, Optimized.”

Peter Zaitsev05/17/13
301 views
0 replies

Virident vCache vs. FlashCache: Part 1

Over the past few weeks I have been looking at a preview release of Virident’s vCache software, which is a kernel module and set of utilities designed to provide functionality similar to that of FlashCache.

Peter Zaitsev05/17/13
341 views
0 replies

Virident vCache vs. FlashCache: Part 2

This is the second part in a two-part series comparing Virident’s vCache to FlashCache. The first part was focused on usability and feature comparison; in this post, we’ll look at some sysbench test results.

Allen Coin05/16/13
5037 views
1 replies

Links You Don't Want to Miss (May 16)

Today: A full-text client-side search in CSS3, Georgia Tech's online MS in Computer Science for $7,000, 3 new APIs for Android announced at Google I/O, and a Klingon translator!

Greg Duncan05/16/13
1274 views
0 replies

"The database is slow!" Here's a SQL Server Performance Crib Sheet [well almost book] that might help you...

Should be enough to get you stared at least in looking into your DB performance "issues".

Peter Zaitsev05/15/13
1146 views
0 replies

Is Synchronous Replication right for your app?

There’s a lot of different facts about Galera that come into play here, and it isn’t always obvious how they will affect your database workload.

Peter Zaitsev05/14/13
617 views
0 replies

Webinar: MySQL 5.6 Performance Schema

In this Webinar I will offer an overview of Performance Schema, focusing on new features that have been added in MySQL 5.6, go over the configuration and spend most time showing how you can use the wealth of information Performance Schema gathers to understand some of the typical performance bottlenecks.

Erik Ejlskov Jensen05/10/13
832 views
0 replies

SQL Server Compact Code Snippet of the Week #14 : script all data in a table

Another entry in the scripting API samples, you will find an overview of getting started with the API here. This weeks entry demonstrates the general pattern for scripting smaller chunks of SQL based on a single table, in this case a INSERT statement for each row in the table.

Peter Zaitsev05/10/13
1301 views
0 replies

How to create a new (or repair a broken) GTID based slave with Percona XtraBackup

Percona XtraBackup 2.0.7 has been published with support for GTID based replication. As promised, here is the step-by-step guide on how to create a new GTID based slave (or repair a broken one) using XtraBackup. The process is pretty straightforward.