11
geekwright
Re: Many users admin->users timing out, mysql pegged at 100% CPU

That is great news!

Thank you for bringing this issue to our attention, and reporting your results.

Since you reported this, I've observed several sites where the problem queries are taking quite a bit of resource to complete. None are extreme enough to grind to a halt, but obviously they are using way too much. Eventually, left unchanged, I'm sure they will run out of something and start failing. Xoops.org is one of those, and mamba does a good job of keeping us honest with the "eat our own dogfood" strategy -- most of the time, especially near releases, we are running the newest code from the head once it has passed local testing.

Next step, I'll use that 2.5.4 system I started up to test the upgrade for 2.5.11. Waste not, want not as my mother used to say.

Thanks again.

12
rossb
Re: Many users admin->users timing out, mysql pegged at 100% CPU
  • 2021/3/23 14:13

  • rossb

  • Just popping in

  • Posts: 77

  • Since: 2006/8/28


@geekwright

FYI; reverted to old db 300000K+ users, 100K never logged in. Your changes still work.

...B

13
DrakenJ35J
Re: Many users admin->users timing out, mysql pegged at 100% CPU
  • 2021/4/23 17:02

  • DrakenJ35J

  • Just popping in

  • Posts: 2

  • Since: 2021/4/23


Thanks, I had similar issues with users timing out (which was especially problematic when they're supposed to stay logged on for extended periods of time as Xoops is one of our working tools...), clearing the cached did the job!

Login

Who's Online

163 user(s) are online (79 user(s) are browsing Support Forums)


Members: 0


Guests: 163


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits