by Yves Trudeau | Nov 19, 2012 | MySQL
Recently, I found myself involved in the migration of a large read-only InnoDB database to MyISAM (eventually packed). The only issue was that for one of the table, we were talking of 5 TB of data, 23B rows. Not small… I calculated that with something like...
by Kenny Gryp | Nov 19, 2012 | MySQL, Percona Events
Another Percona Live event is coming up, this time in London on the 3rd and 4th of December. I’m sure it is going to be as awesome as it was last year. This year, I will talk about ‘Choosing Hardware For MySQL’. Of course, the most important hardware...
by Peter Zaitsev | Nov 16, 2012 | Insight for DBAs, MySQL
I’ve got the great response to my two previous polls (1,2) so lets continue learning about how we all use MySQL. The question of this week is What is the maximum number of tables per MySQL instance do you use ? What is the largest amount of tables do you have...
by Brian Fraser | Nov 15, 2012 | MySQL, Percona Events, Percona Software
The Percona Toolkit team is happy to announce the release of Percona Toolkit version 2.1.6. This is the sixth stable release in the 2.1 series, and primarily a bug-fix release; We suggest that users upgrade to the latest version of the tools. The complete list of...
by Hrvoje Matijakovic | Nov 15, 2012 | MySQL
Percona is glad to announce the release of Percona XtraDB Cluster on November 15th, 2012. Binaries are available from downloads area or from our software repositories. Features: Percona XtraDB Cluster has ported Twitter’s MySQL NUMA patch. This patch implements...
by Frederic Descamps | Nov 14, 2012 | MySQL
2013 is near… and so is the next FOSDEM edition ! This year again, MySQL will be represented by its Community. If you want to discuss with friends of MySQL it’s the place to be in February ! Like every year, FOSDEM takes place the first week-end of February in...
by Tim.Callaghan | Nov 13, 2012 | MySQL
In my three previous MongoDB blogs I wrote about our implementation of Fractal Tree(R) indexes on MongoDB, showing a 10x insertion performance increase, a 268x query performance increase, and a comparison of covered indexes and clustered indexes. These benchmarks show...
by Tokutek | Nov 12, 2012 | MySQL
There is obviously much being written these days about Big Data. While the term has many different meanings to many different folks, our MySQL and MariaDB customers tend to find their data to be uncomfortably big when the tables become too large for memory. In this...
by Peter Zaitsev | Nov 9, 2012 | Insight for DBAs, MySQL
My previous poll got a great response so I thought I should continue these series. The question of the day today is How much data do your store in your largest MySQL instance ? I’m interested about single instance not the total amount of data you have in MySQL...
by Jay Janssen | Nov 8, 2012 | MySQL
This is not necessarily going to be a comprehensive post, but I learned somethings about MySQL SSL today that I thought would be worth sharing. I was setting up a PRM install for a customer and one of the requirements was SSL replication. In this particular case, I...
by Jay Janssen | Nov 8, 2012 | MySQL, Percona Events
I was honored to be asked to be a member of the committee for the “big” MySQL conference: Percona Live MySQL Conference and Expo 2013 in Santa Clara, CA. Personally, I’ve been attending this conference for 6 or 7 years and missing it only when my...
by Peter Zaitsev | Nov 7, 2012 | MySQL, Percona Events
The Internet Summit seems to be the largest Tech event of the year in Raleigh,NC area. I’ve attended this conference last year and I’m proud to be a speaker this time around. If you’re up for early morning talks I’m part of “Tech Track:...
by Frederic Descamps | Nov 6, 2012 | MySQL
First I wanted to thanks all the attendees and for the nice comments I got. As promised during the webinar, these are the answers of the questions you asked. Q: Does Percona provide plugin for cacti? A: Yes we do. They are part of Percona Monitoring Plugins. You can...
by Tokutek | Nov 5, 2012 | MySQL
It certainly has been a tough week on the East Coast. In the Boston area, where I am located, we got grazed by Sandy – power outages, trees down, schools closed, and Halloween delayed. This though, pales in comparison to what our NY office had to endure. One of...
by Jay Janssen | Nov 5, 2012 | MySQL, Percona Events
On November 15th at 1PM Eastern / 10 AM Pacific, I will be giving a webinar entitled “The Hazards of Multi-writing in a Dual-Master Setup”. In my experience many people do not understand the difficulty of managing writes to RDBMS datastores in a high...
by Peter Zaitsev | Nov 2, 2012 | Insight for DBAs, MySQL
We have seen number of issues with MySQL Server related to amount of memory you have in the system – these range from problems with large size Query Cache to bad drop table performance with large Innodb Buffer Pool size. As such I wonder how much memory do we...
by Daniel Nichter | Nov 1, 2012 | Insight for DBAs, Percona Software
pt-online-schema-change is simple to use, but internally it is complex. Baron’s webinar about pt-online-schema-change hinted at several of the tool’s complexities. Consequently, users often want to know before making changes what pt-online-schema-change...
by Tim.Callaghan | Oct 30, 2012 | MySQL
This webinar covers the basics of B-trees and Fractal Tree Indexes, the benchmarks we’ve run so far, and the development road map going forward. Date: November 13th Time: 2 PM EST / 11 AM PST REGISTER TODAY Topics will include: What is a Fractal Tree Index? How to...
by Peter Zaitsev | Oct 30, 2012 | MySQL, Percona Events
Percona Live, London 2012 continues streak of “not to be missed” events in London, following the footsteps of Royal Wedding, Diamond Jubilee and Summer Olympics. We have prepared great set of Tutorials and Sessions for these two day event. Here is my...
by Peter Zaitsev | Oct 29, 2012 | Insight for DBAs, MySQL
MySQL command line utilities have an interesting property – if you only use the prefix of the option or command it will go over the list of available command and if there is only one command with matching prefix it will execute it with no warnings or any kind,...
