SQL Zone - The social network for developers

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

PeterZaitsev — Thu, 23 May 2013 06:30:00 +0000

This post comes from Justin Swanhart at the MySQL Performance Blog. This blog post is part two in what is now a continuing series on the Star Schema Benchmark. Preview Text: 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...

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

ErikEJ — Wed, 22 May 2013 06:30:00 +0000

Under normal operation, SQL Server Compact keeps all pending disk writes in memory, and flushes them to disk at least every 10 seconds. The connection string property to control this is called “Flush Interval”, and valid values are between 1 and 1000 seconds. But you may want to flush to disk immediately under certain circumstances, and this weeks code snippet demonstrates how to do just...

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

PeterZaitsev — Wed, 22 May 2013 06:30:00 +0000

This post comes from Stephane Combaudon at the MySQL Performance Blog. Preview Text: 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. ...

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

acoin — Wed, 22 May 2013 06:30:00 +0000

Looking at Memcached 10 Years Later This week was the 10 year anniversary since the creation of Memcached. First created for the blog-building site, LiveJournal, Memcached has remained a staple persistence technology. Preview Text: Today: Memcached 10 years later, JS struggles, why can't testers and developers get along?; Neil...

Webinar: SQL Query Patterns, Optimized

PeterZaitsev — Tue, 21 May 2013 06:30:00 +0000

This post comes from Bill Karwin at the MySQL Performance Blog. Preview Text: 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.” Legacy Sponsored: ...

Virident vCache vs. FlashCache: Part 2

PeterZaitsev — Fri, 17 May 2013 06:30:00 +0000

This post comes from Ernie Souhrada at the MySQL Performance Blog. 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. Disclosure: The research and testing conducted for this post were sponsored by Virident. Preview...

Virident vCache vs. FlashCache: Part 1

PeterZaitsev — Fri, 17 May 2013 06:30:00 +0000

This post comes from Ernie Souhrada at the MySQL Performance Blog. Preview Text: 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. Legacy Sponsored: ...

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

gduncan411 — Thu, 16 May 2013 06:30:00 +0000

Contents Introduction Overview Measuring Performance Perfmon Perfmon Counter Set Using perfmon Evaluating perfmon data Server health Memory Memory Grants Pending Lock Requests/Sec Deadlock/Sec Extended Events Dynamic Management Objects Third Party Tools Tuning Performance Server Performance Database Performance Indexin Preview Text: ...

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

acoin — Thu, 16 May 2013 06:30:00 +0000

Full-Text, Client-Side Search in CSS3 This is a pretty simple and straightforward trick you should try out if you just want to search for items on one page. Sure you can also use Ctrl+F, but this looks a lot nicer. Preview Text: Today: A full-text client-side search in CSS3, Georgia Tech's online MS in Computer Science for $7,000, 3 new...

Is Synchronous Replication right for your app?

PeterZaitsev — Wed, 15 May 2013 06:30:00 +0000

This post comes from Jay Janssen at the MySQL Performance Blog. Preview Text: 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. Legacy Sponsored: unsponsored

Webinar: MySQL 5.6 Performance Schema

PeterZaitsev — Tue, 14 May 2013 06:30:00 +0000

This Wednesday, May 15 at 10 a.m. Preview Text: 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...

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

PeterZaitsev — Fri, 10 May 2013 06:30:00 +0000

This post comes from Miguel Angel Nieto at the MySQL Performance Blog. Preview Text: 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. ...

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

ErikEJ — Fri, 10 May 2013 06:30:00 +0000

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. Preview Text: Another entry in the scripting API samples, you will...

MySQL and Percona Server in LinkBench benchmark

PeterZaitsev — Thu, 09 May 2013 06:30:00 +0000

This post comes from Alexey Stroganov at the MySQL Performance Blog. Preview Text: Around a month ago Facebook announced the Linkbench benchmark that models the social graph OLTP workload. We decided to run this benchmark for MySQL Server 5.5.30, 5.6.11 Legacy Sponsored: ...

Benchmarking Percona Server TokuDB vs InnoDB

PeterZaitsev — Wed, 08 May 2013 06:30:00 +0000

This post comes from Vadim Tkachenko at the MySQL Performance Blog. Preview Text: After compiling Percona Server with TokuDB, of course I wanted to compare InnoDB performance vs TokuDB. Legacy Sponsored: unsponsored