OSGrid Offline for MySQL Maintenance for a few hours

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

OSGrid Offline for MySQL Maintenance for a few hours

Charles Krinke-3
We had to take OSGrid offline this afternoon to export the MySQL database which has grown to 78GByte of the 115GByte available. This project involves the export, a table drop, a table optimize, re-import, and then deleting all assets whose "access_time" field is zero.

The implication of the "access_time" field being zero means that the table entry has not be accessed since access_times started being written into the database, which is right around mid-November. We have over 1,000,000 entries in the assets table of which we estimate about 1/3 to 1/2 are unused, unusable and obsolete. The criteria for this pruning project is those assets not accessed since mid November.

We only have a limited amount of space on the RAID array in the server so kindly donated by ESC for OSGrid, so until we can negotiate more disk space, this is the best option.

Because we are all volunteers and some of the participants are in Europe, Australia and the US, it is necessary to do this project this afternoon as opposed to in the middle of the night.

Please bear with us as we proceed.

Charles Krinke
Director of OSGrid
OpenSim Core Developer

Opensim-users mailing list
[hidden email]