webERP Forum

Full Version: DB Maintenance at Logon taking too long
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi all:

We are facing a increase of time needed to perform the DB maintenance at logon and it is becoming annoying as (as example) today it took 18 minutes to finish Angry when used to be 2-5 minutes some weeks ago.

DB is hosted in a shared server at Hostgator. All other DB are working fine, time is OK, checked with Hostgator and seems like server side is 100% ok.
DB size (when backing up) is around 675 Mb.
DB Maintenance set to weekly.
webERP version running 4.09.1.
Via PhpMyAdmin it takes only 4,5 minutes to copy the whole DB into a new one.

Some questions:
1) The DB maintenance routine, has it been changed, improved, modified lately (last few months)?
2) Is there any trick to make it faster?
3) Is it a "must do" maintenance? Does it really improve efficiency of the database?
Would be interesting to turn it off and see what happens to performance over a period. I suspect it is really not that useful for innodb tables.
Wonder why it has suddenly increased in time though - nothing changed in this area that I can recall off the top of my head.

As sugguested by Phil here and Tim by email, I will set it up to "never" and see what happens. I will think of a system to measure performance, so I can come back with some figures.

After almost 2 months, no change in performance has been detected. Measured against 3 very long scripts, executed 10 times each, and execution time is appro. the same.

But, one side effect of turning off the DB Maintenance is that audit log does not get purged as it should.

Probably lines 151-154 from should be moved outside the
if(isset($_SESSION['DB_Maintenance'])){ at line 141.

Purge of Audit log should be done in any case, IMHO.
Agreed and done
Thanks Ricard
Thanks to you!
Reference URL's