Installation method of MySQL transaction database (InnoDB type)_PHP tutorial

There are two types of MySQL databases, one is the traditional data table format, and the other is the data table format that supports transaction processing (InnoDB, BDB, mainly InnoDB). Below I will introduce the installation and installation of the MySQL transaction processing database. How to use
You first need to download the Mysql max version installation program, download address: www.mysql.com
Install according to the conventional method
After the installation is completed, start mysql inWinMySQLadmin
and then Exit
Run
mysql inmydqld-nt --remove
mysql inmysqld-max-nt --install
The above two lines are to remove the mysql service that does not support transaction processing and change it to support mysql transactions Processing services
Then create an ibdata directory and iblogs directory under c:. Of course, the names can be different. Remember these two names and drive letters. You will need them in the future. You also don’t need to create them on the C drive, and then , open my.ini in the c:winnt or c:windows directory, and add at the end: [code]
innodb_data_file_path = ibdata1:2000M;ibdata2:2000M
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=30M
set-variable = innodb_log_buffer_size=8M
in nodb_flush_log_at_trx_commit=1
innodb_log_arch_dir = c:iblogs
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=80M
set-variable = innodb_additional_mem_pool_size=10M
set-variable = innodb_file_io_threads=4
set- variable = innodb_lock_wait_timeout= 50
[/code]
where
innodb_data_file_path = ibdata1:2000M;ibdata2:2000M
The 2000M in this line can be changed to 200m. It depends on the capacity of your disk. MySQL recommends 10G and above. It is best to use this setting for the hard disk space;
The following line
innodb_data_home_dir = c:ibdata
can also be changed to a directory you created yourself, mainly to see where the directory you just created is located
According to the above method, you have installed the mysql transaction database. However, if you install it according to the method in the mysql manual and put the above configuration into my.cnf, an error will occur
Okay, now let's try to see if the installation is complete. Start apache, or iis, start the mysql service in the service, open phpmyadmin, enter: SHOW variables like "have_%"
If you see the following results , that means you installed it successfully
[code]
Variable_name Value
have_bdb YES

http://www.bkjia.com/PHPjc/629386.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/629386.htmlTechArticleMySQL database is divided into two types, one is the traditional data table format, and the other is data that supports transaction processing Table format (InnoDB, BDB, mainly InnoDB), let me introduce something about MySQL...