I’ve decided to upgrade old Nextcloud 12 which I was using for a while to version 13 but I’ve experienced some issues. I think the problem is caused by big oc_filecache table so upgrade is stuck 48+ hours.
mysql> show table status like "oc_filecache"\G;
*************************** 1. row ***************************
Name: oc_filecache
Engine: InnoDB
Version: 10
Row_format: Compressed
Rows: 14387677
Avg_row_length: 136
Data_length: 1970176000
Max_data_length: 0
Index_length: 2412077056
Data_free: 1476395008
Auto_increment: 32926128
Create_time: 2019-08-09 20:43:11
Update_time: 2019-09-10 23:33:55
Check_time: NULL
Collation: utf8mb4_bin
Checksum: NULL
Create_options: row_format=COMPRESSED
Comment:
1 row in set (0.00 sec)
-rw-r----- 1 mysql mysql 5.5G Sep 10 23:33 oc_filecache.ibd
Is there anything I can do about this problem?