Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Data Purging and Archiving
11-10-2017, 06:46 PM,
#11
RE: Data Purging and Archiving
There are a couple of things you can do that should help.

Firstly try reducing the amount of audit trail you keep. This is nearly always by far the biggest table, and you are probably keeping far more data than you need. You should find the setting for this in the system configuration page.

Secondly force the database maintenance function to run. This is also in the system configuration page.

Tim
Reply
11-17-2017, 08:32 AM, (This post was last modified: 11-17-2017, 08:35 AM by VortecCPI.)
#12
RE: Data Purging and Archiving
I use MySQL OPTIMIZE in CRON Jobs to tidy up tables on our servers

Is this the same thing the DB_Maintenance function is doing?
Sorry for being a bit lazy... I just answered my own question by looking at the code but good to know...

$TablesResult = DB_query("SHOW TABLES");
while ($myrow = DB_fetch_row($TablesResult)) {
$Result = DB_query('OPTIMIZE TABLE ' . $myrow[0]);
}
https://www.linkedin.com/in/eclipsepaulbecker
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)