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 replies on “Google Perftools 1.3 available for Lenny”
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
one more thing – mysql is in version 5.0.81-0.dotdeb on Etch if it is important for my question
@lubos : I just uploaded the packages for Etch.
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!
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) 🙁
@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
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
@Patrick : are you using amd64 or i386 machines?
sorry: it’s on i386 .
@Patrick : I’ll try to fix this soon, but if you want to downgrade, take a look at http://archives.dotdeb.org/
Already done 🙂 I had a backup of previous version.
Thanks a lot.
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
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!
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) ([email protected]) (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.
@Daniel : you have to uninstall libtcmalloc-minimal0 before upgrading libgoogle-perftools0.
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.
@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.
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
Anyone willing to report this in detail in the issue queue at http://code.google.com/p/google-perftools/issues/list ?
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 : I just uploaded Google Perftools 1.4 for Lenny, I did edit the corresponding how-to (http://localhost:8080/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.