Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bugzilla DB migration completed. Please report issues to Infra team via email via infra@gentoo.org or IRC
Bug 103111 - Add USE-Flag to just build static mysqld but build client libraries
Summary: Add USE-Flag to just build static mysqld but build client libraries
Status: RESOLVED WONTFIX
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: New packages (show other bugs)
Hardware: All Linux
: High enhancement (vote)
Assignee: Gentoo Linux MySQL bugs team
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-08-20 01:59 UTC by Matthias Blaser
Modified: 2006-03-18 04:24 UTC (History)
0 users

See Also:
Package list:
Runtime testing required: ---


Attachments
proposed patch for 5.0 ebuilds (static-5.0.patch,877 bytes, patch)
2005-08-20 02:00 UTC, Matthias Blaser
Details | Diff
proposed patch for 4.1 ebuilds (static-4.1.patch,890 bytes, patch)
2005-08-20 02:01 UTC, Matthias Blaser
Details | Diff

Note You need to log in before you can comment on or make changes to this bug.
Description Matthias Blaser 2005-08-20 01:59:13 UTC
MySQL allows to just statically link mysqld, but still build the client shared
libraries. Rather than just configure if the whole package will be linked
statically, it would be nice to say to only apply 'static' to mysqld. (Attached
is a proposed patch for mysql-5.XXX and mysql-4.1.X ebuilds)

Reproducible: Always
Steps to Reproduce:
Comment 1 Matthias Blaser 2005-08-20 02:00:07 UTC
Created attachment 66370 [details, diff]
proposed patch for 5.0 ebuilds
Comment 2 Matthias Blaser 2005-08-20 02:01:02 UTC
Created attachment 66371 [details, diff]
proposed patch for 4.1 ebuilds
Comment 3 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2005-08-20 03:13:22 UTC
why do you want mysqld built statically?
it's slower than being built shared.
Comment 4 Matthias Blaser 2005-08-20 05:21:47 UTC
(In reply to comment #3)
> why do you want mysqld built statically?
> it's slower than being built shared.

Not at all... we couldn't achieve 13% like it is stated in the documentation of
mysql, but it's faster. The official binaries are also linked statically.

http://dev.mysql.com/doc/mysql/en/compile-and-link-options.html
If you link dynamically (without -static), the result is 13% slower on Linux.
Note that you still can use a dynamically linked MySQL library for your client
applications. It is the server that is most critical for performance.

Comment 5 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2005-08-20 21:04:49 UTC
umm, with your patch applied, this case also fails:
USE='mysql-static-daemon ssl' emerge mysql

I'm doing some benchmarking, on a new box I've got recently, as I'm very 
certain that shared is still faster (for the sole reason that stuff is already 
in the cache
Comment 6 Francesco R. (RETIRED) gentoo-dev 2006-03-18 04:24:45 UTC
me too prefere an all or nothing "static" flag, afraid to close this as wontfix.