Archive Read Only Schedule

2-16-16

CHARACTER SET CONVERSION COMPLETE!

I've revised my schedule, because my RL work schedule is amping up.  To ensure I get this done as quickly as possible, I'll be putting the archive in to READ ONLY mode every day for approximately 4 hours at a time.

For today:  

3 pm EST to 7 pm EST - done
2-14 - 3 pm EST to 7 pm EST - done
2-15 - 6 pm EST to 9 pm EST
2-16 - 6 pm EST to 9 pm EST

Because I ran so much of the clean up queries yesterday, I expect for the character set conversions themselves to go more smoothly than they have been, as well as more quickly.

The Monday through Friday times will start at 6 pm as I've stated above.  I honestly do NOT expect this to take longer than tomorrow, but we'll see.  I will do this every day until I am finished.

When I get to the final phase, where the conversion has been checked and I'm ready to switch tables, I do delete the old table and rename the new converted ones.  This takes approximately 3 to 5 minutes altogether, where you won't see any data AT ALL in the subdomain where I'm doing this.  In other words, all blank pages, not the white page of doom, but there is no data to draw FROM while I do this last part.  If you do see that, be patient, it'll be back up within a few minutes.  Each table set takes a minimum of 45 minutes to convert and then check, so I might not get all the ones listed above done.  

Of course, the 45 minutes is based on the last set of tables I did, where I ran in to issues and had to come up with fixes.  So, it could very well take less time this time around.  I won't know until I actually do it.  Now that I know for certain the oddball side effects that this conversion causes, I also know what to do to fix it all before I even make the tables live.  That will certainly speed it up.

UPDATE below the cut!!