"popularity-contest"? On a #Ubuntu #server? Freshly installed? Without notice?
Guys, seriously. Installing some kind of software "just because we can" during OS deployment is Microsoft-style. Honestly I do not care if it runs without further configuration or whatever, but a by-default enabled cron job is enough for me to take further action.
This is exactly what causes computer security issues. Dropping software on users without need nor confirmation. Please. Don't be #Microsoft.
With the help of mysqldumpsql -s at -t 10 -a I found some slow SQL queries the current develop code causes: SELECT `id` FROM `contact` WHERE (`network` IN ('dfrn', 'dspr', 'stat', 'apub', 'zot!', 'unkn') AND `self` = 0 AND `id` IN (SELECT `cid` FROM `post-tag` WHERE `cid` = `contact`.`id`) AND (`last-update` < '2022-06-24 18:39:07' OR (NOT `failed` AND `last-update` < '2022-07-17 18:39:07'))) LIMIT 100 This query took over 70 seconds which is WAY to slow (as it also keeps the FPM child process busy and unable to process another request). An EXPLAIN gives me following extra information: - table contact: Using index condition; Using where - table post-tag: Using index; FirstMatch(contact)
It looks already optimized but is still so slow. Another one I came across:
SELECT `account_type`, COUNT(*) AS `count`
FROM `profile` p
JOIN `server` s ON s.`id` = p.`server_id` AND s.`available` AND NOT s.`hidden`
WHERE p.`available` AND NOT p.`hidden` AND p.`region` LIKE 'foo%'
GROUP BY p.`account_type`
ORDER BY `count` DESC
Which is caused by Friendica Directory. The query now runs fast but has an infamous Using where; Using temporary; Using filesort on the table s (server) which MAY slow it down. But the next one hits the jackpot of most-used tables in a single query: SELECT `uid`, `id`, `parent`, `guid`, `network`, `gravity`, `uri-id`, `uri`, `thr-parent-id`, `thr-parent`, `parent-uri-id`, `parent-uri`, `commented`, `created`, `edited`, `received`, `verb`, `object-type`, `postopts`, `plink`, `wall`, `private`, `starred`, `origin`, `parent-origin`, `title`, `body`, `language`, `content-warning`, `location`, `coord`, `app`, `rendered-hash`, `rendered-html`, `object`, `allow_cid`, `allow_gid`, `deny_cid`, `deny_gid`, `mention`, `global`, `author-id`, `author-link`, `author-name`, `author-avatar`, `author-network`, `author-updated`, `author-gsid`, `author-addr`, `author-uri-id`, `owner-id`, `owner-link`, `owner-name`, `owner-avatar`, `owner-network`, `owner-contact-type`, `owner-updated`, `causer-id`, `causer-link`, `causer-name`, `causer-avatar`, `causer-contact-type`, `causer-network`, `contact-id`, `contact-uid`, `contact-link`, `contact-name`, `contact-avatar`, `writable`, `self`, `cid`, `alias`, `event-created`, `event-edited`, `event-start`, `event-finish`, `event-summary`, `event-desc`, `event-location`, `event-type`, `event-nofinish`, `event-ignore`, `event-id`, `question-id`, `question-multiple`, `question-voters`, `question-end-time`, `has-categories`, `has-media`, `delivery_queue_count`, `delivery_queue_done`, `delivery_queue_failed` FROM `post-user-view` WHERE ((`uid` = N OR (`uid` = N AND NOT `global`)) AND `uri-id` IN (N, N, N, N, N, N, N, N, N, N, N, N, N, N, N, N, N, N, N, N) AND `visible` AND NOT `deleted` AND NOT `author-blocked` AND NOT `owner-blocked` AND (NOT `causer-blocked` OR `causer-id` = N OR `causer-id` IS NULL) AND NOT `contact-blocked` AND ((NOT `contact-readonly` AND NOT `contact-pending` AND (`contact-rel` IN (N, N))) OR `self` OR `gravity` != N OR `contact-uid` = N) AND NOT EXISTS (SELECT `uri-id` FROM `post-user` WHERE `uid` = N AND `uri-id` = `post-user-view`.`uri-id` AND `hidden`) AND NOT EXISTS (SELECT `cid` FROM `user-contact` WHERE `uid` = N AND `cid` = `author-id` AND `blocked`) AND NOT EXISTS (SELECT `cid` FROM `user-contact` WHERE `uid` = N AND `cid` = `owner-id` AND `blocked`) AND NOT EXISTS (SELECT `cid` FROM `user-contact` WHERE `uid` = N AND `cid` = `author-id` AND `ignored` AND `gravity` = N) AND NOT EXISTS (SELECT `cid` FROM `user-contact` WHERE `uid` = N AND `cid` = `owner-id` AND `ignored` AND `gravity` = N)) ORDER BY `id` DESC This one causes also the same infamous Using index condition; Using where; Using temporary; Using filesort over the table post-user and is really scary to see.
cc !Friendica Admins what I'm facing here is, that a lot fpm child processes are being started, causing the whole web server to slow down and most of them come from my Friendica instance.
I'm currently upgrading to #Devian 4.0. If you are already on #Beowulf just replace bewulf with chimaera. Your resulting /etc/apt/sources.list should then have these lines:
deb http://deb.devuan.org/merged chimaera main
deb http://deb.devuan.org/merged chimaera-updates main
deb http://deb.devuan.org/merged chimaera-security main
#deb http://deb.devuan.org/merged chimaera-backports main
This upgrade also includes an upgrade from PHP 7.3 to 7.4.
Remember when you get stuck updating #SearX you might have to rm -rf ~/searx-ve to get rid of the old environment. So just run ./manage buildenv again.
System Administrator Appreciation Day am Freitag, den 29. Juli, ab 19 Uhr im Hacklabor in #Schwerin. Mal Danke sagen an die Leute, die den Laden am Laufen halten. Mit Ansible-Vortrag “Automatisierung ist des Admins bester Freund" hacklabor.de/2022/07/SysAdminD…
@Pascal That's a single #Invidious instance. I use the redirector (invidio.us still works) to balance load over all instances and not just one and a playlist so you can continue on watching more.
Legale Reklame und illegale Spam sind zwei Seiten der gleichen wertlosen Münze – genau so, wie die Lüge des Werbers und die Lüge des Betrügers aus dem gleichen vergammelten Holz geschnitzt sind.
Sahra Wagenknecht - Gegen die neoliberale Linke Die Selbstgerechten. Mein Gegenprogramm – für Gemeinsinn und Zusammenhalt.
Sahra Wagenknecht war von 2015 bis 2019 Vorsitzende der Bundestagsfraktion der Partei Die Linke, die bei den Wahlen 2017 mehr als 9 % der Stimmen erhielt. Zwei Jahre später trat sie offiziell aus Stressgründen zurück. Es gibt jedoch viele, die vermuten, dass ihre Entscheidung durch das allmähliche Abgleiten ihrer Partei in diese Form des "progressiven Neoliberalismus" motiviert war, der mittlerweile alle westlichen Linken infiziert zu haben scheint und der laut Wagenknecht den schwersten Stein für die Linke zu werden droht (zur Erinnerung: bei den Wahlen 2021 halbierte die Partei, die nun in den Händen der liberal-progressiven Strömung ist, ihre Stimmen: ihr schlechtestes Ergebnis überhaupt). Genau diesem Linksdriften ist Wagenknechts neues Buch-Manifest gewidmet. Die zeitgenössische westliche Linke - so prangert der Autor an - hat Begriffe wie Klassenkampf und Kampf gegen Ungleichheiten inzwischen auf den Müllhaufen der Geschichte geworfen und ist zu einer "modischen Linken" geworden: ein Lebensstilvorrecht einer kleinen Elite - vertreten durch die neue Mittelschicht der Universitätsabsolventen aus den Großstädten - und inspiriert von den Dogmen des Kosmopolitismus, des Globalismus, des Europäismus, des Multikulturalismus, des Umweltschutzes, des Identitarismus und der politischen Korrektheit. Eine Elite, die zur Verarmung der Mittelschicht und zur Ausbeutung der Arbeitnehmer nichts zu sagen hat, die nicht nur die Interessen der Globalisierungsgewinner vertritt, sondern die Verlierer, d.h. die Arbeiterklasse und ihre Werte, offen verachtet und als faschistisch, rassistisch, rückschrittlich, sexistisch, nationalistisch und populistisch beschimpft. Eine Elite, die in Bezug auf Wahlen immer kleiner wird, aber dennoch eine sehr starke Hegemonie über die Medien und die Welt der Kultur ausübt. Im Gegensatz zu dieser Linken der Privilegierten entwirft Sahra Wagenknecht eine radikal andere Vision für eine Linke, die wieder in der Lage ist, die Volksschichten zu vertreten und mit ihnen zu sprechen: ein Gegenprogramm, das sich auf Werte stützt, die nicht individualistisch, sondern gemeinschaftlich sind - einschließlich der von den zeitgenössischen Progressiven verabscheuten Begriffe wie Heimat, Gemeinschaft, Zugehörigkeit - und das in der Lage ist, die Identität nicht mehr einer intellektuellen Minderheit, sondern einer aus konkreten Personen bestehenden Mehrheit zu definieren. Damit legen wir den Grundstein für die Schaffung einer gerechteren Gesellschaft.
First of, I don't like #POC at all, because since when is my skin color not a fucking color? And how about Chinese people, from the Northern areas, they have a very bright skin color. And how about Russian people, a lot have "white" skin color there, too. I found POC very racist.
But okay, if these #self-righteous #woke want to have #TikTok for their own, so be it. Let's all quit TikTok (I'm my myself have no account there).
So here is the video, that #OdinsMen has analyzed:
@jec That's not hate-speech what I nor #OdinsMen do. You call everything "hate-speech" what does not 100% reflect your view. The narrator is actually trying to move along with #woke #LGBTQ people and never have shown any hatred towards them, neither do I. He (and I) tried understand the logic behind what these kind of people are saying. If you came to this conclusion, you never watched any of his videos (and I could easily say that in regard to #JordanPeterson 's videos and arguments he gave). Wishing someone having cancer (and die painfully) is obviously more hateful than what he or I did. So how can I possibly be a racist while my girlfriend comes from an African country, hmm?
#Woke say, that also trans-men can be #pregnant, not realizing that trans-men are biological women until the #uterus is being medically removed, then technically spoken, that person is a human with no reproductive organs. Woke don't understand that only adult female humans (definition for a #woman ) can have babies because they have the proper organs to do so.
So who do you think will win the #Olympics of Morons?
PS: Don't feel anger, try to logically understand what they say and see the world. Try to move a bit along with them, but don't get dragged into the long way down to insanity (which never ends).
More #woke #trans-man things that men can be #pregnant, while only women can. But since trans-man = man and trans-woman = woman, what can you see to them without being called #transphobic? #Narcissism is rampant again:
And: #Woke agenda has ruined a woman's voice to no repair (right red-colored one). Do they think a lesbian or a straight woman wants to date them now? They are ruined for the doctor's sake (costs all a lot of money, beyond repair).
And "old"-school #lesbian is speaking out about the "new" ABC mafia #woke , listen what she has to say: BTW: Also the doctor is speaking honest words about to early vaccinations. And the woman from the thumbnail is basically hating White #straight men (like I am).
The #drag-queen on the left speaks out truth against #Grooming your children and NOT bring them to #LGBTQ #pride festivals because they are going to see "things that belong into the bedroom", as she says. The #gay on the right also is like her minded, good that not all LGBTQ are groomers.
Listen to the 2nd-last one, #Joey who was a naturally born woman but tried to to turn into a man (trans-man) but failed completely. Even the simple act of peeing is a nightmare to Joey.
"Modern" #feminism make women like the #African lady here feel unwanted and undesired because it turns them (not her, she has realized it in tears) into #toxic and lonely people: My #respect goes out to all of these women, wanting to do the home chores and cooking for our whole family.
Feminism was once a powerful word to represent women for basic yet powerful portrayal of women strength and portrayal of what we women can do . But now feminism is just men hating men loathing cringe worthy some kind of thing that makes my ears bleed .
Another #woke #trigender (don't listen to them, they just take pieces of obscured history to "reason" it): There is nothing it between men and women, #non-binary means mentally ill. I get along with inter-sexual, who actually have 2 sexes, penis and vagina, at the same time. But that's only <0.1%. #GenitaliaMatter #StopErasingSex #SexIsReal #SexNotGender
A similar percentage will be actually transgender, like <0.1%
The rest are following a trend because:
1. It is the one way hwite men can compete in terms of victimhood with minorities, LGBT, and women 2. Egalitarian societies are victimhood olympics and this gives them #2 pity status 3. Socialized medicine pays for it all and makes them a big deal where they would otherwise be unexceptional
Cut out the free stuff and equality, problem goes away.
#woke #Karen want to make you feel bad when they are around, no matter if they are white, black, old, young, #trans , it doesn't matter: And: If you don't agree with #BLM #BankLocalMilfs, you are a racist and fuck off.
The #woke cult wants you to not mind what your sex/gender is, unless it is abortion: #queer teacher are the worst for children, they don't teach them stuff that really matters, like #mathematics, #history or what a man and what a woman is and how society actually works. They just indoctrinate these pool children, like you have seen now when a trans-dad has tried to brainwash "his" (her) daughter into believing that she is a boy. I feel sorry for these kids, not the grown up ones with their woke cult and #pronouns-theater.
#trans-woman demands you pay for their #trans-kids mental illness and go with their pronouns or they leave your country, does this makes sense to you? You cannot make these people happy, don't even start listening to their repeated talking points.
#woke #POC (I hate this phrase, because it is anti-white (Chinese/Russian included? They are White, too, but not Western ...) freak out: Best comments:
"When you're born you get a ticket to the freak show. When you're born in America you get a front row seat." --the late, great George Carlin
The black lady behind these "stunningly brave" talkers (narcissistic) just embarrasses herself, nodding all nonsense talking points off. This is what they want from you, just nod it off and blindly agree with it, so you cancel yourself and become a miserable and in anger dying person. #StrongIndependentWoman
These narcissistic people hate local citizens, happens here in #Germany, too. They want to rebuild your (white-supremacist country) into their vision, where you don't exist. They blame white people who brought them there. And again all the stupid talking points, like #racism and some "phobia".
@panelfmedia And which exact laws are these? Name book, and paragraphs when you make such statements. False accusations are a crime here in Germany, you know this?
The account @panelfmedia@social.vivaldi.net is now instance-wide blocked. He seem to disagree with what I post from #OdinsMen and then threatens me later on with "expect consequences". Wow, so brave of him. Not.
His childish journey continues not realizing that he is blocked here. And how can I be a #racist while I date an African woman and getting to know her family and culture? And that "transphobic" slur against me, they get my point. I only date love women, not trans. I don't have a weird fetish that wants a man who looks like a woman, wears a wig, pretends to be a woman and still has a penis down there. I'm not into that weird fetish. Just stop calling a #trans-woman as woman, they aren't. #StopErasingWomen #StopErasingSex
There is no room for discussion with these brainwashed people, they label you #cis when they want to shame on you, only when you say that you are a man or a woman. They will say: "No, you are a cis-man or a cis-woman. You don't know what a man/woman is! But I know it but cannot tell you because I keep bragging about myself, how stunning and brave I am."
#trans-woman says why they cannot have periods and why these #woke lunatics are all mental and crazy:
It is physically, medically and biologically impossible for a trans-gender woman like myself to have a period because we do not have uterus(es) therefore we cannot she a(n) uterine lining. We do not have ovaries, how the fuck is a menstruation? Cause it isn't. Trans-women cannot get periods, period!
See, this is why I don't associate with the fucking community (woke ABC mafia) because you are all crazy. But you come out with the dumbest fucking bullshit, man. Seriously, like envision 2 parallel lines right now, right in front of you. One of these lines is the lives and struggles of cis-gendered women and one of these other lines is the lives and struggles of trans-women. Now, we may go through the same struggles, we may go through some of the same problems but we're different. We are womenhumans but we all have different lives. We all have different struggles and we all have our differences, yeah okay. ...
Listen on over there! But a lot true things (I stroke some out I disagree with, as I'm a man and that's biologically also a man).
#StopErasingWomen , they are not bleeders, or chest-feeders, uterus-owners, they are not cis (neither am I a cis-gendered man, I'm a man) because that's disrespectful: #DylanMulvaney is the most aggressive promoter and indoctrinator (I created it from indoctrination) for of this woke shit going on, right in front of our own eyes. Not yet over here in #Germany but that won't last long.
I never asked for being called "cis", so stop calling us that way. #ManNotCis #WomanNotCis #StraightDontFuckWithTrans . Go, get yourself a real life and wake up from your woke dreamland.
I’m a woman. Full stop. How is asking NOT to be called cis ANY different than asking someone to use chosen pronouns? Actually, it IS different. I didn’t choose my pronouns, God did, please respect that.
Sub comment:
It's not different but they crazy. So they refused to listen to anything you have to say but demands you listening to everything they had to say.
BTW: I'm in my manhood for 16,571 days by now. So I don't have to say anything of being a heterosexual man? No, nothing? Go fuck yourself, #woke #lunatics !
Old woman tells #DylanMulvaney how it is being a woman on a farm, sure she stays home and takes care of her grandchild, Dylan will never have and call his own: If you talk or write about it, it is #hate-speech , if you do not think what these #woke ABC mafia lunatics tell you, it is a #thought-crime, if you don't magically agree with then, that women can have penises and men can give birth, too (because they try to change the definition of what a woman or a man is), you are #transphobic and a bad person, period. All of this mounts in nothing short but emotional extortion.
#trans woMAN with a groomer flag (aka. trans-flag) demands money for his teeth and voice: Plus: Professional athlete speak up against #transgender ("men bodily individual") in competition with (biological, real) women. These woke woMEN don't want to have own division, they just say: "I'm a woman, with a female penis. Accept me or you are misogynist and #transphobic!" And: SIMP aka. "Stay-at-home" man does all the work a wife does. But if a wife does, she is oppressed and needs to be freed by woke feminists. Get it? If she is on #OnlySimps aka. #OnlyFans she is stunning and brave and sexually freed.
Due to 2 strikes to #OdinsMen 's all channels, I will from now on link to videos from #Rumble and not #Youtube anymore. But it costs me more time as following there isn't possible through any proxy-following like I did with #Invidious .
#Black bitter woman was brainwashed by the "Goddess of #Wokism ". She will turn miserable when she turns old: So she is the biggest victim, right? Fat Black woman? Maybe even trans? Biggest victim of "white-supremacy". #Narcissistic person she is!
I got my first apartment when I was 21. I looked 16. I went across the street to the deli to but something. The guy behind the counter asked me if I was new to the neighborhood. I said yes, that I'd just moved in across the street. I asked him about safety on the street, garbage pick-up, etc. He asked me what my parents do and which highschool I was going to. I laughed, told him I'd recently graduated from college and had my own place across the street. He laughed, apologized. It was so not a thing.
It was not a problem that the man thought I looked to young to have my own place. It was SO not a microaggression or any kind of an aggression. It was actually helpful to me to know that I looked like a high-school kid so I knew I might want to dress differently to look more like a grown-up. These people need to stop with this BS.
And:
"I'm not your friend I'm your parent" is EXACTLY the relationship parents should have with their kids. Respect is EARNED. This is the reason kids are ruling their parents these days.
Also:
The Home Depot employee might have been concerned that the woman was being taken advantage of if she rented. But oh no it has to come from a place of racism not real concern. 😕
#woke lunatic wants you to "use your eyeballs" and nod off their stupid #pronouns-theater : #queer #non-binary "individual" (she is a woman, our minds don't bend around that stuff they talk about) needs to seek help, not exposing their craziness on us.
#woke diversity sucks and here is why: Put functional people into such positions, not because they are so "diverse". Also the #Pronouns-Circus is touring again.
#POC #ShowTime #Woke Anti-White TV shows like these are not there to heal, they are there to hurt and make you fight at each other without any real reason. They want to divide people further into White/POC and they started with destroying family. Just cancel your subscription with ShowTime or any of these woke shows.
There is so much tabloid BS on TV and shows like these are one of them and vert aggreesive on you. They try to push you in that direction that your minds will comply with what they want. So you start hating other people you never met and don't know. Terence McKenna once said it very clearly what this type of media is there for:
"Stay the fuck away from that tabloid bullshit, reality tv, the news channels feeding you fear and hatred, lulling your unique human consciousness into a materialistic slumber only useful for selfish gain and the aggrandization of the ego which is ultimately an illusion and which will never be satisfied no matter what you buy. This gratification is and will always be transcient, so don’t buy shit you don’t need, don’t hate people you don’t know, and most importantly, don’t spend your precious time on Earth consuming garbage styled as entertainment."
#trans woMEN should never go in #sports competition against women because that's no competition at all. It is unfair to women due to their body mass and muscle (men have ~60% more muscle mass).
#woke lunatic thinks that the word "woke" is derogatory when used to describe them:
#LGBTQ+ Jeffery is a pedophile, trying to disconnect children from their parents, what pedophiles actually do so they have full control over their victims.
I'm being called insecure and the usual transphobic/homophobic slur only because of I have a different opinion what a woman is (= adult female human):
And:
I won't stop you from chopping of your penis, go ahead and do it. I won't stop you from wearing whatever you want to wear. I won't stop you from where ever you want to stick your dick in, as long as it is with #consent . Enjoy sucking your partner's dick, I don't care. Live your life happily and best way possible. But stop preying on people who feel offended by you (no straight man wants to suck your dick). Rules are universal, respect is ALWAYS earned!
#woke #polyamorous people are fun to watch on #TikTok : JT asked: When you are the first one and a 3rd persons enters your relationship, do you still feel loved as before?
They want to "normalize" this again, by calling it "natural". No, the most natural human way is to have a #commitment and #monogamous relationship for easily make offspring (children) and also lesser jealousy is created in it.
#Afro-American people being #racist towards White people, the lady isn't 100% Black, she has a White mother: You cannot fight #racism with racism, you cannot take out a fire with fire.
How does this help us all heal/fix things as humans? Personally, I hate no white people - are there things in all races that need fixing absolutely but at the end of the day we all must live on this earth & if we do not come together and ignore the people trying to keep us apart, we will not accomplish so much.
I'm a gay millennial male and I hate what the lgbt community has become. They talk down to you and call you all kinds of phobes. It's really annoying.
Even don't try to be an ally of these woke #trans , if you don't agree with them, you are #transphobic #misogynist . And don't accept #cis-gendered , never accept it!
#Muslim woman's car has been damaged by (so far) unknown group, she thinks it is the crazy/#woke leftist mob that found her videos somehow "phobic": The corridor of allowed (by these crazy leftists) talking points is getting tighter and tighter each year and on an accelerating speed. Start saying "No, I don't agree with you!", don't be afraid to raise your voice, you are not alone. #Trans
Now the #woke mob sent threats to the #Muslim woman. #Straight woman sides with #JeffreyMarsh and has been brainwashed to think he (I don't go with they/them for him) is okay: Stop doing that, nobody deserves threats for just raising their voice. And it isn't #transphobic at all!
You do not apologize enough for these people, they gas-light you, commit defamation and doxxing on you and get away with it: Please never give up speaking for your point of view, with that and that's what they want, to silence you, until #AlJazeera stepped in:
#queer #non-binary "individual" (she is a woman, our minds don't bend around that stuff they talk about) needs to seek help, not exposing their craziness on us.
Roland Häder🇩🇪
in reply to Roland Häder🇩🇪 • •fpmchild processes are being started, causing the whole web server to slow down and most of them come from my Friendica instance.