List:General Discussion« Previous MessageNext Message »
From:Joerg Bruehe Date:July 6 2010 9:30am
Subject:Re: How to slim MySQL?
View as plain text  
Hi!


Nima Mohammadi wrote:
> On Mon, Jul 5, 2010 at 8:26 PM, Rob Wultsch <wultsch@stripped> wrote:
> 
>> [[...]]
>>
>> You probably want to compile your own version of MySQL. You probably
>> want to remove debugging symbols* (which have been present since the
>> mid 5.0 series, iirc), and any engines/character sets/etc you don't
>> need.
>>
>> *Alternatively you can run the strip command.
>>
>> --
>> Rob Wultsch
>> wultsch@stripped
>>
> 
> [[...]]
> I guess for removing debug symbols I need to add the "--without-debug"
> option to the ./configure command. I think using these options would also be
> helpful:
> 
>    - --without-man
>    - --without-docs

This will affect the package size, but not the individual binary.

>    - --without-ipv6
>    - --disable-largefile

"largefile" shouldn't have a big effect on size, but in a tiny embedded
system you probably really don't need it.

> 
> I'm not sure which engine we're going to use, so I'll have to defer this to
> another time.

The engine will be quite important, stripping all engines you don't need
will have the largest effect on size.

> Is there any other work I could do to strip MySQL?

Check the character sets you configure, get rid of those you don't need.

You might look into compiler options optimizing for space rather than
for speed, but I hope you are not that much limited by your system.

If you want to run client/server as separate binaries, you can use
"--without-embedded". However, I guess linking the server part to the
application will have a big effect on space requirements, so you really
should look into that.

Are you using version 5.1 or 5.5 ?


Jörg

-- 
Joerg Bruehe,  MySQL Build Team,  Joerg.Bruehe@stripped
ORACLE Deutschland B.V. & Co. KG,   Komturstrasse 18a,   D-12099 Berlin
Geschaeftsfuehrer: Juergen Kunz, Marcel v.d. Molen, Alexander v.d. Ven
Amtsgericht Muenchen: HRA 95603

Thread
How to slim MySQL?Nima5 Jul
  • Re: How to slim MySQL?Rob Wultsch5 Jul
    • Re: How to slim MySQL?Nima Mohammadi5 Jul
      • Re: How to slim MySQL?Rob Wultsch5 Jul
        • Re: How to slim MySQL?Nima Mohammadi5 Jul
          • Re: How to slim MySQL?Michael Dykman5 Jul
      • Re: How to slim MySQL?Joerg Bruehe6 Jul
        • Re: How to slim MySQL?Nima Mohammadi6 Jul
  • Re: How to slim MySQL?mos6 Jul
    • Re: How to slim MySQL?Nima Mohammadi6 Jul
      • Re: How to slim MySQL?AndrĂ©s Tello6 Jul
        • Re: How to slim MySQL?Nima Mohammadi7 Jul
Re: How to slim MySQL?Michael Dykman5 Jul