Cannot get value for DCI ... (Request timed out)

[rgkordia]

Hi,

I have an issue when trying to graph a period of time over 1 week long.  I collect DCI's per minute and when I attempt to graph more than 1 week I get timeouts from the client:

    * Cannot get value for DCI routername:"Input Bandwidth on GigabitEthernet1/0/1" (Request timed out)

I'm running MariaDB 10.1 on Windows Server 2012 R2 and NetXMS 2.0.4 all on one box.

I migrated (~3 months ago) from MSSQL 2010, where the DB was on our corporate cluster offbox.  Didn't have the issue with this setup. 

This graph has 4 series (in/out for primary/secondary link) so I appreciate there is a lot of data.  What I want to know is:

a) Is there a way to increase the timeout in the client?
b) Is there a performance tweak I can do with MySQL/MariaDB that will resolve these issues?

Sometimes if the period is not too long it gets the data after a refresh, presumably due to cache, but longer periods just refuse to graph.

Thanks,
Richard

[alk]

Try http://mysqltuner.com/, it usually gives you quite decent ideas about MySQL configuration (it's not a silver bullet though).