Performance (1 Viewer)

pete

chronic procrastinator
Staff member
Since 1999
Thread starter
Joined
Nov 14, 1999
Messages
59,114
Solutions
3
Location
iPanopticon
Website
thumped.com
only a very shitty query would cause that. So could be a sign of a DDOS. Maybe boards dot ie are trying to sabotage.

if its running in a jvm and that jvm only has a max of 5GB heap assigned to it, it will tank rather than use the free memory on the system.
Mysql (well, MariaDB) is Just another system process on here. If I got enough concurrent connections and enough slow queries it could peak but realistically I’d imagine something else would fail long before the database started to complain, ha.
 

rettucs

Well-Known Member
Supporter
Joined
Apr 18, 2006
Messages
24,436
Solutions
2
Location
Post of the week winner: 22nd March, 2013
Mysql (well, MariaDB) is Just another system process on here. If I got enough concurrent connections and enough slow queries it could peak but realistically I’d imagine something else would fail long before the database started to complain, ha.
Aye, true.

Is it a system process controlled by systemd? Any chance of another htop screenshot?

Btw what outstanding issues are there? Performance has seemed pretty good to me.
 

pete

chronic procrastinator
Staff member
Since 1999
Thread starter
Joined
Nov 14, 1999
Messages
59,114
Solutions
3
Location
iPanopticon
Website
thumped.com
Aye, true.

Is it a system process controlled by systemd? Any chance of another htop screenshot?

Btw what outstanding issues are there? Performance has seemed pretty good to me.
Yeah it’s calmed down now. I bumped the number of php-fpm Max Children ("The number of PHP-FPM processes to spawn to process PHP code for web server requests") from the default of 5 to 20 so instead of it maxing out and hanging when the previous Max Requests ("Controls how many requests are served by a process (Max Children) before killing and spawning a new process." - default is 20) x Max Children limit of 100 is hit it should now last until 400 (20 children x 20 processes).

The only outstanding issue/problem is i the fact still don't know what caused this change in behaviour.

But on a more positive note this has all made me go back and fix a ton of stuff i'd been ignoring.



1653556044589.png


[OK] Maximum reached memory usage: 13.7G (58.77% of installed RAM)
[!!] Maximum possible memory usage: 45.0G (192.58% of installed RAM)
[!!] Overall possible memory usage with other process exceeded memory
 
Last edited:

pete

chronic procrastinator
Staff member
Since 1999
Thread starter
Joined
Nov 14, 1999
Messages
59,114
Solutions
3
Location
iPanopticon
Website
thumped.com
@scutter you might find this interesting. i've just restarted the database server (a few times heh) so might not be representative

1653560898217.png
 

rettucs

Well-Known Member
Supporter
Joined
Apr 18, 2006
Messages
24,436
Solutions
2
Location
Post of the week winner: 22nd March, 2013
@scutter you might find this interesting. i've just restarted the database server (a few times heh) so might not be representative

View attachment 15731

guessing the relative spikes are due to the restarts then.

nothing jumping out at me that might signify a problem. Obviously those slow queries warrant further investigation but other than that, the mystery remains.
 
New posts

Users who are viewing this thread

21 Day Calendar

Lightning Bolt
Whelans
25 Wexford St, Portobello, Dublin 2, D02 H527, Ireland
Panikatax, Chimers (Australia), Fierce Shook, Carpark Sci-fi
Bello Bar
1 Portobello Harbour, Saint Kevin's, Dublin, Ireland
Kurt Vile & The Violators
Vicar Street
Vicar St, Saint Catherine's, Dublin, Ireland

Latest Activity

Loading…

Support thumped.com

Support thumped.com and upgrade your account

Upgrade your account now to disable all ads... If we had any... Which we don't right now.

Upgrade now

Latest posts

Trending Threads

Latest threads

Top