EmergencyEMERGENCY? Get 24/7 Help Now!

A case for MariaDB’s Hash Joins

 | May 31, 2012 |  Posted In: Benchmarks, Insight for DBAs, MySQL

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 benchmarks […]

Read More

Webinar: TokuDB v6 Replication Performance

 | May 30, 2012 |  Posted In: Tokutek, TokuView

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

 | May 30, 2012 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Percona Software

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 this […]

Read More

Percona at SELF

 | May 30, 2012 |  Posted In: MySQL

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 MySQL […]

Read More

Secure passwords being insecure

 | May 27, 2012 |  Posted In: Insight for DBAs, MySQL

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 […]

Read More

Announcing Percona Server 5.1.63-13.4

 | May 24, 2012 |  Posted In: MySQL, Percona Software

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

 | May 24, 2012 |  Posted In: Tokutek, TokuView

    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 […]

Read More

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

 | May 23, 2012 |  Posted In: MySQL

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 […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.