附送上本人健全的[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
