-
Notifications
You must be signed in to change notification settings - Fork 189
/
Copy pathmaintain_tutorial.html
174 lines (161 loc) · 9.35 KB
/
maintain_tutorial.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
<!DOCTYPE html>
<html lang="en" data-content_root="./">
<head>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" /><meta name="viewport" content="width=device-width, initial-scale=1" />
<title>Database administration commands — FireWorks 2.0.4 documentation</title>
<link rel="stylesheet" type="text/css" href="_static/pygments.css?v=03e43079" />
<link rel="stylesheet" type="text/css" href="_static/nature.css?v=b0beeceb" />
<script src="_static/documentation_options.js?v=adc66a14"></script>
<script src="_static/doctools.js?v=9bcbadda"></script>
<script src="_static/sphinx_highlight.js?v=dc90522c"></script>
<link rel="index" title="Index" href="genindex.html" />
<link rel="search" title="Search" href="search.html" />
<link rel="next" title="Querying FireWorks and Workflows / Generating Reports" href="query_tutorial.html" />
<link rel="prev" title="Dealing with Failures and Crashes" href="failures_tutorial.html" />
<link href='https://fonts.googleapis.com/css?family=Lato:400,700' rel='stylesheet' type='text/css'>
</head><body>
<div class="related" role="navigation" aria-label="Related">
<h3>Navigation</h3>
<ul>
<li class="right" style="margin-right: 10px">
<a href="genindex.html" title="General Index"
accesskey="I">index</a></li>
<li class="right" >
<a href="py-modindex.html" title="Python Module Index"
>modules</a> |</li>
<li class="right" >
<a href="query_tutorial.html" title="Querying FireWorks and Workflows / Generating Reports"
accesskey="N">next</a> |</li>
<li class="right" >
<a href="failures_tutorial.html" title="Dealing with Failures and Crashes"
accesskey="P">previous</a> |</li>
<li class="nav-item nav-item-0"><a href="index.html">FireWorks 2.0.4 documentation</a> »</li>
<li class="nav-item nav-item-this"><a href="">Database administration commands</a></li>
</ul>
</div>
<div class="document">
<div class="documentwrapper">
<div class="bodywrapper">
<div class="body" role="main">
<section id="database-administration-commands">
<h1>Database administration commands<a class="headerlink" href="#database-administration-commands" title="Link to this heading">¶</a></h1>
<p>There are two types of maintenance operations that can be performed through the LaunchPad:</p>
<ul class="simple">
<li><p><strong>maintain</strong> - automatically detects and marks failed jobs and deleted queue reservations</p></li>
<li><p><strong>tuneup</strong> - tries to speed up database performance by updating indices and compacting the database. Should be performed during database downtime.</p></li>
</ul>
<section id="maintain-to-mark-failed-jobs-and-queue-reservations">
<h2>Maintain to mark failed jobs and queue reservations<a class="headerlink" href="#maintain-to-mark-failed-jobs-and-queue-reservations" title="Link to this heading">¶</a></h2>
<p>We recommend that all users periodically run the <em>maintain</em> command from the LaunchPad. This will detect failed jobs and queue reservations - for details, refer to the <a class="reference internal" href="failures_tutorial.html"><span class="doc">failures tutorial</span></a> and <a class="reference internal" href="queue_tutorial_pt2.html"><span class="doc">queue reservation tutorial</span></a>. In summary, the command will mark the state of failed jobs as <em>FIZZLED</em> and will move any long-waiting <em>RESERVED</em> FireWorks back to <em>READY</em>. The maintenance command can be run using:</p>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">lpad</span> <span class="n">admin</span> <span class="n">maintain</span>
</pre></div>
</div>
<p>If you would like to run maintenance in an infinite loop, you can use:</p>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">lpad</span> <span class="n">admin</span> <span class="n">maintain</span> <span class="o">--</span><span class="n">infinite</span> <span class="o">--</span><span class="n">maintain_interval</span> <span class="mi">6000</span>
</pre></div>
</div>
<p>This formulation will run a maintenance job every 6000 seconds (100 minutes).</p>
</section>
<section id="tuneup-to-improve-performance">
<h2>Tuneup to improve performance<a class="headerlink" href="#tuneup-to-improve-performance" title="Link to this heading">¶</a></h2>
<p>You only need to run a database tuneup if you are not satisfied with the performance of FireWorks.</p>
<p>The tuneup will update all the indices:</p>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">lpad</span> <span class="n">admin</span> <span class="n">tuneup</span>
</pre></div>
</div>
<p>You can do a full tuneup which will block while updating indices and also compact the database. You should only run the full tuneup command during periods of downtime:</p>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">lpad</span> <span class="n">admin</span> <span class="n">tuneup</span> <span class="o">--</span><span class="n">full</span>
</pre></div>
</div>
</section>
<section id="force-refresh-workflow">
<h2>Force Refresh Workflow<a class="headerlink" href="#force-refresh-workflow" title="Link to this heading">¶</a></h2>
<p>This command should not be needed, but if you would like to force a workflow refresh you can do it via:</p>
<blockquote>
<div><p>lpad admin refresh_wf -i <FW_ID></p>
</div></blockquote>
<p>where <code class="docutils literal notranslate"><span class="pre"><FW_ID></span></code> is the id of any one FW in the Workflow you want to refresh. More options are available, use <code class="docutils literal notranslate"><span class="pre">lpad</span> <span class="pre">admin</span> <span class="pre">refresh</span> <span class="pre">-h</span></code> for more information.</p>
</section>
</section>
<div class="clearer"></div>
</div>
</div>
</div>
<div class="sphinxsidebar" role="navigation" aria-label="Main">
<div class="sphinxsidebarwrapper">
<div>
<h3><a href="index.html">Table of Contents</a></h3>
<ul>
<li><a class="reference internal" href="#">Database administration commands</a><ul>
<li><a class="reference internal" href="#maintain-to-mark-failed-jobs-and-queue-reservations">Maintain to mark failed jobs and queue reservations</a></li>
<li><a class="reference internal" href="#tuneup-to-improve-performance">Tuneup to improve performance</a></li>
<li><a class="reference internal" href="#force-refresh-workflow">Force Refresh Workflow</a></li>
</ul>
</li>
</ul>
</div>
<div>
<h4>Previous topic</h4>
<p class="topless"><a href="failures_tutorial.html"
title="previous chapter">Dealing with Failures and Crashes</a></p>
</div>
<div>
<h4>Next topic</h4>
<p class="topless"><a href="query_tutorial.html"
title="next chapter">Querying FireWorks and Workflows / Generating Reports</a></p>
</div>
<div role="note" aria-label="source link">
<h3>This Page</h3>
<ul class="this-page-menu">
<li><a href="_sources/maintain_tutorial.rst.txt"
rel="nofollow">Show Source</a></li>
</ul>
</div>
<search id="searchbox" style="display: none" role="search">
<h3 id="searchlabel">Quick search</h3>
<div class="searchformwrapper">
<form class="search" action="search.html" method="get">
<input type="text" name="q" aria-labelledby="searchlabel" autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false"/>
<input type="submit" value="Go" />
</form>
</div>
</search>
<script>document.getElementById('searchbox').style.display = "block"</script>
</div>
</div>
<div class="clearer"></div>
</div>
<div class="related" role="navigation" aria-label="Related">
<h3>Navigation</h3>
<ul>
<li class="right" style="margin-right: 10px">
<a href="genindex.html" title="General Index"
>index</a></li>
<li class="right" >
<a href="py-modindex.html" title="Python Module Index"
>modules</a> |</li>
<li class="right" >
<a href="query_tutorial.html" title="Querying FireWorks and Workflows / Generating Reports"
>next</a> |</li>
<li class="right" >
<a href="failures_tutorial.html" title="Dealing with Failures and Crashes"
>previous</a> |</li>
<li class="nav-item nav-item-0"><a href="index.html">FireWorks 2.0.4 documentation</a> »</li>
<li class="nav-item nav-item-this"><a href="">Database administration commands</a></li>
</ul>
</div>
<div class="footer" role="contentinfo">
© Copyright 2013, Anubhav Jain.
Created using <a href="https://www.sphinx-doc.org/">Sphinx</a> 8.1.3.
</div>
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-53488807-1', 'auto');
ga('send', 'pageview');
</script>
</body>
</html>