I will be updating the software to the latest version of vBulletin (4.1.5) very shortly. The site may be offline for a few minutes while I am doing this.
I also this afternoon (4PM Central time) changed how attachments are stored by the system, so that they are stored in the file system rather than in the MySQL database. The database size was ~750MB out of a maximum size of 1 GB. By contrast, once all of the attachments/images were removed from the database (I just re-checked the size of the DB) it is down to a measly 39.6 MB (7.9 MB compressed as a gzip file).
Lastly I also moved all of the avatars and signature pictures out of the database to the file system. As a final maintenance task, I re-sized and reset all of the "thumbnail" photos (the miniature versions of attached photos that show up at the bottom of posts) to reflect the larger size I selected of 300 x 300 pixels, which is easier to see.
Hopefully this process was transparent to those of you who were using the site at the time I was doing this. I'll update the software late tonight when y'all are in bed sleeping
Cheers,
Gerry
I also this afternoon (4PM Central time) changed how attachments are stored by the system, so that they are stored in the file system rather than in the MySQL database. The database size was ~750MB out of a maximum size of 1 GB. By contrast, once all of the attachments/images were removed from the database (I just re-checked the size of the DB) it is down to a measly 39.6 MB (7.9 MB compressed as a gzip file).
Lastly I also moved all of the avatars and signature pictures out of the database to the file system. As a final maintenance task, I re-sized and reset all of the "thumbnail" photos (the miniature versions of attached photos that show up at the bottom of posts) to reflect the larger size I selected of 300 x 300 pixels, which is easier to see.
Hopefully this process was transparent to those of you who were using the site at the time I was doing this. I'll update the software late tonight when y'all are in bed sleeping
Cheers,
Gerry










for your support.......