[原创] 开启MYSQL INNODB数据支持

附送上本人健全的[mysqld]进程配置，放在my.ini里的。

[mysqld]
port		= 3306
socket		= /tmp/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 32M

max_connections = 1000
default-storage-engine = MYISAM

#--------opetion innodb--------#
#skip-innodb
innodb_additional_mem_pool_size=2M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=15M
innodb_log_file_size=10M
innodb_thread_concurrency=8

log-bin = D:/www/log/mysql.log
port=3306
long_query_time = 1
#记录慢查询
log-slow-queries = D:/www/log/slowQuery.txt
#log=G:/bakcup/sqlLog/allQuery.txt
#记录所有未使用索引的语句
log-queries-not-using-indexes = off

最重要的是

#——–opetion innodb——–#
#skip-innodb
innodb_additional_mem_pool_size=2M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=15M
innodb_log_file_size=10M
innodb_thread_concurrency=8

这一段，是配置innodb的，同时开启innodb的，开启的方法就是注释掉skip-innodb