登陆论坛 找回密码 立刻获得20pp! 地图 帮助
宽带山生活
版主:

  • 主题内容
<< [1] >>  [只看楼主]  [加入关注] 点击:284 回复:7 已被0人关注

主题:为什么在win2003服务器上用mysql服务器有问题

土豆
158 0

来自:上海
注册:2003-12-17
发帖:72+242 
平台win2003+php4.36+mysql3.25
开始点击PHP页面的时候正常,速度也很快,但是点了两下页面MYSQL就shutdown了,产生了一个.err错误日志文件
是不是my.ini的配置或者php.ini的配置不对啊?
寻求各位大侠帮助!downloading



-------------------------------------------------------------------------------------------
Athlon XP 2500+ OC 3200+
Albatron KS600 PRO
KINGSTON DDR 400 512M
Gainward FX5700

发表于:2005-02-23 22:55:12
推荐:牙齿有问题,您找我! ...楼主...

挖挖菠萝
606 0

来自:海外
注册:2001-12-15
发帖:128+2972 
err里面写什么?



-------------------------------------------------------------------------------------------
上海创业、开公司、开店办厂、投资... http://ubsh.yeah.net

发表于:2005-02-24 23:36:51

土豆
158 0

来自:上海
注册:2003-12-17
发帖:72+242 
MySql: ready for connections
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init parameters in your my.cnf
or my.ini. If you want to use InnoDB tables, add to the [mysqld]
section, for example,
innodb_data_file_path = ibdata1:10M:autoextend
But to get good performance you should adjust for your hardware
the InnoDB startup options listed in section 2 at
http://www.innodb.com/ibman.html
050222 16:19:28 MySql: Normal shutdown

050222 16:19:28 MySql: Shutdown Complete

MySql: ready for connections
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init parameters in your my.cnf
or my.ini. If you want to use InnoDB tables, add to the [mysqld]
section, for example,
innodb_data_file_path = ibdata1:10M:autoextend
But to get good performance you should adjust for your hardware
the InnoDB startup options listed in section 2 at
http://www.innodb.com/ibman.html
050223 1:26:37 MySql: Normal shutdown

050223 1:26:38 MySql: Shutdown Complete

MySql: ready for connections
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init parameters in your my.cnf
or my.ini. If you want to use InnoDB tables, add to the [mysqld]
section, for example,
innodb_data_file_path = ibdata1:10M:autoextend
But to get good performance you should adjust for your hardware
the InnoDB startup options listed in section 2 at
http://www.innodb.com/ibman.html
050223 14:53:09 MySql: Normal shutdown

050223 14:53:09 MySql: Shutdown Complete

MySql: ready for connections
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init parameters in your my.cnf
or my.ini. If you want to use InnoDB tables, add to the [mysqld]
section, for example,
innodb_data_file_path = ibdata1:10M:autoextend
But to get good performance you should adjust for your hardware
the InnoDB startup options listed in section 2 at
http://www.innodb.com/ibman.html
050223 16:57:29 MySql: Normal shutdown

050223 16:57:29 MySql: Shutdown Complete

MySql: ready for connections
InnoDB: The first specified data file .ibdata1 did not exist:
InnoDB: a new database to be created!
050223 16:57:34 InnoDB: Setting file .ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
050223 16:57:35 InnoDB: Log file .ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
050223 16:57:35 InnoDB: Log file .ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .ib_logfile1 size to 5 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
050223 16:57:38 InnoDB: Started



-------------------------------------------------------------------------------------------
Athlon XP 2500+ OC 3200+
Albatron KS600 PRO
KINGSTON DDR 400 512M
Gainward FX5700

发表于:2005-02-25 17:12:15
推荐:迎新年牙齿美容大行动 ...第2楼...

土豆
158 0

来自:上海
注册:2003-12-17
发帖:72+242 
这个有人知道吗。。。downloading



-------------------------------------------------------------------------------------------
Athlon XP 2500+ OC 3200+
Albatron KS600 PRO
KINGSTON DDR 400 512M
Gainward FX5700

发表于:2005-02-28 17:18:49
推荐:kds红日官网启动啦!!! ...第3楼...

番薯
539 0

来自:保密
注册:2004-01-29
发帖:52+559 
呵呵,我在用很好,没问题



-------------------------------------------------------------------------------------------
http://iicl.vicp.net
SONY DSC-F717
QQ:8100342
Email:dyw@email.com.cn

发表于:2005-02-28 21:19:13

240 0

来自:上海
注册:2001-05-29
发帖:1+11 
不是写得很明白吗?叫你disable innodb

Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init parameters in your my.cnf
or my.ini. If you want to use InnoDB tables, add to the [mysqld]
section, for example,
innodb_data_file_path = ibdata1:10M:autoextend
But to get good performance you should adjust for your hardware
the InnoDB startup options listed in section 2 at
http://www.innodb.com/ibman.html



-------------------------------------------------------------------------------------------
问世间情是何物,直教人生死相许

发表于:2005-03-03 18:50:37
推荐:KDS红日球迷会2010招募公告 ...第5楼...

358 0

来自:上海
注册:2000-10-01
发帖:2+61 
把InnoDB关掉应该就没问题了!很明显是InnoDB造成的问题!
But to get good performance you should adjust for your hardware
the InnoDB startup options listed in section 2 at



-------------------------------------------------------------------------------------------
我在海上漂泊……我需要帮助……

发表于:2005-03-04 02:53:26
推荐:S*H*E你是卖艺还是卖色! ...第6楼...

回复主题 [ 返回 ]
主题: 为什么在win2003服务器上用mysql服务器有问题
手机看宽带山

关于我们 - 联系我们 - 加入我们 - 营销服务 - 友情链接 - 频道合作- PChome Widget
Copyright © 1996-2009 PChome.net All rights reserved. 电脑之家 版权所有