Skip to content
This repository has been archived by the owner. It is now read-only.

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

Closed
icinga-migration opened this issue Jan 10, 2013 · 4 comments
Closed

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

icinga-migration opened this issue Jan 10, 2013 · 4 comments
Milestone

Comments

@icinga-migration
Copy link
Member

@icinga-migration icinga-migration commented Jan 10, 2013

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:

@icinga-migration

This comment has been minimized.

Copy link
Member Author

@icinga-migration icinga-migration commented Jan 12, 2013

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

This comment has been minimized.

Copy link
Member Author

@icinga-migration icinga-migration commented Mar 4, 2013

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

This comment has been minimized.

Copy link
Member Author

@icinga-migration icinga-migration commented May 2, 2013

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

This comment has been minimized.

Copy link
Member Author

@icinga-migration icinga-migration commented Dec 8, 2014

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
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
1 participant
You can’t perform that action at this time.