webERP Forum
DB Maintenance at Logon taking too long - Printable Version

+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (/forumdisplay.php?fid=1)
+--- Forum: Problems / Bugs? (/forumdisplay.php?fid=8)
+--- Thread: DB Maintenance at Logon taking too long (/showthread.php?tid=532)



DB Maintenance at Logon taking too long - PakRicard - 02-07-2013 10:33 AM

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?


RE: DB Maintenance at Logon taking too long - phil - 02-07-2013 04:45 PM

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.


RE: DB Maintenance at Logon taking too long - PakRicard - 02-20-2013 12:31 PM

Hi:

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.
Thanks!


RE: DB Maintenance at Logon taking too long - PakRicard - 04-16-2013 04:28 PM

Hi:

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 session.inc should be moved outside the
if(isset($_SESSION['DB_Maintenance'])){ at line 141.

Purge of Audit log should be done in any case, IMHO.


RE: DB Maintenance at Logon taking too long - phil - 04-16-2013 06:28 PM

Agreed and done
Thanks Ricard


RE: DB Maintenance at Logon taking too long - PakRicard - 04-17-2013 04:51 PM

Thanks to you!