MySQL Performance: MySQL => Binaries / Compiled

Members

Help

Home

Home » Performance » MySQL » Binaries / Compiled

Show: Today's Messages :: Show Polls :: Message Navigator

Binaries / Compiled [message #225]

Wed, 04 October 2006 14:39

orban
Messages: 3
Registered: October 2006

Junior Member

http://dev.mysql.com/downloads/mysql/5.0.html

"For maximum stability and performance, we recommend that you use the binaries we provide."

Is that true? I always compiled my own MySQL (don't actually know why, I just always compiled my own lighty, php and mysql).

Is there actually any performance gain?

Running debian stable Linux blabla 2.6.8-2-686-smp #1 SMP Tue Aug 16 12:08:30 UTC 2005 i686 GNU/Linux

Report message to a moderator

Re: Binaries / Compiled [message #226 is a reply to message #225 ]

Wed, 04 October 2006 16:43

Peter
Messages: 405
Registered: August 2006

Senior Member
Super Guru

Debian users typically do it, or using Debian package. Normally they are smart enough to do good builds, we had some issues with bad builds on debian as well however.

Using MySQL provided builds is more about Stability than performance. Using special compiler switches for your CPU model you typically can make MySQL even faster 1-2% but it increases chances of problems with compiler/GLIBC issues.

Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/

Report message to a moderator

Re: Binaries / Compiled [message #227 is a reply to message #225 ]

Wed, 04 October 2006 16:47

orban
Messages: 3
Registered: October 2006

Junior Member

I'm just using

./configure \
--prefix=/usr \
--exec-prefix=/usr \
--libexecdir=/usr/sbin \
--datadir=/usr/share \
--sysconfdir=/etc/mysql \
--localstatedir=/var/lib/mysql \
--includedir=/usr/include \
--infodir=/usr/share/info \
--mandir=/usr/share/man \
--enable-shared \
--enable-static \
--enable-thread-safe-client \
--without-debug \
--with-unix-socket-path=/var/run/mysqld/mysqld.sock \
--with-mysqld-user=mysql \
--with-embedded-server \
--without-docs \
--without-bench \
--with-extra-charsets=all \
--with-vio \
--with-charset=latin1 \
--with-collation=latin1_swedish_ci \
--with-extra-charsets=all

I don't use any special compiler switches though...

Using Dual Xeons 2.8GhZ with HT...

Report message to a moderator

Re: Binaries / Compiled [message #228 is a reply to message #227 ]

Wed, 04 October 2006 16:53

Peter
Messages: 405
Registered: August 2006

Senior Member
Super Guru

This seems to be OK. At least nothing which catches my eye

Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/

Report message to a moderator

Re: Binaries / Compiled [message #229 is a reply to message #225 ]

Wed, 04 October 2006 17:02

orban
Messages: 3
Registered: October 2006

Junior Member

Okay, thanks for your help!

Report message to a moderator

Previous Topic:	Problem with compressed tables
Next Topic:	Inner joining big table

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 10 01:54:35 EDT 2009

Total time taken to generate the page: 0.01172 seconds

.:: Contact :: Home ::.

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.