在服务管理器里启动mysql服务报错为 1607:进程意外终止。
mysql的端口为9902,防火墙已经允许了9901到9905端口的通信。
mysql的配置文件my.ini 如下:
[client]
port=9902
[mysql]
default-character-set=utf8
[mysqld]
# The TCP/IP Port the MySQL Server will listen on
port=9902
basedir="C:/Program Files/MySQL/mysql5.1/9002/"
datadir="D:/Data/9902/"
#tmpdir="D:/Data/9902/"
character-set-server=utf8
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=10000
query_cache_size=18M
table_cache=1400
tmp_table_size=16M
thread_cache_size=38
#*** MyISAM Specific options
myisam_max_sort_file_size=8M
myisam_sort_buffer_size=25M
key_buffer_size=256K
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K
#*** INNODB Specific options ***
innodb_data_home_dir="D:/Data/9902/"
innodb_additional_mem_pool_size=12M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=6M
innodb_buffer_pool_size=2048M
innodb_log_file_size=10M
innodb_thread_concurrency=18
group_concat_max_len = 200000
log_bin="d:/mysql_log/mysql9902_bin"
binlog_ignore-db=mysql,test
max_binlog_size=300M
binlog_format=mixed
innodb_flush_log_at_trx_commit=2
thread_stack=10M
join_buffer_size=1M
read_rnd_buffer_size=1M
mysql的错误日志信息如下:
121120 17:14:21 [Note] Plugin 'FEDERATED' is disabled.
121120 17:14:21 InnoDB: Initializing buffer pool, size = 2.0G
121120 17:14:22 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file D:\Data\9902\ibdata1 did not exist:
InnoDB: a new database to be created!
121120 17:14:22 InnoDB: Setting file D:\Data\9902\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
121120 17:14:22 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 10 MB
InnoDB: Database physically writes the file full: wait...
121120 17:14:22 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
121120 17:14:23 InnoDB: Started; log sequence number 0 0
121120 17:14:23 [ERROR] Aborting
121120 17:14:23 InnoDB: Starting shutdown...
121120 17:14:29 InnoDB: Shutdown completed; log sequence number 0 44233
121120 17:14:29 [Note]
121120 17:53:04 [Note] Plugin 'FEDERATED' is disabled.
121120 17:53:05 InnoDB: Initializing buffer pool, size = 2.0G
121120 17:53:05 InnoDB: Completed initialization of buffer pool
121120 17:53:06 InnoDB: Started; log sequence number 0 44233
121120 17:53:06 [ERROR] Aborting
121120 17:53:06 InnoDB: Starting shutdown...
121120 17:53:12 InnoDB: Shutdown completed; log sequence number 0 44233
121120 17:53:12 [Note]
121120 17:56:06 [Note] Plugin 'FEDERATED' is disabled.
121120 17:56:06 InnoDB: Initializing buffer pool, size = 2.0G
121120 17:56:06 InnoDB: Completed initialization of buffer pool
121120 17:56:07 InnoDB: Started; log sequence number 0 44233
121120 17:56:07 [ERROR] Aborting
121120 17:56:07 InnoDB: Starting shutdown...
121120 17:56:13 InnoDB: Shutdown completed; log sequence number 0 44233
121120 17:56:13 [Note]
在网上找了N多办法都没有解决,可以正常创建日志和innodb数据文件,但是服务就是启动不了,求哪位大侠帮看看这是怎么回事