尝试启动mysql时获取pthread_create错误13 (权限)

Question

我正在尝试在RedHat AWS box上开始一个干净的5.6mysql安装。在日志中打印以下内容后挂起。它最终会消亡：

mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
[Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)
[Warning] Buffered warning: Changed limits: table_cache: 431 (requested 2000)
[Note] Plugin 'FEDERATED' is disabled.
[Note] InnoDB: Using atomics to ref count buffer pool pages
[Note] InnoDB: The InnoDB memory heap is disabled
[Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
[Note] InnoDB: Memory barrier is not used
[Note] InnoDB: Compressed tables use zlib 1.2.3
[Note] InnoDB: Using Linux native AIO
[Note] InnoDB: Using CPU crc32 instructions
[Note] InnoDB: Initializing buffer pool, size = 128.0M
[Note] InnoDB: Completed initialization of buffer pool
InnoDB: Error: pthread_create returned 13
mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

它根本不会创建套接字。下面是my.cnf：

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

# Recommended in standard MySQL setup
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

有什么想法吗？

Answer 1

$ perror 13
OS error code  13:  Permission denied

也许你安装的时候不是root用户？

[Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)

这是由于ulimit (在操作系统中)只有1024造成的。

Answer 2

我也有InnoDB: Error: pthread_create在CentOS7上启动mysql服务器时返回13。

找到了这个问题，检查了mysql文件夹的权限，但没有发现任何错误的权限。

将mysql服务器更新到最新版本修复了我的所有问题。(我现在的版本是14.14 Distrib 5.6.23)