Monthly Archives - May 2012

A case for MariaDB’s Hash Joins

MariaDB 5.3/5.5 has introduced a new join type “Hash Joins” which is an implementation of a Classic Block-based Hash Join Algorithm. In this post we will see what the Hash Join is, how it works and for what types of queries would it be the right choice. I will show the results of executing […]

Read more

Webinar: TokuDB v6 Replication Performance

TokuDB® is a proven solution that scales MySQL® and MariaDB® from GBs to TBs with unmatched insert and query speed, compression, and online schema flexibility.
Tokutek’s recently launched TokuDB v6 delivers all of these features and more, with the introduction of high performance replication for MySQL and MariaDB. TokuDB v6 eliminates the common and persistent […]

Read more

Data compression in InnoDB for text and blob fields

Have you wanted to compress only certain types of columns in a table while leaving other columns uncompressed? While working on a customer case this week I saw an interesting problem where a table had many heavily utilized TEXT fields with some read queries exceeding 500MB (!!), and stored in a 100GB table. In […]

Read more

Percona at SELF

There is a great conference – SELF (South East Linux Fest) taking place in June 8-9 in Charlotte,NC
This conference has a great lineup for MySQL with 2 tracks on Friday dedicated to it. There are many great speakers both from Oracle and community on the list.
From Percona I will speak about Optimizing […]

Read more

Secure passwords being insecure

If you follow the general advices to create secure password the following ones seem to be secure, right?
s11P$||!sh&2
pr0&!!ke0
3kj39|!381

The answer to the question is, “it depends on how you use them” 🙂
Notice that these passwords all contain multiple exclamation points and ampersands which are normally special characters for your shell. The people tend to […]

Read more

Announcing Percona Server 5.1.63-13.4

Percona is glad to announce the release of Percona Server 5.1.63-13.4 on May 24th, 2012 (Downloads are available from Percona Server 5.1.63-13.4 downloads and from the Percona Software Repositories).
Based on MySQL 5.1.63, including all the bug fixes in it, Percona Server 5.1.63-13.4 is now the current stable release in the 5.1 series. All of Percona‘s software is open-source and free, all the […]

Read more

Challenges of Big Databases with MySQL – IOUG Presentation

 
 
Many database management tasks become difficult as you move from millions of rows and gigabytes of data to billions of rows and terabytes of data. Such tasks include ingesting data while maintaining indexes; changing schemas without downtime; and supporting connections, replication, and backup. For some scaling problems (connections and replication), MySQL® is better than […]

Read more

Webinar – Migrating to Percona XtraDB Cluster

Whenever I learn about a new technology, I typically want to know the major administrative touch points more than I want to know exhaustive detail about every configuration option.  Give me the gist, show me enough to get started, and give me a link to the manual.
XtraDB cluster (and Galera, the technology on which it […]

Read more

Percona Live MySQL Conference 2012 Prize Winners and Percona Live New York 2012

I’m pleased to announce a variety of prize winners associated with the Percona Live MySQL Conference and Expo 2012. The following people won prizes in the pre-conference registration promotion:
Kindle Fire Winners:
Tatiana B., Etsy, United States
Tom H., Cloudtree, United States
Loren A., HearSayCorp, United States
High Performance MySQL 3rd Edition Book Winners:
Marcus O., Discover Books Ltd., Canada
Steven […]

Read more