mysql无辜崩溃。新手求解

qq_33437240 2016-12-09 03:57:26
我是windows10操作系统
刚在官网下的一套安装包。 但是mysql打开没多久就自动关闭。
由于是菜逼,也看不懂什么意思。 请大神说下。
mysql的报错

2016-12-09T07:24:50.063558Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-12-09T07:24:50.084573Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 5.7.16-log) starting as process 10144 ...
2016-12-09T07:24:50.504370Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-12-09T07:24:50.505371Z 0 [Note] InnoDB: Uses event mutexes
2016-12-09T07:24:50.505371Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2016-12-09T07:24:50.505871Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-12-09T07:24:50.506872Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
2016-12-09T07:24:50.507372Z 0 [Note] InnoDB: Number of pools: 1
2016-12-09T07:24:50.507872Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2016-12-09T07:24:51.052758Z 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
2016-12-09T07:24:51.054264Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-12-09T07:24:51.548109Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2016-12-09T07:24:51.594641Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 15053205
2016-12-09T07:24:51.595142Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 15053214
2016-12-09T07:24:51.625164Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 15053214
2016-12-09T07:24:51.626164Z 0 [Note] InnoDB: Database was not shutdown normally!
2016-12-09T07:24:51.626664Z 0 [Note] InnoDB: Starting crash recovery.
2016-12-09T07:24:57.299540Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2016-12-09T07:24:57.300541Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-12-09T07:24:57.312049Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2016-12-09T07:24:57.862606Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2016-12-09T07:24:57.869599Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2016-12-09T07:24:57.870099Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2016-12-09T07:24:57.870612Z 0 [Note] InnoDB: Waiting for purge to start
2016-12-09T07:24:57.928774Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6551ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2016-12-09T07:24:57.961295Z 0 [Note] InnoDB: 5.7.16 started; log sequence number 15053214
2016-12-09T07:24:57.961797Z 0 [Note] Plugin 'FEDERATED' is disabled.
2016-12-09T07:24:57.971803Z 0 [Note] InnoDB: Loading buffer pool(s) from C:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
2016-12-09T07:24:58.280240Z 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-12-09T07:24:58.281741Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2016-12-09T07:24:58.282755Z 0 [Note] IPv6 is available.
2016-12-09T07:24:58.282755Z 0 [Note] - '::' resolves to '::';
2016-12-09T07:24:58.283255Z 0 [Note] Server socket created on IP: '::'.
2016-12-09T07:24:58.710360Z 0 [Note] Event Scheduler: Loaded 0 events
2016-12-09T07:24:58.722369Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: ready for connections.
Version: '5.7.16-log' socket: '' port: 3306 MySQL Community Server (GPL)
2016-12-09T07:24:59.277115Z 0 [Note] InnoDB: Buffer pool(s) load completed at 161209 15:24:59



错误日志


2016/12/09 13:36:11 [emerg] 5412#9880: CreateFile() "D:\phpStudy\apps/conf/nginx.conf" failed (3: The system cannot find the path specified)

...全文
454 6 打赏 收藏 转发到动态 举报
写回复
用AI写文章
6 条回复
切换为时间正序
请发表友善的回复…
发表回复
zhujinqiang 2016-12-26
  • 打赏
  • 举报
回复
mysql 和nginx怎么扯上联系的?
rucypli 2016-12-20
  • 打赏
  • 举报
回复
D:\phpStudy\apps/conf/nginx.conf 这怎么一会正斜杠一会反斜杠
cqyy725 2016-12-20
  • 打赏
  • 举报
回复
明显的路径问题啊··
msh158 2016-12-20
  • 打赏
  • 举报
回复
把你的innodb_buffer_pool_size调大点,大小为物理内存的75%左右
LongRui888 2016-12-10
  • 打赏
  • 举报
回复
你这个并不是mysql报错,从上面第一个里并没有看到有报错。 下面那个是php的报错信息吧
致命的西瓜 2016-12-09
  • 打赏
  • 举报
回复
mysql 怎么还有nginx的目录,这个日志哪看得

56,679

社区成员

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

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