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: google-perftools, release
21 Responses to “Google Perftools 1.3 available for Lenny”
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
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
By Guillaume Plessis on Jun 17, 2009 | Reply
@lubos : I just uploaded the packages for Etch.
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!
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)
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
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
By Guillaume Plessis on Jun 18, 2009 | Reply
@Patrick : are you using amd64 or i386 machines?
By pmenier on Jun 18, 2009 | Reply
sorry: it’s on i386 .
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/
By pmenier on Jun 18, 2009 | Reply
Already done
I had a backup of previous version.
Thanks a lot.
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
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!
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.
By Guillaume Plessis on Jun 19, 2009 | Reply
@Daniel : you have to uninstall libtcmalloc-minimal0 before upgrading libgoogle-perftools0.
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.
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.
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
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 ?
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.
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.