MYSQL My.ini Chinese Detailed

[Mysqld]

Port = 3306

Socket =/tmp/mysql.sock

# set the MySQL installation directory

Basedir=f:\\hzq Soft\\mysql Server 51GA

# set up the MySQL database data storage directory, must be either data, or \\xxx-data

Datadir=f:\\hzq Soft\\mysql Server 51ga\\data

#innodb_log_arch_dir default DataDir

#innodb_log_group_home_dir default DataDir

# set the MySQL server's character set, default encoding

Default-character-set=utf8

#连接数的操作系统监听队列数量, this value can be appropriately increased if the "Deny connection" error occurs frequently

Back_log = 50

#不使用接听TCP/IP Port method, mysqld by named pipe connection

#skip-networking

# Maximum number of connections

max_connections = 100

#打开表的线程数量限定, Max 4096, unless the limit is opened with Mysqld_safe

Table_open_cache = 2048

#MySql service receives the maximum query package size for each process

Max_allowed_packet = 16M

#作用于SQL查询单笔处理使用的内存缓存, if the binary data of an operation exceeds the limited size, it will open up space processing on the disk, generally set to 1-2m, the default 1M

Binlog_cache_size = 2M

#单个内存表的最大值限定

Max_heap_table_size = 64M

#为每个线程分配的排序缓冲大小

Sort_buffer_size = 8M

#join the buffer size of the table operation, set according to the actual business, default 8M

Join_buffer_size = 32M

#操作多少个离开连接的线程的缓存

Thread_cache_size = 8

#并发线程数量, the default is 8, can be appropriately increased to twice times within. If you have more than one CPU, you can multiply the number of CPUs. The dual-core CPU can multiply the current maximum number and multiply the 70%-85%

Thread_concurrency = 16

#专用于具体SQL的缓存, if the submitted query is the same as a query in a few times and is present in the query cache, the result in the cache is returned directly.

Query_cache_size = 64M

#对应上一条设置, when the result of a query exceeds the size set below, it will not be interesting to the buffer set above, avoiding a large result occupying a large cache.

Query_cache_limit = 2M

#设置加全文检索中的最小单词长度.

#ft_min_word_len = 4

#CREATE The default table type for the table statement, and if you do not specify the type yourself, use the type of downlink

Default-storage-engine = InnoDB

#线程堆栈大小, MySQL says its own stack size does not exceed 64K. This value can be set to a higher point (in the RCA project are shared with the same database connection), the default 192K

Thread_stack = 800K

#设置事务处理的级别, the default Repeatable-read, the general use it can, the following two lines correspond in order,

#可读写未提交的数据, create uncommitted data copy read-write, read-not before commit, allow only serial sequence of merchants bank transactions.

# read-uncommitted, read-committed, Repeatable-read, SERIALIZABLE

Transaction_isolation = Repeatable-read

#单一内存临时表在内存中的大小, more than this value is automatically converted to disk operations

Tmp_table_size = 64M

#启动二进制日志功能, which enables point-in-time recovery of the most recent backup

#log-bin=mysql-bin

#二进制日志格式, right on the previous one,-suggested mixed format

#binlog_format =mixed

#转换查询为缓慢查询

Slow_query_log

#对应上一条, if a query exceeds the time set by the following article, execute the previous one.

Long_query_time = 2

#自定义主机ID识别符, for identification between the master or multiple servers, for an int type

Server-id = 1

#一般用来缓存MyISAM表的主键, also used for temporary disk table cache primary key, several times the temporary disk table, so even if not MyISAM also better set a value for it, the default 32M

Key_buffer_size = 64M

#全表扫描MyISAM表时的缓存, each thread has a downward size.

Read_buffer_size = 2M

#排序操作时与磁盘之间的缓存, divided into each thread, default 16M

Read_rnd_buffer_size = 24M

#MyISAM使用特殊树形进行批量插入时的缓存, such as insert ... values (..) (..) (..)

Bulk_insert_buffer_size = 64M

#MyISAM索引文件的最大限定,

Myisam_max_sort_file_size = 10G

#如果一个myisam表有一个以上的索引, MyISAM can use a thread to sort parallel them. More hardware resources, if your environment is good, you can increase this value.

Myisam_repair_threads = 2

#自动检查和修复无法正确关闭MyISAM表.

Myisam_recover

# * * * * INNODB Specific Options * * * *

#开启下条将会禁用 INNODB

#skip-innodb

#一般不用设置或者说设了也没多大用, InnoDB interacts with the operating system to manage the size of the INNODB storage data used by its additional memory pool

Innodb_additional_mem_pool_size = 16M

#innodb整体缓冲池大小, should not be too large, set as local memory 50%-75% more appropriate, in the process of the development of the machine can be set smaller as 64m,256m

Innodb_buffer_pool_size = 256M

#InnoDB的数据存储在一个或多个数据文件组成的表空间

Innodb_data_file_path = Ibdata1:10m:autoextend

#用于异步IO操作的线程数量, the default is 4, can be appropriately improved

Innodb_file_io_threads = 8

#线程数内允许的InnoDB内核, not too high

Innodb_thread_concurrency = 16

#InnoDB的事务日志快存行为, the default is 1, 0 to reduce disk i/0 operation, but also think 2

Innodb_flush_log_at_trx_commit = 1

#InnoDB的用于的缓冲日志数据的大小

Innodb_log_buffer_size = 8M

#日志文件, the total cache size can be set to 25%-90%, the default 256M. Modify this item to delete datadir\ib_logfilexxx first

Innodb_log_file_size = 256M

#日志组数量, defaults to 3

Innodb_log_files_in_group = 3

#InnoDB的日志文件位置. The default is MySQL DataDir

#innodb_log_group_home_dir

#InnoDB最大允许的脏页缓冲池的百分比, default 90

innodb_max_dirty_pages_pct = 80

#事务死锁超时设定

Innodb_lock_wait_timeout = 120

[Client]

Port = 3306

Socket =/tmp/mysql.sock

# set the MySQL client's character set

Default-character-set=utf8

[Mysqldump]

Quick

Max_allowed_packet = 16M

[MySQL]

No-auto-rehash

# only allow UPDATEs and deletes the use keys.

#safe-updates

[Winmysqladmin]

# Specify MySQL service startup startup files

Server=f:\\myweb\\mysql Server\\bin\\mysqld.exe

You can import the database in the form of. txt text, but the format matches the table structure built in the database!

But when I was in the import of a garbled???????? The problem.

Post your show variables like '%char% ';

Add in My.ini:

[MySQL]

default-character-set=gb2312

[Mysqld]

default-character-set=gb2312