二进制安装Maria后无法启动
2020-06-07 16:08:48 140259540711168 [Note] /usr/local/mysql/bin/mysqld (initiated by: unknown): Normal shutdown 2020-06-07 16:08:48 140259540711168 [Note] Event Scheduler: Purging the queue. 0 events 2020-06-07 16:08:48 140258946434816 [Note] InnoDB: FTS optimize thread exiting. 2020-06-07 16:08:48 140259540711168 [Note] InnoDB: Starting shutdown... 2020-06-07 16:08:48 140258842756864 [Note] InnoDB: Dumping buffer pool(s) to /data/mysql/ib_buffer_pool 2020-06-07 16:08:48 140258842756864 [Note] InnoDB: Buffer pool(s) dump completed at 200607 16:08:48 2020-06-07 16:08:50 140259540711168 [Note] InnoDB: Shutdown completed; log sequence number 1601869 2020-06-07 16:08:50 140259540711168 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2020-06-07 16:08:50 140259540711168 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 2020-06-07 16:08:51 140562504634944 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-06-07 16:08:51 140562504634944 [Note] InnoDB: Uses event mutexes 2020-06-07 16:08:51 140562504634944 [Note] InnoDB: Compressed tables use zlib 1.2.11 2020-06-07 16:08:51 140562504634944 [Note] InnoDB: Using Linux native AIO 2020-06-07 16:08:51 140562504634944 [Note] InnoDB: Number of pools: 1 2020-06-07 16:08:51 140562504634944 [Note] InnoDB: Using SSE2 crc32 instructions 2020-06-07 16:08:51 140562504634944 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2020-06-07 16:08:51 140562504634944 [Note] InnoDB: Completed initialization of buffer pool 2020-06-07 16:08:51 140561601169152 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-06-07 16:08:51 140562504634944 [Note] InnoDB: Highest supported file format is Barracuda. 2020-06-07 16:08:51 140562504634944 [Note] InnoDB: 128 out of 128 rollback segments are active. 2020-06-07 16:08:51 140562504634944 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-06-07 16:08:51 140562504634944 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-06-07 16:08:51 140562504634944 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-06-07 16:08:51 140562504634944 [Note] InnoDB: Waiting for purge to start 2020-06-07 16:08:51 140562504634944 [Note] InnoDB: 5.7.30 started; log sequence number 1601869 2020-06-07 16:08:51 140561592776448 [Note] InnoDB: Loading buffer pool(s) from /data/mysql/ib_buffer_pool 2020-06-07 16:08:51 140561592776448 [Note] InnoDB: Buffer pool(s) load completed at 200607 16:08:51 2020-06-07 16:08:51 140562504634944 [Note] Plugin 'FEEDBACK' is disabled. 2020-06-07 16:08:51 140562504634944 [ERROR] /usr/local/mysql/bin/mysqld: unknown variable 'able_open_cache=256' 2020-06-07 16:08:51 140562504634944 [ERROR] Aborting

因为我是安装后没有多进行配置,日志中显示
[ERROR] /usr/local/mysql/bin/mysqld: unknown variable 'able_open_cache=256'
到配置文件中注释这项就行


浙公网安备 33010602011771号