[dev.icinga.com #3527] use transactions for large object dumps

[icinga-migration]

This issue has been migrated from Redmine: https://dev.icinga.com/issues/3527

Created by mfriedrich on 2013-01-10 19:16:18 +00:00

Assignee: gbeutner
Status: Resolved (closed on 2013-03-04 17:59:05 +00:00)
Target Version: 1.9
Last Update: 2014-12-08 14:38:01 +00:00 (in Redmine)

---

this is handy when the config dump on reload/restart happens, not issueing a commit after every single query, but once the data packet is being done processing. e.g. within such a chunk, you'll get server+contacts+contactgroups+etc...

this is experimental, and disabled by default, set use_transactions=1 in ido2db.cfg in order to enable that.

Changesets

2013-01-10 19:13:46 +00:00 by (unknown) 59776d2

correct config description for transactions, add as new config item to update location refs #3527

2013-01-10 19:22:08 +00:00 by (unknown) 954349c

update Changelog for refs #3527

---

Relations:

• relates #3527
• relates #3527
• relates #3527

[icinga-migration]

Updated by mfriedrich on 2013-01-12 16:40:18 +00:00

A normal startup with my 4k test service setup on a 4core 2gb box with debian 6 and un-tuned mysql 5.1.66

Jan 12 17:30:14 sol icinga: Icinga 1.9.0dev starting... (PID=28564)
Jan 12 17:31:28 sol icinga: Event loop started...

= 74sec

using the git branch with use_transactions=1 in ido2db.cfg

Jan 12 17:35:39 sol icinga: Icinga 1.9.0dev starting... (PID=3512)
Jan 12 17:36:49 sol icinga: Event loop started...

= 70sec

not that much, but still, one gotta optimize mysql and such too, especially when having large scale setups. furthermore, my test config does not have that much dependencies or groups which may slow down the config dump massively.

[icinga-migration]

Updated by mfriedrich on 2013-03-04 17:59:05 +00:00

• Status changed from New to Resolved
• Assigned to set to gbeutner
• Done % changed from 0 to 100

experimental opt-in

[icinga-migration]

Updated by mfriedrich on 2013-05-02 09:08:35 +00:00

• Subject changed from use transactions for large object dumps, opt-in config option to use transactions for large object dumps

[icinga-migration]

Updated by mfriedrich on 2014-12-08 14:38:01 +00:00

• Project changed from 18 to Core, Classic UI, IDOUtils
• Category changed from 57 to IDOUtils