Nextcloud 31 möchte dynamische Tebellen

Ich hoste eine kleine Instanz von Nextcloud. Man wundert sich, was die Nextcloudanalyse nach einem Update von sich wirft. Quasi jede Datenbanktebelle könnte optimiert werden, indem man sie auf dynamisch stellt. Wenn man SQL aber nur alle Jubeljahre mal anpackt, stellt einen das doch vor eine Aufgabe.

Keine Ahnung, ob man es mit einer Schleife hätte hinbekommen können, aber ich habs nun händisch gemacht:

ALTER TABLE [nextcloud_database_name].oc_polls_options ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_deck_board_acl ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_text_sessions ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_talk_participants ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_circles_mountpoint ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_news_items ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_quicknotes_note_tags ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_twofactor_backupcodes ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_quicknotes_attach ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_properties ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_polls_comments ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_mail_messages ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_talk_rooms ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_recent_contact ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_deck_cards ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_collres_resources ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_flow_checks ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_dav_shares ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_calendar_appt_configs ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_mail_trusted_senders ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_quicknotes_colors ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_webauthn ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_jobs ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_ldap_group_mapping ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_deck_boards ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_polls_polls ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_systemtag_object_mapping ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_notifications_pushhash ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_deck_labels ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_calendarchanges ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_ldap_user_mapping ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_systemtag ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_circles_remote ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_talk_signaling ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_quicknotes_notes ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_documentserver_sess ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_calendarobjects ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_users ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_directlink ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_authtoken ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_bruteforce_attempts ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_polls_preferences ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_files_avir_status ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_user_transfer_owner ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_filecache_extended ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_groups ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_group_admin ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_ojsxc_stanzas ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_calendarobjects_props ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_circles_membership ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_mail_coll_addresses ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_dav_cal_proxy ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_whats_new ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_richdocuments_direct ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_oauth2_access_tokens ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_mail_attachments ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_mail_mailboxes ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_storages_credentials ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_polls_notif ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_files_antivirus ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_schedulingobjects ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_mail_local_messages ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_polls_votes ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_external_options ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_richdocuments_assets ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_systemtag_group ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_text_documents ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_filecache ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_authorized_groups ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_group_user ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_calendar_invitations ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_collres_accesscache ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_addressbooks ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_news_folders ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_cards_properties ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_appconfig ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_circles_circle ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_federated_reshares ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_calendars ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_quicknotes_shares ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_collres_collections ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_migrations ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_news_feeds ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_calendar_rooms_md ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_activity_mq ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_deck_attachment ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_polls_log ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_known_users ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_files_trash ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_external_applicable ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_mimetypes ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_trusted_servers ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_talk_guests ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_vcategory ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_share_external ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_direct_edit ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_mail_accounts ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_twofactor_providers ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_circles_token ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_notifications ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_calendar_appt_bookings ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_circles_member ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_oauth2_clients ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_accounts ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_accounts_data ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_activity ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_addressbookchanges ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_bookmarks ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_bookmarks_folders ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_bookmarks_folders_public ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_bookmarks_root_folders ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_bookmarks_shared_folders ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_bookmarks_shared_to_shares ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_bookmarks_shares ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_bookmarks_tags ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_bookmarks_tree ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_calendar_reminders ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_calendar_resources ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_calendar_resources_md ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_calendar_rooms ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_calendarsubscriptions ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_cards ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_circles_event ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_circles_mount ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_circles_share_lock ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_comments ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_comments_read_markers ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_deck_assigned_labels ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_deck_assigned_users ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_deck_stacks ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_documentserver_changes ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_documentserver_ipc ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_documentserver_locks ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_file_locks ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_flow_operations ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_flow_operations_scope ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_login_flow_v2 ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_mail_aliases ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_mail_classifiers ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_mail_message_tags ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_mail_provisionings ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_mail_recipients ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_mail_tags ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_mounts ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_notes_meta ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_notifications_pushtokens ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_ojsxc_presence ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_onlyoffice_filekey ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_preferences ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_privacy_admins ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_profile_config ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_ratelimit_entries ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_richdocuments_member ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_richdocuments_wopi ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_share ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_storages ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_talk_commands ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_text_steps ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_user_status ROW_FORMAT=DYNAMIC;

ALTER TABLE [nextcloud_database_name].oc_vcategory_to_object ROW_FORMAT=DYNAMIC;