SAF = Slow As F***

Why is this thing so slow again?

Negged.....(I keed).
IZ SLOOOOOOOW

My way of dealing with it all is I open 4 tabs, and while one thread is loading, I read another. Hope this helps.

Didn’t say it did. I would guess it is related to WHM and it’s background processes.

Found an interesting bottleneck and tried an experiment that seems to have helped (converting the session table from MEMORY to InnoDB). Seems like a bad idea, but things got better instantly, so...we'll see.

Does seem quicker.
You the man face
Sunday is double time, too!

I mostly just try to experiment without breaking stuff. :)

Suddenly MUCH better, thanks DaFace

Nicely done. It's exponentially quicker now. Actually not noticing any significant lag.

Any of the tables that are constant write to should be converted to InnoDB. If they are primary read only tables the MyISAM.

I hereby name the server........SYBIL.

This is the best post you have ever had.

Well, whatever you did worked. It was like a glacial flow this morning.

I get that for most tables, but the session table is almost universally believed to be best as a MEMORY table. But I did some reading that suggested InnoDB might be better for relatively high-use servers, and we basically have the whole DB read into RAM at this point anyway, so I figured I'd give it a go.

I don't fully understand WHY it worked, but it certainly seems to be making a difference. The backups are still doing their thing in the background, and our CPU load is a little elevated, but I'm hopeful that we're chipping away at the various bottlenecks.

FWIW, AC told me that PHP 7.1 is on the radar (which requires a slight update to vB 3.8.11 as well). The rest of the stuff is up to date at this point.