Hi Dojo,
There have been cases where the System Cache folder gets flooded with lots of files while offloading to the DB(MySQL) and this causes the DMA to not start up. Why does this happen and what can we do to ensure this does not occur ? Thanks in advance.
Hi Arunkrishna,
Offloading towards files (instead of DB) happens when DataMiner is unable to communicate with the DB. You will need to find out why your MySQL database was unreachable according to DataMiner. You should be able to find more information on this in the SLDBConnection log file.
As you have a MySQL DB I would also have a look into your data folder. We already seen in the past that when the ibdata1 file is starting to grow over a couple of GB and that this file could be the cause of large delays on your queries and therefor the cause of MySQL not responding in time to DataMiner. We have normally a scheduled task to do some DB maintenance (Skyline DataMiner Database Optimization) one of the things this task does is to reduce the size of that file when possible.
Hope this helps you further.
Thank you Michiel.
Actually MySQL will always offload to files before they are inserted into the DB, this to make use of ‘bulk’ offload instead of opening a connection for every query.