V
V
VA2017-07-28 11:00:36
linux
VA, 2017-07-28 11:00:36

Mysql won't start (CentOS 6.7)?

Happy Friday everyone!
I can't figure out what's going on. I'm doing
:

#/etc/init.d/mysqld start
MySQL Daemon failed to start.
Starting mysqld:                                           [FAILED]

The last entry in the logs:
mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

my.cnf config
spoiler
[client]
port            = 3306
socket          = /var/lib/mysql/mysql.sock

[mysqld]
#skip-grant-tables
port            = 3306
socket          = /var/lib/mysql/mysql.sock
skip-locking

log = /var/log/mysqld.log
long_query_time = 10
log_error = /var/log/mysql/mysql.err
log_warnings = 1
tmpdir = /dev/shm
skip-name-resolve
#memlock
thread_concurrency = 12 

max_connections = 500
key_buffer_size = 256M
max_allowed_packet = 16M
table_open_cache = 256
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 192K
query_cache_size = 16M
thread_cache_size = 300
tmp_table_size = 1024M
max_heap_table_size = 1024M
join_buffer_size = 8M
table_open_cache = 2048
 
bind-address            = 0.0.0.0
 
innodb_buffer_pool_size = 16000M
innodb_thread_concurrency = 16
innodb_additional_mem_pool_size = 20M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 2
innodb_flush_method = O_DIRECT

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
 
[myisamchk]
key_buffer_size = 8M
sort_buffer_size = 8M

[mysqlhotcopy]
interactive-timeout

Answer the question

In order to leave comments, you need to log in

1 answer(s)
V
vman, 2017-07-28
@vman

run it manually from mysqld console and see what it says

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question