我使用的命令是:
/mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/data/mysql/mysql3306/ --user=mysql
拷少参数了还找半天,,,,,,,,
[root@node02 bin]#
./mysqld --initialize --basedir=/usr/local/mysql --datadir=/data/mysql/data/ --user=mysql
改成这个就好了撒!
[root@node02 data]# cat /etc/my.cnf
[client]
port = 13306
socket = /data/mysql/data/mysql.sock
[mysqld]
character_set_server=UTF8MB4
init_connect='SET NAMES UTF8MB4'
basedir=/usr/local/mysql
datadir=/data/mysql/data
socket=/data/mysql/data/mysql.sock
log-error=/data/mysql/data/mysqld.log
pid-file=/data/mysql/data/mysqld.pid
lower_case_table_names = 1
max_connections=5000
open_files_limit = 65535
max_connect_errors = 100000
default-time_zone = '+8:00'
max_binlog_size = 256M
sync_binlog = 0
gtid-mode = on
enforce-gtid-consistency=1
innodb_buffer_pool_size = 4G
innodb_buffer_pool_instances = 1
innodb_data_file_path = ibdata1:1024M:autoextend
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 8M
innodb_log_file_size = 1024M
innodb_log_files_in_group = 3
innodb_max_dirty_pages_pct = 50
innodb_file_per_table = 1
innodb_rollback_on_timeout
innodb_io_capacity = 2000
table_open_cache = 2048
table_definition_cache = 2048
table_open_cache = 2048
max_heap_table_size = 96M
sort_buffer_size = 128K
join_buffer_size = 128K
thread_cache_size = 200
thread_stack = 192K
tmp_table_size = 96M
key_buffer_size = 8M
read_buffer_size = 2M
read_rnd_buffer_size = 16M
bulk_insert_buffer_size = 32M