Search
Items tagged with: database
How long have you been on diaspora*, how did you discover it, and what features of this social network stand out to you?
#diaspora #pods #socialnetwork #social #hello #hola #newhere #newuser #freedom #freesoftware #fediverse #podmin #question #publish #home #account #database #network #users #network
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
);Running the last query triggers the error
Foreign key constraint is incorrectly formed. Is there no way to reference multiple tables in foreign keys out of a compound primary key?#SQL #Database #DBA
Soapbox insists on having the #config be in the #database but when that's set Pleroma/Akkoma refuses to start.
Anyways, too tired right now to mess with it. Will have to look into it more tomorrow.
Database size
about a week ago my database grew massively, from about 11GB to over 20GB. I assume that it is related to this pull-request (10484). Is this normal or is there something that did not work properly when updating the database?
#Friendica #database
Database Cleanup
how can I check if the database cleanup works even if I have enabled database cleanup in the settings? My Databas is growing and growing an i do not know, why.
#friendica #database