Skip to main content



Many mysql processes "/usr/bin/mariadbd" and CPU at 100%,makes Friendica unstable


Hello @Friendica Support I need your support please
I have a problem for a few weeks now which makes my server unstable , and makes Friendica inaccessible, the simplest and fastest solution is to restart the server.
I noticed that this problem also happens to me when I send friend requests

Ubuntu Server 24.04 LTS
Friendica version 2024.08
mariadb Ver 15.1 Distrib 10.11.8-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper

As you can see from the screenshot there are many mysql processes , /usr/bin/mariadbd , and the CPU is at 100%

Some help please...

Thanks
Cheers

in reply to NeMyS

Have a look at your MySQL/MariaDB settings. It seems as if you could assign more memory to it. Have a look at the innodb settings. I can't really suggest any specific values, see here: mariadb.com/kb/en/mariadb-memo…
in reply to Michael Vogel

Hi @Michael Vogel
I tried to change my configuration /etc/mysql/my.cnf I added

[mysqld]

join_buffer_size = 2M
innodb_log_file_size = 1G
tmp_table_size = 512M
max_heap_table_size = 512M
wait_timeout = 60
max_connections = 500
skip-name-resolve
query_cache_size=64M
innodb_buffer_pool_size=4600M
key_buffer_size=1G
innodb_file_per_table=1
innodb_log_buffer_size=212M
innodb_buffer_pool_instances=5
innodb_flush_log_at_trx_commit = 1
innodb_flush_method = O_DIRECT
open_files_limit=40000
table_open_cache=2200
wait_timeout=28800
interactive_timeout=28800
max_connections=1000

This is the current configuration,I made small changes at a time, but the problem is the same (Bad Gateway Error 502), with the other configurations I had little RAM usage but the CPU was at 100% .

It could be an inefficient/Slow query? 🙄




The Apple Pencil on an iPad's bare screen feels awful :(



#UX
I'm a flip-the-toilet-roll-when-its-facing-inward kind of house guest.

There are rules.

#UX
in reply to Federico Mena Quintero

@federicomena It's relative.

Outside is almost always better and even the original intent (according to the patent* filing), but inner rolling supposedly prevents** cats (and toddlers) from unspiraling a roll of toilet paper across the entire bathroom.

* patents.google.com/patent/US46…

** en.m.wikipedia.org/wiki/Toilet…

Although there are other ways to cat-proof TP (requires woodworking skill): youtu.be/NnuzSl51y5c



I don’t know the last time I’ve set up a computer this quickly. This might be the quickest. The only thing I can’t figure out is the ad and remove programs interface is all weird now. You arrow to the app you want to uninstall and hit the overflow button, and then hitting uninstalled does nothing. How does anyone uninstall anything these days?
in reply to Allison Meloy

Windows+r and type appwiz.cpl. You can make a desktop or start menu shortcut pointing at that as well to quickly get there if you're averse to the Run dialog. In there, you can see all of your non-Windows Store applications and press enter on them to uninstall, or press the Applications key for more options. Much nicer, sometimes.


HP ink cartridge DRM bypass demonstrated using physical man-in-the-middle-attack

A tiny PCB installed on a refilled HP ink cartridge allows users to continue using it despite HP's strict DRM settings.
#hardware
tomshardware.com/peripherals/p…



Limited-time deal: EMEET 3 in 1 Webcam - 1080P Webcam with Microphone and Speakers, Noise Reduction, Auto Low Light Correction W/Cover, C980 Pro USB Camera Webcam 65°-90° for Video Conferencing Streaming/Gaming/Class a.co/d/gt9Cv1x a.co/d/gt9Cv1x


This is the PC I bought. You’ll either want to hook up a monitor or use a headless dongle. Beelink Mini PC, AMD Ryzen 7... amazon.com/dp/B0CRYN3HVS?ref=p… amazon.com/dp/B0CRYN3HVS?ref=p…



#ProblemasDePrimerMundo
Hay un disco que tengo en MP3 de baja calidad... no lo venden.. no está en torrent.. no esta en plataformas... hay un disco en acetato/LP/vinil en 🇨🇱 Chile... aunque decidiera pagar por el disco y el envío, no tengo como digitalizarlo..
discointrepido.cl/punto-de-ent…

de casualidad no hay alguien en #Santiago con un #tornamesa digital que quiera ayudar?

This entry was edited (1 month ago)


43 is a prime number.

I turned 43 today 🥳🎂 #birthday

I'm back in my prime! 😄



Has the shine on the new HP Spectre 360 worne off after a week? Not quite to me. I still get fairly good battery with light use all-day long, it's only about 10% heavier than my MBA 2017, slightly lighter than my MBP 2021, and in that week's time, very little news about Arrow Lake processors surfaced, beyond the fact that the desktop SKUs are canceled, because of course Intel. Really not happy with the slow progress, but need the CPU that's non-AMD for Mac OS virtualization.
This entry was edited (1 month ago)


due to a little refactoring mishap my Brainfuck compiler switched around the < and > commands, and this resulted in no test failures. I suppose this is obvious but it hadn't occurred to me
in reply to John Regehr

@wingo reminds me of that part in SICP where they show you can implement true and false with whatever the fuck values you want.
in reply to Federico Mena Quintero

@federicomena @wingo hilarious! I need to go back and reread that. I read it over a lazy summer when I was in college or maybe grad school, but I don't know that it really stuck


PSA: Git will read config and gitignore from your .config if they exist.

You can move the files at `~/.config/git/{config, ignore}`




He estado probando clientes de mastodon para IOS y el único que me ha convencido es Ice Cubes pese a que también tiene algún fallo como quedarse “sin conexión” de vez en cuando.
Me ha gustado Metatext pero no respeta los 1000 caracteres que me permite escribir mi instancia y se queda en 500.
Los que tenéis IOS, qué cliente utilizáis?


#PSA #PayPal is changing their privacy statement/terms of service starting November so that they can sell your information to merchants.

You CAN opt out, but you have to do it before they start:

Settings > Data & Privacy > Manage shared info > Personalized shopping, and toggle that shit off

ETA: this is probably country specific, due to differing privacy laws.

You can try privacy>settings>recommendations

Check replies, people have found the same toggle under a different header.

This entry was edited (1 month ago)


¿Apoyar la creación de un impuesto europeo sobre las grandes fortunas? Dónde hay que firmar? Aquí :ablobjam: tax-the-rich.es/

No hace falta firma digital, con número dni también. Y es una iniciativa oficial a nivel europeo, no un change.org

Joer, me ha llevado menos de 60 segundos y lo había retooteado muchas veces y aún no lo había firmado

Faltan pocos días y aún no se ha llegado al mínimo. No hagáis como yo y retooteis sin haber firmado antes, son 40 segundos 😅

#taxtherich

This entry was edited (1 month ago)


WTF is wrong with people worldwide?!

“#Austria's far-right Freedom Party is heading for unprecedented general election victory under leader Herbert Kickl: projections..based on initial results, give Kickl's party 29.1% - almost three points ahead of the conservative People's Party on 26.2%, but far short of a majority.

Freedom Party has been in coalition before, but the second-placed conservative People's Party has refused to take part in a government led by him”

bbc.in/3TOHeNI





This is an AMAZING deep dive into Chinese crypto and app based money laundering. Incredible really. The mechanics of it and the social aspects of how it all works. An ethnographic masterpiece

globalchinapulse.net/moving-br…

#China #MoneyLaundering #Crypto #DeepDive #Ethnography

This entry was edited (1 month ago)


Oh man! I was cringing for the poor guy just listening to this. What a pro.

In the 11 o'clock hour on Friday morning, an outage in the newsroom led to WBBM's signal coming off the air and news gathering systems going down. WBBM NEWSRADIO
Anchor Rob Hart was in the studio and brought people up to speed while things got running again. WBBM NEWSRADIO 780AM & 105.9FM is in Chicago, Illinois.
Owned by Audacy, Inc.

And while this was resolved quickly enough, it does raise some serius issues about how the public would be kept informed if some sort of sustained cyber attack was launched that took out newsrooms like this.

reshared this



Die Pandemie hat die #Kirche dazu genötigt, endlich digitaler zu werden. Warum wir jetzt nicht wieder ausschließlich zum Analogen übergehen sollten:
evangelische-aspekte.de/wach-b… #digitalekirche #kolumne #meinung
in reply to Evangelische Akademikerschaft

Ui, vielleicht hier gar nicht so einfach unmissverständlich und in aller Kürze umfänglich genug darzustellen...

Bei Kirchens sehe ich eine weite Spanne: Von der digitalen Totalverweigerung bis zu den Superhipstern.

Kleinere Gemeinden im ländlichen Raum sind mir vielleicht am nächsten. Da gibt es manche, die steht vor dem personellen Kollaps...

Praktische Unterstützung im digitalen Bereich vor Ort könnte ein Aufgabengebiet sein. Grundlegende Medien- und Digitalkompetenzvermittelung an konkreten Aufgaben, z.B. wie organisiert man eine Vorbereitungsgruppe für den Weihnachtsgottesdienst digital:

* Einsatz eines fairen Chatsystems für die Arbeitsgruppe
* Bearbeitung gemeinsamer Dokumente in einer selbstgehosteten Cloud des Kirchenkreises
* Nutzung von Trackingfreiem SocialMedia, nicht um 1000de Follower zu bekommen, sondern lokal ansprechend wahrgenommen zu werden
usw. usw.

Das alles auf eine Art und Weise und mit Tools, die beispielgebend sind für eine #selbstbestimmtDigital e Arbeit, in der wir unsere besonderen Skills auspielen, siehe z.B. hier:

procial.tchncs.de/notes/9yh18b…

in reply to FediVerseExplorer

Ein anderer Aspekt könnte praktische Unterstützung für Vernetzung sein:

Es gibt in D eine breitgefächerte, professionelle und trotzdem an der Basis gebliebene Szene, die sich für eine freiheitlich-demokratische #Digitalgesellschaft einsetzt.

Ich sehe #digitaleKirche nur in wenigen Ausnahmen in dieser Richtung konsequent unterwegs. @librechurch@kirche.social wäre eine solche Ausnahme.

Hin und wieder wird aus der Szene mal ein Speaker für eine Keynote zu digitaler Kirche eingeladen, aber die praktische Arbeit in den Gemeinden vor Ort (und auf höherer kirchlicher Ebene?) scheint mir sehr weit weg davon.



Mám pocit akoby som niečo domrvil ale nejak nemám mať prečo.


So I watched some train videos on YouTube recently and it did what YouTube does and suggested this gem which really needs more views. Why electric trains make the different sounds that they do with examples. youtube.com/watch?v=IRJIJPTUXX…


I had a friend in highschool who needed support and a place to live if he was to complete highschool. I asked my parents if we might be able to offer that support and it happened without hesitation.
We were definitely not wealthy.

Looking back on this years later, I realized how much that cost, but more importantly how much it taught both my friend and I about looking out for others and being kind.

It has shaped and guided much of my life.



Hey Siri, if I specify the artist of a song I request, playing anything from ANY artist that isn't that one is NOT a success case, even if metrics consider it a success.


gcc 14 is so strict now that lot of C developers are probably crying foul because their shit code no longer build.
This entry was edited (1 month ago)


Talk about a grotesque invasion of privacy:

"Smart TVs from Samsung and LG take screenshots of what you are watching even when you are using them to display images from a connected laptop or video game console"

newscientist.com/article/24491…

How can this possibly be legal?

Here's why: Congress isn't just indifferent to your privacy. It is actively complicit with big corporations -- and law enforcement -- in embedding surveillance into everything we do.

This entry was edited (1 month ago)


@winter conspiracy theory I heard some years back: major design trends, including and since Windows Phone 7, exist to accommodate product managers with no design experience who want to design interfaces and icons without leaving PowerPoint.
RE: pleroma.envs.net/objects/5c9fe…
in reply to Seirdy

i mean, think about it. the defining difference between UI design pre- and post-Metro/Material/iOS 7 is how easy it is to use office suite shape tools to prototype a UI.

i don’t think this theory is true but i want it to be since it explains everything.

in reply to Seirdy

notable exception: modern Google app icons are impossible for stereotypical PMs or good designers to dream up. a special third type of fucked-up creature was brought in.

someone at Google let the authors of their technical writing style guides write the icon design guidelines.

in reply to Seirdy

ok I think I made a joke that was just for me.

Google’s technical writing in practice isn’t actually that bad. the things the style guide chooses to be opinionated and lax on are just a bit odd. very lax on ambiguous terminology but opinionated about using contractions.

the joke I was going for was that the official app icons give me that exact vibe. very ambiguous, very different styles, yet somehow too coherent. it’s actually a bit unsettling.

Meet, Chat, TV, even Calendar: all empty rainbow squares that look the same. Prioritizing similar aesthetics over uniqueness.

Yet most older apps with an existing brand not tied to their empty-rainbow-outline icon guidelines seem recognizable: Classroom, Earth, Voice, YouTube (different palettes, not empty shapes). But some of these will likely join the graveyard of abandoned Google products.

New silly conspiracy theory: Google sunsets old products so they can be replaced by products with icons conforming to its newest icon guidelines.

This entry was edited (1 month ago)
in reply to Seirdy

the actual explanation: making it possible for an app developer to make a reasonably looking ui without needing a team of designers
in reply to Alice

@alice that sounds like a good goal but looking at current indecipherable icon styles i feel like some departments lost sight of it at some point.
in reply to Seirdy

I mean yeah, some icons are just bad

but e.g. from GNOME perspective that was absolutely the right move. At one point we had icons like this: 3.bp.blogspot.com/-UBhifwD1gzU…
Well, that's an idealistic lie. In reality, they were like this: news-cdn.softpedia.com/images/…
See, only about 3 people in the entire world knew how to draw icons in that specific style and it tooks weeks to make a single icon. Yeah, there were guidelines, but it's way too elaborate for anyone to bother, and so no one did. Every single third party app (except those jimmac/etc made an icon for personally) had crappy icons. I mean corebird on the second screenshot is actually a GNOME app.

So, we drastically simplified icons and made them very geometric, as well as got rid of all the 5 or 6 different sizes and just have a single svg per app. Result? Even the less polished apps have reasonable looking icons. I mean look at this: apps.gnome.org/ - there isn't a single app with a crappy icon there. (ok ok, being in circle already implies a baseline level of quality, but take a look at apps designed for gnome on flathub and it's same story there)

Same story for symbolics - some people were pissed that GNOME uses symbolic icons for apps instead of tango style, but like? I'm not an artist at all, and yet I managed to draw a bunch of these icons for highscore just fine. Previously I'd have to ask a designer.

And well - same for UI styles. Yeah, iOS 6 apps looked very very elaborate, but good luck doing that without an artist. The barrier of entry is so so much lower without an expectation that your app will use wood/leather textures (which were not a part of the platform btw! it was a custom thing in each app, unlike Mac OS X brushed metal)

in reply to Alice

@alice yeah i was thinking about like. official apps and components that progressively simplify the design at the expense of usability.

Apple honestly didn’t do nearly as badly here as MS did, but at least MS supports WHCM to put bring borders back so I can identify boundaries between components.

I’m biased. I really struggle with identifying boundaries without prominent borders or gradients, remembering icon purposes, etc. so I’ve mostly been noticing years of regressions that I’ve had to theme away.

in reply to Seirdy

@alice I think desktop Qt desktop apps have the right approach to icons by letting us choose to put text next to icons so we don’t have to know an icon’s purpose.


@MapComplete Could cafés be included in the restaurant category as well?
I'm often just looking for places to eat and don't care whether a place is officially labeled "café" or "restaurant".
I'd also really like to answer some questions about cafés which are currently restaurant exclusive like whether a place offers vegan food.

On the other hand, I've never looked for either a café or a bar at the same time

#MapComplete #OSM #OpenStreetMap



Please read the following article. It illustrates the extent to which discrimination against people with disabilities, their service animals, and people of color exists today, even with the supposed protections of the Americans with Disabilities Act (ADA. Uber Almost Got Me Killed! nfb.org//images/nfb/publicatio…



📣 Sei unser #A11y und unterstütze den Zugang zum !@metalab für Menschen mit Sehbehinderung oder Blindheit! Komm zum Do-It-Blind (DIB) Treffen 🛠️ am Montag, 30. September, Treffpunkt Ring-Passage U3-Station Volkstheater um 16:00; Ende 20:00 metalab.at/calendar/event/7625… #make #blind #inklusion
in reply to Oskar

Ich finde diese Initiative einfach großartig! 🤩 Metalab für Menschen mit Sehbehinderung oder Blindheit zugänglich zu machen, ist ein so großer Schritt in Richtung Inklusion. 🌈 Ich wünschte, ich könnte teilnehmen.

PS
Hast du die Braille-Tastatur selbst 3D-gedruckt?

in reply to Debby

@Debby Danke! Die Braille-Tastatur haben wir entwickelt und selbst 3D-gedruckt. defineblind.at/post/metabraill…



If it’s actually true that WordPress only makes $23K a year from donations that really puts the idea that donations are a sustainable open source business model to bed. It powers 40% of the web and only receives a fraction of one person’s salary in return. Ouch. werd.social/@ben/1132170023499…

#opensource

This entry was edited (1 month ago)


Russian law could ban the child-free lifestyle.

Russians who promote 'child-free movement' could soon face hefty fine, Putin says woman's purpose is to birth children and basically, being childless is a threat to national security and state longevity

They are trying to consolidate that the woman’s role boils down to exclusively bearing children

Now we know where JD Vance got his anti cat woman, pro birth woman talking points #USPol
nbcnews.com/news/world/russia-…

This entry was edited (1 month ago)


***** Where AI excels *****

Obviously, to anyone familiar with my missives on these topics, I am extraordinarily critical of generative AI systems. I won't bend your ear (or eyes) with the details in this message. My stance on this is clear enough.

BUT, I do want to emphasize that my concerns are almost entirely with generative AI, not with AI in general.

First: I don't worry about "evil AI systems" taking over the world or exterminating humanity. Great sci-fi plots though. The most evil AI in film I know of is the computer from "The Invisible Boy" (1957). I mean, that is one really, really nasty AI, who turns Robby the Robot into his slave. Jeez. But these are fantasies.

One sector where AI really excels is in analysis of patterns. Medical diagnostics. Speech recognition. A long list where these machine learning systems are just vastly better than humans at dealing with masses of data and extracting key insights from them. Sidenote: I really enjoy watching the #Google speech recognition system at work, as it quickly corrects, capitalizes, and in other ways "homes in" on utterances as your continuing speech provides more context. I'm pretty constantly amazed at how it picks up on what I would consider to be subtle cues.

In any case, the distinction between this kind of AI and generative AI is not made frequently enough or clearly enough by the mass media at least, with so much attention on generative AI these days.

And it's a very important distinction to keep in mind.

L

This entry was edited (1 month ago)