by Baron Schwartz | Jun 2, 2012 | Benchmarks, Insight for DBAs, MySQL, Percona Software
One of our customers asked me whether it’s safe to enable the so-called USER_STATISTICS features of Percona Server in a heavy-use production server with many tens of thousands of tables. If you’re not familiar with this feature, it creates some new...
by Michael.Bender | Jun 1, 2012 | MySQL
Martin Farach-Colton and I ran a Tutorial on Algorithms for Memory Sensitive Computing on May 18th at the 44th ACM Symposium on Theory of Computing (STOC) at NYU. Here is the program for the tutorial. Erik Demaine (MIT) spoke on the History of I/O Models. Throughout...
by Hrvoje Matijakovic | Jun 1, 2012 | MySQL, Percona Software
Percona is glad to announce the release of Percona Server 5.5.24-26.0 on June 1st, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.24, including all the bug fixes in it, Percona Server 5.5.24-26.0 is now the current...
by Ovais Tariq | May 31, 2012 | 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...
by Tokutek | May 30, 2012 | MySQL
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...
by Michael Coburn | May 30, 2012 | 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...
by Peter Zaitsev | May 30, 2012 | 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....
by Miguel Angel Nieto | May 27, 2012 | 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...
by Stewart Smith | May 24, 2012 | 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...
by kuszmaul | May 24, 2012 | MySQL
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...
by Jay Janssen | May 24, 2012 | Insight for DBAs, MySQL, Percona Events, Percona Software
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....
by Aurimas Mikalauskas | May 24, 2012 | Insight for DBAs, MySQL
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...
by Terry Erisman | May 23, 2012 | 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.,...
by Vadim Tkachenko | May 22, 2012 | Benchmarks, Hardware and Storage, MySQL
Every time I have a conversation on SSD, someone mentions btrfs filesystem. And usually it is colored as a solution that will solve all our problems, improve overall performance and SSD in particular, and it is a saviour. Of course it caught my curiosity and I decided...
by Vadim Tkachenko | May 21, 2012 | Benchmarks, MySQL
In my raw IO benchmark of Intel 520 SSD we saw that the drive does not provide uniform throughput and response time, but it is interesting how does it affect workload if it comes from MySQL. I prepared benchmarks results for Sysbench OLTP workload with MySQL running...
by Michael.Bender | May 18, 2012 | MySQL
This Saturday afternoon in New York, Martin Farach-Colton and I will run a tutorial on the theoretical foundations of memory sensitive computing to be be held at the 44th ACM Symposium on Theory of Computing (STOC). Here is the program for the tutorial. Topics include...
by Tokutek | May 16, 2012 | MySQL
Tackling machine data on the ground to ensure successful operations for NASA in space Issues addressed: Scaling MySQL to multi-terabytes Insertion rates as InnoDB hit a performance wall Schema flexibility to handle an evolving data model The Company: Southwest...
by Tokutek | May 16, 2012 | MySQL
The impact to our required storage was dramatic. We benefited from over 9x compression. In our comparison benchmarks, we went from 452GB with InnoDB to 49GB with TokuDB.
by Peter Zaitsev | May 16, 2012 | MySQL, Percona Events
I’m going to deliver MySQL Training next week (May 21-24) in London. This is a rare opportunity as I do not personally deliver a lot of Training, especially outside of US. There are still some places left if you want to sign up. You will also get a signed copy...
by Ovais Tariq | May 16, 2012 | Benchmarks, Cloud, Insight for DBAs, MySQL
I have been working for a customer benchmarking insert performance on Amazon EC2, and I have some interesting results that I wanted to share. I used a nice and effective tool iiBench which has been developed by Tokutek. Though the “1 billion row insert...
