Google Perftools 1.3 available for Lenny

June 16, 2009 · 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 d esactivate 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…

lubos June 17, 2009
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
lubos June 17, 2009
one more thing - mysql is in version 5.0.81-0.dotdeb on Etch if it is important for my question
Guillaume Plessis June 17, 2009
@lubos : I just uploaded the packages for Etch.
Scott June 17, 2009
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!
- Guillaume Plessis June 17, 2009
  @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
lubos June 17, 2009
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) :(
pmenier June 18, 2009
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
Guillaume Plessis June 18, 2009
@Patrick : are you using amd64 or i386 machines?
pmenier June 18, 2009
sorry: it’s on i386 .
Guillaume Plessis June 18, 2009
@Patrick : I’ll try to fix this soon, but if you want to downgrade, take a look at http://archives.dotdeb.org/
pmenier June 18, 2009
Already done :) I had a backup of previous version.
Thanks a lot.
lubos June 18, 2009
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
lubos June 18, 2009
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!
Daniel June 19, 2009
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.
Guillaume Plessis June 19, 2009
@Daniel : you have to uninstall libtcmalloc-minimal0 before upgrading libgoogle-perftools0.
Daniel June 19, 2009
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.
Guillaume Plessis June 20, 2009
@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.
Bernhard June 23, 2009
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
Gurpartap Singh July 18, 2009
Anyone willing to report this in detail in the issue queue at http://code.google.com/p/google-perftools/issues/list ?
Guillaume October 2, 2009
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.
Guillaume Plessis October 3, 2009
@Guillaume : I just uploaded Google Perftools 1.4 for Lenny, I did edit the corresponding how-to (/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.

/etc/init.d/mysql restart

/etc/init.d/mysql start