My MySQL transaction processing. # This is the configuration of my MySql data # in this article, my computer's mysql database installation directory is d: webservermysql # My Database Directory is f: sundatamysqldata # IP address of my computer # This is the configuration of my MySql data
# In this article, my computer's mysql database installation directory is "d: webservermysql"
# My Database Directory is "f: sun datamysql data"
# My computer's IP address is 192.168.0.2. if it is a public IP address, the same is true.
# [Mysqld] is the mysql environment configuration section.
# [WinMySQLadmin] for database startup
The section between [code] and [/code] that configures the environment variables and the transaction processing database
# In this article, the "#" part is optional for the text part of the comment line with "#", which can be opened
# This article references 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 = user name for starting the database
Password = password for starting the database
[Code]
Innodb_data_file_path = ibdata1: 1000 M; ibdata2: 1000 M
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 = 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
Set-variable = innodb_log_files_in_group = 3
Set-variable = innodb_log_file_size = 30 M
Set-variable = innodb_log_buffer_size = 8 M
# Set-variable = key_buffer = 16 M
[/Code]
# In this article, the installation directory of my computer's mysql database is d: webservermysql # My Database Directory is f: sun datamysql data # My computer's IP address...
