I note that when autocheckpointing in turned on, checkpoints will be run W

timh over 12 years ago

I note that when autocheckpointing in turned on, checkpoints will be run
Where can I find out more information about configuring checkpointing?
What is the average time it takes for a checkpoint to run for example? The documentation says that if autocheckpoint is enabled, then a checkpoint will run "approximately once every 4 to 12 hours, depending on a number of factors, including transaction volume”.
Where can I find information on what those factors are, or what the transaction volume thresholds are that would trigger a 4, 5 or 12 hourly checkpoint? Is there a "Checkpoint Best Practices" page for example?...

Discussion posts and replies are publicly visible

0 Mike Cichy
Appian Employee
over 12 years ago

We recommend that auto checkpoint be disabled for production systems even for multiple gateway installations. With auto checkpointing, you are able to set the thresholds but you are unable to control when the thresholds are reached.
As to how long a checkpoint runs, depends on mutliple factors: size of the kdb, disk I/O, etc. but anything above 10 seconds is logged as a warning in the logs.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 michaelr236 over 12 years ago

Thanks Mike. In Dev, where autocheckpointing is enabled, how can we find 1) how frequently checkpoints occur, and 2) how long a checkpoint takes?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Mike Cichy
Appian Employee
over 12 years ago

1) You can easily tell by the kdb last modified timestamp. Like I said, these times will vary on a number of factors.
2) You will need to inspect the db logs, and calculate the time between initiation of the save to the kdb switch. Normally the save is limited by I/O because of writing the sizeable files to disk but should take less than a few seconds on DEV. You can open an Appian Support case to help you identify the start and end times.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 joanneh over 6 years ago in reply to Mike Cichy

Hi Mike Cichy

Do you know how to disable auto checkpointing?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 nathan.schmitz
Certified Associate Developer
over 6 years ago in reply to joanneh

In the server/_conf directory update the gateway-config.xml file to set the auto-database-save="0" to disable auto check pointing.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eliot Gerson
Appian Employee
over 6 years ago in reply to joanneh

The documentation here docs.appian.com/.../Configuring_Application_Checkpointing.html includes the current (since 17.3) guidance for checkpointing and instructions for configuring it.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel