nextcloud/nextcloudpi

Optimize database with mysqlcheck

開放

#989 建立於 2019年9月4日

 (4 則留言) (2 個反應) (1 位負責人)Shell (320 個分叉)auto 404
enhancementgood first issuehas-updates

倉庫指標

星標
 (2,920 顆星)
PR 合併指標
 (PR 指標待抓取)

描述

After running NC with NCP for more then a year with over 2 million files stored on it, I asked myself if the mysql/mariadb DB needs to be maintained? I searched the internet and the simplest solution I found was using

sudo mysqlcheck -o --all-databases

This reduced the DB size from around 950MB to a little over 800MB and NC seems to be a little more responsive (but this could homeopathic as well)

Any, would it make sens to extend NCP with an "DB Optimize" option?

5 Days after the optimization plus an upgrade to NC 16.0.4 I am still under 850MB. I am fetching the information via ocs_data_server_database_size provided by serverinfo.

貢獻者指南