MySQL database question

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

Hi Eric.

im not a SQL guy, but i have tried to fill out, but i get this error :frowning:

/Kristian

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.

Hi Eric.

Thats working, got this back

/Kristian

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