Hi, i have used next cloud for 3 month now, i have stored 33gb data - but the SQL database is all ready at 55gb - all in all my 33gb used almost 100gb, do anyone know if thats correct or do i have a error on mySQL database?
That doesn’t seem right… my cloud has been running for over a year, I currently store almost 300GB, and my DB size is only around 120MB. Did you check the DB size using this query?
SELECT table_schema "nextcloud", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB", sum( data_free )/ 1024 / 1024 "Free Space in MB" FROM information_schema.TABLES GROUP BY table_schema
Can you try copying and pasting the query from my post? From the screenshot it looks like you missed some underscores. SELECT Table schema should be SELECT table_schema, etc.
I would look at which tables are using up all that space. I could be wrong, but that does not look right. Try looking at how large each individual table is using this query, and particularly look for any tables that don’t belong:
SELECT TABLE_NAME, table_rows, data_length, index_length,
round(((data_length + index_length) / 1024 / 1024),2) "Size in MB"
FROM information_schema.TABLES WHERE table_schema = "nextcloud_db"
ORDER BY (data_length + index_length) DESC