Database Size almost 20GB!

alt=
@andrusito
4 years ago
298 posts
It has come to my attention my database size is 19,635.56 MB!

Is there a way to bring the size down? Where should I start to look?
updated by @andrusito: 22 Dec 2018 09:30:50PM
michael
@michael
4 years ago
7,550 posts
look in the database to see what is large.
ACP -> MODULES -> DEVELOPER TOOLS -> TOOLS -> DATABASE ADMIN
alt=
@andrusito
4 years ago
298 posts
Thank you SO much!

I found out the cache table was about 17GB!

now I have these... is there a way to empty the data inside JR?

jr_jrcore_log_debug InnoDB utf8_unicode_ci 272 269 312
jr_jrcharts_history InnoDB utf8_unicode_ci 66 600 960
jr_jruser_item_key InnoDB utf8_unicode_ci 32 079 872
jr_jruser_session InnoDB utf8_unicode_ci 1 581 252 608
michael
@michael
4 years ago
7,550 posts
The debug log from:
ACP -> DASHBOARD -> ACTIVITY LOG -> DEBUG LOG -> DELETE DEBUG LOG

Nothing usually goes in there unless you've put fdebug(?????) into your code to direct it there though, so may pay to take a look at what is getting logged. or delete it and see what comes back.

The others I would have expected would go away with the integrity check.
ACP -> MODULES -> CORE -> SYSTEM CORE -> TOOLS -> INTEGRITY CHECK -> (check all the options) -> RUN.
alt=
@andrusito
4 years ago
298 posts
Thank you, Michael.

I deleted the debug log by going to the location you mentioned and also did another integrity check... but the numbers are the same, nothing was deleted...

Is it safe to delete the info there using Tools / Database Admin?
michael
@michael
4 years ago
7,550 posts
jr_jrcore_log_debug This is the ? on the right side of the ACTIVITY LOG. Deleting the activity log clears this out.

jr_jrcharts_history This is your charts history. If you have any charts on your site "most popular for the last 7 days" type thing, deleting this will remove that data and charts will no longer work until the data is built up again.

jr_jruser_item_key This is the main datastore for your users. Deleting this will cause all your users to be deleted.

jr_jruser_session This is the user session. Deleting this will cause any users logged in to be logged out and they will have to log back in again.

Dont DELETE them, use TRUNCATE instead to just empty those you want to empty.
alt=
@andrusito
4 years ago
298 posts
Thank you so much for the detailed explanation, that is VERY useful.

However, I still see data inside the log debug table... or that's what I think it is... take a look:
Screenshot (118).png
Screenshot (118).png  •  275KB

Screenshot (117).png

michael
@michael
4 years ago
7,550 posts
Delete your activity log. If it doesnt go away with that one, truncate the table.
ACP -> DASHBOARD -> ACTIVITY LOG -> EMPTY ACTIVITY LOG
alt=
@andrusito
4 years ago
298 posts
Thanks! That did bring the data down.

is there a way to clean these?

jr_jrcore_cache (more than 600MB)
jr_jruser_session (about 1,5 GB)(You said "... Deleting this will cause any users logged in to be logged out... but on certain times there are no users logged in)
michael
@michael
4 years ago
7,550 posts
Both of those are just temp tables, you can truncate them.
Strumelia
Strumelia
@strumelia
4 years ago
3,601 posts
Andrusito, once you're done with all that.... there's also an additional tool to reduce the size of images that have been added to your site by users.
Go in your ACP to:
Core->image support->tools->resize item images
then use the drop down menu to reduce the size of your user's images in the various modules, such as Audio, image galleries, Comments, etc.
I do this every few months to catch and reduce the size of my members' uploaded images... the ones that somehow slip by my usual limit settings.


--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015

Tags