MySQL DB creation with demo data

Hi, I have setup 10.04 branch in my dev enviornment, with MySQL db server(v5.1.46 on a separate VM) with utf8 encoding on Open Suse 11.3 having 4 processors & 2 gb ram. Encoding in entityengine.xml is set to utf8. Database creation with demo data takes minimum 40 minutes. Is this an acceptable for

Re: MySQL DB creation with demo data

That's pretty dog slow. You probably need to tune mysql. Ofbiz has a lot of tables. Here is what I was using: # # * Fine Tuning # key_buffer = 64M max_allowed_packet = 640M thread_stack= 192K thread_cache_size = 8 max_connections= 256 table_cache

Re: MySQL DB creation with demo data

It's far too slow. On my 2 years old Windows box (Intel dual Proc, 4 GB, SATAs) it takes about 3 mins with Postgres 8.4 and 12 with Derby (not much else running at the same time) Jacques From: "varun bhansaly" Hi, I have setup 10.04 branch in my dev enviornment, with MySQL db server(v5.1.46 o

Re: MySQL DB creation with demo data

ySQL-DB-creation-with-demo-data-tp2401466p2401921.html Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: MySQL DB creation with demo data

if I read this correct you have introduced many variables. 1) have you tested loading a MySQL db over the network in this configuration, list a restore, not using ofbiz? 2) have you tested loading a local MySQL db using ofbiz? = BJ Freeman

Re: MySQL DB creation with demo data

I have tried loading over network as well as from local. Are talking of mysqldump restore as well ? On Tue, Aug 31, 2010 at 10:30 PM, BJ Freeman wrote: > if I read this correct you have introduced many variables. > 1) have you tested loading a MySQL db over the network in this > configuration, l

Re: MySQL DB creation with demo data

the first is to isolate if ofbiz is causing anything by removing it from the equation. so do a equivalent restore of data from the machine that ofbiz resides on to the target that MySQL resides on and time. you can do this by saving the MySQL data of a current db that has ofbiz structure and dat

Re: MySQL DB creation with demo data

Thanks BJ, what is available is the 'target' m/c only with latest MySQL, no backup has been taken for this dev env. Since I work primarily with ofbiz, theres no other dataset to reference. On Tue, Aug 31, 2010 at 11:02 PM, BJ Freeman wrote: > the first is to isolate if ofbiz is causing anything

Re: MySQL DB creation with demo data

that does make it more difficult. Not sure what you can do, you might check if it is the MySQL jdbc driver you using in ofiz. and possibly so setting the driver needs in the entityengine.xml = BJ Freeman Strategic Power Office with Supplie

Re: MySQL DB creation with demo data

I have tried with latest Connector/J 5.1.13, but result is the same (slow db creation) On Tue, Aug 31, 2010 at 11:58 PM, BJ Freeman wrote: > that does make it more difficult. > Not sure what you can do, you might check if it is the MySQL jdbc driver > you using in ofiz. and possibly so setting t

Re: MySQL DB creation with demo data

unfortunately I use postgres and don't have time to do a setup of mysql. hopefully someone that is using mysql can help you further. = BJ Freeman Strategic Power Office with Supplier Automation

Re: MySQL DB creation with demo data

I have two environments: 2 x 3Ghz + 4GB RAM - server - takes a couple of minutes to load the initial data. 2 x 2.8Ghz + 8GB RAM - laptop - it takes about 40 minutes to load the data. Don't have the solution but I have noticed that on machines with slow disks the performance while creating indices,

Re: MySQL DB creation with demo data

On Aug 31, 2010, at 3:35 PM, Michał Cukierman wrote: > I have two environments: > 2 x 3Ghz + 4GB RAM - server - takes a couple of minutes to load the > initial data. > 2 x 2.8Ghz + 8GB RAM - laptop - it takes about 40 minutes to load the > data. > > Don't have the solution but I have noticed tha

Re: MySQL DB creation with demo data

I have tried on Win 7, 64bit with 4 gigs ram, MySQL v5.1.50 community server, utf8 encoding default, it takes 3.38 mins with demo data. On Wed, Sep 1, 2010 at 5:54 AM, David E Jones wrote: > > On Aug 31, 2010, at 3:35 PM, Michał Cukierman wrote: > > > I have two environments: > > 2 x 3Ghz + 4GB

Re: MySQL DB creation with demo data

Another piece of stat - Suppose db is created, when ofbiz is booting, it takes it around a minute to gather db information, thats in collecting meta data. On Wed, Sep 1, 2010 at 6:38 AM, varun bhansaly wrote: > I have tried on Win 7, 64bit with 4 gigs ram, MySQL v5.1.50 community > server, utf8

Re: MySQL DB creation with demo data

Db creation takes 10 mins now (acceptable than 2 hours). It was due to the new h/w we had migrated to. Thanks for all the responses. On Wed, Sep 1, 2010 at 6:44 AM, varun bhansaly wrote: > Another piece of stat - Suppose db is created, when ofbiz is booting, it > takes it around a minute to gat