[858] | 1 | <h2>Maintenance</h2> |
---|
| 2 | |
---|
[2342] | 3 | <p>To optimize page generation time, Piwigo uses cached |
---|
[858] | 4 | information. For example, instead of counting the number of pictures |
---|
| 5 | contained in each category at each page reload, this information is stored |
---|
| 6 | in the database. In theory, this information should always be correct, but |
---|
| 7 | sometimes an error can occur and cached information becomes wrong.</p> |
---|
| 8 | |
---|
[5379] | 9 | <p>Some information become useless with time going by. Deleting this useless |
---|
[858] | 10 | information from database make you save disk space.</p> |
---|
| 11 | |
---|
| 12 | <ul> |
---|
| 13 | |
---|
[1656] | 14 | <li><strong>Update categories informations:</strong> For each category, |
---|
[5379] | 15 | the following information is checked, and updated if necessary : list of parent |
---|
| 16 | categories, number of pictures, last picture date, position among |
---|
[858] | 17 | brother categories, position among all categories. This action also checks |
---|
[5379] | 18 | the representative picture consistency.</li> |
---|
[858] | 19 | |
---|
[5379] | 20 | <li><strong>Update images information:</strong> For each picture, |
---|
| 21 | information updated is : full path to file, average |
---|
| 22 | rate. <em>Warning</em>, do not mix up: metadata information |
---|
| 23 | must be synchronized from <span class="pwgScreen">Administration, |
---|
| 24 | Categories, Synchronize</span>, or on the modification screen of a |
---|
[858] | 25 | single picture (through <span class="pwgScreen">Picture</span> for |
---|
| 26 | example).</li> |
---|
| 27 | |
---|
[5379] | 28 | <li><strong>Repair and optimize the database:</strong> |
---|
| 29 | Perform re-order, repair and optimize operations on each table of the database. |
---|
[2064] | 30 | </li> |
---|
| 31 | </ul> |
---|
| 32 | |
---|
| 33 | <ul> |
---|
[5379] | 34 | <li><strong>Purge history details:</strong> Delete all lines from the |
---|
[858] | 35 | <code>history</code> table. Screen <span class="pwgScreen">Administration, |
---|
[5379] | 36 | Specials, History</span> will not longer show information for the past |
---|
| 37 | history. <em>Warning</em>: all data will be lost, without any way to |
---|
| 38 | get them back.</li> |
---|
[858] | 39 | |
---|
[5379] | 40 | <li><strong>Purge history summary:</strong> Delete all the summary information about visit history. This summary is calculated from the history details.</li> |
---|
[2064] | 41 | |
---|
[1656] | 42 | <li><strong>Purge sessions:</strong> Delete expired user sessions.</li> |
---|
[858] | 43 | |
---|
[1111] | 44 | <li><strong>Purge never used notification feeds</strong></li> |
---|
[858] | 45 | |
---|
[5379] | 46 | <li><strong>Purge searches history</strong></li> |
---|
[4484] | 47 | |
---|
| 48 | <li><strong>Purge compiled templates</strong></li> |
---|
[858] | 49 | </ul> |
---|