Home  >  Article  >  Backend Development  >  My MySQL transaction processing_PHP tutorial

My MySQL transaction processing_PHP tutorial

WBOY
WBOYOriginal
2016-07-13 17:03:42738browse

#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]

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/630910.htmlTechArticle#This is the configuration of my MySql data #In this article, the mysql database installation directory of my computer is d: webservermysql #My database directory is f:sun datamysql data #The IP address of my computer...
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn