mysql启动不了

asdf2015 2016-11-09 11:43:52
求大神指导,net start mysql 遇到下面的问题,应该怎么解决?


err文件内容:
2016-11-09T15:35:14.571879Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-11-09T15:35:14.571879Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2016-11-09T15:35:14.572408Z 0 [Note] MySQL (mysqld 5.7.16) starting as process 7852 ...
2016-11-09T15:35:15.163254Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-11-09T15:35:15.164760Z 0 [Note] InnoDB: Uses event mutexes
2016-11-09T15:35:15.165759Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2016-11-09T15:35:15.167276Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-11-09T15:35:15.168777Z 0 [Note] InnoDB: Number of pools: 1
2016-11-09T15:35:15.170278Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2016-11-09T15:35:15.179285Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-11-09T15:35:15.191843Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-11-09T15:35:15.207231Z 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
2016-11-09T15:35:15.209279Z 0 [Note] InnoDB: Setting file '.\ibdata1' size to 12 MB. Physically writing the file full; Please wait ...
2016-11-09T15:35:17.302176Z 0 [Note] InnoDB: File '.\ibdata1' size is now 12 MB.
2016-11-09T15:35:17.318707Z 0 [Note] InnoDB: Setting log file .\ib_logfile101 size to 48 MB
2016-11-09T15:35:24.421743Z 0 [ERROR] InnoDB: Operating system error number 1117 in a file operation.
2016-11-09T15:35:24.423246Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-11-09T15:35:24.425247Z 0 [ERROR] InnoDB: File (unknown): 'flush' returned OS error 1217. Cannot continue operation
2016-11-09T15:35:24.427249Z 0 [ERROR] InnoDB: Cannot continue operation.

...全文
401 2 打赏 收藏 转发到动态 举报
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
grf870618 2016-11-11
  • 打赏
  • 举报
回复
http://jingyan.baidu.com/article/597035521d5de28fc00740e6.html 里面有 我的博客地址是:http://blog.sina.com.cn/u/1336517871
rucypli 2016-11-10
  • 打赏
  • 举报
回复
换一个数据目录试试

57,062

社区成员

发帖
与我相关
我的任务
社区描述
MySQL相关内容讨论专区
社区管理员
  • MySQL
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧