Hi Guys,
I was using successfully mango M2M using Derby database on Windows 7 (x64), but recently I have a need to monit around 8 000 points in real time (on BACnet).
My problem is long delay in refreshing values on my graphical view. It take around 5 min, despiate of fact that I set 3min for saving database and 2 minutes in points specifications (INTERVAL) with 0.0 tolerance.
I am fighting with it quite long time.
- I tried to increase cache dedicated to JAVA, my web browser, etc. Without success. Still I get information, that JAVA has Memory Cheap Overspace.
- I have 32GB of RAM to use and I still have use of maksimum 4GB of memory.
I saw many topics related to switching Derby to MYSQL but I wasn't able to switch it to the MYSQL database. Even if I created empty MYSQL databse, Apache wasn't able to use MYSQL database.
I would appreciate if you help me go through whole process of running MYSQL on my operating system to be able to run Mango with following changes in file env.properities:
db.type=mysql
db.url=~/../../bin/mangoDB2
db.username=
db.password=
db.pool.maxActive=10
db.pool.maxIdle=10
db.update.log.dir=${catalina.base}/logs/
convert.db.type=mysql
convert.db.url=~/../../bin/mangoDB2
convert.db.username=
convert.db.password=
grove.url=http://mango.serotoninsoftware.com/servlet
If you have advices for me I would appreciate it!