Install the transaction database (InnoDB) for MySQL)

There are two types of SQL databases: one is the traditional data table format and the other is the data table format that supports transaction processing (InnoDB, BDB, with InnoDB as the main one ), the following describes how to install and use MySQL transaction processing database.

You need to download the Mysql max installation program: mysql.com

Install as usual

After installation, start mysqlbinWinMySQLadmin

Exit again

Run

Mysqlbinmydqld-nt -- remove

Mysqlbinmysqld-max-nt -- install

The above two rows remove the mysql service that does not support transaction processing and change it to the service that supports mysql transaction processing.

Then, create an ibdata directory and an iblogs directory under c:. Of course, the names can be different. Remember these two names and drive letters and they will be used later. You can also choose not to create a c disk. Then, open my. ini, add at the end:

Innodb_data_file_path = ibdata1: 2000 M; ibdata2: 2000 M

Innodb_data_home_dir = c: ibdata

Set-variable = innodb_mirrored_log_groups = 1

Innodb_log_group_home_dir = c: iblogs

Set-variable = innodb_log_files_in_group = 3

Set-variable = innodb_log_file_size = 30 M

Set-variable = innodb_log_buffer_size = 8 M

Innodb_flush_log_at_trx_commit = 1

Innodb_log_arch_dir = c: iblogs

Innodb_log_archive = 0

Set-variable = innodb_buffer_pool_size = 80 M

Set-variable = innodb_additional_mem_pool_size = 10 M

Set-variable = innodb_file_io_threads = 4

Set-variable = innodb_lock_wait_timeout = 50

　　

Where

Innodb_data_file_path = ibdata1: 2000 M; ibdata2: 2000 M

You can change 200 m in this line to m by yourself. Check the disk capacity. We recommend that you use this setting for hard disk space of 10 Gb or above for mysql;

The following line

Innodb_data_home_dir = c: ibdata

You can also change it to your own directory, mainly to see where the directory you just created is

According to the above method, you have installed the mysql transaction database, but if you install it according to the method in the mysql manual, put the above section in my. if cnf is used, errors may occur.

Now, let's see if the installation is complete. Start apache or iis, start mysql service in the service, open phpmyadmin, and enter SHOW variables like "have _ %"

If you see the following result, it indicates that the installation is successful.