Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
| 79:system_requirements_mysql [2024/03/06 01:22] – created - external edit 127.0.0.1 | 79:system_requirements_mysql [2024/04/30 13:53] (current) – [Native MySQL installation] EmrichTiba, Ernest | ||
|---|---|---|---|
| Line 10: | Line 10: | ||
| character-set-server=utf8 | character-set-server=utf8 | ||
| max_allowed_packet=500M | max_allowed_packet=500M | ||
| - | innodb_lock_wait_timeout=600 | + | innodb_lock_wait_timeout=7200 |
| transaction-isolation=READ-COMMITTED | transaction-isolation=READ-COMMITTED | ||
| lower_case_table_names=1 | lower_case_table_names=1 | ||
| Line 16: | Line 16: | ||
| default-time-zone=" | default-time-zone=" | ||
| + | </ | ||
| + | |||
| + | The following settings are recommended for MySQL 8.0, especially to improve database write performance: | ||
| + | |||
| + | < | ||
| + | innodb_flush_log_at_trx_commit=2 | ||
| + | sync_binlog=0 | ||
| + | innodb_log_buffer_size=512M | ||
| </ | </ | ||