数据库被终止造成宕机修复。

爱晴皇岛

数据库被终止造成宕机修复。

Version: '10.1.21-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
2019-12-06 16:35:55 2584 [Note] E:\xampp\mysql\bin\mysqld.exe: Normal shutdown

2019-12-06 16:35:55 2584 [Note] Event Scheduler: Purging the queue. 0 events
2019-12-06 16:35:55 4064 [Note] InnoDB: FTS optimize thread exiting.
2019-12-06 16:35:55 2584 [Note] InnoDB: Starting shutdown...
2019-12-06 16:35:55 2584 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2019-12-06 16:35:57 2584 [Note] InnoDB: Shutdown completed; log sequence number 1878849
2019-12-06 16:35:57 2584 [Note] E:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2019-12-06 16:36:00 1374 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.
2019-12-06 16:36:00 4980 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-12-06 16:36:00 4980 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-12-06 16:36:00 4980 [Note] InnoDB: The InnoDB memory heap is disabled
2019-12-06 16:36:00 4980 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-12-06 16:36:00 4980 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-12-06 16:36:00 4980 [Note] InnoDB: Compressed tables use zlib 1.2.3
2019-12-06 16:36:00 4980 [Note] InnoDB: Using generic crc32 instructions
2019-12-06 16:36:00 4980 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-12-06 16:36:00 4980 [Note] InnoDB: Completed initialization of buffer pool
2019-12-06 16:36:00 4980 [Note] InnoDB: Highest supported file format is Barracuda.
2019-12-06 16:36:00 4980 [Note] InnoDB: 128 rollback segment(s) are active.
2019-12-06 16:36:00 4980 [Note] InnoDB: Waiting for purge to start
2019-12-06 16:36:00 4980 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 1878849
2019-12-06 16:36:01 4980 [Note] Plugin 'FEEDBACK' is disabled.
2019-12-06 16:36:01 4980 [Note] Server socket created on IP: '::'.
2019-12-06 16:36:01 5064 [Note] InnoDB: Dumping buffer pool(s) not yet started
2019-12-06 16:36:01 4980 [Note] E:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.21-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
2019-12-06 16:43:00 6116 [ERROR] mysqld.exe: Table '.\long5@002ecom\pre_xigua_x_fans' is marked as crashed and should be repaired
2019-12-06 16:43:00 6116 [Warning] Checking table:   '.\long5@002ecom\pre_xigua_x_fans'
2019-12-06 16:43:01 6116 [ERROR] mysqld.exe: Table '.\long5@002ecom\pre_xigua_x_log' is marked as crashed and should be repaired
2019-12-06 16:43:01 6116 [Warning] Checking table:   '.\long5@002ecom\pre_xigua_x_log'
2019-12-06 16:50:34 4336 [ERROR] mysqld.exe: Table '.\long5@002ecom\pre_common_admincp_session' is marked as crashed and should be repaired
2019-12-06 16:50:34 4336 [Warning] Checking table:   '.\long5@002ecom\pre_common_admincp_session'
2019-12-06 16:50:35 4336 [ERROR] mysqld.exe: Table '.\long5@002ecom\pre_common_searchindex' is marked as crashed and should be repaired
2019-12-06 16:50:35 4336 [Warning] Checking table:   '.\long5@002ecom\pre_common_searchindex'
2019-12-06 16:50:36 4336 [ERROR] mysqld.exe: Table '.\long5@002ecom\pre_forum_modwork' is marked as crashed and should be repaired
2019-12-06 16:50:36 4336 [Warning] Checking table:   '.\long5@002ecom\pre_forum_modwork'
2019-12-06 16:50:36 4336 [ERROR] mysqld.exe: Table '.\long5@002ecom\pre_home_friend_request' is marked as crashed and should be repaired
2019-12-06 16:50:36 4336 [Warning] Checking table:   '.\long5@002ecom\pre_home_friend_request'
2019-12-06 16:50:36 4336 [ERROR] mysqld.exe: Table '.\long5@002ecom\pre_home_poke' is marked as crashed and should be repaired
2019-12-06 16:50:36 4336 [Warning] Checking table:   '.\long5@002ecom\pre_home_poke'
2019-12-06 16:50:36 4336 [ERROR] mysqld.exe: Table '.\long5@002ecom\pre_home_pokearchive' is marked as crashed and should be repaired
2019-12-06 16:50:36 4336 [Warning] Checking table:   '.\long5@002ecom\pre_home_pokearchive'
2019-12-06 16:50:39 4336 [ERROR] mysqld.exe: Table '.\long5@002ecom\pre_plugin_daka_user' is marked as crashed and should be repaired
2019-12-06 16:50:39 4336 [Warning] Checking table:   '.\long5@002ecom\pre_plugin_daka_user'

从而造成崩溃


解决方案:

(1)打开任务管理器终止mysqld进程；

(2)打开mysql安装目录的data文件夹，删除以下2个文件：
ib_logfile0和ib_logfile1

(3)重新启动mysql

参考解决办法:
XAMPP启动mysql遇到的问题