Home > database >  Mariadb won't start
Mariadb won't start

Time:09-17

./scripts/mysql_install_db - datadir=/app/data - user=mysql
Initialization is completed
Use the/etc/init. D/mysql start launch failure
 
[root @ izuf63nb42ltsh1wvt3nwvz mysql] #/etc/init. D/mysql start
Starting MariaDB. 180925 21:57:38 mysqld_safe Logging to '/var/log/MariaDB/MariaDB. The log'.
180925 21:57:38 mysqld_safe Starting mysqld daemon with databases from/app/data
(FAILED)


Err, log and no error message, have a great god told the reason

CodePudding user response:

Configuration file is as follows:
[client]
Port=3306
The socket=/TMP/mysql. The sock
Default - character - set=utf8mb4
[mysqld_safe]
The socket=/TMP/mysql. The sock
Nice=0
[mysqld]
Character - set - the client - handshake=FALSE
Character - set - server=utf8mb4
Collation - server=utf8mb4_unicode_ci
='SET NAMES init_connect utf8mb4'


User=mysql
Pid - file=/app/mysqld. Pid
The socket=/TMP/mysql. The sock
Port=3306
Basedir=/usr/local/mysql
Datadir=/app/data
Tmpdir=/TMP
Lc_messages_dir=/usr/share/mysql
Lc_messages=en_US
Skip_name_resolve=on
Skip - external - locking
Max_connections=5000
Wait_timeout=600
Max_allowed_packet=16 m
Thread_cache_size=256
Sort_buffer_size=4 m
Bulk_insert_buffer_size=16 m
Both tmp_table_size=64 m
Max_heap_table_size=64 m
Myisam_recover=BACKUP
Key_buffer_size=256 m
Table_open_cache=400
Myisam_sort_buffer_size=1024 m
Concurrent_insert=2
Read_buffer_size=8 m
Read_rnd_buffer_size=8 m
Query_cache_limit=512 k
Query_cache_size=256 m
General_log_file=/var/log/mysql/mysql. The log
General_log=1
Log_error=/var/log/mysql/err log
Log_warnings=2

Slow_query_log=1


Slow_query_log_file=/var/log/mysql/mariadb - missile. The log
Long_query_time=1


Log_slow_verbosity=query_plan


Log_bin=/var/log/mysql/mariadb - bin
Log_bin_index=/var/log/mysql/mariadb - bin. The index




Expire_logs_days=10
Max_binlog_size=100 m




Default_storage_engine=InnoDB




Innodb_buffer_pool_size=256 m
Innodb_log_buffer_size=8 m
Innodb_file_per_table=1
Innodb_open_files=400
Innodb_io_capacity=400
Innodb_flush_method=O_DIRECT


[the mysqldump]
The quick
Quote - names
Max_allowed_packet=16 m


[mysql]


Default - character - set=utf8mb4
[isamchk]
Key_buffer=16 m


! Includedir/etc/mysql/conf. D/

CodePudding user response:

Stick the error log out and have a look

CodePudding user response:

There is no error log, there is no error, I changed the official my - huge, CNF is solved

CodePudding user response:

refer to the second floor baijiu1 response:
stick error log out to see


There is no error log, there is no error, I changed the official my - huge, CNF is solved

CodePudding user response:

In the/etc/my CNF modify
  • Related