Good day,
I'm currently running latest Znuny stable (6.5.*).
We noticed performance drops and think we traced it to tickets with Email signatures containing many images.
Seems if you have a mail conversation with Emails that contain many images, and replies multiplying this, the database is getting hammered.
Each image seems to be a database connection.
I have a few questions about migrating to ArticleStorageFS.
* I'm wondering if switching to ArticleStorageFS would also include these images, and result in much less database load?
* I found documentation for 7.1 ( https://doc.znuny.org/znuny-7_1/standar ... index.html ), but not for 6.5.*. are the steps the same? Does documentation exist for 6.5?
Thanks for anyone offering insights.
ArticleStorageFS migration questions - Database load question
Moderator: crythias
-
finalbeta2
- Znuny newbie
- Posts: 17
- Joined: 26 Apr 2023, 11:31
- Znuny Version: 6.4.5
- Real Name: Jochen
-
Johannes
- Moderator
- Posts: 428
- Joined: 30 Jan 2008, 02:26
- Znuny Version: All of them ^^
- Real Name: Hannes
- Company: Znuny|OTTERHUB
Re: ArticleStorageFS migration questions - Database load question
Hi,
it is suggested to not have the files in the DB, just migrate them to the FS.
It is straight forward and improves loading times and backup times overall.
Just make sure you have enough space for the export.
If things do not improve, check the size of your DB and match it against the configuration.
So "optimize" it, one would say.
For MySQL/MariaDB, use the MySQL tuner as a guideline.
Regards
Johannes
it is suggested to not have the files in the DB, just migrate them to the FS.
It is straight forward and improves loading times and backup times overall.
Just make sure you have enough space for the export.
If things do not improve, check the size of your DB and match it against the configuration.
So "optimize" it, one would say.
For MySQL/MariaDB, use the MySQL tuner as a guideline.
Regards
Johannes