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