|
How to run
MySQL Server Instance
Configuration Wizard - Part 1
1. The MySQL Server Instance Configuration Wizard will
start after you complete MySQL installation. Or you can run it from
Start>All Programs>MYSQL>MYSQL Server.
2. In MySQL Instance Configuration, you have tow options.
The Standard Configuration option is
intended for new users who want to get started with MySQL quickly without
having to make many decisions about server configuration. The Detailed
Configuration option is intended for advanced users who want more
fine-grained control over server configuration.
3. There are three different server types available. The
server type that you choose affects the decisions on memory, disk, and
processor usage.
1) Developer Machine: Choose this option for a typical
desktop workstation where MySQL is intended only for personal use. It is
assumed
that many other desktop applications are running. The MySQL server is
configured to use minimal system resources.
2) Server Machine: Choose this option for a server machine where the MySQL
server is running alongside other server applications
such as FTP, email, and Web servers. The MySQL server is configured to use a
moderate portion of the system resources.
3) Dedicated MySQL Server Machine: Choose this option for a server machine
that is intended to run only the MySQL server. It is assumed
that no other applications are running. The MySQL server is configured to
use all available system resources.
4. The DATABASE USAGE selection enables you to indicate
the storage engines that you expect to use and what percentage of the server
resources are available.
1) Multifunctional Database: This option enables both the InnoDB and MyISAM
storage engines and divides resources evenly
between the two. This option is recommended for users who use both storage
engines on a regular basis.
2) Transactional Database Only: This option enables both the InnoDB and
MyISAM storage engines, but dedicates most server resources
to the InnoDB storage engine. This option is recommended for users who use
InnoDB almost exclusively and make only
minimal use of MyISAM.
3) Non-Transactional Database Only: This option disables the InnoDB storage
engine completely and dedicates all server resources to
the MyISAM storage engine. This option is recommended for users who do not
use InnoDB.
5. The InnoDB Tablespace Settigns give you an option to
select the drive for InnoDB Database.
Next
Post your questions, comments, feedbacks and suggestions
Contact a consultant
Related Topics
|
