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

[Phil D. <ph...@lo...>]

I am not sure it makes a big difference with innodb tables to be brutal. 
Given the delay I've stopped using it. Adding the commands to a cron job 
directly on the server at some off peak time seems more sensible.

Phil

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

On 16/03/17 09:43, Dale Scott wrote:
>
> 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...
>     <mailto:web...@li...>
>
>     https://lists.sourceforge.net/lists/listinfo/web-erp-users
>
>
>
> ------------------------------------------------------------------------------
> 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