|
08-25-2019, 12:59 PM | #406 |
Starter
Join Date: Feb 2013
Casino cash: $8194907
|
SAF = Slow As F***
|
Posts: 737
|
08-25-2019, 01:01 PM | #407 |
Admitted Planet Junky
Join Date: Oct 2000
Casino cash: $2091627
|
Why is this thing so slow again?
__________________
Fanaticism is nowhere. There is no tenderness or humanity in fanaticism. |
Posts: 19,195
|
08-25-2019, 01:02 PM | #408 |
Supporter
Join Date: Apr 2004
Location: North Central Kansas
Casino cash: $4766131
|
|
Posts: 10,662
|
08-25-2019, 01:06 PM | #409 |
...
Join Date: May 2002
Location: Kansas City, MO
Casino cash: $2232295
VARSITY
|
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: 27,716
|
08-25-2019, 01:20 PM | #410 |
Starter
Join Date: Jun 2019
Casino cash: $10000400
|
|
Posts: 574
|
08-25-2019, 01:53 PM | #411 |
Kind of a mod
Join Date: Aug 2005
Location: Donkey Land
Casino cash: $2056899
|
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: 51,749
|
0 1 |
08-25-2019, 01:57 PM | #412 | |
MVP
Join Date: Aug 2000
Location: nemo
Casino cash: $1719900
|
Quote:
You the man face Sunday is double time, too!
__________________
"Mr. seclark. Wrong for gravy, wrong for jelly, wrong for biscuits." -rj "If every Planeteer who was disliked by another Planeteer stopped being a Planeteer we wouldn't have any Planeteers." -rj |
|
Posts: 13,399
|
08-25-2019, 01:58 PM | #413 |
Kind of a mod
Join Date: Aug 2005
Location: Donkey Land
Casino cash: $2056899
|
|
Posts: 51,749
|
1 0 |
08-25-2019, 01:59 PM | #414 |
pie is never free
Join Date: Sep 2006
Location: the drivers seat
Casino cash: $3757775
|
Suddenly MUCH better, thanks DaFace
|
Posts: 91,634
|
08-25-2019, 02:00 PM | #415 |
...
Join Date: May 2002
Location: Kansas City, MO
Casino cash: $2232295
VARSITY
|
Nicely done. It's exponentially quicker now. Actually not noticing any significant lag.
|
Posts: 27,716
|
08-25-2019, 02:11 PM | #416 |
Starter
Join Date: Jun 2019
Casino cash: $10000400
|
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
Casino cash: $2801110
|
I hereby name the server........SYBIL.
__________________
"The only difference between sex for free and sex for money is that sex for free costs you a WHOLE LOT more!" ~Redd Foxx~ "The men who drafted Patrick Mahomes" |
Posts: 50,426
|
08-25-2019, 02:24 PM | #418 |
Starter
Join Date: Jun 2019
Casino cash: $10000400
|
|
Posts: 574
|
08-25-2019, 02:40 PM | #419 |
WE ARE THE CHAMPIONS
Join Date: Aug 2000
Casino cash: $3155085
|
Well, whatever you did worked. It was like a glacial flow this morning.
|
Posts: 119,484
|
08-25-2019, 02:46 PM | #420 | |
Kind of a mod
Join Date: Aug 2005
Location: Donkey Land
Casino cash: $2056899
|
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: 51,749
|
|
|