October 20, 2014

MySQL Binaries Percona build10

We made new binaries for MySQL 5.0.67 build 10 which include next fixes:

  • We addressed concerns about potential logging and statistics overhead, so now you can fully turn on / off query statistics for microslow patch and user statistics in runtime.

Next variables were added:

With both slow_query_log = OFF and userstat_running = OFF we have no performance penalties of using of patches.

  • Also we fixed potential memory leaks in microslow and userstats patches, the leak appeared under some workloads.

The -percona release includes:

and -percona-highperf release additionaly includes

You can download RPMs for RedHat / CentOS 4.x and 5.x for x86_64, binaries, sources and patches there

OurDelta builds of this should becoming soon.

About Vadim Tkachenko

Vadim leads Percona's development group, which produces Percona Clould Tools, the Percona Server, Percona XraDB Cluster and Percona XtraBackup. He is an expert in solid-state storage, and has helped many hardware and software providers succeed in the MySQL market.

Comments

  1. si says:

    When we are can see the release 5.1 with percona patches ?

  2. Vadim says:

    Si,

    No decided date yet, we are working on porting patch fixes to new tree.

  3. Anonymous Coward says:

    Is there any specific method you suggest to follow upgrade path from 5.0.51 (or whatever) standard mysql to your percona-highperf build?

  4. peter says:

    Assuming you’re using RPM with same layout you can upgrade same way as you would upgrade to MySQL versions of them.

    (RPM from RedHat and MySQL for example use a bit different layout for the same platform)

  5. Vadim says:

    Actually just update may not work. As we use different Vendor in RPM .spec the way to install is to delete old RPM (rpm -e) and install new one (rpm -i)

  6. kas says:

    No build for win32? :) ourdelta doesn’t do it either…

  7. Vadim says:

    kas,

    We have not focused on win32 development, and I even guess some our patches break windows compilation.
    It comes from the fact we fix performance problems on production boxes, but MySQL is rarely run on Win32 production system.

  8. Antony says:

    I’m going to see if I can set aside some time to do some Win32 builds … And I’ll look at learning how to create msi binaries so that they may be easily installed.

    If I have enough spare moments, I may build the Win32 binaries to permit storage engines to be installed as plugins. The last time I did that was an internal mysql “proof of concept” build I did more than 2 years ago. AFAIK, the zip file is still attached to the worklog. 2

  9. Vadim says:

    Antony,

    We may look into, though I expect problem with compilation (even for Solaris it is not compiled clean). And I don’t think we can make rw_lock working on Win32 (though we may exclude this patch)

  10. nicholas says:

    Hello,
    we have been using the 67-b10 version since around release, and we see a memory usage development that would indicate a meory leak?

    Server version: 5.0.67-percona-highperf-b10-log MySQL Percona High Performance Edition (GPL)

    http://nicholas.users.linpro.no/mysql-memory-month.png

    Week 50 we ran stock redhat mysql . Early week 51 we installed the percona version. since then memory usage has been growing. Last week orso it ran out of swap space, so we added some more today ;)

    We also run http://www.percona.com/mysql/5.0.68/RPM/rhel5/ another place, without the same problems.

    greetings
    -nicholas

  11. Vadim says:

    nicholas,

    can you show your my.cnf and SHOW GLOBAL VARIABLES

    you can send me it in private email to vadim @ thisdomain

  12. nicholas,

    We created bug for this problem – https://bugs.launchpad.net/percona-patches/+bug/315619

Speak Your Mind

*