if you are getting slammed or being DDoS attacked, you can move your ONLINE and TOPIC_VIEWS temporary tables from heap (memory) to disk.

DEFAULT SETTINGS to be used since 2024 for all versions of UBB.threads. standard in UBBT 8.x
--- Set temp data table engines: disk ---
SQL Query
alter table ubbt_ONLINE ENGINE=MyISAM
SQL Query
alter table ubbt_TOPIC_VIEWS ENGINE=MyISAM


DEFAULT SETTINGS used since 2007 for UBB.threads 7.1 - 7.7.5
--- Set temp data table engines: heap (memory) ---
SQL Query
alter table ubbt_ONLINE ENGINE=heap
SQL Query
alter table ubbt_TOPIC_VIEWS ENGINE=heap

current developer of UBB.threads php forum software
current release: UBB.threads 8.0.1 // wip: UBB.threads 8.1.0
isaac @ id242.com // my forum @ CelicaHobby.com