Hi @helpers
My instance is very slow and in 4 out of 5 calls it shows me the typical 504 error
The instance was installed with the help of Yunohost on an old laptop with 4GB RAM, 500GB hard disk and according to htop, it almost never exceeds 500MB RAM overall load
I have disabled infinite scroll and I have lowered just to 5 messages per page the timeline
What else can I do?
PS: The 504 is almost always on /network, /community and the circles pages
Jools [Friendica]
in reply to ɯɟʇɹ • • •@ɯɟʇɹ Translated with DeepL:
I was able to detect the error “504” in my instance when I made a database backup and had not previously activated the maintenance mode in Friendica.
Then there were problems with the connection to MariaDB and just such 504 errors.
VegOS
in reply to ɯɟʇɹ • • •JB Carroll
in reply to ɯɟʇɹ • •Friendica Support reshared this.
ɯɟʇɹ
in reply to JB Carroll • • •@jbcarroll
The truth is that I have no idea about databases.
How can I query the current size of that variable?
How can I assign the new value to it?
Thank you very much
@helpers
Friendica Support reshared this.
JB Carroll
in reply to ɯɟʇɹ • •@ɯɟʇɹ @Friendica Support 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;TekNo ⚝ aEvl likes this.
Friendica Support reshared this.
TekNo ⚝ aEvl
in reply to ɯɟʇɹ • • •Friendica Support reshared this.
TekNo ⚝ aEvl
in reply to ɯɟʇɹ • • •ERROR 1232 (42000): Incorrect argument type to variable 'innodb_buffer_pool_size
Friendica Support reshared this.
TekNo ⚝ aEvl
in reply to TekNo ⚝ aEvl • • •MariaDB [(none)]> SHOW VARIABLES LIKE 'innodb_buffer_pool_size';
+-------------------------+-----------+
| Variable_name | Value |
+-------------------------+-----------+
| innodb_buffer_pool_size | 134217728 |
+-------------------------+-----------+
1 row in set (0.001 sec)
TekNo ⚝ aEvl
in reply to ɯɟʇɹ • • •Friendica Support reshared this.
TekNo ⚝ aEvl
in reply to TekNo ⚝ aEvl • • •+-------------------------+------------+
| Variable_name | Value |
+-------------------------+------------+
| innodb_buffer_pool_size | 2147483648 |
+-------------------------+------------+
1 row in set (0.001 sec)