by Alexander Rubin | Aug 2, 2013 | MySQL, Webinars
Thanks to all who attended my “MySQL Query Tuning” webinar on July 24. If you missed it, you can you can download the slides and also watch the recorded video. Thank you for the excellent questions after the webinar as well. Query tuning is a big topic...
by Peter Zaitsev | Aug 1, 2013 | MySQL, Percona Services, Percona Software
Today we’re celebrating Percona’s 7th anniversary. A lot has changed in these past 7 years – we have grown from a two-person outfit focused exclusively on consulting to a 100-person company with teammates in 22 different countries and 18 different...
by Stephane Combaudon | Aug 1, 2013 | Insight for Developers, MongoDB, MySQL
For people used to relational databases and doing MySQL database design, using NoSQL solutions such as MongoDB brings interesting challenges. One of them is schema design: while in the relational world, normalization is a good way to start, how should we design our...
by Ernie Souhrada | Jul 31, 2013 | Benchmarks, Insight for DBAs, Insight for Developers, MySQL
This is part 3 of a 3 part series covering the new InnoDB full-text search features in MySQL 5.6. To catch up on the previous parts, see part 1 or part 2 Some of you may recall a few months ago that I promised a third part in my InnoDB full-text search (FTS) series,...
by Stewart Smith | Jul 30, 2013 | Hardware and Storage, Insight for DBAs, MySQL, Percona Events, Percona Software, Webinars
The new Percona Server 5.6 is the most manageable, highest performance, and most scalable version of MySQL available. Percona Server 5.6 is the best open source MySQL choice for enterprise-grade applications because it combines new features with the best features of...
by Frederic Descamps | Jul 30, 2013 | MySQL, Percona Live
In the MySQL ecosystem, there is some sort of conference or another all year long. But why are they important? To answer this, we can split the audience into 3 groups: – MySQL Professionnals – MySQL Community Members – MySQL (Future?) Users Depending...
by Daniel Nichter | Jul 29, 2013 | MySQL, Percona Software
Poor pt-heartbeat 2.1: it was perfectly fine through Percona Toolkit 2.1.7, but it’s had a rough life since. Its troubles are finally over as of Percona Toolkit 2.1.10. At a conference recently, a user joked to me that “Percona Toolkit is awesome, but you...
by Aleksandr Kuzminsky | Jul 26, 2013 | Insight for DBAs, Insight for Developers, MySQL
If we have InnoDB pages there are two ways to learn how many records they contain: PAGE_N_RECS field in the page header Count records while walking over the list of records from infimum to supremum In some previous revision of the recovery tool a short summary was...
by Roman Vynar | Jul 25, 2013 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Monitoring Plugins 1.0.4. The components are designed to integrate seamlessly with widely deployed solutions such as Nagios and Cacti, and are delivered in the form of templates, plugins, and scripts. Changelog: *...
by Stewart Smith | Jul 24, 2013 | MySQL, Percona Software
It was once said that “real artists ship.” In looking over the history of Percona software releases, we are currently shipping more software than ever before. First, let’s look at Percona Server. Let’s look at all major versions: 5.1, 5.5 and...
by Leif.Walsh | Jul 23, 2013 | MySQL
Since we released TokuMX, one of the most frequent requests has been for a migration tool. TokuMX has a completely different storage format than MongoDB, which means that you have to actually move all of your data out of MongoDB and into TokuMX, you can’t just...
by Jervin Real | Jul 23, 2013 | MySQL
It is everywhere in the world of MySQL that if your replication is broken because an event caused a duplicate key or a row was not found and it cannot be updated or deleted, then you can use ‘ STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE; ‘...
by Zardosht.Kasheff | Jul 22, 2013 | MySQL
A lot is said about the differences in the data between MySQL and MongoDB. Things such as “MongoDB is document based”, “MySQL is relational”, “InnoDB has a clustering key”, etc.. Some may wonder how TokuDB, our MySQL storage engine, and TokuMX, our MongoDB product,...
by Vadim Tkachenko | Jul 19, 2013 | Insight for DBAs, Insight for Developers, MySQL
In writing a recommendation for our Web development team on how to use MySQL, I came up with the following list, which I want to share: What kind of queries are bad for MySQL? Any query is bad. Send a query only if you must. (Hint: use caching like memcache or redis)...
by Hrvoje Matijakovic | Jul 18, 2013 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Toolkit 2.1.10 on July 18th, 2013 (Downloads are available here). Bugs Fixed: Unfortunately, the relatively new –utc option for pt-heart was still broken because “MySQL interprets date as a value in the...
by Alexander Rubin | Jul 17, 2013 | MySQL, Webinars
On July 24 at 10 a.m. PDT, I will be delivering a Webinar on Advanced MySQL Query Tuning. I will focus on optimizing the common slow queries with group by and order by. Those queries usually create temporary tables and perform a “filesort” operation. I...
by Hrvoje Matijakovic | Jul 17, 2013 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Toolkit 2.2.4 on July 17th, 2013 (Downloads are available here and from the Percona Software Repositories). New Features: pt-query-digest –output json includes query examples as of v2.2.3. Some people might not...
by Aleksandr Kuzminsky | Jul 16, 2013 | Insight for DBAs, MySQL
MySQL 5.6 introduces a new feature – microseconds resolution in some temporal types. As of 5.6.4 TIME, TIMESTAMP and DATETIME can have a fractional part. To create a field with subseconds you can specify precision in brackets: TIME(3), DATETIME(6) etc....
by Stewart Smith | Jul 16, 2013 | MySQL, Percona Software
Run Ubuntu and want to try new features of Percona XtraBackup? Well, now you can. We have a Personal Package Archive (PPA) percona-daily/percona-xtrabackup. Every time code is pushed to our main source code repository, the PPA is updated. We are currently building for...
by Zardosht.Kasheff | Jul 15, 2013 | MySQL
Before creating a unique index in TokuMX or TokuDB, ask yourself, “does my application really depend on the database enforcing uniqueness of this key?” If the answer is ANYTHING other than yes, do not declare the index to be unique. Why? Because unique indexes may...
