What is the difference between a MySQL essential version and a regular version? _mysql

MySQL's official website download address: http://www.mysql.com/downloads/

In this download interface there will be several versions of the selection.

1. MySQL Community Server Community version, open source free, but does not provide official technical support.
2. MySQL Enterprise Edition Enterprise version, you need to pay, you can try 30 days.
3. MySQL Cluster Cluster Edition, open source free. Several MySQL servers can be encapsulated into one server.
4. MySQL Cluster CGE Advanced Cluster Edition, which is subject to payment.
5. mysql Workbench (GUI TOOL) is a er/database modeling tool designed for MySQL. It is the successor of the famous Database design tool DBDesigner4. The MySQL Workbench is divided into two versions, namely the Community Edition (MySQL Workbench OSS), the Business Edition (MySQL Workbench SE).

MySQL Community Server is open source for free, which is also our usual version of MySQL. Broken down into multiple versions based on different operating system platforms, let's take a Windows platform as an example.

For example, download the MySQL 5.5.19 interface as follows:

Description
We chose generally Available (GA) release to download it. A GA is a generic version of a software, typically a version that is officially released.
Mysql-5.5.19-win32.msi,windows installation package, MSI installation package is completed with Msiexec installation. Windows Double-click under the wizard to install it, simple and convenient.
Mysql-5.5.19.zip, this is a Windows source file that needs to be compiled.
Mysql-5.5.19-win32.zip, this file can be used after unpack, is compiled good windows32 bit MySQL. Requires manual configuration.
With "Winx64" is the corresponding 64-bit version, which is used under 64-bit operating systems.
Generally do background development, we will download Mysql-5.5.19-win32.msi.

For example, download the MySQL 5.1.60 interface as follows:

Description

Select generally Available (GA) release to download. A GA is a generic version of a software, typically a version that is officially released.
"Essentials" refers to a compact version that does not contain the embedded server and benchmark suite, has an automatic installer and Configuration Wizard, and does not have a MySQL document.
"Noinstall" means a compressed package that is not installed. Contains the embedded server and benchmark suite, no automatic installer and Configuration Wizard, manual installation configuration, MySQL documentation.
Mysql-essential-5.1.60-win32.msi is a compact version, and if you only need MySQL services, select this version.
Mysql-5.1.60-win32.msi is a full version containing the setup and configuration wizards, with MySQL documentation.
Mysql-noinstall-5.1.60-win32.zip Zip compression package is not installed, there is no automatic installer and Configuration Wizard, you need to manually install the configuration, there is a MySQL document.
Mysql-5.1.60.zip is a MySQL source compression package for Windows
With "Winx64" is the corresponding 64-bit version, which is used under 64-bit operating systems.
Generally do background development, we will download Mysql-essential-5.1.60-win32.msi can.

"Author":

The Essentials Package:
Does not contain the embedded server and benchmark suite, there is an automatic installer and Configuration Wizard, and no MySQL documentation.

The Complete Package:
Contains the embedded server and benchmark suite, with the Automatic Installer and Configuration Wizard, with MySQL documentation.

The Noinstall Archive:
Contains the embedded server and benchmark suite, there is no automatic installer and Configuration Wizard, there is a MySQL documentation.

In general, we will use the installation with the automatic installation program and Configuration Wizard version, convenient to configure MySQL, of course, the master can not use, manually configured.

Reference:

For MySQL 5.0, there are three installation packages to choose from when installing MySQL on Windows:

The Essentials package:this Package has a filename similar to Mysql-essential-5.0.40-win32.msi and contains the minimum s Et of files needed to install MySQL on Windows, including the Configuration Wizard. This package does does not include optional components such as the embedded server and benchmark suite.

The Complete package:this Package has a filename similar to Mysql-5.0.40-win32.zip and contains all files needed for a CO Mplete Windows installation, including the Configuration Wizard. This package includes optional components such as the embedded server and benchmark suite.

The Noinstall archive:this package has a filename similar to Mysql-noinstall-5.0.40-win32.zip and contains all the files Found in the Complete install package, with the exception Configuration. This package does is not include a automated installer, and must be manually installed and configured.

The Essentials package is recommended for most users. It is provided as a. msi file with the Windows Installer. The Complete and Noinstall distributions are packaged as ZIP archives. To use them, your must have a tool that can unpack. zip files.

Your choice of install package affects the installation process you must. If you are choose to install either the Essentials or Complete install packages, and the "2.4.8.2 MySQL with T He automated Installer ". If you are install MySQL from the Noinstall archive, choose 2.4.8.5, "Installing MySQL from a noinstall Zip ARC Hive ".