Shulou(Shulou.com)06/01 Report--

There are three kinds of MySQL installation packages under Linux platform: RPM package, binary package and source package.

(1) RPM package:

Advantages: easy to install, do not need too much installation and configuration, suitable for beginners to install and use

Disadvantages: need to download client and server, of course, now can be bundled to download, the installation path is the default installation path can not be modified, a server can only install one MySQL, can not install multiple virtual hosts.

File installation path:

/ usr/bin (client programs and scripts)

/ usr/sbin (mysqld server)

/ var/lib/mysql (log files and databases)

/ usr/share/doc/packages (documentation)

/ usr/include/mysql (including common header files)

/ usr/lib/mysql (library file)

/ usr/share/mysql (error message and character set file)

/ usr/share/sql-bench (benchmark)

(2) binary package:

Advantages: easy to install, can be installed to any path, good flexibility; one server can install multiple mysql

Disadvantages: it has been compiled, the performance is not as good as the source code compilation, and the compilation parameters can not be flexibly customized.

File layout:

Bin: (client programs and mysqld servers)

Data (log files and databases)

Docs (documentation and ChangeLog)

Include (including common header files)

Lib (library file)

Script (mysql_install_db script, used to install the system database)

Share/mysql (error message file)

Sql-bench (benchmark)

(3) Source package:

Advantages: can be customized to compile on demand, the most flexible; the best performance; one server can install multiple MySQL

Disadvantages: complex installation process; long compilation time; not suitable for beginners

File layout:

Bin (client programs and scripts)

Include/mysql (common header file)

Info (document in Info format)

Lib/mysql (library file)

Libexec (mysql's server)

Share/mysql (error message file)

Sql-bench (benchmark and crash-me testing)

Var (database and log files)

The summary of the above content comes from MySQL.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.