SQL Zone | The social network for developers

Peter Zaitsev03/17/13
999 views
0 replies

Announcing Percona Server for MySQL 5.6.10-60.2

Percona is glad to announce the release of Percona Server for MySQL 5.6.10-60.2.

Peter Zaitsev03/15/13
765 views
0 replies

MySQL Backup tools used by Percona Remote DBA for MySQL

With our Remote DBA service we can take care of backups for you, what follows are some of the internals of our implementation.

Peter Zaitsev03/15/13
761 views
0 replies

MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown

While preparing the webinar I will deliver this Friday, I ran into a quite interesting (although not very impacting) optimizer issue: a “SELECT *” taking half the time to execute than the same “SELECT one_indexed_column” query in MySQL 5.6.10.

Peter Zaitsev03/14/13
689 views
0 replies

Oracle Technical Experts at the Percona Live MySQL Conference and Expo

I’m pleased to announce that Oracle is sending some of their top technical people to speak at the Percona Live MySQL Conference and Expo.

Erik Ejlskov Jensen03/14/13
790 views
0 replies

SQL Server Compact Code Snippet of the Week #10 : generate a CREATE TABLE script

This week's entry demonstrates the general pattern for scripting smaller chunks of SQL based on a single table, in this case a CREATE TABLE statement. The statement will also include any indexes and primary/foreign keys.

Allen Coin03/14/13
3996 views
0 replies

DZone Links You Don't Want To Miss (2013.03.14)

Today: Words of wisdom for engineers, Android Project Lead Andy Rubin steps down, Netflix can now share your viewing history through Netflix Social, and A Monkey Controls a Robot with Its Mind!

Peter Zaitsev03/12/13
704 views
0 replies

MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark

So far most of the benchmarks posted about MySQL 5.6 use the sysbench OLTP workload. I wanted to test a set of queries which, unlike sysbench, utilize joins. I also wanted an easily reproducible set of data which is more rich than the simple sysbench table. The Star Schema Benchmark (SSB) seems ideal for this.

Henrik Warne03/12/13
4361 views
0 replies

Algorithm of the Week: Coursera's Design and Analysis of Algorithms: Part II

I recently finished the Coursera course Algorithms: Design and Analysis, Part 2 by Professor Tim Roughgarden of Stanford. I’ve already reviewed part 1, and here are my thoughts on the second part.

Erik Ejlskov Jensen03/11/13
665 views
0 replies

SQL Server Compact Code Snippet of the Week #9 : migrate a SQL Compact database to SQL Server

This week’s snippet directly follows the one from previous week, demonstrating my SQL Server Compact scripting API once again.

Peter Zaitsev03/11/13
638 views
0 replies

MySQL performance: Impact of memory allocators (Part 2)

Last time I wrote about memory allocators and how they can affect MySQL performance in general. This time I would like to explore this topic from a bit different angle: What impact does the number of processor cores have on different memory allocators and what difference we will see in MySQL performance in this scenario?