mysql每天都要重启几次,但找不到是何缘故,我的系统是2003sever,以下是mysql的错误日志,求高手帮助分析:
100607 4:11:04 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.15-nt' socket: '' port: 3306 Official MySQL binary
100607 4:11:06 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...
100607 4:11:06 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 123203428.
InnoDB: Doing recovery: scanned up to log sequence number 0 123264385
100607 4:11:06 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 0, file name
100607 4:11:06 InnoDB: Started; log sequence number 0 123264385
100607 4:11:06 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.15-nt' socket: '' port: 3306 Official MySQL binary
100607 4:11:08 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...
100607 4:11:08 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 123264402.
InnoDB: Doing recovery: scanned up to log sequence number 0 123325359
100607 4:11:08 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 0, file name
100607 4:11:08 InnoDB: Started; log sequence number 0 123325359
100607 4:11:09 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.15-nt' socket: '' port: 3306 Official MySQL binary
100607 4:11:10 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...
100607 4:11:10 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 123325415.
InnoDB: Doing recovery: scanned up to log sequence number 0 123386388
100607 4:11:10 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 0, file name
100607 4:11:11 InnoDB: Started; log sequence number 0 123386388
100607 4:11:11 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.15-nt' socket: '' port: 3306 Official MySQL binary
100607 4:11:12 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...
100607 4:11:12 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 123386405.
InnoDB: Doing recovery: scanned up to log sequence number 0 123447362
100607 4:11:12 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 0, file name
100607 4:11:13 InnoDB: Started; log sequence number 0 123447362
100607 4:11:13 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.15-nt' socket: '' port: 3306 Official MySQL binary
100607 4:11: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...
100607 4:11:15 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 123447379.
InnoDB: Doing recovery: scanned up to log sequence number 0 123508336
100607 4:11:15 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 0, file name
100607 4:11:15 InnoDB: Started; log sequence number 0 123508336
100607 4:11:15 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.15-nt' socket: '' port: 3306 Official MySQL binary
100608 16:46: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...
100608 16:46:15 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 123909962.
InnoDB: Doing recovery: scanned up to log sequence number 0 123956524
100608 16:46:15 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 0, file name
100608 16:46:15 InnoDB: Started; log sequence number 0 123956524
100608 16:46:15 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.15-nt' socket: '' port: 3306 Official MySQL binary
100608 16:46:17 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...
100608 16:46:17 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 123909962.
InnoDB: Doing recovery: scanned up to log sequence number 0 123975009
100608 16:46:17 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 0, file name
100608 16:46:18 InnoDB: Started; log sequence number 0 123975009
100608 16:46:18 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.15-nt' socket: '' port: 3306 Official MySQL binary
100608 17:01:13 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown100608 17:01:15 [Warning] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 82 user: 'root'100608 17:01:15 [Warning] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 2 user: 'root'100608 17:01:15 InnoDB: Starting shutdown...
100608 17:01:18 InnoDB: Shutdown completed; log sequence number 0 123975053
100608 17:01:18 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete100608 17:01:24 InnoDB: Started; log sequence number 0 123975053
100608 17:01:24 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.15-nt' socket: '' port: 3306 Official MySQL binary
100608 17:05:08 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown100608 17:05:10 [Warning] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 25 user: 'root'100608 17:05:10 [Warning] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 24 user: 'root'100608 17:05:10 [Warning] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 6 user: 'root'
100607 4:11:04 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.15-nt' socket: '' port: 3306 Official MySQL binary
100607 4:11:06 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...
100607 4:11:06 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 123203428.
InnoDB: Doing recovery: scanned up to log sequence number 0 123264385
100607 4:11:06 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 0, file name
100607 4:11:06 InnoDB: Started; log sequence number 0 123264385
100607 4:11:06 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.15-nt' socket: '' port: 3306 Official MySQL binary
100607 4:11:08 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...
100607 4:11:08 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 123264402.
InnoDB: Doing recovery: scanned up to log sequence number 0 123325359
100607 4:11:08 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 0, file name
100607 4:11:08 InnoDB: Started; log sequence number 0 123325359
100607 4:11:09 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.15-nt' socket: '' port: 3306 Official MySQL binary
100607 4:11:10 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...
100607 4:11:10 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 123325415.
InnoDB: Doing recovery: scanned up to log sequence number 0 123386388
100607 4:11:10 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 0, file name
100607 4:11:11 InnoDB: Started; log sequence number 0 123386388
100607 4:11:11 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.15-nt' socket: '' port: 3306 Official MySQL binary
100607 4:11:12 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...
100607 4:11:12 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 123386405.
InnoDB: Doing recovery: scanned up to log sequence number 0 123447362
100607 4:11:12 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 0, file name
100607 4:11:13 InnoDB: Started; log sequence number 0 123447362
100607 4:11:13 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.15-nt' socket: '' port: 3306 Official MySQL binary
100607 4:11: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...
100607 4:11:15 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 123447379.
InnoDB: Doing recovery: scanned up to log sequence number 0 123508336
100607 4:11:15 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 0, file name
100607 4:11:15 InnoDB: Started; log sequence number 0 123508336
100607 4:11:15 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.15-nt' socket: '' port: 3306 Official MySQL binary
100608 16:46: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...
100608 16:46:15 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 123909962.
InnoDB: Doing recovery: scanned up to log sequence number 0 123956524
100608 16:46:15 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 0, file name
100608 16:46:15 InnoDB: Started; log sequence number 0 123956524
100608 16:46:15 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.15-nt' socket: '' port: 3306 Official MySQL binary
100608 16:46:17 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...
100608 16:46:17 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 123909962.
InnoDB: Doing recovery: scanned up to log sequence number 0 123975009
100608 16:46:17 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 0, file name
100608 16:46:18 InnoDB: Started; log sequence number 0 123975009
100608 16:46:18 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.15-nt' socket: '' port: 3306 Official MySQL binary
100608 17:01:13 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown100608 17:01:15 [Warning] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 82 user: 'root'100608 17:01:15 [Warning] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 2 user: 'root'100608 17:01:15 InnoDB: Starting shutdown...
100608 17:01:18 InnoDB: Shutdown completed; log sequence number 0 123975053
100608 17:01:18 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete100608 17:01:24 InnoDB: Started; log sequence number 0 123975053
100608 17:01:24 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.15-nt' socket: '' port: 3306 Official MySQL binary
100608 17:05:08 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown100608 17:05:10 [Warning] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 25 user: 'root'100608 17:05:10 [Warning] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 24 user: 'root'100608 17:05:10 [Warning] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 6 user: 'root'
100608 17:05:14 InnoDB: Shutdown completed; log sequence number 0 123975703
100608 17:05:14 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete100608 17:05:15 InnoDB: Started; log sequence number 0 123975703
100608 17:05:15 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.15-nt' socket: '' port: 3306 Official MySQL binary
100608 17:09:31 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown100608 17:09:33 [Warning] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 26 user: 'root'100608 17:09:33 [Warning] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 23 user: 'root'100608 17:09:33 [Warning] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 4 user: 'root'100608 17:09:33 InnoDB: Starting shutdown...
100608 17:09:35 InnoDB: Shutdown completed; log sequence number 0 123975713
100608 17:09:35 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete100608 17:09:36 InnoDB: Started; log sequence number 0 123975713
100608 17:09:36 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.15-nt-log' socket: '' port: 3306 Official MySQL binary
100608 17:10:26 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown100608 17:10:28 [Warning] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 6 user: 'root'100608 17:10:28 [Warning] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 4 user: 'root'100608 17:10:28 InnoDB: Starting shutdown...
100608 17:10:30 InnoDB: Shutdown completed; log sequence number 0 123975713
100608 17:10:30 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete100608 17:10:30 InnoDB: Started; log sequence number 0 123975713
100608 17:10:30 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.15-nt-log' socket: '' port: 3306 Official MySQL binary
另外看看这个文章
http://user.qzone.qq.com/792218?ptlang=2052
或许有帮助、
2. mysql某些配置参数不当
3. 程序问题
都有可能
谢谢各位~