How to update auto refresh interval in gadgets globally
Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.
Some of the gadgets type can be configured with an auto refresh interval set to 15 minutes that cannot be configured within a user interface. However, this may cause unnecessary strain to the system if there are many gadgets operating in the same time.
It is possible to automatically disable refresh in all existing gadgets or set them to a different interval. The gadgets settings are stored in the gadgetuserpreference table, which can be manipulated with help of the following sample queries:
UPDATE gadgetuserpreference SET userprefvalue='false' WHERE userprefkey='refresh';
You can set the auto refresh to a predetermined interval in minutes:
UPDATE gadgetuserpreference SET userprefvalue='240' WHERE userprefkey='refresh';
Restart JIRA for the setting to take effect. Note that any active dashboards will need to be reloaded for new setting to take effect.