… with automake 1.12. Bug fixed #1099387 (Alexey Bychko). Reduced the overhead from innodb_pass_corrupt_… PAM Authentication Plugin couldn’t be loaded with Perl and Python clients when plugin-dir option … on the launchpad bug tracker. UPDATE[18-04-2013]: There was a RPM packaging regression …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… with automake 1.12. Bug fixed #1099387 (Alexey Bychko). Reduced the overhead from innodb_pass_corrupt_… PAM Authentication Plugin couldn’t be loaded with Perl and Python clients when plugin-dir option … on the launchpad bug tracker. UPDATE[18-04-2013]: There was a RPM packaging regression …
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… limitations in the fast index creation feature introduced in the InnoDB plugin is that it only works when indexes are explicitly created… rows in set (1 min 12.19 sec) mysql> SHOW TABLE STATUS LIKE ‘t’\G *************************** 1. row *************************** Name: t Engine: InnoDB Version: 10…-06 10:04:10 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: 1 row in…
Post: Hijacking Innodb Foreign Keys
January 2, 2012 By 2 Comments
… get it right even though Innodb is able to drop indexes without rebuilding table since MySQL 5.1 (Innodb Plugin) dropping foreign keys which… child set v=”aaa”; Query OK, 1 row affected (0.04 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> update child set parent…_id`), CONSTRAINT `child_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `parentx` (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 1 row in set (0…
Post: Thinking about running OPTIMIZE on your Innodb Table ? Stop!
December 9, 2010 By 18 Comments
…do it. If you’re running Innodb Plugin on Percona Server with XtraDB you… +—-+——————————————+ 10 rows in set (0.04 sec) # This is just random SHA(1) hashes mysql> optimize table a; …
Post: MySQL versions shootout
October 10, 2011 By 6 Comments
… in question: MySQL 4.1 MySQL 5.0 MySQL 5.1 (with built-in InnoDB) MySQL 5.1 with InnoDB-plugin MySQL 5.5 MySQL 5…) threads MySQL 4.1 MySQL 5.0 MySQL 5.1 MySQL 5.1+InnoDB-plugin MySQL 5.5 MySQL 5.6.2 1 685.52 639….41 5078.02 4910.21 7535.65 7269.47 6994.04 Scripts and results are also on our Launchpad Benchmark project…
Post: Percona builds with Percona patchsets
July 16, 2008 By 35 Comments
… (show info about query execution in slow log) InnoDB statistic (show extended InnoDB usage during query execution in slow log) Google’s… some of our patches here: http://www.mysqlperformanceblog.com/2008/04/20/updated-msl-microslow-patch-installation-walk-through/ Some features….1, we are going to make releases with the InnoDB plugin version compiled in (not as a plugin), as the current system with independent InnoDB…
