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 = 2400 table_definition_cache = 2400 max_heap_table_size = 512M tmp_table_size = 512M join_buffer_size = 5M #thread_concurrency = 10 # # * Query Cache Configuration # query_cache_limit = 64M query_cache_size = 128M However, I'm currently in the process of dumping mysql due to it's timestamp issue. On Tue, Aug 31, 2010 at 5:32 AM, varun bhansaly <[email protected]> wrote: > 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 db creation given above configuration ? > > PS : My previous MySQL server with latin1 encoding with 6 CPU and 12 gigs > ram used to take 10 mins. > > -- > Regards, > Varun Bhansaly >
