# Configuration serveur MariaDB, instance de test # Version : 11.8.9-MariaDB-deb12-log # Releve UTC : 2026-10-10T13:14:42.981967+00:00 # Sections serveur des fichiers inclus, dans leur ordre de lecture. # Identifiants reseau et secrets retires ; sections de connexion client exclues. # Ressource documentaire : les valeurs retirees doivent etre adaptees pour une installation. # Source: /etc/mysql/my.cnf [mysqld] rocksdb_wal_recovery_mode=2 table_definition_cache = 10000 table_open_cache = 10000 table_open_cache_instances=8 metadata_locks_cache_size=10000 rocksdb_flush_log_at_trx-commit=2 query_response_time_stats=ON userstat=ON innodb_autoextend_increment = 1000 innodb_strict_mode=1 sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION performance_schema = ON performance_schema_consumer_events_statements_history = ON performance_schema_consumer_events_statements_history_long = ON connect_timeout=10 innodb_rollback_on_timeout=1 wait_timeout=18000 character_set_server = utf8mb4 collation_server = utf8mb4_general_ci user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /srv/mysql/data tmpdir = /srv/mysql/tmp lc_messages_dir = /usr/share/mysql lc_messages = en_US plugin_dir = /usr/lib/mysql/plugin/ skip-name-resolve log_error=/srv/mysql/log/error.log max_connections = 2000 connect_timeout = 10 wait_timeout = 600 max_allowed_packet = 256M thread_cache_size = 128 sort_buffer_size = 8M bulk_insert_buffer_size = 16M tmp_table_size = 256M max_heap_table_size = 256M myisam_recover_options = BACKUP key_buffer_size = 128M open_files_limit = 10000 myisam_sort_buffer_size = 512M concurrent_insert = 2 read_buffer_size = 2M read_rnd_buffer_size = 1M key_cache_segments = 64 query_cache_limit = 128K query_cache_size = 0 query_cache_type = OFF general_log_file = /srv/mysql/log/general.log log_warnings = 2 slow_query_log=1 slow_query_log_file = /srv/mysql/log/mariadb-slow.log long_query_time=1 log_slow_verbosity = query_plan log_slave_updates = 1 # server-id : identifiant reseau retire # report_host : identifiant reseau retire log_bin = /srv/mysql/binlog/mariadb-bin log_bin_index = /srv/mysql/binlog/mariadb-bin.index sync_binlog = 10000 binlog_expire_logs_seconds = 3600 max_binlog_size = 100M relay_log = /srv/mysql/relaylog/relay-bin relay_log_index = /srv/mysql/relaylog/relay-bin.index relay_log_info_file = /srv/mysql/relaylog/relay-bin.info log_slave_updates default_storage_engine = InnoDB innodb_log_file_size = 512M innodb_buffer_pool_size = 2G innodb_buffer_pool_size_auto_min= 1G innodb_buffer_pool_size_max=3G innodb_log_buffer_size = 8M innodb_file_per_table = 1 innodb_open_files = 2000 innodb_io_capacity = 2000 innodb_flush_method = O_DIRECT event-scheduler = ON # Source: /etc/mysql/my.cnf [galera] wsrep_on=OFF # wsrep_cluster_name : identifiant reseau retire wsrep_provider=/usr/lib/galera/libgalera_smm.so # wsrep_cluster_address : identifiant reseau retire # wsrep_node_address : identifiant reseau retire # wsrep_node_name : identifiant reseau retire wsrep_gtid_mode=ON wsrep_sst_method = xtrabackup-v2 # wsrep_sst_auth : valeur retiree wsrep_provider_options="gcache.size = 20G" wsrep_max_ws_rows = 500000 binlog_format=row default_storage_engine=InnoDB innodb_autoinc_lock_mode=2 # bind-address : identifiant reseau retire wsrep_slave_threads=4 innodb_flush_log_at_trx_commit=2 wsrep_certify_nonPK=1 wsrep_max_ws_rows=131072 wsrep_max_ws_size=1073741824 wsrep_debug=0 wsrep_convert_LOCK_to_trx=0 wsrep_retry_autocommit=1 wsrep_auto_increment_control=1 wsrep_drupal_282555_workaround=0 wsrep_causal_reads=0 wsrep_log_conflicts=1 # Source: /etc/mysql/conf.d/60-pmacontrol-tls.cnf [mariadb] ssl_ca = /etc/mysql/tls-pmacontrol/ca.crt ssl_cert = /etc/mysql/tls-pmacontrol/server.crt # ssl_key : valeur retiree require_secure_transport = OFF # Source: /etc/mysql/conf.d/80-pmacontrol-duckdb.cnf [mysqld] plugin-maturity=gamma plugin-load-add=ha_duckdb.so duckdb_memory_limit=536870912 duckdb_max_threads=2 duckdb_temp_directory=/srv/mysql/duckdb-tmp duckdb_max_temp_directory_size=536870912 duckdb_dml_in_batch=OFF # Source: /etc/mysql/conf.d/rocksdb.cnf [mariadb] plugin-load-add=ha_rocksdb.so rocksdb_use_direct_io_for_flush_and_compaction = 1 rocksdb_block_cache_size = 2G rocksdb_max_background_jobs = 8 rocksdb_flush_log_at_trx_commit = 2 # Source: /etc/mysql/releem.conf.d/collect_metrics.cnf [mysqld] performance_schema = 1 slow_query_log = 1 performance-schema-consumer-events-statements-history = ON performance-schema-consumer-events-statements-current = ON performance_schema_events_statements_history_size = 500 # Source: /etc/mysql/releem.conf.d/z_aiops_mysql.cnf [mysqld] max_connections = 2000 ### Manually set (was 100) — pinned 2026-06-02 key_buffer_size = 134217728 ### Previous value : 134217728 max_heap_table_size = 134217728 ### Reduced to limit per-session memory growth tmp_table_size = 134217728 ### Reduced to limit per-session memory growth innodb_log_file_size = 994050048 ### Previous value : 727711744 innodb_max_dirty_pages_pct = 70.000000 ### Previous value : 70.000000 thread_stack = 524288 ### Previous value : 524288 innodb_buffer_pool_chunk_size = 0 ### Previous value : 0 transaction_prealloc_size = 8192 ### Previous value : 8192 # Source: /etc/mysql/releem.conf.d/zz_pmacontrol_ps_history_experiment.cnf [mysqld] performance_schema_events_statements_history_size = 50 # Source: /etc/mysql/releem.conf.d/zzzz_pmacontrol_memory_safety.cnf [mysqld] max_connections = 128 tmp_table_size = 64M max_heap_table_size = 64M sort_buffer_size = 4M read_buffer_size = 1M read_rnd_buffer_size = 512K max_session_mem_used = 512M