Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
DB Maintenance at Logon taking too long
02-07-2013, 10:33 AM
Post: #1
DB Maintenance at Logon taking too long
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?

Regards,
Pak Ricard
Find all posts by this user
Quote this message in a reply
02-07-2013, 04:45 PM
Post: #2
RE: DB Maintenance at Logon taking too long
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.

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
02-20-2013, 12:31 PM
Post: #3
RE: DB Maintenance at Logon taking too long
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!

Regards,
Pak Ricard
Find all posts by this user
Quote this message in a reply
04-16-2013, 04:28 PM
Post: #4
RE: DB Maintenance at Logon taking too long
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.

Regards,
Pak Ricard
Find all posts by this user
Quote this message in a reply
04-16-2013, 06:28 PM
Post: #5
RE: DB Maintenance at Logon taking too long
Agreed and done
Thanks Ricard

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
04-17-2013, 04:51 PM
Post: #6
RE: DB Maintenance at Logon taking too long
Thanks to you!

Regards,
Pak Ricard
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 2 Guest(s)