终于找到2013的问题所在了,在启动系统后,启动mysql时可以从.err文件中看到以下内容:
Version: '4.0.26-nt' socket: '' port: 3306 Official MySQL binary
060412 16:00:56 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 11 1967579589
InnoDB: Doing recovery: scanned up to log sequence number 11 1967588054
InnoDB: 1 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 111644 row operations to undo
InnoDB: Trx id counter is 0 27898368
060412 16:00:56 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 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: Starting rollback of uncommitted transactions
InnoDB: Rolling back trx with id 0 27891722, 111644 rows to undo
InnoDB: Progress in percents: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 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 100
InnoDB: Rolling back of trx id 0 27891722 completed
InnoDB: Rollback of uncommitted transactions completed
060412 16:13:55 InnoDB: Flushing modified pages from the buffer pool...
060412 16:13:56 InnoDB: Started
MySQL: ready for connections.
Version: '4.0.26-nt' socket: '' port: 3306 Official MySQL binary
其中InnoDB: Progress in percents: 1 2 .......的速度特别慢。这个过程大约经过15分钟才结束,这个过程结束后系统就运行正常了。
在这15分钟内运启动任何使用mysql的系统,都会有2013 这个错误,也怪不得有时候在停止服务后反而可以了,可能是因为这个过程已经结束。
好了。现在系统正常了。以前的问题如果等15分钟可能就没问题了!!!