"Mysql5.5 xp system Download" MySQL XP system installation diagram

File name: "Mysql5.5 xp system Download" MySQL XP system installation diagram

File Description:

typical (Typical installation) installs only the MySQL server, the MySQL command line client, and the command-line utility. The command line client and utilities include mysqldump, Myisamchk, and several other tools to help you manage your MySQL server.
complete (fully installed) installation installs all the components contained within the package. The components included in the full installation package include the embedded server library, benchmark suite, support scripts, and documentation.
custom (custom installation) installation allows you full control over the packages and installation paths you want to install.

650) this.width=650; "height=" 379 "src=" Http://files.jb51.net/file_images/article/201109/2011092100341282.gif " Width= "504" style= "margin:0px;padding:0px;border:1px solid rgb (204,204,204); vertical-align:middle;" Alt= " 2011092100341282.gif "/>

Step 3: Select configuration Type
You can choose between two configuration types: detailed configuration (verbose) and standard configuration. The standard configuration option is suitable for new users who want to start MySQL quickly without having to consider the server configuration. Detailed configuration options are suitable for advanced users who want finer granularity in controlling server configuration.
standard configuration setting option may not be compatible with the system on which MySQL is installed. If MySQL and the installation you want to configure are already installed on your system, it is recommended that you choose a detailed configuration.

You can choose 3 types of servers, Choosing which server will affect the memory, hard disk, and process or usage decisions of the MySQL Configuration Wizard.
Developer machine: This option represents a typical personal desktop workstation. Assume that there are multiple desktop applications running on the machine. Configure the MySQL server to use minimal system resources.
Server machine: This option represents a server that the MySQL server can run with other applications, such as FTP, email, and Web servers. The MySQL server is configured to use the appropriate scale of system resources.
Dedicated MySQL server machine (dedicated MySQL servers): This option represents a server that only runs the MySQL service. Assume that the run is not running other applications. The MySQL server is configured to use all available system resources.

650) this.width=650; "height=" 379 "src=" Http://files.jb51.net/file_images/article/201109/2011092100341284.gif " Width= "504" style= "margin:0px;padding:0px;border:1px solid rgb (204,204,204); vertical-align:middle;" Alt= " 2011092100341284.gif "/>

Step 5: Select the storage engine
You can indicate the table processor used when creating the MySQL table. With this option, you can choose whether to use the InnoDB storage engine, and how much of the server resources the InnoDB occupies.
· Multifunctional database: Select this option to use both the InnoDB and MyISAM storage engines and distribute resources evenly between the two engines. This option is recommended for users who frequently use two storage engines.
· Transactional database only (transactional databases only): This option uses both the INNODB and MyISAM storage engines, but most server resources are assigned to the InnoDB storage engine. It is recommended that you select this option primarily using InnoDB only occasionally with MyISAM users.
· Non-transactional database only (non-transactional databases only): This option completely disables the InnoDB storage engine and assigns all server resources to the MyISAM storage engine. It is recommended that you do not use InnoDB to select this option.
Here's a brief introduction, InnoDB and MyISAM are the two most common table types used by MySQL, each with its pros and cons, depending on the application. The basic difference is that the MyISAM type does not support advanced processing such as transaction processing, and InnoDB type support. The MyISAM type of table emphasizes performance, which is performed more quickly than the InnoDB type, but does not provide transactional support, and InnoDB provides advanced database functionality such as transaction support and foreign keys.

650) this.width=650; "height=" 379 "src=" Http://files.jb51.net/file_images/article/201109/2011092100341285.gif " Width= "504" style= "margin:0px;padding:0px;border:1px solid rgb (204,204,204); vertical-align:middle;" Alt= " 2011092100341285.gif "/>

Step 6: Select the InnoDB data file to store the directory

650) this.width=650; "height=" 379 "src=" Http://files.jb51.net/file_images/article/201109/2011092100341286.gif " Width= "504" style= "margin:0px;padding:0px;border:1px solid rgb (204,204,204); vertical-align:middle;" Alt= " 2011092100341286.gif "/>

Decision Support (DSS)/olap: This option can be selected if the server does not require a large number of parallel connections. Assume that the average number of parallel connections is 20.
Online Transaction processing (on-line transaction processing) (OLTP): Select this option if your server requires a large number of parallel connections. The maximum number of connections is set to 500.
Manual Setting (Manual setting): Select this option to manually set the maximum number of server parallel connections. Select the number of parallel connections from the previous drop-down box, and if the number you expect is not in the list, enter the maximum number of connections in the drop-down box.

mysql Server supports multiple character sets , you can set the default server character set that applies to all tables, columns, and databases. Use the character set (character Set dialog box) to change the default character set of the MySQL server.
Standard Character set (normal character Set): Select this option if you want to use Latin1 as the default server character set. Latin1 is used in English and many Western European languages.
Best supports for multilingualism (multiple languages): Select this option if you want to use UTF8 as the default server character set. UTF8 can store characters in different languages as a single character set.
Manual Selected default Character set/collation (manually selected defaults/proofing rules): Select the default character set for the server if you want to manually select it. Select the desired character set from the drop-down list.

650) this.width=650; "height=" 379 "src=" Http://files.jb51.net/file_images/article/201109/2011092100341291.gif " Width= "504" style= "margin:0px;padding:0px;border:1px solid rgb (204,204,204); vertical-align:middle;" Alt= " 2011092100341291.gif "/>

OK, finally done.

More Software Downloads: http://www.gdhongshuo.net/wonload

"Mysql5.5 xp system Download" MySQL XP system installation diagram