database update

the database is fixed. 😌

what happened? that’s complex.

recently, i had my web site redesigned. the new design uses the “Enfold” theme, which uses a lot of what they call “transients” to maintain the look and feel of the site, regardless of the platform on which it’s being viewed. “transients” are sort of like cookies, except that you can’t opt out of them, and they don’t contain any personally identifying information. some of these “transients” expire immediately when a person leaves the web site, and others persist, for a few minutes to several days. they persist on your computer AND on my server… in the one of the tables in the database…

the “Enfold” theme has automatic caching and garbage collection routines that are supposed to handle these expired “transients”, but, because it’s a wordpress theme, it doesn’t do all the jobs very well… or, sometimes, at all… which is why i also use a caching plugin that actually, you know, works ALL the time, and not only some of the time… 😒

except that, for some reason, prior to my site upgrade, “someone” (and i have yet to identify who, but it was either my web designer or my host provider) recommended that i disable the caching plugin, because of some issue with the new version of wordpress… or something like that… as i said, i don’t remember. i distinctly remember disabling the plugin on someone’s recommendation, i just don’t remember exactly who, when or why. 😖

one way or the other, my caching plugin was disabled, which meant that, when i installed the new theme, it was relying on the not-working-the-way-it-should, internal cache… which, basically, didn’t work, causing the table in the database to expand beyond my disk space allocation. 🤯

it didn’t show up in my cPanel because i wasn’t looking at the SQL disk space, which is “below the fold” of my browser, and i just didn’t scroll down far enough to see it. 😕 during the nightly automatic backup, it was overwhelming the server for everybody, not just me. i had to pay my web designer for two days of poking through piles of arcane SQL code and deleting bits and pieces of it. it was not fun.

the solution was to enable the caching plugin(!), and to install a “transient manager” plugin, so that i can delete the expired transients from the wordpress dashboard, and not from the SQL database,… which requires A LOT more “knowing what to look for” and “knowing how to delete stuff without damaging other stuff” than i have on board, personally.