[mysqld]
disable-log-bin = 1
default-authentication-plugin = mysql_native_password
performance-schema = 0
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock

# تنظیمات InnoDB
innodb_buffer_pool_size = 130G
innodb_buffer_pool_instances = 16
innodb_log_file_size = 1G
innodb_flush_method = O_DIRECT
innodb_io_capacity = 8000
innodb_io_capacity_max = 16000
innodb_file_per_table = 1
innodb_flush_log_at_trx_commit = 2
innodb_thread_concurrency = 28
innodb_adaptive_hash_index_parts = 128

# تنظیمات پایه
max_allowed_packet = 512M
open_files_limit=80000
max_connections = 10000
table_open_cache = 250000
table_definition_cache = 90000
tmp_table_size = 256M
max_heap_table_size = 256M 
join_buffer_size = 32M
sort_buffer_size = 32M
read_rnd_buffer_size = 32M
key_buffer_size = 64M


symbolic-links = 0

# تنظیمات وردپرس و کش
wait_timeout = 90
interactive_timeout = 90

# لاگ‌ها و خطاها
log-error = /var/log/mysqld.log


# حالت‌های SQL
sql_mode = "NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"

max_execution_time = 250000

# لاگ‌ها و خطاها
pid-file = /var/run/mysqld/mysqld.pid
log_error_verbosity = 1


validate_password.policy=LOW
validate_password.length=1
validate_password.mixed_case_count=0
validate_password.number_count=0
validate_password.special_char_count=0