[原创] 开启MYSQL INNODB数据支持 - konakona
konakona
Dream Afar.
konakona

[原创] 开启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

赞赏

团哥

文章作者

继续玩我的CODE,让别人说去。 低调,就是这么自信。

发表回复

textsms
account_circle
email

konakona

[原创] 开启MYSQL INNODB数据支持
附送上本人健全的[mysqld]进程配置,放在my.ini里的。 [mysqld] port = 3306 socket = /tmp/mysql.sock skip-locking key_buffer = 16M max_allowed_packet = 1M table_…
扫描二维码继续阅读
2010-10-08