A New... 7/2/26... Update From Kestryll

[TrappedinCalifornia]

At 3:56 pm today, Kestryll posted this to an OT thread on .net - https://www.calguns.net/forum/general-discussion/the-off-topic-discussion-lounge/54927853-calguns-is-fixed?p=54928528#post54928528 ...

Let's not get ahead of ourselves. I was finally able to hire a DB engineer to look at our database and he found several things going on and looks to have fixed them.
However we still have an issue that is coming out of the software. This is from the DB guy:
"The table cacheevent is growing too quickly and too large. vBulletin keeps continuously high-concurrency writing into this table, which is causing deadlocks frequently.
I cleaned the table today, but it grows back to millions of rows in a few hours."

vBulletin's initial answer seems to be 'You need to pay for an upgraded license.' I'm seriously kicking myself for choosing to update vB from where we used to be to this instead of switching to SMF or Xenforo.

We're doing better and moving forward but not where I want us to be yet.

So, the machinations weren't, quite, what the pinned headline indicated, but efforts were, in fact, being made.

There has been an improvement in performance, not to mention site availability.  But, as was noted, we're not quite out of the woods yet.

Getting there though... 

[TrappedinCalifornia]

I'll have to assume Librarian is aware of that post given his own post... https://www.calguns.net/forum/general-discussion/the-off-topic-discussion-lounge/54927853-calguns-is-fixed?p=54928891#post54928891

Re the cacheevent table ...

In vBulletin (especially v4/v5/v6), the cacheevent table is part of the built-in database caching system.
Purpose
It stores cache invalidation events - basically "tags" or markers that tell the system when cached data needs to be refreshed or cleared.

• vBulletin caches a lot of frequently used data (forum nodes, user info, settings, templates, etc.) in the cache table to improve performance.
  The cacheevent table tracks events (like "this node was updated" or "a post was added") that should trigger cache clearing for related items.
  This is an event-driven invalidation mechanism so the software doesn't serve stale data after changes.

How It Works (Simplified)

• When something changes (e.g., a thread is updated), vBulletin inserts a record into cacheevent.
  On subsequent page loads, the system checks cacheevent to see if any cached items are outdated → if so, it rebuilds/clears them from the cache table.

Common Issues

• This table (along with cache) can grow very large on busy forums → leading to slow queries, table locks, or crashes.
  Admins often TRUNCATE (empty) both cache and cacheevent tables during maintenance, server moves, or performance tuning. It's generally safe to do (the system will repopulate them as needed).

You can safely clear it via AdminCP → Maintenance → Clear Cache ...

ETA VB does not like something in X formatting - the quoted stuff is from Grok.

The above is slightly modified due to the differences between .net and .org in terms of what they accept.

As you can see, I still didn't get the formatting quite right; thus, the hyperlink.