TIL that the "My" in MySQL is not the English word my but the Swedish name My, for the daughter of #MySQL co-founder Michael Widenius. ♡

The name My was introduced by Tove Jansson for the #Moomins character Little My, who is named after the Greek letter mu.

So you could pronounce My as [ˈmyː] or as [maɪ].

Never mind how to pronounce SQL.

MySQL documentation defines the official #pronunciation as “My Ess Que Ell” but the devs in Swedish say "mü-ess-ku-ell".

Sources in reply.

#linguistics

@Hiker

Ist es #MySQL oder #MariaDB?

Zumindest bei #MyISAM sollte auch via #SQL ein #OPTIMIZE funktionieren...

@feb @zwovierzwo

CREATE TABLE IF NOT EXISTS `user` (
	`uid` mediumint unsigned NOT NULL auto_increment COMMENT 'sequential ID',
	...
	 PRIMARY KEY(`uid`)
);
CREATE TABLE IF NOT EXISTS `gserver` (
	`id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID',
	...
	 PRIMARY KEY(`id`)
);

CREATE TABLE IF NOT EXISTS `user-gserver` (
	`uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Owner User id',
	`gsid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'Gserver id',
	...
	PRIMARY KEY(`uid`,`gsid`),
	FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE,
	FOREIGN KEY (`gsid`) REFERENCES `gserver` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE
);

#Friendica needs new contributors!

I'm not used to do this, but with the large influx of new users and node admins recently coming from #Twitter, our small team is now behind the curve for handling support requests, bug reports and bring about much-needed features.

The project is built on a #PHP / #MySQL platform, but we also need people to be able to assist others just using the software to give developers some space.

If you're willing and able to help, please follow @Friendica Support and the project on Github: https://github.com/friendica/friendica

Thank you!

GitHub - friendica/friendica: Friendica Communications Platform

Friendica Communications Platform. Contribute to friendica/friendica development by creating an account on GitHub.

^GitHub

Mai 28 03:10:26 friendica mariadbd[553]: 2021-05-28  3:10:26 0 [Warning] InnoDB: A long semaphore wait:
Mai 28 03:10:26 friendica mariadbd[553]: --Thread 139676422764096 has waited at row0upd.cc line 179 for 465.00 seconds the semaphore:
Mai 28 03:10:26 friendica mariadbd[553]: S-lock on RW-latch at 0x55a2a8136178 created in file dict0dict.cc line 1041
Mai 28 03:10:26 friendica mariadbd[553]: a writer (thread id 139674262697536) has reserved it in mode  wait exclusive
Mai 28 03:10:26 friendica mariadbd[553]: number of readers 1, waiters flag 1, lock_word: ffffffff
Mai 28 03:10:26 friendica mariadbd[553]: Last time write locked in file dict0stats.cc line 2487

ylms_friendica.item-activity
note     : Table does not support optimize, doing recreate + analyze instead
status   : OK

ylms_friendica.item-content
note     : Table does not support optimize, doing recreate + analyze instead
error    : Duplicate entry '' for key 'uri-plink-hash'
status   : Operation failed