32 lines
922 B
YAML
32 lines
922 B
YAML
apiVersion: v1
|
|
kind: ConfigMap
|
|
metadata:
|
|
name: mysql-config
|
|
namespace: epcare
|
|
data:
|
|
mysql.cnf: |
|
|
[mysqld]
|
|
# optimise for large db-imports
|
|
innodb_redo_log_capacity = 2147483648
|
|
|
|
# Buffer pool - bump this if the host has more RAM available
|
|
innodb_buffer_pool_size = 512M
|
|
|
|
# Log buffer - good
|
|
innodb_log_buffer_size = 256M
|
|
|
|
# Flush behavior - 2 is good for import speed, consider switching
|
|
# back to 1 in production for ACID compliance
|
|
innodb_flush_log_at_trx_commit = 2
|
|
|
|
# WARNING: O_DIRECT can fail on overlay2 (common Docker storage driver)
|
|
# Safer default for containers:
|
|
innodb_flush_method = fsync
|
|
|
|
# Recommended additions for large imports:
|
|
innodb_write_io_threads = 8
|
|
innodb_read_io_threads = 8
|
|
bulk_insert_buffer_size = 256M
|
|
|
|
sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"
|