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]
Als Antwort auf ɯɟʇɹ • • •@ɯɟʇɹ 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.
Friendica Support hat dies geteilt.
VegOS
Als Antwort auf ɯɟʇɹ • •Cătă mag das.
Friendica Support hat dies geteilt.
ɯɟʇɹ
Als Antwort auf VegOS • • •@vegos_f06
On the same machine I have immich (an application to manage photos) and I see no access problems. To access /settings or /notifications is slow, but never given me a 504 error.
I thought that reducing the period of time to retain information from external abandoned accounts or forgetting messages from other instances might help improve speed, but nothing.
If increasing the amount of RAM for PHP from 128MB to 256MB would have any effect?
JB Carroll
Als Antwort auf ɯɟʇɹ • • •Friendica Support hat dies geteilt.
ɯɟʇɹ
Als Antwort auf 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
JB Carroll
Als Antwort auf ɯɟʇɹ • • •@ɯɟʇɹ @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;Friendica Support hat dies geteilt.
TekNo ⚝ aEvl
Als Antwort auf ɯɟʇɹ • • •Friendica Support hat dies geteilt.
TekNo ⚝ aEvl
Als Antwort auf ɯɟʇɹ • • •ERROR 1232 (42000): Incorrect argument type to variable 'innodb_buffer_pool_size
Friendica Support hat dies geteilt.
TekNo ⚝ aEvl
Als Antwort auf 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
Als Antwort auf ɯɟʇɹ • • •Friendica Support hat dies geteilt.
TekNo ⚝ aEvl
Als Antwort auf TekNo ⚝ aEvl • • •+-------------------------+------------+
| Variable_name | Value |
+-------------------------+------------+
| innodb_buffer_pool_size | 2147483648 |
+-------------------------+------------+
1 row in set (0.001 sec)