ɯɟʇɹ (nprofile…akxd) Friendica Support (nprofile…xmvk) I would log into your mariadb on your server laptop by using sudo mariadb -u root -p, enter the password, then enter the following in the mariadb client you just logged in to, to show the current size:
SHOW VARIABLES LIKE 'innodb_buffer_pool_size';
(The semicolon at the end is required!) To change it, in the same mariadb client, you can enter:
SET GLOBAL innodb_buffer_pool_size = 2G;
The can exit the mariadb client by typing quit;
JB Carroll /
npub17a…5pm2a
2025-03-29 20:30:50
in reply to nevent1q…rtr5
Author Public Key
npub17ahu7djsy07s2kgsajwf8uf6x58wzk8290ncp4zf2ygfdvlwu47qj5pm2aSeen on
wss://relay.mostr.pubPublished at
2025-03-29 20:30:50Event JSON
{
"id": "e3eafec3dbee8479ee99a71d13cde791219fd6b7951c48f2d4407e085cc69d36",
"pubkey": "f76fcf365023fd055910ec9c93f13a350ee158ea2be780d449511096b3eee57c",
"created_at": 1743280250,
"kind": 1,
"tags": [
[
"p",
"06d5ab92a1cb968abbb4e2f8f7ca9b80e6d356cbf466891a169b84a0e7be8d0d",
"wss://relay.mostr.pub"
],
[
"p",
"15b7758904cd6ec9c4d780aed7cca01019b61be45945dea8a68e2d2322a45ecd",
"wss://relay.mostr.pub"
],
[
"p",
"cbdf7b879293cc1fc111a8430a62942b699e8e470c41981a537b2a43ee54bb4f",
"wss://relay.mostr.pub"
],
[
"p",
"08e210217b9bf22ce53ebf1e27b5ed8dc9db28dc1d82f1f4575eee7b3a76743a",
"wss://relay.mostr.pub"
],
[
"p",
"f76fcf365023fd055910ec9c93f13a350ee158ea2be780d449511096b3eee57c",
"wss://relay.mostr.pub"
],
[
"e",
"5cc1f4c611e1f0cecdb9e5c0e73d6e6c46f8b7454ed7dfe9c93681edc134f3e7",
"wss://relay.mostr.pub",
"reply"
],
[
"proxy",
"https://friendica.jb-net.us/objects/052e3994-2067-e858-7ab2-145079461022",
"activitypub"
]
],
"content": "nostr:nprofile1qy2hwumn8ghj7un9d3shjtnddaehgu3wwp6kyqpqqm26hy4pewtg4wa5utu00j5msrndx4kt73ngjxsknwz2pea735xsnrakxd nostr:nprofile1qy2hwumn8ghj7un9d3shjtnddaehgu3wwp6kyqpqzkmhtzgye4hvn3xhszhd0n9qzqvmvxlyt9zaa29x3ckjxg4ytmxsavxmvk I would log into your mariadb on your server laptop by using sudo mariadb -u root -p, enter the password, then enter the following in the mariadb client you just logged in to, to show the current size:\n\nSHOW VARIABLES LIKE 'innodb_buffer_pool_size';\n\n(The semicolon at the end is required!) To change it, in the same mariadb client, you can enter:\n\nSET GLOBAL innodb_buffer_pool_size = 2G;\n\nThe can exit the mariadb client by typing quit;",
"sig": "b37162afd0b2b2f18d0b09ff0059e12bbf370786d1826c802df4829ccaf726db10d85f0f3a953bb0f05d805f284a96adebd4c70edbce23a3e1168415344f0c62"
}