ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ashish Vijaywargiya <vijaywargiya.ash...@gmail.com>
Subject Re: Anyone using OFBiz Trunk + MySql 5.0.x + Ubuntu 10.04 + Sun Jdk1.6 combination - How much time it take to run "ant run-install" command?
Date Mon, 21 Feb 2011 04:41:40 GMT
Will give it a try and be back. Thanks Mike!

--
Ashish

On Mon, Feb 21, 2011 at 2:40 AM, Mike <mz4wheeler@gmail.com> wrote:

> Your key buffer is pretty gigantic.  Try these:
>
> #
> # * Fine Tuning
> #
> key_buffer              = 64M
> max_allowed_packet      = 640M
> thread_stack            = 192K
> thread_cache_size       = 8
> max_connections        = 256
> table_cache            = 2400
> table_definition_cache  = 2400
> max_heap_table_size     = 512M
> tmp_table_size          = 512M
> join_buffer_size        = 5M
> thread_concurrency     = 10
> query_cache_limit       = 64M
> query_cache_size        = 128M
>
>
> On Sun, Feb 20, 2011 at 12:00 PM, Ashish Vijaywargiya
> <vijaywargiya.ashish@gmail.com> wrote:
> > 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 <
> > vijaywargiya.ashish@gmail.com> 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 <mz4wheeler@gmail.com> 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
> >>> <vijaywargiya.ashish@gmail.com> 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
> >>> >
> >>>
> >>
> >>
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message