Home > Article > Backend Development > My MySQL transaction processing_PHP tutorial
#This is the configuration of my MySql data
#In this article, the mysql database installation directory on my computer is "d:webservermysql"
#My database directory is "f:sun datamysql data"
#The IP address of my computer is 192.168.0.2. The same is true if it is a public IP
The #[mysqld] part is the environment configuration part of mysql
#[WinMySQLadmin]Start part for database
The part between [code] and [/code] is for configuring environment variables and transaction processing database
#The part using "#" in this article is a comment line. The part with "#" in the text is optional and can be opened
#This article refers to some mysql reading files.
[mysqld]
basedir=d:/webserver/mysql
#bind-address=192.168.0.2
datadir=F:/Sun Date/mysql data/
#language=d:/webserver/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
[WinMySQLadmin]
Server=d:/webserver/mysql/bin/mysqld-max-nt.exe
user=username to start the database
password=password to start the database
[code]
innodb_data_file_path = ibdata1:1000M;ibdata2:1000M
innodb_data_home_dir = d:webservermysqlibdata
set-variable = innodb_mirrored_log_groups=1
innodb_log_group_home_dir = d:webservermysqliblogs
innodb_flush_log_at_trx_commit=1
innodb_log_arch_dir = d:webservermysqliblogs
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
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=30M
set-variable = innodb_log_buffer_size=8M
#set-variable = key_buffer=16M
[/code]