| 主题 : 登陆系统显示错误 |
级别: 版主
 |
14# 发表于:2019-05-21 10:25:05 IP:117.140.*.*
您试下修改下mysql的sql_module
vi /etc/my.cnf 文件下的 |
||
|---|---|---|---|
级别: 白丁
 |
15# 发表于:2019-05-21 10:41:12 IP:120.168.*.*
[client] port = 3306 socket = /apps/mysql/mysql.sock default-character-set = utf8mb4 [mysqld] port = 3306 server-id = 11 socket = /apps/mysql/mysql.sock basedir = /apps/mysql datadir = /apps/mysql/data pid-file = /apps/mysql/mysql.pid log_error = /apps/mysql/mysql-error.log init-connect = 'SET NAMES utf8mb4' character-set-server = utf8mb4 log_bin_trust_function_creators = 1 event_scheduler = ON innodb_print_all_deadlocks = ON group_concat_max_len = 2M sync_binlog = 1 back_log = 3000 transaction_isolation = READ-COMMITTED sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION max_connections = 1000 max_connect_errors = 1000 open_files_limit = 65535 table_open_cache = 5500 table_definition_cache = 2000 max_allowed_packet = 16M binlog_cache_size = 4M max_heap_table_size = 400M tmp_table_size = 400M read_buffer_size = 8M read_rnd_buffer_size = 12M sort_buffer_size = 8M join_buffer_size = 12M key_buffer_size = 128M thread_cache_size = 64 query_cache_type = 1 query_cache_size = 64M query_cache_limit = 8M ft_min_word_len = 4 log_bin = binlog binlog_format = mixed expire_logs_days = 3 slow_query_log = 1 long_query_time = 15 slow_query_log_file = /apps/mysql/mysql-slow.log performance_schema = 0 skip-external-locking default_storage_engine = InnoDB innodb_file_per_table = 1 innodb_open_files = 3000 innodb_buffer_pool_size = 4G innodb_buffer_pool_instances = 8 innodb_write_io_threads = 16 innodb_read_io_threads = 16 innodb_thread_concurrency = 0 innodb_purge_threads = 1 innodb_flush_log_at_trx_commit = 2 innodb_log_buffer_size = 32M innodb_log_file_size = 1G innodb_log_files_in_group = 3 innodb_max_dirty_pages_pct = 90 innodb_lock_wait_timeout = 120 innodb_print_all_deadlocks=1 bulk_insert_buffer_size = 16M myisam_sort_buffer_size = 32M myisam_repair_threads = 1 interactive_timeout = 3600 wait_timeout = 3600 [mysqldump] max_allowed_packet = 16M [myisamchk] key_buffer_size = 128M sort_buffer_size = 8M read_buffer = 4M write_buffer = 4M |
||
|---|---|---|---|
级别: 版主
|
18# 发表于:2019-05-21 10:43:23 IP:117.140.*.*
吧sql_mode 的参数改为sql_mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
|
||
|---|---|---|---|