Skip to main content

Since a few days sometimes my #mariadb load spikes to 140, anyone else see this, it just takes 1 minute and normalizes again. till now I was to slow to capture the mytop view, just the end of such thing in this capture.

When it is over the load normalizes at 0.8 again.

@Steffen K9 🐰 did you experience anything like that? I saw it twice, once yesterday and just now.
@Michael Vogel any idea what happens?

#friendica !Friendica Support

#friendica #MariaDB @Michael Vogel @Steffen K9 🐰 !Friendica Support

Friendica Support reshared this.

utzer [Friendica]
utzer [Friendica]  
•
@Michael Vogel@Steffen K9 🐰 ah, I think the yellow line it the last of the hundreds of queries... but not sure. I will try to catch it next time.
@Michael Vogel @Steffen K9 🐰
Steffen K9 🐰
Steffen K9 🐰  
•
You can configure 'mytop' to hide the sleeping connections. Maybe that helps.
Steffen K9 🐰
Steffen K9 🐰  
•
Not recently. The current RC code runs very smoothly here.
Steffen K9 🐰
Steffen K9 🐰  
•
The database queries that were problematic for me have been fixed already. I can't complain at the moment. :-)
Steffen K9 🐰
Steffen K9 🐰  
•
create a file .mytop in your users home. Put this line idle=0 into that file.
utzer [Friendica]
utzer [Friendica]  
•
@Steffen K9 🐰 addee it, complained it can't connect to mysql, rm .mytop, tried again, still can't connect. Worked before. Buffled now. @Michael Vogel
@Michael Vogel @Steffen K9 🐰
⇧