56,677
社区成员
发帖
与我相关
我的任务
分享mariadb启动不了
./scripts/mysql_install_db --datadir=/app/data --user=mysql
初始化完成之后
使用/etc/init.d/mysql start启动一直失败
err.log也没有报错信息，有没有大神告知一下原因
初始化完成之后
使用/etc/init.d/mysql start启动一直失败
[root@izuf63nb42ltsh1wvt3nwvz mysql]# /etc/init.d/mysql start
Starting MariaDB.180925 21:57:38 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
180925 21:57:38 mysqld_safe Starting mysqld daemon with databases from /app/data
[FAILED]
err.log也没有报错信息，有没有大神告知一下原因
...全文
请发表友善的回复…
发表回复
me-川子 2019-10-10
- 打赏
- 举报
在 /etc/my.cnf中 修改
qq_32184937 2018-09-26
- 打赏
- 举报
没有错误日志，没有报错，我换了官方的my-huge.cnf就解决了
qq_32184937 2018-09-26
- 打赏
- 举报
没有错误日志，没有报错，我换了官方的my-huge.cnf就解决了
叶落千尘 2018-09-26
- 打赏
- 举报
把错误日志贴出来看看
qq_32184937 2018-09-25
- 打赏
- 举报
配置文件如下：
[client]
port=3306
socket=/tmp/mysql.sock
default-character-set=utf8mb4
[mysqld_safe]
socket=/tmp/mysql.sock
nice=0
[mysqld]
character-set-client-handshake=FALSE
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
user= mysql
pid-file=/app/mysqld.pid
socket=/tmp/mysql.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=16M
thread_cache_size=256
sort_buffer_size=4M
bulk_insert_buffer_size=16M
tmp_table_size=64M
max_heap_table_size=64M
myisam_recover=BACKUP
key_buffer_size=256M
table_open_cache=400
myisam_sort_buffer_size=1024M
concurrent_insert=2
read_buffer_size=8M
read_rnd_buffer_size=8M
query_cache_limit=512K
query_cache_size=256M
general_log_file=/var/log/mysql/mysql.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-slow.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.index
expire_logs_days=10
max_binlog_size=100M
default_storage_engine=InnoDB
innodb_buffer_pool_size=256M
innodb_log_buffer_size=8M
innodb_file_per_table=1
innodb_open_files=400
innodb_io_capacity=400
innodb_flush_method=O_DIRECT
[mysqldump]
quick
quote-names
max_allowed_packet=16M
[mysql]
default-character-set=utf8mb4
[isamchk]
key_buffer=16M
!includedir /etc/mysql/conf.d/
[client]
port=3306
socket=/tmp/mysql.sock
default-character-set=utf8mb4
[mysqld_safe]
socket=/tmp/mysql.sock
nice=0
[mysqld]
character-set-client-handshake=FALSE
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
user= mysql
pid-file=/app/mysqld.pid
socket=/tmp/mysql.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=16M
thread_cache_size=256
sort_buffer_size=4M
bulk_insert_buffer_size=16M
tmp_table_size=64M
max_heap_table_size=64M
myisam_recover=BACKUP
key_buffer_size=256M
table_open_cache=400
myisam_sort_buffer_size=1024M
concurrent_insert=2
read_buffer_size=8M
read_rnd_buffer_size=8M
query_cache_limit=512K
query_cache_size=256M
general_log_file=/var/log/mysql/mysql.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-slow.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.index
expire_logs_days=10
max_binlog_size=100M
default_storage_engine=InnoDB
innodb_buffer_pool_size=256M
innodb_log_buffer_size=8M
innodb_file_per_table=1
innodb_open_files=400
innodb_io_capacity=400
innodb_flush_method=O_DIRECT
[mysqldump]
quick
quote-names
max_allowed_packet=16M
[mysql]
default-character-set=utf8mb4
[isamchk]
key_buffer=16M
!includedir /etc/mysql/conf.d/
