Posted by & filed under MySQL.

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…

21 Responses to “Google Perftools 1.3 available for Lenny”

  1. lubos

    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

  2. lubos

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

  3. Scott

    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!

  4. lubos

    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) 🙁

  5. Guillaume Plessis

    @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

  6. pmenier

    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

  7. pmenier

    Already done 🙂 I had a backup of previous version.

    Thanks a lot.

  8. lubos

    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

  9. lubos

    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!

  10. Daniel

    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.

  11. Daniel

    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.

  12. Guillaume Plessis

    @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.

  13. Bernhard

    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

  14. Guillaume

    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.