前往小程序,Get更优阅读体验!
立即前往
首页
学习
活动
专区
工具
TVP
发布
社区首页 >专栏 >Mysql启动后秒退问题

Mysql启动后秒退问题

作者头像
用户2657851
发布2020-03-04 13:52:01
1.2K0
发布2020-03-04 13:52:01
举报
文章被收录于专栏:vsdfa
代码语言:javascript
复制
2016-01-06 12:32:16 174c InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
160106 12:32:16 [Note] InnoDB: Using mutexes to ref count buffer pool pages
160106 12:32:16 [Note] InnoDB: The InnoDB memory heap is disabled
160106 12:32:16 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
160106 12:32:16 [Note] InnoDB: Memory barrier is not used
160106 12:32:16 [Note] InnoDB: Compressed tables use zlib 1.2.3
160106 12:32:16 [Note] InnoDB: Not using CPU crc32 instructions
160106 12:32:16 [Note] InnoDB: Initializing buffer pool, size = 16.0M
160106 12:32:16 [Note] InnoDB: Completed initialization of buffer pool
160106 12:32:16 [Note] InnoDB: Highest supported file format is Barracuda.
160106 12:32:16 [Note] InnoDB: The log sequence numbers 1800204 and 1800204 in ibdata files do not match the log sequence number 1800224 in the ib_logfiles!
160106 12:32:16 [Note] InnoDB: Database was not shutdown normally!
160106 12:32:16 [Note] InnoDB: Starting crash recovery.
160106 12:32:16 [Note] InnoDB: Reading tablespace information from the .ibd files...
160106 12:32:16 [Note] InnoDB: Restoring possible half-written data pages 
160106 12:32:16 [Note] InnoDB: from the doublewrite buffer...
160106 12:32:17 [Warning] InnoDB: Resizing redo log from 2*3072 to 2*320 pages, LSN=1800224
160106 12:32:17 [Warning] InnoDB: Starting to delete and rewrite log files.
160106 12:32:17 [Note] InnoDB: Setting log file D:\xampp\mysql\data\ib_logfile101 size to 5 MB
160106 12:32:17 [Note] InnoDB: Setting log file D:\xampp\mysql\data\ib_logfile1 size to 5 MB
160106 12:32:18 [Note] InnoDB: Renaming log file D:\xampp\mysql\data\ib_logfile101 to D:\xampp\mysql\data\ib_logfile0
160106 12:32:18 [Warning] InnoDB: New log files created, LSN=1800716
160106 12:32:18 [Note] InnoDB: 128 rollback segment(s) are active.
160106 12:32:18 [Note] InnoDB: Waiting for purge to start
160106 12:32:18 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.22-72.0 started; log sequence number 1800224
160106 12:32:18 [Note] Plugin 'FEEDBACK' is disabled.
160106 12:32:18 [Note] Server socket created on IP: '::'.  

xampp环境,错误日志文件见上面,反复重启和修改配置文件页不行,备份mysql文件夹下的ibdata1文件,删除mysql下的全部文件,只保留文件夹。然后启动mysql,一切正常。然后将备份的ibdata1文件替换新生成的。ok

本文参与 腾讯云自媒体同步曝光计划,分享自作者个人站点/博客。
原始发表:2016-01-06,如有侵权请联系 cloudcommunity@tencent.com 删除

本文分享自 作者个人站点/博客 前往查看

如有侵权,请联系 cloudcommunity@tencent.com 删除。

本文参与 腾讯云自媒体同步曝光计划  ,欢迎热爱写作的你一起参与!

评论
登录后参与评论
0 条评论
热度
最新
推荐阅读
相关产品与服务
云数据库 SQL Server
腾讯云数据库 SQL Server (TencentDB for SQL Server)是业界最常用的商用数据库之一,对基于 Windows 架构的应用程序具有完美的支持。TencentDB for SQL Server 拥有微软正版授权,可持续为用户提供最新的功能,避免未授权使用软件的风险。具有即开即用、稳定可靠、安全运行、弹性扩缩等特点。
领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档