Re: [webERP-users] how to prevent access during upgrade

[Dale S. <dal...@sh...>]

Thanks Gilberto and Phil.

 

Can you say anything about how big a deal it is to run OPTIMIZE TABLE
periodically? How "bad" does it get if you don't OPTIMIZE TABLE
periodically, and in what sort of context? (e.g. number of
users/items/orders). How long can it take OPTMIZE TABLES take to run? I'm
aware I'm asking a loaded question and "it depends", but any generalities?
Fwiw, my server is an old dual-core desktop with 8GB RAM. I just forced
DB_Maintenance to run now and the delay until "fully logged in" was long
enough I might have appreciated a "sorry for the delay" notice.

 

Also, the manual recommends scheduling DB_Maintenance as a cron job, but
doesn't say how. I can use wget and a URL to execute a *.php file, but how
do you execute just one function from within an *.inc file? Or would you put
a mysql command directly into the cron table (with the query given as an
argument to the mysql command)?

 

Thanks,
Dale

 

 

From: Phil Daintree [mailto:ph...@lo...] 
Sent: Tuesday, March 14, 2017 11:02 PM
To: For the general discussion of webERP project
Subject: Re: [webERP-users] how to prevent access during upgrade

 

Yes there is a configuration (webERP/System Parameters.php) setting for this
- under perform database maintenance at logon



Phil
 
Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 15/03/17 14:50, Dale Scott wrote:

How do you prevent user access when you require sole access to the webERP
app or the database server for some reason. E.g. upgrade, patch, restore
database backup, etc.

 

Is there any built-in facility for dealing with "temporarily out of order,
please come back later." Can anyone share a procedure that works for them?
Is anyone bringing up a new server, synchronizing databases, and cutting
over live? Not that I want to, but I'd like to know in case I need to some
day.

 

Cheers!

Dale

 






----------------------------------------------------------------------------
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot






_______________________________________________
web-ERP-users mailing list
web...@li...
https://lists.sourceforge.net/lists/listinfo/web-erp-users