MySQL databases are classified into two types: traditional data table formats and transaction-supported data table formats (InnoDB and BDB, with InnoDB as the primary ), next, I will introduce the installation and usage of MySQL transaction processing Database. first, download the installation program for Mysqlmax: www.mysql.com install and install InnoDBmysql in the conventional way.
MySQL databases are classified into two types: traditional data table formats and transaction-supported data table formats (InnoDB and BDB, with InnoDB as the primary ), the following describes how to install and use MySQL transaction processing database.
Download the installation program for Mysql max, www.mysql.com.
Install as usual
After installation, start mysql \ bin \ WinMySQLadmin
Exit again
Run
Mysql \ bin \ mydqld-nt -- remove
Mysql \ bin \ mysqld-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 not create them on the c drive, then, open my. ini, add the following code at the end: [code]
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
[/Code]
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.
[Code]
Variable_name Value
Have_bdb YES
Have_innodb YES
Have_isam YES
Have_raid NO
Have_symlink YES
Have_openssl NO
Have_query_cache YES
[/Code]
Note: the use of mysql transaction processing methods is similar to the syntax of other databases. I will not talk about it here. In addition, Mysql will implement foreign keys and subqueries in mysql 4.3, simple foreign keys have been implemented in 4.0, but they are not very convenient. I believe they will do better in the future.
The use of transaction tables has been successfully implemented in my online order management system. The effect is good, but it has not gone through the practice of large data volumes.
I wrote the above article based on my own practice. if you want to repost it, please indicate the source and author. you are also welcome to discuss some issues about the Mysql transaction table with me.
