• submit to reddit
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?

Adrian Hills03/10/13
684 views
0 replies

SQL Server Table Designer Bug With Filtered Unique Index

A colleague was getting a duplicate key error when trying to add a new column to a table via the Table Designer in SQL Server Management Studio (2008R2 - not tested on other versions), despite there being no violating data in the table.

Peter Zaitsev03/10/13
663 views
0 replies

Announcing Percona Server for MySQL version 5.1.67-14.4

Percona is glad to announce the release of Percona Server for MySQL version 5.1.67-14.4

Allen Coin03/08/13
4376 views
0 replies

DZone Links You Don't Want To Miss (3/8/13)

Today: Dissecting Amazon's smart dropdowns, reverse-engineering OKCupid's API, a cool trick with Google Spreadsheets, and The Matrix in 60 seconds!

Peter Zaitsev03/07/13
586 views
0 replies

Accessing Percona XtraDB Cluster nodes in parallel from PHP using MySQL asynchronous queries

I decided to try a new asynchronous call to send a query to MySQL using a new MySQLnd driver for PHP. In this post I’ll only show how to make these calls, and in following posts how to measure latency to all nodes.

Moshe Kaplan03/06/13
765 views
0 replies

Some Best Practices for your Next MySQL Installation with SSD

Do you plan on installing a new MySQL server? Did you ask yourself what is the best file system for it? What modification are recommended? What MySQL version to use? Do you consider using SSD? You got to the right place.