Just a follow up to what solved this. Didn't catch it before, and not sure why, but the tables that wouldn't optimize where ISAM instead of MyISAM. Once I changed the tables to that type - all was fine.
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.