August 23, 2014

Announcing Percona Server 5.5.24-26.0

Percona is glad to announce the release of Percona Server 5.5.24-26.0 on June 1st, 2012 (Downloads are available here and from the Percona Software Repositories).

Based on MySQL 5.5.24, including all the bug fixes in it, Percona Server 5.5.24-26.0 is now the current stable release in the 5.5 series. All of Percona‘s software is open-source and free, all the details of the release can be found in the 5.5.24-26.0 milestone at Launchpad.

New Features:

  • Percona PAM authentication plugin has now been integrated into the Percona Server.
  • Percona Server has implemented variable `enforce_storage_engine` which can be used for enforcing the use of a specific storage engine.
  • New column, TOTAL_CONNECTIONS_SSL, has been added in the CLIENT_STATISTICS, THREAD_STATISTICS and USER_STATISTICS tables in the INFORMATION_SCHEMA database.

Bugs Fixed:

  • A Server acting as a replication slave with the query cache enabled could crash with glibc detected memory corruption. This bug was introduced in MySQL 5.5.18 and Percona Server inherited it from MySQL. Bug fixed #915814 (George Ormond Lorch III).
  • Loading LRU dump was preventing shutdown. Bug fixed #712055 (George Ormond Lorch III).
  • A crash could leave behind an InnoDB temporary table with temporary indexes resulting in an unbootable server. Bug fixed #999147 (Laurynas Biveinis).
  • Since the output file is simply overwritten when dumping the LRU list, we could end up with a partially written dump file in case of a crash, or when making a backup copy of it. Safer approach has been implemente. It now dumps to a temporary file first, and then rename it to the actual dump file. Bug fixed #686392 (George Ormond Lorch III).
  • LRU messages are now more verbose for LRU dump. Bug fixed #713481 (George Ormond Lorch III).
  • Building Percona Server with the Clang compiler resulted in a compiler error. Bug fixed #997496 (Alexey Kopytov).
  • Variable `thread_statistics` was a reserved word in Percona Server 5.5. As a result, the server variable with that name had to be quoted with backticks when used. Bug fixed #997036 (Vladislav Lesin).

Release notes for Percona Server 5.5.24-26.0 are available in our online documentation.

Comments

  1. Jim says:

    Hi,
    Could you give us an article on when we should choose Percona Server, MariaDB, MySQL or Drizzle.
    Thanks.

  2. John Doe says:

    Is 12.04 supported yet?

  3. Hrvoje Matijakovic says:

    @John

    Yes, from this version Ubuntu 12.04 LTS is supported as well.

  4. Alexey Polyakov says:

    Have you considered allowing public rsync access to repositories? Right now people have to use tools like mrepo (over http) for creating and maintaining private/public mirrors, this is a lot of overhead.

  5. Hrvoje Matijakovic says:

    @Alexey

    We plan to allow public rsync access to repositories, but currently there isn’t any fixed date when this is going to be implemented.

  6. Steffen Higel says:

    Just to call this out, in case others are bitten by it:

    This build consistently crashed for me with userstat enabled as soon as it was required to replicate a statement from a master.

  7. Chris Bolt says:

    Also getting hit by the userstat crash, here’s the backtrace from the log:

    /usr/sbin/mysqld(my_print_stacktrace+0×35)[0x7c3435]
    /usr/sbin/mysqld(handle_fatal_signal+0x4a4)[0x692484]
    /lib/libpthread.so.0(+0xeff0)[0x7ff0c83f4ff0]
    /usr/sbin/mysqld[0x632ca6]
    /usr/sbin/mysqld(_Z24update_global_user_statsP3THDbl+0x3c2)[0x634792]
    /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0xaa)[0x598d9a]
    /usr/sbin/mysqld(_ZN15Query_log_event14do_apply_eventEPK14Relay_log_infoPKcj+0xcf4)[0x740ce4]
    /usr/sbin/mysqld(_Z26apply_event_and_update_posP9Log_eventP3THDP14Relay_log_info+0×125)[0x532e75]
    /usr/sbin/mysqld[0x5379b9]
    /usr/sbin/mysqld(handle_slave_sql+0×919)[0x538d89]
    /lib/libpthread.so.0(+0x68ca)[0x7ff0c83ec8ca]
    /lib/libc.so.6(clone+0x6d)[0x7ff0c768d92d]

  8. Hrvoje Matijakovic says:

    @Steffen, Chris

    There is already reported bug on launchpad regarding this (https://bugs.launchpad.net/percona-server/+bug/1008278). Clicking the “It affects me” link and providing the additional info will help trace this bug much faster. Also, if you subscribe to the bug you’ll get the status updates regarding the bugfix. Thank you for reporting it here as well.

Speak Your Mind

*