The mysql database is divided into a traditional data sheet format. One is a data sheet format (INNODB, BDB, where INNODB) is supported. I will introduce the installation of the MySQL transaction database. How to use you first download the mysql max version of the installer, download the address:
Www.mysql.com
After installing the installation installation according to the regular method, start mysql / bin / winmysqladmin and exit run mysql / bin / mydqld-nt --removemysql / bin / mysqld-max-nt --install or above is to remove transaction processing MySQL service, changed to the service that supports MySQL transaction processing and then built an ibdata directory and iblogs directory in C: /. Of course, the name can be different, remember these two names and drive characters, after you can use it, you can not built in the C drive, and then, opens c: / winnt or c: / my.ini windows directory, is added at the end: [code] innodb_data_file_path = ibdata1: 2000M; ibdata2: 2000Minnodb_data_home_dir = c: / ibdataset-variable = innodb_mirrored_log_groups = 1innodb_log_group_home_dir = c: / iblogsset-variable = innodb_log_files_in_group = 3set-variable = innodb_log_file_size = 30Mset-variable = innodb_log_buffer_size = 8Minnodb_flush_log_at_trx_commit = 1innodb_log_arch_dir = c: / iblogsinnodb_log_archive = 0set-variable = innodb_buffer_pool_size = 80Mset-variable = innodb_additional_mem_pool_size = 10Mset-variable = innodb_file_io_threads = 4Set-variable = INNODB_LOCK_WAIT_TIMEOUT = 50 [/ code] where IBDATA1: 2000M; IBDATA2: 2000M This line can change to 200M yourself, see your capacity size, MySQL recommended 10g and above hard disk space is best used Such settings; the following line InnoDB_DATA_HOME_DIR = C: / IBDATA can also change to your own directory, mainly to see you Where is the directory you just built, you have installed the Mysql transaction database, but you have installed the above paragraph in the mysql manual, but you will go to my.cnf, but Will go wrong, now let's try it is installed, start Apache, or IIS, launch mysql service in the service, open phpMyadmin, enter: show variables like "Have_%" You want to see the results below , Indicating that you have successfully installed [CODE] Variable_Name Value Have_IDB YES HAVE_INNODB YES HAVE_ISAM YES HAVE_RAID NO HAVE_SYMLINK YES HAVE_OPENSSL No Have_Query_Cache Yes [/ Code] Note:
