For mysql, there is tuning_primer.sh: https://launchpad.net/mysql-tuning-primer
For postgresql, there is pgtune: http://pgfoundry.org/projects/pgtune Most folks just use yum/apt-get to get pgtune: apt-get install pgtune --or-- yum install pgtune Although neither are perfect, both utilities attempt to change the DB settings to take advantage of hardware, or look at certain things, like the number of tables, and adjust the DB settings for maximum performance. The default settings for mysql are quite limiting for ofbiz. For instance, ofbiz has over 800 tables and the default table cache for mysql is like 60 tables. On Tue, Nov 24, 2015 at 9:22 AM, Mike <mz4whee...@gmail.com> wrote: > > at least not OFBiz cache since > > I didn't mean the ofbiz cache. I meant the database (mysql/postgres) > cache settings. > > On Tue, Nov 24, 2015 at 8:34 AM, Nick Rosser <nros...@solveda.com> wrote: > >> Thanks Mike -- don't think this is a cache issue -- at least not OFBiz >> cache since it is not showing up in the OFBiz Cache maintenance page. >> Nick >> >> -----Original Message----- >> From: Mike [mailto:mz4whee...@gmail.com] >> Sent: Tuesday, November 24, 2015 11:31 AM >> To: user <user@ofbiz.apache.org> >> Subject: Re: VISIT and VISITOR Entities >> >> Most likely this table is stealing cache memory from the rest of the >> tables. Either increase cache memory, delete the rows, write to a separate >> database, or keep the table trim to xxx rows (as Adrian said) via an >> internal ofbiz job or external script (via crontab). >> >> On Tue, Nov 24, 2015 at 7:48 AM, Len Shein <lsh...@solveda.com> wrote: >> >> > All, >> > >> > We have a LIVE application in which the VISIT AND VISITOR entities >> > have grown to over 19 and 18 million rows respectively. >> > >> > Has anyone experienced any performance issues when these entities have >> > grown to such capacity? >> > >> > >> > >> > We recently had a performance issue and decided to turn off the visit >> > history feature until this feature can be ruled out as the issue. >> > >> > stats.persist.visit=false >> > >> > stats.persist.visitor=false >> > >> > >> > >> > Note: The application is currently using Ofbiz r.10. >> > >> > >> > Len Shein >> > >> > <mailto:lsh...@solveda.com> lsh...@solveda.com >> > >> > O: 516.742.7888 x225 >> > >> > O: 732.333.4303 >> > C: 917.882.8515 >> > >> > >> > >
