通过源码编译安装mysql的优势

Under some circumstances, you probably will be better off installing MySQL from a source distribution:

• You want to install MySQL at some explicit location. The standard binary distributions are "ready to run" at any place, but you may want to have even more flexibility to place MySQL components where you want.

• You want to configure mysqld with some extra features that are not included in the standard binary distributions. Here is a list of the most common extra options that you may want to use:

  • --with-innodb (default for MySQL 4.0 and up)

  • -with-berkeley-db (not available on all platforms)

  • --with-raid

  • --with-libwrap

  • --with-named-z-libs (this is done for some of the binaries)

  • --with-debug[=full]

• You want to configure mysqld without some features that are included in the standard binary distributions. For example, distributions normally are compiled with support for all character sets. If you want a smaller MySQL server, you can recompile it with support for only the character sets you need.

• You have a special compiler (such as pgcc) or want to use compiler options that are better optimized for your processor. Binary distributions are compiled with options that should work on a variety of processors from the same processor family.

• You want to use the latest sources from one of the BitKeeper repositories to have access to all current bugfixes. For example, if you have found a bug and reported it to the MySQL development team, the bugfix will be committed to the source repository and you can access it there. The bugfix will not appear in a release until a release actually is issued.

• You want to read (or modify) the C and C++ code that makes up MySQL. For this purpose, you should get a source distribution, because the source code is always the ultimate manual.

• Source distributions contain more tests and examples than binary distributions.