Tweet
After work and efforts of months(ok so it wasnt that long) we've switched the system behind forum attachments. The change occured yesterday and today and took several hours as there were over 49000 files of a total size of 4.8GB to process.
The difference is that now attachments are not stored in the mysql database but separately. E.g. there is still a table for the various necessary information(the post that it is attached on, the owner, etc) but the actual file is placed outside the database.
The user processes of viewing, adding, editing, removing attachments have not changed at all.
This should easen the load on the mysql server and lead to less server busy messages for both registered users and guests. Already (and in that have helped some other configuration changes that we have done on mysql lately) the first results seem positive.
Now we want you to check if your (most important as plenty of you have lots of them
) attachments have been transfered succesfully. E.g. if they are images if they show up correctly or if they are zip files if they can be downloaded in a correct form, etc.
Please report back any problems on this thread. Thank you!
The difference is that now attachments are not stored in the mysql database but separately. E.g. there is still a table for the various necessary information(the post that it is attached on, the owner, etc) but the actual file is placed outside the database.
The user processes of viewing, adding, editing, removing attachments have not changed at all.
This should easen the load on the mysql server and lead to less server busy messages for both registered users and guests. Already (and in that have helped some other configuration changes that we have done on mysql lately) the first results seem positive.
Now we want you to check if your (most important as plenty of you have lots of them
) attachments have been transfered succesfully. E.g. if they are images if they show up correctly or if they are zip files if they can be downloaded in a correct form, etc. Please report back any problems on this thread. Thank you!
Comment