设备防止mysql启动

Question

我试图在mysql 5.5上启动ubuntu 14.04服务，但失败了。

我在dmesg中注意到以下错误：

[ 1201.519101] init: mysql post-start process (22140) terminated with status 1
[ 1201.539004] init: mysql main process (22165) terminated with status 1
[ 1201.539016] init: mysql main process ended, respawning
[ 1201.542554] init: mysql post-start process (22166) terminated with status 1
[ 1201.562121] init: mysql main process (22196) terminated with status 1
[ 1201.562134] init: mysql respawning too fast, stopped

我该怎么解决这个问题？

我最近对my.cnf对innodb相关的配置做了一些更改，以防这导致问题：

# Read the manual for more InnoDB related options. There are many!
innodb_read_io_threads          = 16
innodb_write_io_threads         = 16  #To stress the double write buffer
innodb_buffer_pool_size         = 28000M
# innodb_log_file_size          = 256M #Small log files, more page flush
innodb_log_files_in_group       = 2
innodb_file_per_table           = 1
# innodb_log_buffer_size            = 512M
innodb_flush_method         = O_DIRECT
innodb_flush_log_at_trx_commit      = 0
innodb_file_format          = BARRACUDA
# innodb_log_file_size          = 512M

Answer 1

在网上搜索

mysql apparmor

有很多解决办法。有几种可能性：

https://askubuntu.com/a/953988

https://serverfault.com/questions/896653/how-do-i-get-the-right-apparmor-profile-for-mysql-on-ubuntu

您不应该需要禁用或删除设备。