|
08-25-2019, 12:59 PM | #406 |
Starter
Join Date: Feb 2013
|
SAF = Slow As F***
|
Posts: 750
|
08-25-2019, 01:01 PM | #407 |
Admitted Planet Junky
Join Date: Oct 2000
|
Why is this thing so slow again?
|
Posts: 19,409
|
08-25-2019, 01:02 PM | #408 |
Supporter
Join Date: Apr 2004
Location: North Central Kansas
|
|
Posts: 10,757
|
08-25-2019, 01:06 PM | #409 |
...
Join Date: May 2002
Location: Kansas City, MO
|
My way of dealing with it all is I open 4 tabs, and while one thread is loading, I read another. Hope this helps.
|
Posts: 29,055
|
08-25-2019, 01:20 PM | #410 |
Starter
Join Date: Jun 2019
|
|
Posts: 574
|
08-25-2019, 01:53 PM | #411 |
Kind of a mod
Join Date: Aug 2005
Location: Donkey Land
|
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.
|
Posts: 52,457
|
0 1 |
08-25-2019, 01:57 PM | #412 | |
MVP
Join Date: Aug 2000
Location: nemo
|
Quote:
You the man face Sunday is double time, too! |
|
Posts: 13,438
|
08-25-2019, 01:58 PM | #413 |
Kind of a mod
Join Date: Aug 2005
Location: Donkey Land
|
|
Posts: 52,457
|
1 0 |
08-25-2019, 01:59 PM | #414 |
pie is never free
Join Date: Sep 2006
Location: the drivers seat
|
Suddenly MUCH better, thanks DaFace
|
Posts: 94,534
|
08-25-2019, 02:00 PM | #415 |
...
Join Date: May 2002
Location: Kansas City, MO
|
Nicely done. It's exponentially quicker now. Actually not noticing any significant lag.
|
Posts: 29,055
|
08-25-2019, 02:11 PM | #416 |
Starter
Join Date: Jun 2019
|
Any of the tables that are constant write to should be converted to InnoDB. If they are primary read only tables the MyISAM.
|
Posts: 574
|
08-25-2019, 02:18 PM | #417 |
Politically Incorrect
Join Date: Feb 2009
Location: Scottsdale, AZ
|
I hereby name the server........SYBIL.
|
Posts: 52,396
|
08-25-2019, 02:24 PM | #418 |
Starter
Join Date: Jun 2019
|
|
Posts: 574
|
08-25-2019, 02:40 PM | #419 |
WE ARE THE CHAMPIONS
Join Date: Aug 2000
|
Well, whatever you did worked. It was like a glacial flow this morning.
|
Posts: 120,029
|
08-25-2019, 02:46 PM | #420 | |
Kind of a mod
Join Date: Aug 2005
Location: Donkey Land
|
Quote:
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. |
|
Posts: 52,457
|
|
|