PHP+MySQL求救! 我用PHP5+MySQL5写了一个网站,运行一年后,有个页面调的数据比较多,现在一打开这个页面,服务器就死掉了。不知是蓝屏,还是重启,我用的是远程看不到结果,只知道打开页面,远程中断,所有网站都打不开,要过10几分钟后才正常。找了一个来月,就是查不出原因, MySQL也重新装过一个新版本,My.ini也优化过,都不行,请各位兄弟帮忙,谢谢了。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 如果是IIS:控制面板->管理员工具->事件查看->应用程序如果是Apache:Apache安装目录\log\error.log data下面有个 svctag-675jc2x.err 文件,里面没有最近的错误信息,只有以前的。100707 0:46:57 [Note] Plugin 'FEDERATED' is disabled.InnoDB: The first specified data file .\ibdata1 did not exist:InnoDB: a new database to be created!100707 0:46:57 InnoDB: Setting file .\ibdata1 size to 10 MBInnoDB: Database physically writes the file full: wait...100707 0:46:57 InnoDB: Log file .\ib_logfile0 did not exist: new to be createdInnoDB: Setting log file .\ib_logfile0 size to 5 MBInnoDB: Database physically writes the file full: wait...100707 0:46:57 InnoDB: Log file .\ib_logfile1 did not exist: new to be createdInnoDB: Setting log file .\ib_logfile1 size to 5 MBInnoDB: Database physically writes the file full: wait...InnoDB: Doublewrite buffer not found: creating newInnoDB: Doublewrite buffer createdInnoDB: Creating foreign key constraint system tablesInnoDB: Foreign key constraint system tables created100707 0:46:57 InnoDB: Started; log sequence number 0 0100707 0:46:57 [ERROR] MySQL5: unknown variable 'default-storage-enqine=MyISAM'100707 0:46:57 [ERROR] Aborting100707 0:46:57 InnoDB: Starting shutdown...100707 0:47:02 InnoDB: Shutdown completed; log sequence number 0 44233100707 0:47:02 [Note] MySQL5: Shutdown complete100707 0:47:21 [Note] Plugin 'FEDERATED' is disabled.100707 0:47:21 InnoDB: Started; log sequence number 0 44233100707 0:47:21 [ERROR] MySQL5: unknown variable 'default-storage-enqine=MyISAM'100707 0:47:21 [ERROR] Aborting100707 0:47:21 InnoDB: Starting shutdown...100707 0:47:26 InnoDB: Shutdown completed; log sequence number 0 44233100707 0:47:26 [Note] MySQL5: Shutdown complete100707 0:49:00 [Note] Plugin 'FEDERATED' is disabled.100707 0:49:00 InnoDB: Started; log sequence number 0 44233100707 1:38:03 [Note] Plugin 'FEDERATED' is disabled.100707 1:38:05 InnoDB: Started; log sequence number 0 44233100707 1:38:05 [ERROR] Do you already have another mysqld server running on port: 3306 ?100707 1:38:05 [ERROR] Aborting100707 1:38:05 InnoDB: Starting shutdown...100707 1:38:11 InnoDB: Shutdown completed; log sequence number 0 44233100707 1:38:11 [Note] MySQL51: Shutdown complete100707 1:39:52 [Note] Plugin 'FEDERATED' is disabled.100707 1:39:53 InnoDB: Started; log sequence number 0 44233100707 1:39:53 [ERROR] Do you already have another mysqld server running on port: 3306 ?100707 1:39:53 [ERROR] Aborting100707 1:39:53 InnoDB: Starting shutdown...100707 1:39:58 InnoDB: Shutdown completed; log sequence number 0 44233100707 1:39:58 [Note] MySQL51: Shutdown complete100707 1:40:22 [Note] Plugin 'FEDERATED' is disabled.100707 1:40:22 InnoDB: Started; log sequence number 0 44233100707 1:40:23 [Note] Event Scheduler: Loaded 0 events100707 1:40:23 [Note] MySQL51: ready for connections.Version: '5.1.48-community' socket: '' port: 3308 MySQL Community Server (GPL)100707 2:06:24 [Note] MySQL51: Normal shutdown100707 2:06:24 [Note] Event Scheduler: Purging the queue. 0 events100707 2:06:24 InnoDB: Starting shutdown...100707 2:06:28 InnoDB: Shutdown completed; log sequence number 0 12797536100707 2:06:28 [Note] MySQL51: Shutdown complete100707 2:06:29 [Note] Plugin 'FEDERATED' is disabled.100707 2:06:29 InnoDB: Started; log sequence number 0 12797536100707 2:06:29 [Note] Event Scheduler: Loaded 0 events100707 2:06:29 [Note] MySQL51: ready for connections.Version: '5.1.48-community-log' socket: '' port: 3308 MySQL Community Server (GPL) 是 Windows2003,事件查看里面我看过,没有MySQL相关的错误信息。 那就查IIS错误和系统错误,这个错误不一定是在MySQL的错误里面 请问一下,目前流行的在线视频播放是那些?优酷网的视频播放是怎样做的!请指点下!!!! 问个apache的URL Rewrite问题 图片刷新问题 遇到一个比较棘手的正则表达式问题 求助,页面不显示问题 編程,就是用有限的積木堆積無限的可能 静态页面生成后,调用动态新闻显示列表,用js实现,是否可以说下原理,大家讨论下 怎样用php做URL转发? 如何用php实现简体to繁体的转换,急! 注册用户分行显示问题,急!! CI框架中libraries类库使用问题 smarty问题
控制面板->管理员工具->事件查看->应用程序如果是Apache:
Apache安装目录\log\error.log
100707 0:46:57 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
100707 0:46:57 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
100707 0:46:57 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...
100707 0:46:57 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
100707 0:46:57 InnoDB: Started; log sequence number 0 0
100707 0:46:57 [ERROR] MySQL5: unknown variable 'default-storage-enqine=MyISAM'
100707 0:46:57 [ERROR] Aborting100707 0:46:57 InnoDB: Starting shutdown...
100707 0:47:02 InnoDB: Shutdown completed; log sequence number 0 44233
100707 0:47:02 [Note] MySQL5: Shutdown complete100707 0:47:21 [Note] Plugin 'FEDERATED' is disabled.
100707 0:47:21 InnoDB: Started; log sequence number 0 44233
100707 0:47:21 [ERROR] MySQL5: unknown variable 'default-storage-enqine=MyISAM'
100707 0:47:21 [ERROR] Aborting100707 0:47:21 InnoDB: Starting shutdown...
100707 0:47:26 InnoDB: Shutdown completed; log sequence number 0 44233
100707 0:47:26 [Note] MySQL5: Shutdown complete100707 0:49:00 [Note] Plugin 'FEDERATED' is disabled.
100707 0:49:00 InnoDB: Started; log sequence number 0 44233
100707 1:38:03 [Note] Plugin 'FEDERATED' is disabled.
100707 1:38:05 InnoDB: Started; log sequence number 0 44233
100707 1:38:05 [ERROR] Do you already have another mysqld server running on port: 3306 ?
100707 1:38:05 [ERROR] Aborting100707 1:38:05 InnoDB: Starting shutdown...
100707 1:38:11 InnoDB: Shutdown completed; log sequence number 0 44233
100707 1:38:11 [Note] MySQL51: Shutdown complete100707 1:39:52 [Note] Plugin 'FEDERATED' is disabled.
100707 1:39:53 InnoDB: Started; log sequence number 0 44233
100707 1:39:53 [ERROR] Do you already have another mysqld server running on port: 3306 ?
100707 1:39:53 [ERROR] Aborting100707 1:39:53 InnoDB: Starting shutdown...
100707 1:39:58 InnoDB: Shutdown completed; log sequence number 0 44233
100707 1:39:58 [Note] MySQL51: Shutdown complete100707 1:40:22 [Note] Plugin 'FEDERATED' is disabled.
100707 1:40:22 InnoDB: Started; log sequence number 0 44233
100707 1:40:23 [Note] Event Scheduler: Loaded 0 events
100707 1:40:23 [Note] MySQL51: ready for connections.
Version: '5.1.48-community' socket: '' port: 3308 MySQL Community Server (GPL)
100707 2:06:24 [Note] MySQL51: Normal shutdown100707 2:06:24 [Note] Event Scheduler: Purging the queue. 0 events
100707 2:06:24 InnoDB: Starting shutdown...
100707 2:06:28 InnoDB: Shutdown completed; log sequence number 0 12797536
100707 2:06:28 [Note] MySQL51: Shutdown complete100707 2:06:29 [Note] Plugin 'FEDERATED' is disabled.
100707 2:06:29 InnoDB: Started; log sequence number 0 12797536
100707 2:06:29 [Note] Event Scheduler: Loaded 0 events
100707 2:06:29 [Note] MySQL51: ready for connections.
Version: '5.1.48-community-log' socket: '' port: 3308 MySQL Community Server (GPL)