Wow, too quick Mike. Thanks a lot! Doing this changes right away and will be back to you in next 15 minutes or so.
This is quite interesting, I am having 1 more machine on which Ubuntu 8.04 is running and over there I didn't do any manual adjustment. The "ant run-install" command takes about 4-5 minutes in completion. -- Ashish On Mon, Feb 21, 2011 at 12:35 AM, Mike <[email protected]> wrote: > Tuning. Ofbiz has over 800 tables. Here are a few things to tweak. > > table_cache = 2400 > table_definition_cache = 2400 > max_heap_table_size = 512M > tmp_table_size = 512M > join_buffer_size = 5M > query_cache_limit = 64M > query_cache_size = 128M > > > On Sun, Feb 20, 2011 at 10:54 AM, Ashish Vijaywargiya > <[email protected]> wrote: > > Hello, > > > > Since last 2 years I was using OFBiz Trunk + Mysql 5.0.x + Ubuntu 8.04 + > Sun > > Jdk1.6. Everything was working as expected & the command "ant > run-install" > > was taking about 4 - 5 minutes on my laptop. > > > > Before 3, 4 month I have switched to Ubuntu 10.04 but now "ant > run-install" > > command is taking about 19 - 22 minutes on my laptop. > > *On my machine I have observed that "ant run-install" command is taking > too > > much time at the time of index creation.* > > > > I have tried with all the mysql connector(3.0.x, 3.1.x & 5.x) but all the > > time completion time for "ant run-install" command remains around 19 - 22 > > minutes. > > > > ashish@ashish-laptop:~/ofbiz_dev/testing$ svn info > > Path: . > > URL: https://svn.apache.org/repos/asf/ofbiz/trunk > > Repository Root: https://svn.apache.org/repos/asf > > Repository UUID: 13f79535-47bb-0310-9956-ffa450edef68 > > Revision: 1072680 > > Node Kind: directory > > Schedule: normal > > Last Changed Author: erwan > > Last Changed Rev: 1072600 > > Last Changed Date: 2011-02-20 19:43:03 +0530 (Sun, 20 Feb 2011) > > > > Recently ran this command and here is the out come of time frame: > > > > [java] 2011-02-21 00:17:43,537 (main) > > [EntityDataLoadContainer.java:397:INFO ] 00004 of 15353 from > > > file:/home/ashish/ofbiz_dev/testing/specialpurpose/webpos/data/WebPosSecurityData.xml > > [java] 2011-02-21 00:17:43,537 (main) > > [EntityDataLoadContainer.java:408:INFO ] =-=-=-=-=-=-= Finished the data > > load with 15353 rows changed. > > [java] 2011-02-21 00:17:43,537 (main) [ > > ContainerLoader.java:113:INFO ] Shutting down containers > > > > BUILD SUCCESSFUL > > Total time: 21 minutes 35 seconds > > > > Anyone using OFBiz Trunk + MySql 5.0.x + Ubuntu 10.04 + Sun Jdk1.6 > > combination? How much time it is taking to run "ant run-install" command > for > > you? > > I am assuming that I may need to do some additional settings inside > my.cnf > > file in Ubuntu 10.04. > > Any pointer would be greatly appreciated. > > > > Thanks! > > > > -- > > Ashish > > >
