cjy5066 2020-09-28 17:02 采纳率: 88.2%
浏览 145
已采纳

本地可以连接远程mysql,但是打开其中一个库就卡死,服务器上用Navicat连接也是一样的问题。

错误日志:

[Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-09-24T01:38:57.368376Z 0 [Note] InnoDB: Uses event mutexes
2020-09-24T01:38:57.368376Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2020-09-24T01:38:57.384129Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2020-09-24T01:38:57.384129Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
2020-09-24T01:38:57.384129Z 0 [Note] InnoDB: Number of pools: 1
2020-09-24T01:38:57.384129Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2020-09-24T01:38:57.399646Z 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
2020-09-24T01:38:57.399646Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-09-24T01:38:57.477755Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-09-24T01:38:57.493375Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 8144079740
2020-09-24T01:38:57.493375Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 8144079749
2020-09-24T01:38:57.493375Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 8144079749
2020-09-24T01:38:57.493375Z 0 [Note] InnoDB: Database was not shutdown normally!
2020-09-24T01:38:57.493375Z 0 [Note] InnoDB: Starting crash recovery.
2020-09-24T01:38:59.337165Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-09-24T01:38:59.337165Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-09-24T01:38:59.337165Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-09-24T01:38:59.462136Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2020-09-24T01:38:59.493395Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-09-24T01:38:59.493395Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-09-24T01:38:59.493395Z 0 [Note] InnoDB: Waiting for purge to start
2020-09-24T01:38:59.556984Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 8144079749
2020-09-24T01:38:59.556984Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-09-24T01:38:59.556984Z 0 [Note] InnoDB: Loading buffer pool(s) from C:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
2020-09-24T01:38:59.556984Z 0 [ERROR] InnoDB: Cannot open 'C:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool' for reading: No such file or directory

重启服务:
图片说明

重启失败之后,服务显示为停止,启动直接为灰色了
图片说明

  • 写回答

1条回答 默认 最新

报告相同问题?

问题事件

  • 已采纳回答 8月17日

悬赏问题

  • ¥170 如图所示配置eNSP
  • ¥20 docker里部署springboot项目,访问不到扬声器
  • ¥15 netty整合springboot之后自动重连失效
  • ¥15 悬赏!微信开发者工具报错,求帮改
  • ¥20 wireshark抓不到vlan
  • ¥20 关于#stm32#的问题:需要指导自动酸碱滴定仪的原理图程序代码及仿真
  • ¥20 设计一款异域新娘的视频相亲软件需要哪些技术支持
  • ¥15 stata安慰剂检验作图但是真实值不出现在图上
  • ¥15 c程序不知道为什么得不到结果
  • ¥15 键盘指令混乱情况下的启动盘系统重装