Home | Troubleshooting |  Quick Setup  |  Cisco How to  |  Data Recovery  |  Forums   | Blog | IT Exam Practice | Services  | About Us | Chicagotech MVP  | Search  | Contact Us  |                 

 

 

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


 

 


 

 

Hit Counter   This web is provided "AS IS" with no warranties.
Copyright © 2002-2018 ChicagoTech.net, All rights reserved. Unauthorized reproduction forbidden.