BTW I am using 1.6.0_11 since last 2 years without having any issue, but I think its time to do an upgrade ;)
ashish@ashish-laptop:~$ java -version java version "1.6.0_11" Java(TM) SE Runtime Environment (build 1.6.0_11-b03) Java HotSpot(TM) Server VM (build 11.0-b16, mixed mode) -- Ashish On Mon, Feb 21, 2011 at 10:12 AM, Ashish Vijaywargiya < [email protected]> wrote: > Thanks BJ. I will give it a try with latest version of JDK which is > 1.6.0_24. > May be we can have better results. Will keep you guys posted on my progress > on this. > > -- > Ashish > > > On Mon, Feb 21, 2011 at 3:07 AM, BJ Freeman <[email protected]> wrote: > >> there was a version of 1.6 before _18 that caused slowness in ofbiz. >> changing to version at or above 18 solved the problem. >> >> ========================= >> BJ Freeman >> Strategic Power Office with Supplier Automation < >> http://www.businessesnetwork.com/automation/viewforum.php?f=52> >> Specialtymarket.com <http://www.specialtymarket.com/> >> Systems Integrator-- Glad to Assist >> >> Chat Y! messenger: bjfr33man >> >> >> Ashish Vijaywargiya sent the following on 2/20/2011 12:00 PM: >> >> Hello Mike, >>> >>> Not much difference. >>> >>> Here is the output of recent "ant run-install' command. >>> >>> [java] 2011-02-21 01:25:02,929 (main) >>> [EntityDataLoadContainer.java:408:INFO ] =-=-=-=-=-=-= Finished the data >>> load with 15353 rows changed. >>> [java] 2011-02-21 01:25:02,929 (main) [ >>> ContainerLoader.java:113:INFO ] Shutting down containers >>> >>> BUILD SUCCESSFUL >>> Total time: 19 minutes 10 seconds >>> ashish@ashish-laptop:~/ofbiz_dev/testing$ >>> >>> I am sharing the content of my.cnf file so that you can better comment. >>> >>> ashish@ashish-laptop:~/ofbiz_dev/testing$ cat /etc/mysql/my.cnf >>> # >>> # The MySQL database server configuration file. >>> # >>> # You can copy this to one of: >>> # - "/etc/mysql/my.cnf" to set global options, >>> # - "~/.my.cnf" to set user-specific options. >>> # >>> # One can use all long options that the program supports. >>> # Run program with --help to get a list of available options and with >>> # --print-defaults to see which it would actually understand and use. >>> # >>> # For explanations see >>> # http://dev.mysql.com/doc/mysql/en/server-system-variables.html >>> >>> # This will be passed to all mysql clients >>> # It has been reported that passwords should be enclosed with >>> ticks/quotes >>> # escpecially if they contain "#" chars... >>> # Remember to edit /etc/mysql/debian.cnf when changing the socket >>> location. >>> [client] >>> port = 3306 >>> socket = /var/run/mysqld/mysqld.sock >>> >>> # Here is entries for some specific programs >>> # The following values assume you have at least 32M ram >>> >>> # This was formally known as [safe_mysqld]. Both versions are currently >>> parsed. >>> [mysqld_safe] >>> socket = /var/run/mysqld/mysqld.sock >>> nice = 0 >>> >>> [mysqld] >>> # >>> # * Basic Settings >>> # >>> >>> # >>> # * IMPORTANT >>> # If you make changes to these settings and your system uses apparmor, >>> you >>> may >>> # also need to also adjust /etc/apparmor.d/usr.sbin.mysqld. >>> # >>> >>> user = mysql >>> socket = /var/run/mysqld/mysqld.sock >>> port = 3306 >>> basedir = /usr >>> datadir = /var/lib/mysql >>> tmpdir = /tmp >>> skip-external-locking >>> # >>> # Instead of skip-networking the default is now to listen only on >>> # localhost which is more compatible and is not less secure. >>> bind-address = 127.0.0.1 >>> # >>> # * Fine Tuning >>> # >>> key_buffer = 2048M >>> max_allowed_packet = 2048M >>> thread_stack = 192K >>> max_heap_table_size = 512M >>> tmp_table_size = 512M >>> join_buffer_size = 5M >>> thread_cache_size = 8 >>> >>> # This replaces the startup script and checks MyISAM tables if needed >>> # the first time they are touched >>> myisam-recover = BACKUP >>> max_connections = 100 >>> table_cache = 2400 >>> #table_definition_cache = 2400 >>> thread_concurrency = 10 >>> # >>> # * Query Cache Configuration >>> # >>> query_cache_limit = 64M >>> query_cache_size = 128M >>> # >>> # * Logging and Replication >>> # >>> # Both location gets rotated by the cronjob. >>> # Be aware that this log type is a performance killer. >>> # As of 5.1 you can enable the log at runtime! >>> #general_log_file = /var/log/mysql/mysql.log >>> #general_log = 1 >>> >>> log_error = /var/log/mysql/error.log >>> >>> # Here you can see queries with especially long duration >>> #log_slow_queries = /var/log/mysql/mysql-slow.log >>> #long_query_time = 2 >>> #log-queries-not-using-indexes >>> # >>> # The following can be used as easy to replay backup logs or for >>> replication. >>> # note: if you are setting up a replication slave, see README.Debian >>> about >>> # other settings you may need to change. >>> #server-id = 1 >>> #log_bin = /var/log/mysql/mysql-bin.log >>> expire_logs_days = 10 >>> max_binlog_size = 100M >>> #binlog_do_db = include_database_name >>> #binlog_ignore_db = include_database_name >>> # >>> # * InnoDB >>> # >>> # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/. >>> # Read the manual for more InnoDB related options. There are many! >>> # >>> # * Security Features >>> # >>> # Read the manual, too, if you want chroot! >>> # chroot = /var/lib/mysql/ >>> # >>> # For generating SSL certificates I recommend the OpenSSL GUI "tinyca". >>> # >>> # ssl-ca=/etc/mysql/cacert.pem >>> # ssl-cert=/etc/mysql/server-cert.pem >>> # ssl-key=/etc/mysql/server-key.pem >>> >>> >>> >>> [mysqldump] >>> quick >>> quote-names >>> max_allowed_packet = 16M >>> >>> [mysql] >>> #no-auto-rehash # faster start of mysql but no tab completition >>> >>> [isamchk] >>> key_buffer = 16M >>> >>> # >>> # * IMPORTANT: Additional settings that can override those from this >>> file! >>> # The files must end with '.cnf', otherwise they'll be ignored. >>> # >>> !includedir /etc/mysql/conf.d/ >>> >>> >>> I have commented out "#table_definition_cache = 2400" as it was not >>> allowing >>> me to restart mysql server. >>> >>> Do you think that switching to Mysql 5.1.x can make any difference here? >>> In >>> past I have also tried on Mysql 5.1.x version but at that time didn't do >>> "Fine Tunning" thing. >>> May be this time setting few additional parameter on Mysql 5.1.x can give >>> better result. WDYT? >>> >>> Thanks! >>> >>> -- >>> Ashish >>> >>> >>> On Mon, Feb 21, 2011 at 12:39 AM, Ashish Vijaywargiya< >>> [email protected]> wrote: >>> >>> 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 >>>>>> >>>>>> >>>>> >>>> >>>> >>> >> >
