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
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 […]
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
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 […]
If you follow the general advices to create secure password the following ones seem to be secure, right?
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 […]
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 […]
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 […]
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 […]
I used to think one should never look at max_binlog_size, however last year I had a couple of interesting cases which showed that sometimes it may be very important variable to tune properly. I meant to write about it earlier but never really had a chance to do it. I have it now! (more…)Read more
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