Based on MySQL 5.1.66, including all the bug fixes in it, Percona Server 5.1.66-14.2 is now the current stable release in the 5.1 series. All of Percona‘s software is open-source and free, all the details of the release can be found in the 5.1.66-14.2 milestone at Launchpad.
GRANT FILEcommand. This bug fix comes originally from MariaDB (see MDEV-3884). Bug fixed #1083377 (Vlad Lesin).
Rows_readwas calculated in a way which lead to a negative value being printed in the slow query log. Fixed by making
Rows_readto be a synonym for
Rows_examinedin the slow query log. Bug fixed #830286 (Alexey Kopytov).
UPDATE. In some cases this could cause infinite loop. Bug fixed #917942 (Mark Callaghan, Laurynas Biveinis).
COMMITstages, the prepared InnoDB transaction would not have the slave position recorded and thus would fail to update it once it is replayed during binlog crash recovery. Bug fixed #1012715 (Laurynas Biveinis).
FALSE, makes fake transactions not to take any row locks. Bug fixed #1064326 (Mark Callaghan, Laurynas Biveinis).
mysqldumpwas used with
--innodb-optimize-keys, it did not handle composite indexes correctly when verifying if the optimization is applicable with respect to
AUTO_INCREMENTcolumns. Bug fixed #1039536 (Alexey Kopytov).
AUTO_INCREMENTcolumns where correctly detected,
mysqldumpprevented all such keys from optimization, even though it is sufficient to skip just one (e.g. the first one). Bug fixed #1081003 (Alexey Kopytov).
Query_timeto increase for every query stored procedure logged to the slow query log. Bug fixed #719386 (Alexey Kopytov).
Other bug fixes: bug fixed #901060 (Laurynas Biveinis), bug fixed #1071877 (Laurynas Biveinis), bug fixed #1090596 (Stewart Smith), bug fixed #1050466 (Laurynas Biveinis), bug fixed #890404 (Laurynas Biveinis), bug fixed #1061118 (Hrvoje Matijakovic).
Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.
Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.