social.stefan-muenz.de

Search

Items tagged with: database

Hello #Friendica Admins,
mysqltuner.pl wants me to set "innodb_buffer_pool_size (>= 20.7G)", which is probably because of the #database size. I assigned 20 GB #RAM to the VM and have 20 GB #SWAP too. So setting it that high is not possible, as this would bring the total max #memory usage way beyond 40 GB.

Questions:
1. Why is the total max usage higher than this setting? What is the multiplicand parameter?
2. Any idea how I can set this to use 16 GB for #MySQL all the time, allow double in peak and (swapping then) and not more?

I think I will change the setup at some point which will free more RAM for #mariadb, but now I need to cope with it like it is. I see loading time it really bad with low settings for "innodb_buffer_pool_size", like 0.4 seconds over all, more RAM reduces it by 70%... but then I get omm (out of memory) problem.

!Friendica Admins
 
#PerconaLive is a community-focused event for #database developers, administrators, & decision-makers to network with peers and technology professionals, and we’re looking for YOU to join us as a speaker! Learn more https://cfp.percona.com/ #MySQL #MongoDB #PostgreSQL #opensource #community #cfp #conference
Bild/Foto
 
#Percona Server for #MongoDB 4.4.3-5, Percona #Backup for MongoDB 1.4.1 and Percona Distribution for MongoDB 4.4.3 have been released: https://www.percona.com/software/mongodb

#opensource #database
 
Bild/Foto

What's the Best Way to Set Up a Discussion Group in The Fed?


So, a few of us are still thinking of breaking from #Discogs and I've been asked to set up some way of us discussing and collaborating via the #Fed. I'm the only one with an account here up to now, but it fits with the #cooperative style of the new #music #trading #marketplace we're planning. So if you have any ideas or are interested in #vinyl #records #vinilo, #discos #CD #musique #disques #schallplatten #collecting #buying #selling #database #contributions and all the other formats, please contact me. Our intention is to run said cooperative model whereby all users are a part of the #coop i.e able to share in the dividend. I put forward the idea that #contributors might also be considered as users and so beneficiaries of the dividend, but everything is in v. early stage. Any help will be most welcome.
 
Bild/Foto

What's the Best Way to Set Up a Discussion Group in The Fed?


So, a few of us are still thinking of breaking from #Discogs and I've been asked to set up some way of us discussing and collaborating via the #Fed. I'm the only one with an account here up to now, but it fits with the #cooperative style of the new #music #trading #marketplace we're planning. So if you have any ideas or are interested in #vinyl #records #vinilo, #discos #CD #musique #disques #schallplatten #collecting #buying #selling #database #contributions and all the other formats, please contact me. Our intention is to run said cooperative model whereby all users are a part of the #coop i.e able to share in the dividend. I put forward the idea that #contributors might also be considered as users and so beneficiaries of the dividend, but everything is in v. early stage. Any help will be most welcome.
 

Database Cleanup

Hello @Friendica Support,

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
⬡ The database is the protocol. Reflections on a 20 year tradition of re-inventing the wheel.
Caleb James DeLisle

Live Q&A Recording https://conf.tube/videos/watch/852e2b13-27dc-4d02-a03b-28ae8e597385
Debate in the Forum https://socialhub.activitypub.rocks/t/the-database-is-the-protocol-reflections-on-a-20-year-tradition-of-re-inventing-the-wheel/950
Watch the Talk https://conf.tube/videos/watch/ccad21f7-6bc7-489e-886f-ba0fb8d20647

From UseNet to ActivityPub, every #protocol solves the same problems over again.
• How do we discover #nodes ?
• How do we deal with network #partitions ?
• How do we define bad behavior and how do we prevent it?

#storage #database #sql #apconf2020
 
⬡ NoSQL Databases and ActivityPub
Brad Koehn

Live Q&A Recording https://conf.tube/videos/watch/b6a04bec-45ac-429d-9299-8453552bd0a8
Debate in the Forum https://socialhub.activitypub.rocks/t/nosql-databases-and-activitypub/939
Watch the Talk https://conf.tube/videos/watch/ff168b1a-46d2-40e3-935b-452ee7da3b9f

Implementing an ActivityPub #server can be daunting, but one way to make it easier is by using a #NoSQL database.
In this talk, I’ll lay out the way my server uses NoSQL to provide high-performance, highly-scalabale #storage for ActivityPub objects.
#performance #scalability #database #activitypub #apconf2020
 
NoSQL Databases and ActivityPub

Brad Koehn

Implementing an #ActivityPub server can be daunting, but one way to make it easier is by using a NoSQL database.

In this talk, I’ll lay out the way my server uses NoSQL to provide high-performance, highly-scalabale storage for ActivityPub objects.

VIDEO
https://conf.tube/videos/watch/ff168b1a-46d2-40e3-935b-452ee7da3b9f

Q&A session SAT 13:00 UTC
remote questions also:
https://socialhub.activitypub.rocks/t/nosql-databases-and-activitypub/939

#storage #database #nosql #apconf2020
 
The database is the protocol.
Reflections on a 20 year tradition of re-inventing the wheel.

Caleb James DeLisle

From UseNet to ActivityPub, every protocol solves the same problems over again.
How do we discover nodes?
How do we deal with network partitions?
How do we define bad behavior and how do we prevent it?
[…]

VIDEO
https://conf.tube/videos/watch/ccad21f7-6bc7-489e-886f-ba0fb8d20647

Q&A session SAT 17:30 UTC
remote questions also:
https://socialhub.activitypub.rocks/t/the-database-is-the-protocol-reflections-on-a-20-year-tradition-of-re-inventing-the-wheel/950

#storage #database #protocol #apconf2020
 
Hello, je cherche des comptes/tags à suivre, dans les domaines des #musiques actuelles, #jazz, #fusion, #progrock, #metal, mais aussi des #bassistes, #beatmakers, etc. Je m'intéresse aussi aux #computers, #database, #infosec, #libre, etc. Enfin adore la #moto sous toutes ses formes, la #montagne, la #glisse. Anyone pour me recommander des pages sur ces sujets, en anglais ou en français ? #Facebook #escape #help
 
Hello, je cherche des comptes/tags à suivre, dans les domaines des #musiques actuelles, #jazz, #fusion, #progrock, #metal, mais aussi des #bassistes, #beatmakers, etc. Je m'intéresse aussi aux #computers, #database, #infosec, #libre, etc. Enfin adore la #moto sous toutes ses formes, la #montagne, la #glisse. Anyone pour me recommander des pages sur ces sujets, en anglais ou en français ? #Facebook #escape #help
 
Hello, je cherche des comptes/tags à suivre, dans les domaines des #musiques actuelles, #jazz, #fusion, #progrock, #metal, mais aussi des #bassistes, #beatmakers, etc. Je m'intéresse aussi aux #computers, #database, #infosec, #libre, etc. Enfin adore la #moto sous toutes ses formes, la #montagne, la #glisse. Anyone pour me recommander des pages sur ces sujets, en anglais ou en français ? #Facebook #escape #help
 
And that is why one should take a look at one's backups:
The supposedly copied database might not be there at all.

#Backup #Database #DBA #DBMS
 
There is a #coalexitlist by #urgewald, means another database which could be very interesting for our #fediverse project.
Sadly we need to register to use this database, means it's not #opendata as we wish.
The search engine #ecosia uses this #database to show us a small icon that shows websites that support #coal companies.
They also use other organizations to label websites, but there are less information available on these databases.

Sources:
https://de.blog.ecosia.org/grune-suche/
https://coalexit.org/
 
Yay .. now again i'm installing a #PostgreSQL #database server..... 😎

Live without #SQL is #possible but #meaningless...

#randomshit ;)
 

The SQL Murder Mystery


#SQL #mruder #database
 
Later posts Earlier posts