Differences

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

--- computing:nextcloud [2026/09/27 17:12] – oemb1905
+++ computing:nextcloud [2026/10/14 15:15] (current) – oemb1905
@@ Line 214: / Line 214: @@
 For Nextcloud 35.0.1, they started suggesting db optimizations, so create ''nano /etc/mysql/mariadb.conf.d/99-nextcloud.cnf'' and drop in something like:
-  [mysqld]
+<code bash>
-  slow_query_log = ON
+[mysqld]
-  slow_query_log_file = /var/log/mysql/mariadb-slow.log
+slow_query_log = ON
-  long_query_time = 2
+slow_query_log_file = /var/log/mysql/mariadb-slow.log
-  tmp_table_size = 64M
+long_query_time = 1
-  max_heap_table_size = 64M
+log_queries_not_using_indexes = ON
-  innodb_log_file_size = 256M
+min_examined_row_limit = 1000
-  innodb_flush_log_at_trx_commit = 1
+log_slow_verbosity = query_plan,explain
-  table_open_cache = 8000
-  table_definition_cache = 2000
+tmp_table_size = 128M
-  table_open_cache_instances = 8
+max_heap_table_size = 128M
-  open_files_limit = 32768
+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>
 If you get the missing indexes error on an upgrade, and/or after optimizing your db, run:

Haack's Wiki