Time taken to go into test

RLJB

Since upgrading to 5.7 we have business spaces taking a very long time to go into test (7 minutes plus)

We are using MySQL 5.5 and Linux (Ubuntu) servers that are fully powered (16GB of RAM etc)
When we start a new business space and import an existing BSV it goes into test fast for like the first 3 add times, then it starts to slow and slow until a few days later, when there still isn't a lot of data, it takes 7 minutes

Can others please report if they are experiencing any slowness in going into test?

Tks.

Rennur

My BSV is 1.5mb, lots of objects, attributes etc.

To put under test

Check integrity ticked: Just > 1min
Check integrity un-ticked: 10 seconds

FYI my current setup
AwareIM: 5.7
JAVA JDK: Version 7 Update 45 64Bit (Not sure what the Out-of-box version is)
Tomcat: Version 6.0.37 64Bit (Out-of-box: 32bit Version 6.0.35)
Tomcat: lib>tools.jar replaced with latest java JDK tools.jar
MySQL: Version 5.5.34 64Bit
MySQL Connector/J: Version 5.1.26 (Not sure what the Out-of-box version is, but i think its 3.1.12)

RocketRod

No issues with 5.7. Have very large BSV, no time increases on previous versions of AwareIM.

Not what you want to hear I guess.

Cheers Rod

RLJB

thanks guys, it's helpful regardless

Powerm

I have a 18Mb bsv, takes 4-5 min at first publish in an other machine ( test is ok, takes 1 mn ). Server has 18 GB RAM.
I know it is due to the Rules listed on bsv.

pbrad

Hi,
I have a couple of bsv's that are very slow to test. One of them is over 10 minutes to go into test mode. That same bsv takes over 20 minutes when uploading a new version via operation mode.

This has definitely only started to occur in the past two months. I am glad to hear that I am not the only one.

Cheers,
Pete

Gabbitas

My BSV is 1.7mb and was taking up to 20mins to go into test mode. When publishing it would take about 2mins to publish but then the initial login would take 18mins to load in the operation mode.

I then upgraded to MySQL5.6 (a couple of weeks ago) and these times instantly came down to about 2mins for test mode and less than 1min to publish. Initial login to operation mode was about 30 secs.

Unfortunately these times seem to be slowly increasing again. It currently takes 6 mins to test and about 5 mins to publish. My worry is that these times will continue to increase and before to long I will be waiting twenty minutes just to test! Worse than that I fear I will start to get the 'AwareIm server is not responding' error again!!

I'm really no expert and am purely guessing, but is it possible that there is a table or some temp directory somewhere that needs flushing out from time to time?

I don't know when this started to happen for me but at first I thought it was just a slow increase in times due to my BSV getting bigger by the week...maybe not?

Thanks

pbrad

Support, it would seem that there are at least three of us that are experiencing this issue. Any ideas?
Pete

rocketman

May be connected - maybe not but the other day whilst searching for something else, I discovered about 600 duplicate items in c:\AwareIM\Tomcat\webapps\AwareIM

They all seem to be copies of picture images. It would seem that whenever a user calls up a page with a picture on it, that image gets duplicated as a file outside of AwareIM and just never gets deleted. I recovered about 1Gb of disk space.

It occurred to me that if your drives are a bit on the full side and your memory usage is getting near limits there might be some issues on windows servers especially with the virtual disk space and disk swapping

.... just a thought - probably way off the mark

nlarson

I have not yet hit such extream times, but I also am seeing longer times when converting to test

RLJB

Rocketman - we also suffer this issue (have right from the beginning) it is an annoyance that we have to clean up the disk space every month, I also wish it would be fixed. BUT it isn't the cause of recent slowness as we have always had this factor in our environment.

tford

Probably not the cause of your issue, but I've found that the time to put BSVs in test dramatically increases as the number of obsolete versions accumulate. I am pretty aggressive about deleting obsolete versions.

Powerm

tford wrote
Probably not the cause of your issue, but I've found that the time to put BSVs in test dramatically increases as the number of obsolete versions accumulate. I am pretty aggressive about deleting obsolete versions.

This is true, I try to keep 3-4 versions of the bsv on server.Older versions on Dropbox 🙂

pbrad

That may be true, however I also follow this routine and I only have a couple of obsolete versions. I have also scoured the database and AwareIM installation looking for the root cause with no luck.

Support, your comments please?

Cheers,
Pete

RLJB

Same here, it's a dev box so we rarely publish, 1 obsolete version max and still slow times, takes for the tip tho, will watch for our prod servers

aware_support

In our experience it boils down to MySQL. We have tried version 5.6 at some point and creation of indexes there was painfully slow. The same code worked MUCH faster in MySQL 5.5

If anyone is willing to send us a BSV with outrageous timing we can try it on our MySQL version which has been performing very well on reasonably large BSV's

pbrad

Hi,
I will send you a large bsv but please bear in mind that the first time that it runs, it will likely go into test mode in good time. It seems that the more times that you go into test mode, the longer that it takes each time to do so.
Cheers,
Pete

aware_support

Works absolutely fine on our system. Initial time to put under test is 2 min. All subsequent tests were 7 sec without integrity checking and 52 sec with integrity checking.

This is using Aware IM version 5.7 and MySQL version 5.5.30

aware_support

Those who have it slow please report your exact MySQL version and the operating system.

We performed our test on Windows 8 (and MySQL 5.5.30 as mentioned above)

You can also try your BSV with Derby and see if it is still slow

Gabbitas

I had the problem with MySQL 5.1 and am now getting the problem with MySQL 5.6

I am using windows web server 2008 r3

64bit java, 8gb memory on my machine

Aware 5.7 developer edition

Thanks