Differences

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

--- computing:nextcloud [2026/06/21 14:37] – oemb1905
+++ computing:nextcloud [2026/10/14 15:15] (current) – oemb1905
@@ Line 212: / Line 212: @@
   sudo nano /var/www/html/.user.ini
   max_excution_time = 240 (for all of them)
+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:
+<code bash>
+[mysqld]
+slow_query_log = ON
+slow_query_log_file = /var/log/mysql/mariadb-slow.log
+long_query_time = 1
+log_queries_not_using_indexes = ON
+min_examined_row_limit = 1000
+log_slow_verbosity = query_plan,explain
+tmp_table_size = 128M
+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>
-If you get the missing indexes error on an upgrade, use:
+If you get the missing indexes error on an upgrade, and/or after optimizing your db, run:
   sudo -u www-data php occ db:add-missing-indices
@@ Line 334: / Line 360: @@
- --- //[[alerts@haacksnetworking.org|oemb1905]] 2026/06/21 14:37//
+ --- //[[alerts@haacksnetworking.org|oemb1905]] 2026/09/27 14:50//

Haack's Wiki