|
各位高手，请教下，我这个版本的数据库怎么启用忽略大小写，现在默认是表名是有大小写区分的，我用>set global lower_case_table_names = 1;命令，结果提示该变量只读，我在my.cnf中增加lower_case_table_names = 1，结果数据库启动不了，有什么办法能解决吗？，以下是我修改后的文件内容： [client socket = /data/GreatSQL/mysql.sock [mysql loose-skip-binary-as-hex prompt = "(\\D)[\\u@GreatSQL][\\d]>" no-auto-rehash [mysqld user = mysql port = 3306 server_id = 3306 basedir = /usr/local/GreatSQL-8.0.32-26-Linux-glibc2.28-x86_64 datadir = /data/GreatSQL socket = /data/GreatSQL/mysql.sock pid-file = mysql.pid character-set-server = UTF8MB4 skip_name_resolve = ON default_time_zone = "+8:00" bind_address = "0.0.0.0" secure_file_priv = /data/GreatSQL lower_case_table_names = 1 # Performance lock_wait_timeout = 3600 open_files_limit = 65535 back_log = 1024 max_connections = 1024 max_connect_errors = 1000000 table_open_cache = 2048 table_definition_cache = 2048 thread_stack = 512K sort_buffer_size = 4M join_buffer_size = 4M read_buffer_size = 8M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 64M thread_cache_size = 768 interactive_timeout = 600 wait_timeout = 600 tmp_table_size = 96M max_heap_table_size = 96M max_allowed_packet = 64M net_buffer_shrink_interval = 180 sql_generate_invisible_primary_key = ON loose-lock_ddl_polling_mode = ON loose-lock_ddl_polling_runtime = 200 # Logs log_timestamps = SYSTEM log_error = error.log log_error_verbosity = 3 slow_query_log = ON log_slow_extra = ON slow_query_log_file = slow.log long_query_time = 0.01 log_queries_not_using_indexes = ON log_throttle_queries_not_using_indexes = 60 min_examined_row_limit = 100 log_slow_admin_statements = ON log_slow_replica_statements = ON log_slow_verbosity = FULL log_bin = binlog binlog_format = ROW sync_binlog = 1 binlog_cache_size = 4M max_binlog_cache_size = 6G max_binlog_size = 1G binlog_space_limit = 500G binlog_rows_query_log_events = ON binlog_expire_logs_seconds = 604800 binlog_checksum = CRC32 binlog_order_commits = OFF gtid_mode = ON enforce_gtid_consistency = ON # Replication relay-log = relaylog relay_log_recovery = ON replica_parallel_type = LOGICAL_CLOCK replica_parallel_workers = 16 binlog_transaction_dependency_tracking = WRITESET replica_preserve_commit_order = ON replica_checkpoint_period = 2 loose-rpl_read_binlog_speed_limit = 100 # MGR loose-plugin_load_add = 'mysql_clone.so' loose-plugin_load_add = 'group_replication.so' loose-group_replication_group_name = "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaa1" loose-group_replication_local_address = "172.16.16.10:33061" loose-group_replication_group_seeds = '172.16.16.10:33061,72.16.16.12:33061,72.16.16.12:33061' loose-group_replication_communication_stack = "XCOM" loose-group_replication_recovery_use_ssl = OFF loose-group_replication_ssl_mode = DISABLED loose-group_replication_start_on_boot = OFF loose-group_replication_bootstrap_group = OFF loose-group_replication_exit_state_action = READ_ONLY loose-group_replication_flow_control_mode = "DISABLED" loose-group_replication_single_primary_mode = ON loose-group_replication_enforce_update_everywhere_checks = OFF loose-group_replication_majority_after_mode = ON loose-group_replication_communication_max_message_size = 10M loose-group_replication_arbitrator = OFF loose-group_replication_single_primary_fast_mode = 1 loose-group_replication_request_time_threshold = 100 loose-group_replication_primary_election_mode = GTID_FIRST loose-group_replication_unreachable_majority_timeout = 0 loose-group_replication_member_expel_timeout = 5 loose-group_replication_autorejoin_tries = 288 loose-group_replication_recovery_get_public_key = ON loose-group_replication_donor_threshold = 100 report_host = "172.16.16.10" # InnoDB innodb_buffer_pool_size = 16G innodb_buffer_pool_instances = 8 innodb_data_file_path = ibdata1:12M:autoextend innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size = 32M innodb_redo_log_capacity = 6G innodb_doublewrite_files = 2 innodb_max_undo_log_size = 4G innodb_io_capacity = 4000 innodb_io_capacity_max = 8000 innodb_open_files = 65534 innodb_flush_method = O_DIRECT innodb_lru_scan_depth = 4000 innodb_lock_wait_timeout = 10 innodb_rollback_on_timeout = ON innodb_print_all_deadlocks = ON innodb_online_alter_log_max_size = 4G innodb_print_ddl_logs = ON innodb_status_file = ON innodb_status_output = OFF innodb_status_output_locks = ON innodb_sort_buffer_size = 64M innodb_adaptive_hash_index = OFF innodb_numa_interleave = OFF innodb_spin_wait_delay = 20 innodb_print_lock_wait_timeout_info = ON innodb_change_buffering = none kill_idle_transaction = 300 innodb_data_file_async_purge = ON #innodb monitor settings #innodb_monitor_enable = "module_innodb,module_server,module_dml,module_ddl,module_trx,module_os,module_purge,module_log,module_lock,module_buffer,module_index,module_ibuf_system,module_buffer_page,module_adaptive_hash" #pfs settings performance_schema = 1 #performance_schema_instrument = '%memory%=on' performance_schema_instrument = '%lock%=on' |
|
|
yejr
2024-11-12 16:09:27
| |
合作电话：010-64087828
社区邮箱：greatsql@greatdb.com
