Read the blogs!
Started by Vekseid, February 16, 2009, 06:29:50 AM
Quote from: vbgamer45 on September 16, 2015, 11:20:04 PMIf your mysql server is on the same machine change from connecting from localhost to 127.0.0.1 and get a big boost in some cases just saw this on one of my sites and it just had a massive increased in performance.
alter table smf_sessions add index last_update (last_update);
Quote8: Run the mark read for inactive users script periodically. The log_topics, log_boards, and log_mark_read tables are not the best designs, and for some unlucky folks end up dominating their database. Pruning them can help.
Quote from: vbgamer45 on July 09, 2017, 04:58:44 AMAnother tip just discovered that the smf_sessions table last_update should have an index to add one runCode Select Expandalter table smf_sessions add index last_update (last_update);
Quote from: Arantor on August 06, 2017, 06:27:28 AMIt prunes one set of tables and outs records in the other because if the way SMF works. It just so happens that for you it made it bigger, this is not universally true.
Quote from: gaminh on May 12, 2020, 12:12:06 PMPlease help.After using some of the general tips now my bandwidth is increasing day by day.From 3.6 it has increased to 5.5.Please help and let me know the cause.
Quote from: Arantor on May 12, 2020, 01:38:36 PMAlso, what do 3.6 and 5.5 mean?