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 >
