Google Perftools 1.3 available for Lenny

June 16th, 2009 | by Guillaume Plessis |

Do you remember how to speed up your MySQL server using the Google Perftools? It seems that the amd64 flavour of these libraries makes MySQL crash.

I just bumped the version of the google-perftools packages for Lenny from 1.0 to 1.3. According to the Changelog they’re bringing a lot of bugfixes and improvements, and then enhance the stability of the daemons they’re plugged in.

Upgrading is highly recommended.

Update : The packages are now available for Etch.

Update #2 : Please desactivate the Google Perftools 1.3! They’re crashing MySQL. I’m rolling back to the old version (Etch : 0.98, Lenny : 1.0) until I fix (or Google) fix this issue. Really sorry for the mess…

Tags: ,

  1. 21 Responses to “Google Perftools 1.3 available for Lenny”

  2. By lubos on Jun 17, 2009 | Reply

    hi, I’ve a question – will you create this package for Etch too? Or can I do it myself from sources and it will have the same effect (higher performace)?
    thx, lubos

  3. By lubos on Jun 17, 2009 | Reply

    one more thing – mysql is in version 5.0.81-0.dotdeb on Etch if it is important for my question

  4. By Guillaume Plessis on Jun 17, 2009 | Reply

    @lubos : I just uploaded the packages for Etch.

  5. By Scott on Jun 17, 2009 | Reply

    It looks like the update done today for apache2 2.2.9-10+lenny3 has broken your php5 files.

    Starting web server: apache2[Wed Jun 17 01:25:24 2009] Syntax error on line 15 of /etc/apache2/sites-enabled/MUNGED.net.conf:
    Invalid command ‘php_value’, perhaps misspelled or defined by a module not included in the server configuration
    failed!

  6. By lubos on Jun 17, 2009 | Reply

    thx!
    I’ll try it at night and will see… hopefully it will work fine on amd64 – with perftools v0.98 mysql crashed in 30 min for me (process was still up, but mysql didn’t answer) :(

  7. By Guillaume Plessis on Jun 17, 2009 | Reply

    @Scott : I had no problem with this update. Make sure php5 is activated by lauching :
    a2enmod php5
    /etc/init.d/apache2 stop
    /etc/init.d/apache2 start

  8. By pmenier on Jun 18, 2009 | Reply

    Hi,
    Upgrade of libgoogle-perftools fails on etch (mysql version 5.0.81-0.dotdeb.0) and lenny (mysql version 5.1.34-0.dotdeb.1).

    I got these errors when trying to stop/start mysql:

    Jun 18 09:43:49 myhost kernel: mysql[25519]: segfault at 00000014 eip b7f34d7d esp bff62330 error 4
    Jun 18 09:43:49 myhost kernel: mysql[25520]: segfault at 00000014 eip b7fa5d7d esp bfb1b6e0 error 4

    Any clues ?
    Thanks,
    Patrick

  9. By Guillaume Plessis on Jun 18, 2009 | Reply

    @Patrick : are you using amd64 or i386 machines?

  10. By pmenier on Jun 18, 2009 | Reply

    sorry: it’s on i386 .

  11. By Guillaume Plessis on Jun 18, 2009 | Reply

    @Patrick : I’ll try to fix this soon, but if you want to downgrade, take a look at http://archives.dotdeb.org/

  12. By pmenier on Jun 18, 2009 | Reply

    Already done :) I had a backup of previous version.

    Thanks a lot.

  13. By lubos on Jun 18, 2009 | Reply

    I can confirm the same problem on amd64 in domU:

    # /etc/init.d/mysql restart
    /etc/init.d/mysql: line 99: 16243 Segmentation fault $SELF stop
    /etc/init.d/mysql: line 99: 16244 Segmentation fault $SELF start

    mysql-server/lenny uptodate 5.0.51a-24+lenny1
    libgoogle-perftools0/unknown uptodate 1.3-0.dotdeb.1
    libunwind7/unknown uptodate 0.98.5-7.dotdeb.1

    lubos

  14. By lubos on Jun 18, 2009 | Reply

    when I stop mysql before adding line

    export LD_PRELOAD=”/usr/lib/libtcmalloc.so.0″

    to /etc/init.d/mysql I get different error:

    # /etc/init.d/mysql start
    Starting MySQL database server: mysqld/etc/init.d/mysql: line 110: 16797 Segmentation fault /usr/bin/mysqld_safe > /dev/null 2>&1
    . . . . . . . . . . . . . . failed!

  15. By Daniel on Jun 19, 2009 | Reply

    Hi,
    this error is thrown on upgrading perftools in my debian etch, so upgrading fails:

    #apt-get uprade
    …
    dpkg: error processing /var/cache/apt/archives/libgoogle-perftools0_1.3-0.dotdeb.0_i386.deb (–unpack):
    trying to overwrite »/usr/lib/libtcmalloc_minimal.so.0.0.0«, which is also in package libtcmalloc-minimal0
    dpkg-deb: subprocess paste killed by signal (Broken pipe)
    …

    #cat /proc/version
    Linux version 2.6.18-4-686 (Debian 2.6.18.dfsg.1-12etch2) (dannf@debian.org) (gcc version 4.1.2 20061115 (prerelease) (Debian 4.1.1-21)) #1 SMP Wed May 9 23:03:12 UTC 2007

    I removed perftools until I can use it again.

  16. By Guillaume Plessis on Jun 19, 2009 | Reply

    @Daniel : you have to uninstall libtcmalloc-minimal0 before upgrading libgoogle-perftools0.

  17. By Daniel on Jun 19, 2009 | Reply

    Thank you, this fixed one error but a new one is showing up:

    Starting MySQL database server: mysqld/etc/init.d/mysql: line 108: 1377 Segmentation fault /usr/bin/mysqld_safe >/dev/null 2>&1

    Maybe the same error the others reporting.
    The perftools-version before this update was working.

  18. By Guillaume Plessis on Jun 20, 2009 | Reply

    @Daniel : Google Perftools 1.3 seem to have a problem and crash MySQL. Many users reported this. I’m rolling back to 1.0. Please desactivate them.

  19. By Bernhard on Jun 23, 2009 | Reply

    Hi,

    I also had the problem with version 1.3 and MySQL on Etch (segmentation fault). So I downloaded version 0.98 and then everything went fine. Here ist the link where I downloaded it (I searched a long time for it, so that’s why I post it here): http://archives.dotdeb.org/dists/etch/google-perftools/0.98/binary-i386/

    I don’t know if it’s really faster, is there a way to test it (not subjective) if it’s really faster? Memory consumption should be the same, yes?

    Greetz
    Bernhard

  20. By Gurpartap Singh on Jul 18, 2009 | Reply

    Anyone willing to report this in detail in the issue queue at http://code.google.com/p/google-perftools/issues/list ?

  21. By Guillaume on Oct 2, 2009 | Reply

    Hi there,
    Google Perftools 1.4 has been released, what about an update on dotdeb, so we’ll see if we can use it with mySQL!
    thanks a lot Guillaume for your great work.

  22. By Guillaume Plessis on Oct 3, 2009 | Reply

    @Guillaume : I just uploaded Google Perftools 1.4 for Lenny, I did edit the corresponding how-to (http://www.dotdeb.org/2008/08/25/using-the-google-perftools-to-speed-up-your-mysql-server/) and I’ll make an announce about it.

    Thanks for this upgrade request.

Post a Comment