Core_Sessions Crashing Database

[TimTheMiles]

Hello IPS Users,

So our Core_Sessions Table is around 1.57 GB and keeps causing our Database to Crash.
Do you all know of a way we could go about fixing this?

I did some research and apparently there is a way to truncate?
Hope to hear from you all

[bfarber]

That table should be nowhere near 1.57GB. It holds the current active sessions - even on the largest sites, that size isn't really possible unless you have other server configuration issues going on.

I would recommend restoring the default PHP configuration for session handling (specifically the garbage collection-related settings) if you've adjusted them. Beyond that, you can truncate the table by running

TRUNCATE TABLE core_sessions