by Tim.Callaghan | May 13, 2013 | MySQL
At tomorrow’s Effective MySQL Meetup, I’ll be presenting “Fractal Tree Indexes : Theory and Practice (MySQL and MongoDB).” The meetup is at 6:30pm Tuesday, May 14, 2013, and will be held at Alley NYC in New York City. I’ll give an overview on how Fractal...
by Hrvoje Matijakovic | May 7, 2013 | MySQL, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.1.0-rc1 on May 7, 2013. Downloads are available from our download site here. For this RC release, we will not be making APT and YUM repositories available, just base deb and RPM packages This is an...
by Vadim Tkachenko | May 7, 2013 | Benchmarks, MySQL
After compiling Percona Server with TokuDB, of course I wanted to compare InnoDB performance vs TokuDB. I have a particular workload I’m interested in testing – it is an insert-intensive workload (which is TokuDB’s strong suit) with some roll-up...
by Hrvoje Matijakovic | May 6, 2013 | MySQL
Percona is glad to announce the release of Percona XtraBackup 2.0.7 for MySQL on May 6, 2013. Downloads are available from our download site here and Percona Software Repositories. Percona XtraBackup is the world’s only open-source, free MySQL hot backup...
by Aleksandr Kuzminsky | Apr 25, 2013 | Insight for DBAs, MySQL
After nearly every recovery case the same question arises: How many MySQL records were recovered and how many were lost. Until now there was no way to answer the question without manual investigation. As it turned out a small change can make a big difference. There...
by Aleksandr Kuzminsky | Apr 22, 2013 | Insight for DBAs, MySQL
To recover a dropped or corrupt table with Percona Data Recovery Tool for InnoDB you need two things: media with records(ibdata1, *.ibd, disk image, etc.) and a table structure. Indeed, there is no information about the table structure in an InnoDB page. Normally we...
by Mike Benshoof | Mar 29, 2013 | MySQL
A common practice to offload traffic from MySQL 5.6 is to use a caching layer to store expensive result sets or objects. Some typical use cases include: Complicated query result set (search results, recent users, recent posts, etc) Full page output (relatively static...
by David Hildebrandt | Mar 15, 2013 | MySQL
Percona will be in Chicago and London the week of April 8th delivering two 2-day MySQL workshops. For our MPB readers, we are offering a 15% discount. Just use MPB15A when purchasing your tickets to one or both MySQL workshops. Scaling and Optimization for MySQL on...
by Ernie Souhrada | Mar 4, 2013 | Insight for DBAs, Insight for Developers, MySQL
This is part 2 in a 3 part series on InnoDB MySQL full-text searches. In part 1, we took a quick look at some initial configuration of InnoDB full-text search and discovered a little bit of quirky behavior; here, we are going to run some queries and compare the result...
by Miguel Angel Nieto | Feb 27, 2013 | MySQL
The MySQL optimizer makes the decision of what execution plan to use based on the information provided by the storage engines. That information is not accurate in some engines like InnoDB and they are based in statistics calculations therefore sometimes some tune is...
by Ernie Souhrada | Feb 26, 2013 | Insight for DBAs, Insight for Developers, MySQL
I’ve never been a very big fan of MyISAM; I would argue that in most situations, any possible advantages to using MyISAM are far outweighed by the potential disadvantages and the strengths of InnoDB. However, up until MySQL 5.6, MyISAM was the only storage...
by Tokutek | Dec 27, 2012 | MySQL
Well, it’s that time of the year again for top ten lists. There have been many versions showing up on the web the last few days, including Time Magazine’s “Top 10 Everything of 2012” list, with 55 wide ranging lists! Last year we started using Google...
by Tokutek | Nov 19, 2012 | MySQL
One of the great things about the MassTLC unConference is the spontaneity of the ideas. In the morning I ran into an old colleague whose startup was looking at switching databases and struggling with the options. Hence, “Scalable Databases for Startups” seemed like a...
by Tim.Callaghan | Sep 29, 2012 | MySQL
TokuDB v6.5 adds the ability to expand certain column types without downtime. Users can now enlarge char, varchar, varbinary, and integer columns with no interruption to insert/update/delete statements on the altered table. Prior to this feature, enlarging one of...
by kuszmaul | Sep 27, 2012 | MySQL
Since Fractal Tree indexes turn random writes into sequential writes, it’s easy to see why they offer a big advantage for maintaining indexes on rotating disks. It turns out that that Fractal Tree indexing also offers signficant advantages on SSD. Here are three...
by Martin.FarachColton | Sep 25, 2012 | MySQL
We are excited to announce TokuDB® v6.5, the latest version of Tokutek’s flagship storage engine for MySQL and MariaDB. This version offers optimization for Flash as well as more hot schema change operations for improved agility. We’ll be posting more...
by Justin Swanhart | Aug 28, 2012 | Insight for DBAs, MySQL
As an instructor with Percona, I’m sometimes asked about the differences between the REPEATABLE-READ and READ-COMMITTED transaction isolation levels. There are a few differences between them, and they are all related to locking. Extra locking (not gap locking)...
by Aleksandr Kuzminsky | Aug 22, 2012 | MySQL
In a very popular data loss scenario a table is dropped and empty one is created with the same name. This is because mysqldump in many cases generates the “DROP TABLE” instruction before the “CREATE TABLE”: DROP TABLE IF EXISTS `actor`;...
by Tim.Callaghan | Aug 1, 2012 | MySQL
Benchmarking is a tricky thing, especially when it comes to compression. Some data compresses quite well while other data does not compress at all. Storing jpeg images in a BLOB column produces 0% compression, but storing the string “AAAAAAAAAAAAAAAAAAAA” in a...
by kuszmaul | Jul 9, 2012 | MySQL
Solving the Challenges of Big Databases with MySQL When you’re using MySQL for big data (more than ten times as large as main memory), these challenges often arise: loading data fast; maintaining indexes under insertions deletions, and updates; adding and removing...
