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:
If you have advices for me I would appreciate it!