Categories
MySQL

Google Perftools 1.3 available for Lenny

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

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

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

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) (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.

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.

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

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.

Comments are closed.