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

[gilberto d. s. a. <gs...@gm...>]

hi. global providers already take care for this kind of infra-estructure.
hostgator.com are very ok with shared hosts only about US 7,00 by month.
Any way, you do not need run any concerns about performance related about
mysql 5.5 or 5.6 or 5.7. for local pc or intranet pc allways pain is pc or
server that run this main if are running all this on windows. triple
checks.

--
gilberto dos santos alves
+5511986465049






2017-03-15 17:43 GMT-03:00 Dale Scott <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
>
>
>
> ------------------------------------------------------------
> ------------------
> 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
>
>