XAMPP在Windows下MySql启动Crash
XAMPP出错提示
14:18:00 [mysql] Attempting to start MySQL app...
14:18:01 [mysql] Status change detected: running
14:18:04 [mysql] Status change detected: stopped
14:18:04 [mysql] Error: MySQL shutdown unexpectedly.
14:18:04 [mysql] This may be due to a blocked port, missing dependencies,
14:18:04 [mysql] improper privileges, a crash, or a shutdown by another method.
14:18:04 [mysql] Press the Logs button to view error logs and check
14:18:04 [mysql] the Windows Event Viewer for more clues
14:18:04 [mysql] If you need more help, copy and post this
14:18:04 [mysql] entire log window on the forums
MySql错误日志
Server version: 10.1.38-MariaDB
key_buffer_size=16777216
read_buffer_size=262144
max_used_connections=0
max_threads=1001
thread_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 787931 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
mysqld.exe!my_parameter_handler()
mysqld.exe!strxnmov()
mysqld.exe!strxnmov()
mysqld.exe!my_xml_set_user_data()
mysqld.exe!my_xml_set_user_data()
mysqld.exe!my_xml_set_user_data()
mysqld.exe!my_xml_set_user_data()
mysqld.exe!my_xml_set_user_data()
mysqld.exe!parse_user()
mysqld.exe!?ha_initialize_handlerton@@YAHPEAUst_plugin_int@@@Z()
mysqld.exe!?plugin_init@@YAHPEAHPEAPEADH@Z()
mysqld.exe!?plugin_init@@YAHPEAHPEAPEADH@Z()
mysqld.exe!?init_net_server_extension@@YAXPEAVTHD@@@Z()
mysqld.exe!?win_main@@YAHHPEAPEAD@Z()
mysqld.exe!?mysql_service@@YAHPEAX@Z()
mysqld.exe!?mysqld_main@@YAHHPEAPEAD@Z()
mysqld.exe!strxnmov()
KERNEL32.DLL!BaseThreadInitThunk()
ntdll.dll!RtlUserThreadStart()
解决方法
打开Mysql的配置文件my.ini
...(省略)
innodb_lock_wait_timeout = 50
# 增加下面这一行,重启Mysql
innodb_flush_method=normal
## UTF 8 Settings
...(省略)