… changes would also be needed to the server itself. PostGIS is not only better than MyISAM‘s GIS functionality, it’s better… Percona Server. They are fundamentally different and targeted towards very different use cases. But there are a lot of misconceptions, such as “Percona Server is just a set of patches” or “MariaDB has everything Percona Server has and more.” Henrik: mea…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
Many backup tools including Percona Xtrabackup, MyLVMBackup and others use FLUSH TABLES WITH READ LOCK … statement started execution all writes will be blocked to the server, which in the end causes “field list” operation to be… etc (which are stored in MyISAM tables anyway) you can consider using –no-lock option with Percona Xtrabackup. Many other tools have…
Post: Percona Server 5.5.17-22.1 released
November 18, 2011 By Leave a Comment
… release of Percona Server 5.5.17-22.1 on November 19th, 2011 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.17, including all the bug fixes in it, Percona Server 5.5… 5.5.17-22.1 in the documentation. Bug Fixes MyISAM repair-by-sort buffer could not be greater than 4GB…
Post: Percona Server 5.1.60-13.1
December 16, 2011 By Leave a Comment
Percona is glad to announce the release of Percona Server 5.1.60-13.1 on December 16, 2011 (Downloads are available from Percona Server 5.1.60-13.1 downloads and from the Percona Software Repositories). Based on MySQL 5… upstream MySQL at the time of this Percona Server release. Bug Fixed: #860910 (Alexey Kopytov) MyISAM repair-by-sort buffer cannot be more…
Post: Webinar: Introduction to Percona Server, XtraDB and Xtrabackup
November 26, 2010 By 2 Comments
… had such a large number of signups to our Migrating MyISAM to InnoDB webinar, that we decided to hold one more… the year is out: December, 8th 9AM PST: Introduction to Percona Server, XtraDB and Xtrabackup. As the title suggests: this presentation is…
Post: Return of the Query Cache, win a Percona Live ticket
August 26, 2011 By 4 Comments
…_cache_type is zero. We made some related changes in Percona Server 5.1 a while ago. I don’t recall the… ours, and we didn’t port our fix forward to Percona Server 5.5, and instead backported the 5.5 fix to… you used to be able to see that you had MyISAM problems really easily when you had a screen full of…
Post: Doing Re-run of Migrating MyISAM to Innodb Webinar
December 1, 2010 By 9 Comments
… what happened to me). As result we have scheduled Migrating MyISAM to Innodb webinar to run again on Tuesday, December 7… you would like to register. Note we also Webinar on Percona Server, Xtrabackup and XtraDB next week which is great if you…
Post: Impossible - possible, moving InnoDB tables between servers
June 8, 2009 By 9 Comments
… from customers who migrated from MyISAM to InnoDB – can I just copy .ibd files from one server to another and answer “use… done. Some more information available on http://www.percona.com/docs/wiki/percona-xtradb:patch:innodb_expand_import If you want some… get them from Launchpad projects https://launchpad.net/percona-xtradb and https://launchpad.net/percona-xtrabackup. Binary releases will be ready as…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… might be an indication that it’s time to convert MyISAM tables to InnoDB. (But then again, it might not be… stock MySQL server are extremely limited, and for serious analysis it’s basically mandatory to use a server that has the Percona patches for microsecond logging and additional information in the slow query log output. The stock MySQL server…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 7 Comments
… single InnoDB table as with MyISAM but knowing in advance that there are some prerequisites to comply. Percona Server relaxes a lot of limitations and is able to import tables from different Server instance, when table… this feature in Percona Server Documentation In the next blog post I’ll explain how to do recovery using Percona Data Recovery toolkit…
