看这里(大概5.6.6版本后的变化):
2016-08-21T09:40:50.857477Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-08-21T09:40:50.857477Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2016-08-21T09:40:50.857477Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
解决办法:在my.cnf 中设置
disable-partition-engine-check=1
sql_mode=STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
不清楚啊,是不是我的服务注册有问题?我现在已经把它删除了,准备重新解压配置,心疼,能教我配置吗,或者给个你认为不错的配置链接?[/quote]
参考这个:
MySQL 5.6 for Windows 解压缩版配置安装
http://jingyan.baidu.com/article/f3ad7d0ffc061a09c3345bf0.html[/quote]
谢啦,虽然我已经装好了,只是我重启试试会不会有问题的时候出现了蓝屏,自动重启没啥问题,mysql服务开机启动成功,就不知道有没有后遗症,查看dump文件竟然没有。心里还是有点方。[/quote]
我之前都是用安装版,没有出现过什么问题,另外,用linux版,也没什么问题。[/quote]
额 我看大家大部分都是推荐使用免安装版的,所以我也就用了,只是对于这个的一些配置真心不太了解。[/quote]
再多试几次,正常情况下是不会有问题的,还有上面也提到了,如果是蓝屏,一般都是系统问题,换个电脑试试[/quote]
谢啦,也就是第一次重启蓝了一次屏幕,现在顺滑湿润,爽到爆!!!
不清楚啊,是不是我的服务注册有问题?我现在已经把它删除了,准备重新解压配置,心疼,能教我配置吗,或者给个你认为不错的配置链接?[/quote]
参考这个:
MySQL 5.6 for Windows 解压缩版配置安装
http://jingyan.baidu.com/article/f3ad7d0ffc061a09c3345bf0.html[/quote]
谢啦,虽然我已经装好了,只是我重启试试会不会有问题的时候出现了蓝屏,自动重启没啥问题,mysql服务开机启动成功,就不知道有没有后遗症,查看dump文件竟然没有。心里还是有点方。[/quote]
我之前都是用安装版,没有出现过什么问题,另外,用linux版,也没什么问题。
不清楚啊,是不是我的服务注册有问题?我现在已经把它删除了,准备重新解压配置,心疼,能教我配置吗,或者给个你认为不错的配置链接?[/quote]
参考这个:
MySQL 5.6 for Windows 解压缩版配置安装
http://jingyan.baidu.com/article/f3ad7d0ffc061a09c3345bf0.html[/quote]
谢啦,虽然我已经装好了,只是我重启试试会不会有问题的时候出现了蓝屏,自动重启没啥问题,mysql服务开机启动成功,就不知道有没有后遗症,查看dump文件竟然没有。心里还是有点方。[/quote]
我之前都是用安装版,没有出现过什么问题,另外,用linux版,也没什么问题。[/quote]
额 我看大家大部分都是推荐使用免安装版的,所以我也就用了,只是对于这个的一些配置真心不太了解。[/quote]
再多试几次,正常情况下是不会有问题的,还有上面也提到了,如果是蓝屏,一般都是系统问题,换个电脑试试
不清楚啊,是不是我的服务注册有问题?我现在已经把它删除了,准备重新解压配置,心疼,能教我配置吗,或者给个你认为不错的配置链接?[/quote]
参考这个:
MySQL 5.6 for Windows 解压缩版配置安装
http://jingyan.baidu.com/article/f3ad7d0ffc061a09c3345bf0.html[/quote]
谢啦,虽然我已经装好了,只是我重启试试会不会有问题的时候出现了蓝屏,自动重启没啥问题,mysql服务开机启动成功,就不知道有没有后遗症,查看dump文件竟然没有。心里还是有点方。[/quote]
我之前都是用安装版,没有出现过什么问题,另外,用linux版,也没什么问题。[/quote]
额 我看大家大部分都是推荐使用免安装版的,所以我也就用了,只是对于这个的一些配置真心不太了解。
我今天的错误日志:上半部分
2016-08-21T09:37:20.097891Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-08-21T09:37:20.098891Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2016-08-21T09:37:20.098891Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2016-08-21T09:37:20.098891Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2016-08-21T09:37:20.099901Z 0 [Note] MySQL (mysqld 5.7.14) starting as process 187856 ...
2016-08-21T09:37:20.156932Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-08-21T09:37:20.156932Z 0 [Note] InnoDB: Uses event mutexes
2016-08-21T09:37:20.157933Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2016-08-21T09:37:20.157933Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-08-21T09:37:20.163937Z 0 [Note] InnoDB: Number of pools: 1
2016-08-21T09:37:20.168959Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2016-08-21T09:37:20.172945Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-08-21T09:37:20.179949Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-08-21T09:37:20.232986Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2016-08-21T09:37:20.414114Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-08-21T09:37:20.414114Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2016-08-21T09:37:20.443135Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2016-08-21T09:37:20.450140Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2016-08-21T09:37:20.451140Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2016-08-21T09:37:20.452141Z 0 [Note] InnoDB: Waiting for purge to start
2016-08-21T09:37:20.503183Z 0 [Note] InnoDB: 5.7.14 started; log sequence number 2533750
2016-08-21T09:37:20.504178Z 0 [Note] InnoDB: Loading buffer pool(s) from E:\mysql-5.7.14-winx64\data\ib_buffer_pool
2016-08-21T09:37:20.506181Z 0 [Note] Plugin 'FEDERATED' is disabled.
2016-08-21T09:37:20.532215Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160821 17:37:20
2016-08-21T09:37:20.542254Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2016-08-21T09:37:20.548208Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2016-08-21T09:37:20.549209Z 0 [Note] IPv6 is available.
2016-08-21T09:37:20.549209Z 0 [Note] - '::' resolves to '::';
2016-08-21T09:37:20.550210Z 0 [Note] Server socket created on IP: '::'.
2016-08-21T09:37:21.326775Z 0 [Note] Event Scheduler: Loaded 0 events
2016-08-21T09:37:21.326775Z 0 [Note] MySQL: ready for connections.
Version: '5.7.14' socket: '' port: 3306 MySQL Community Server (GPL)
2016-08-21T09:38:02.065247Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-08-21T09:38:02.065247Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2016-08-21T09:38:02.065247Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2016-08-21T09:38:02.065247Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2016-08-21T09:38:02.065247Z 0 [Note] MySQL (mysqld 5.7.14) starting as process 185384 ...
2016-08-21T09:38:02.079257Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-08-21T09:38:02.079257Z 0 [Note] InnoDB: Uses event mutexes
2016-08-21T09:38:02.080258Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2016-08-21T09:38:02.080258Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-08-21T09:38:02.080258Z 0 [Note] InnoDB: Number of pools: 1
2016-08-21T09:38:02.081258Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2016-08-21T09:38:02.083260Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-08-21T09:38:02.089264Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-08-21T09:38:02.116284Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2016-08-21T09:38:02.119299Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2533769
2016-08-21T09:38:02.119299Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 2533778
2016-08-21T09:38:02.122289Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 2533778
2016-08-21T09:38:02.122289Z 0 [Note] InnoDB: Database was not shutdown normally!
2016-08-21T09:38:02.122289Z 0 [Note] InnoDB: Starting crash recovery.
2016-08-21T09:38:02.298544Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2016-08-21T09:38:02.298544Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-08-21T09:38:02.299545Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2016-08-21T09:38:02.363591Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2016-08-21T09:38:02.373599Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2016-08-21T09:38:02.374599Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2016-08-21T09:38:02.374599Z 0 [Note] InnoDB: Waiting for purge to start
2016-08-21T09:38:02.426635Z 0 [Note] InnoDB: 5.7.14 started; log sequence number 2533778
2016-08-21T09:38:02.427636Z 0 [Note] InnoDB: Loading buffer pool(s) from E:\mysql-5.7.14-winx64\data\ib_buffer_pool
2016-08-21T09:38:02.427636Z 0 [Note] Plugin 'FEDERATED' is disabled.
2016-08-21T09:38:02.438643Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2016-08-21T09:38:02.440645Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2016-08-21T09:38:02.442648Z 0 [Note] IPv6 is available.
2016-08-21T09:38:02.442648Z 0 [Note] - '::' resolves to '::';
2016-08-21T09:38:02.443649Z 0 [Note] Server socket created on IP: '::'.
2016-08-21T09:38:02.449651Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160821 17:38:02
2016-08-21T09:38:02.481674Z 0 [Note] Event Scheduler: Loaded 0 events
2016-08-21T09:38:02.481674Z 0 [Note] MySQL: ready for connections.
Version: '5.7.14' socket: '' port: 3306 MySQL Community Server (GPL)
2016-08-21T09:38:15.668164Z 0 [Note] MySQL: Normal shutdown
2016-08-21T09:38:15.669165Z 0 [Note] Giving 0 client threads a chance to die gracefully
2016-08-21T09:38:15.669165Z 0 [Note] Shutting down slave threads
2016-08-21T09:38:15.670166Z 0 [Note] Forcefully disconnecting 0 remaining clients
2016-08-21T09:38:15.670166Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2016-08-21T09:38:15.671166Z 0 [Note] Binlog end
2016-08-21T09:38:15.672175Z 0 [Note] Shutting down plugin 'ngram'
2016-08-21T09:38:15.673169Z 0 [Note] Shutting down plugin 'partition'
2016-08-21T09:38:15.673169Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2016-08-21T09:38:15.673169Z 0 [Note] Shutting down plugin 'ARCHIVE'
2016-08-21T09:38:15.673169Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-08-21T09:38:15.673169Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2016-08-21T09:38:15.674171Z 0 [Note] Shutting down plugin 'MyISAM'
2016-08-21T09:38:15.674171Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2016-08-21T09:38:15.674171Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-08-21T09:38:15.674171Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-08-21T09:38:15.674171Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-08-21T09:38:15.675171Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-08-21T09:38:15.675171Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-08-21T09:38:15.675171Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-08-21T09:38:15.675171Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-08-21T09:38:15.676171Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-08-21T09:38:15.676171Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-08-21T09:38:15.676171Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-08-21T09:38:15.676171Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-08-21T09:38:15.676171Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-08-21T09:38:15.677172Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-08-21T09:38:15.677172Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-08-21T09:38:15.677172Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-08-21T09:38:15.677172Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2016-08-21T09:38:15.677172Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2016-08-21T09:38:15.678173Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-08-21T09:38:15.678173Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-08-21T09:38:15.678173Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'