Differences

This shows you the differences between two versions of the page.

--- computing:nextcloud [2026/09/28 07:05] – oemb1905
+++ computing:nextcloud [2026/10/14 15:15] (current) – oemb1905
@@ Line 219: / Line 219: @@
 slow_query_log = ON
 slow_query_log_file = /var/log/mysql/mariadb-slow.log
-long_query_time = 2
+long_query_time = 1
-tmp_table_size = 64M
+log_queries_not_using_indexes = ON
-max_heap_table_size = 64M
+min_examined_row_limit = 1000
-innodb_log_file_size = 256M
+log_slow_verbosity = query_plan,explain
-innodb_flush_log_at_trx_commit = 1
-innodb_buffer_pool_size = 2G
+tmp_table_size = 128M
-table_open_cache = 8000
+max_heap_table_size = 128M
+sort_buffer_size = 2M
 table_definition_cache = 2000
+table_open_cache = 32586
 table_open_cache_instances = 8
 open_files_limit = 32768
+innodb_log_file_size = 256M
+innodb_buffer_pool_size = 4G
+innodb_log_file_size = 256M
+innodb_flush_log_at_trx_commit = 1
+innodb_flush_method = O_DIRECT
 </code>

Haack's Wiki