请教关于mysql5.0.27自动停止的问题（约10多个小时停止一次）
您好：
我的环境是
win2003/iis6/php5.2.0/mysql5.0.27
最近mysql5.0.27每运行10多个小时就自动停止
请教是什么原因造成，应该如何解决？谢谢
以下是所有的err日志：
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
061210 20:24:03 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
061210 20:24:03 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 50 MB
InnoDB: Database physically writes the file full: wait...
061210 20:24:04 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 50 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
061210 20:24:05 InnoDB: Started; log sequence number 0 0
061210 20:24:05 [Note] D:\adata\mysql5\bin\mysqld-nt: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
061210 20:48:09 [Note] D:\adata\mysql5\bin\mysqld-nt: Normal shutdown
061210 20:48:09 InnoDB: Starting shutdown...
061210 20:48:11 InnoDB: Shutdown completed; log sequence number 0 43655
061210 20:48:11 [Note] D:\adata\mysql5\bin\mysqld-nt: Shutdown complete
061210 20:49:10 InnoDB: Started; log sequence number 0 43655
061210 20:49:10 [Note] D:\adata\mysql5\bin\mysqld-nt: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
061210 21:24:49 [Note] D:\adata\mysql5\bin\mysqld-nt: Normal shutdown
061210 21:24:49 InnoDB: Starting shutdown...
061210 21:24:52 InnoDB: Shutdown completed; log sequence number 0 43655
061210 21:24:52 [Note] D:\adata\mysql5\bin\mysqld-nt: Shutdown complete
061210 21:25:49 InnoDB: Started; log sequence number 0 43655
061210 21:25:50 [Note] D:\adata\mysql5\bin\mysqld-nt: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
061210 21:46:23 [Note] D:\adata\mysql5\bin\mysqld-nt: Normal shutdown
061210 21:46:23 InnoDB: Starting shutdown...
061210 21:46:25 InnoDB: Shutdown completed; log sequence number 0 43655
061210 21:46:25 [Note] D:\adata\mysql5\bin\mysqld-nt: Shutdown complete
061210 21:47:22 InnoDB: Started; log sequence number 0 43655
061210 21:47:23 [Note] D:\adata\mysql5\bin\mysqld-nt: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
061210 22:18:57 [Note] D:\adata\mysql5\bin\mysqld-nt: Normal shutdown
061210 22:18:57 InnoDB: Starting shutdown...
061210 22:18:58 InnoDB: Shutdown completed; log sequence number 0 43655
061210 22:18:58 [Note] D:\adata\mysql5\bin\mysqld-nt: Shutdown complete
061210 22:19:56 InnoDB: Started; log sequence number 0 43655
061210 22:19:56 [Note] D:\adata\mysql5\bin\mysqld-nt: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
061211 4:03:24 [Note] D:\adata\mysql5\bin\mysqld-nt: Normal shutdown
061211 4:03:25 InnoDB: Starting shutdown...
061211 4:03:26 InnoDB: Shutdown completed; log sequence number 0 43655
061211 4:03:26 [Note] D:\adata\mysql5\bin\mysqld-nt: Shutdown complete
061211 4:04:24 InnoDB: Started; log sequence number 0 43655
061211 4:04:24 [Note] D:\adata\mysql5\bin\mysqld-nt: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
061211 17:40:56 [Note] D:\adata\mysql5\bin\mysqld-nt: Normal shutdown
061211 17:40:56 InnoDB: Starting shutdown...
061211 17:40:58 InnoDB: Shutdown completed; log sequence number 0 43655
061211 17:40:58 [Note] D:\adata\mysql5\bin\mysqld-nt: Shutdown complete
061211 17:41:57 InnoDB: Started; log sequence number 0 43655
061211 17:41:57 [Note] D:\adata\mysql5\bin\mysqld-nt: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
061212 23:21:05 [Note] D:\adata\mysql5\bin\mysqld-nt: Normal shutdown
061212 23:21:05 InnoDB: Starting shutdown...
061212 23:21:07 InnoDB: Shutdown completed; log sequence number 0 43655
061212 23:21:07 [Note] D:\adata\mysql5\bin\mysqld-nt: Shutdown complete
061212 23:22:07 InnoDB: Started; log sequence number 0 43655
061212 23:22:08 [Note] D:\adata\mysql5\bin\mysqld-nt: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
061213 0:35:15 [Note] D:\adata\mysql5\bin\mysqld-nt: Normal shutdown
061213 0:35:15 InnoDB: Starting shutdown...
061213 0:35:17 InnoDB: Shutdown completed; log sequence number 0 43655
061213 0:35:17 [Note] D:\adata\mysql5\bin\mysqld-nt: Shutdown complete
061213 0:36:14 InnoDB: Started; log sequence number 0 43655
061213 0:36:14 [Note] D:\adata\mysql5\bin\mysqld-nt: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
061213 3:33:16 [Note] D:\adata\mysql5\bin\mysqld-nt: Normal shutdown
061213 3:33:16 InnoDB: Starting shutdown...
061213 3:33:18 InnoDB: Shutdown completed; log sequence number 0 43665
061213 3:33:18 [Note] D:\adata\mysql5\bin\mysqld-nt: Shutdown complete
061213 3:34:27 InnoDB: Started; log sequence number 0 43665
061213 3:34:27 [Note] D:\adata\mysql5\bin\mysqld-nt: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
061213 20:13:06 [Note] D:\adata\mysql5\bin\mysqld-nt: Normal shutdown
061213 20:13:06 InnoDB: Starting shutdown...
061213 20:13:08 InnoDB: Shutdown completed; log sequence number 0 43675
061213 20:13:08 [Note] D:\adata\mysql5\bin\mysqld-nt: Shutdown complete
061213 20:14:04 InnoDB: Started; log sequence number 0 43675
061213 20:14:04 [Note] D:\adata\mysql5\bin\mysqld-nt: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
061213 20:37:27 [Note] D:\adata\mysql5\bin\mysqld-nt: Normal shutdown
061213 20:37:27 InnoDB: Starting shutdown...
061213 20:37:29 InnoDB: Shutdown completed; log sequence number 0 43675
061213 20:37:29 [Note] D:\adata\mysql5\bin\mysqld-nt: Shutdown complete
061213 20:38:25 InnoDB: Started; log sequence number 0 43675
061213 20:38:25 [Note] D:\adata\mysql5\bin\mysqld-nt: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
061214 0:40:10 [Note] D:\adata\mysql5\bin\mysqld-nt: Normal shutdown
061214 0:40:10 InnoDB: Starting shutdown...
061214 0:40:13 InnoDB: Shutdown completed; log sequence number 0 43675
061214 0:40:13 [Note] D:\adata\mysql5\bin\mysqld-nt: Shutdown complete
061214 0:41:09 InnoDB: Started; log sequence number 0 43675
061214 0:41:09 [Note] D:\adata\mysql5\bin\mysqld-nt: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
061214 3:05:58 [Note] D:\adata\mysql5\bin\mysqld-nt: Normal shutdown
061214 3:05:58 InnoDB: Starting shutdown...
061214 3:06:01 InnoDB: Shutdown completed; log sequence number 0 43675
061214 3:06:01 [Note] D:\adata\mysql5\bin\mysqld-nt: Shutdown complete
061214 3:06:04 InnoDB: Started; log sequence number 0 43675
061214 3:06:04 [Note] D:\adata\mysql5\bin\mysqld-nt: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
061214 3:55:08 [Note] D:\adata\mysql5\bin\mysqld-nt: Normal shutdown
061214 3:55:08 InnoDB: Starting shutdown...
061214 3:55:10 InnoDB: Shutdown completed; log sequence number 0 43675
061214 3:55:10 [Note] D:\adata\mysql5\bin\mysqld-nt: Shutdown complete
061214 3:56:06 InnoDB: Started; log sequence number 0 43675
061214 3:56:06 [Note] D:\adata\mysql5\bin\mysqld-nt: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
061214 12:22:15 [Note] D:\adata\mysql5\bin\mysqld-nt: Normal shutdown
061214 12:22:15 InnoDB: Starting shutdown...
061214 12:22:18 InnoDB: Shutdown completed; log sequence number 0 43685
061214 12:22:18 [Note] D:\adata\mysql5\bin\mysqld-nt: Shutdown complete
061214 12:23:21 InnoDB: Started; log sequence number 0 43685
061214 12:23:22 [Note] D:\adata\mysql5\bin\mysqld-nt: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
061214 14:47:20 [Note] D:\adata\mysql5\bin\mysqld-nt: Normal shutdown
061214 14:47:20 InnoDB: Starting shutdown...
061214 14:47:21 InnoDB: Shutdown completed; log sequence number 0 43685
061214 14:47:21 [Note] D:\adata\mysql5\bin\mysqld-nt: Shutdown complete
061214 14:48:27 InnoDB: Started; log sequence number 0 43685
061214 14:48:27 [Note] D:\adata\mysql5\bin\mysqld-nt: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
061220 15:40:43 InnoDB: Started; log sequence number 0 43685
061220 15:40:44 [Note] D:\adata\mysql5\bin\mysqld-nt: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
061221 7:47:13 [Note] D:\adata\mysql5\bin\mysqld-nt: Normal shutdown
061221 7:47:13 InnoDB: Starting shutdown...
061221 7:47:15 InnoDB: Shutdown completed; log sequence number 0 43685
061221 7:47:15 [Note] D:\adata\mysql5\bin\mysqld-nt: Shutdown complete
061221 7:48:41 InnoDB: Started; log sequence number 0 43685
061221 7:48:42 [Note] D:\adata\mysql5\bin\mysqld-nt: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
061221 14:13:25 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
061221 14:13:26 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43695.
InnoDB: Doing recovery: scanned up to log sequence number 0 43695
061221 14:13:26 InnoDB: Started; log sequence number 0 43695
061221 14:13:26 [Note] D:\adata\mysql5\bin\mysqld-nt: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
061222 1:14:14 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
061222 1:14:14 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43695.
InnoDB: Doing recovery: scanned up to log sequence number 0 43695
061222 1:14:14 InnoDB: Started; log sequence number 0 43695
061222 1:14:15 [Note] D:\adata\mysql5\bin\mysqld-nt: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
061222 7:57:03 [Note] D:\adata\mysql5\bin\mysqld-nt: Normal shutdown
061222 7:57:06 InnoDB: Starting shutdown...
061222 7:57:09 InnoDB: Shutdown completed; log sequence number 0 43695
061222 7:57:09 [Note] D:\adata\mysql5\bin\mysqld-nt: Shutdown complete
061222 7:57:10 InnoDB: Started; log sequence number 0 43695
061222 7:57:10 [Note] D:\adata\mysql5\bin\mysqld-nt: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
061222 12:50:12 InnoDB: Started; log sequence number 0 43695
061222 12:50:12 [Note] D:\adata\mysql5\bin\mysqld-nt: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
061223 5:51:45 [Note] D:\adata\mysql5\bin\mysqld-nt: Normal shutdown
061223 5:51:47 InnoDB: Starting shutdown...
061223 5:51:49 InnoDB: Shutdown completed; log sequence number 0 43695
061223 5:51:49 [Note] D:\adata\mysql5\bin\mysqld-nt: Shutdown complete
061223 5:51:51 InnoDB: Started; log sequence number 0 43695
061223 5:51:51 [Note] D:\adata\mysql5\bin\mysqld-nt: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
061223 10:26:04 InnoDB: Started; log sequence number 0 43695
061223 10:26:04 [Note] D:\adata\mysql5\bin\mysqld-nt: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
061224 7:48:56 InnoDB: Started; log sequence number 0 43695
061224 7:48:56 [Note] D:\adata\mysql5\bin\mysqld-nt: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
061224 22:03:28 InnoDB: Started; log sequence number 0 43695
061224 22:03:30 [Note] D:\adata\mysql5\bin\mysqld-nt: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL) |
发表于 2006-12-25 03:42 AM
| 
